Affiliate Links Tracker- All in one tool for affiliate marketers

Affiliate Links Tracker- All in one tool for affiliate marketers

Affiliate links tracker is a one stop solution to track all your affiliate links. You can track details such as visits count, referrer, customer country and customer platforms. This tracker doesn’t bother about your affiliate platform.

Affiliate Links tracker

You can have affiliate programs with multiple vendors but all you have to do is to shorten your affiliate link with Google shortener(Of Course you can do that in bulk with this affiliate links tracker tool) and use the shortened link across all your marketing programs(Blog, youtube, ebook)

Downloads

Download Affiliate Links tracker FREE version.

Download Affiliate Links tracker PAID version just for $2.

 

Let’s get dive into the All in One Affiliate Links tracker and explore the features.

 

Prerequisite for Affiliate Links Tracker

            After you have successfully purchased the affiliate links tracker tool, you have to do few steps to access Google APIs. Open the spreadsheet. Go to Tools->Script Editor.

Affiliate links tracker

A script editor window will be opened in new tab. Go to Resources-> Advanced Google Services. Scroll down and ensure that URL shortener API is turned ON.

Note: By default, it’ll be enabled.

Advanced google services 3

After you have done that, click the “Google Developers Console” link that you saw in the above image. You’ll be taken to Google developer console Dashboard.

Google API 2

Click on the Library present down to Dashboard and type “URL shortener” in the search box. It’ll display URL shortener API as shown below.

Google Dashboard 4

Click the URL shortener API link and you’ll be taken to that dashboard. You just have to click the Enable button. After you have clicked the Enable button, it’ll display Disable as shown below

URL shortener API 5

To sum up prerequisite, you have to do only two things for the first time:

1) Verify URL shortener service API is enabled in Advanced Google services

2) Verify URL shortener API is enabled in Google developer console.

Short description about Google URL shortener with analytics and tracking tool

            This Google spreadsheet can be used to 1)Shorten multiple URLs at a time 2)Analyze the shortened URL clicks 3)Give detailed overview about the visitors, platforms and click count 4)Expand the Google shortened URLs.

This Google spreadsheet contain four sheets

  • Bulk URLs Shortener
  • URL Analytics
  • Deep Analytics
  • Bulk URLs Expander

 

Feature #1- Bulk URLs shortener-To shorten multiple URLs at time with Google shortener API

As I said early, you have to shorten all your affiliate links with google shortener. I know it would be difficult to shorten one by one for 100 or 1000 URLs. So I’ve added this as feature #1 in affiliate links tracker to save your valuable time. You would have all your affiliate links kept in either Spreadsheet or notepad or any preferred format.

First sheet “URL shortener” is used to shorten multiple URLs at a time. You need to copy paste the long URLs in Column A and description (optional) in Column C. Once you are done, click the “Shorten URL” button to generate the shortened URL links in Column B for all the long URLs. Now you have to replace all your long affiliate links with Google shortened links across all your platforms(Blog, youtube, etc,.)

Shortener Link 6

If you want to share this link to your email you can click on the button “Share this link to my Email”. It’ll share this Google spreadsheet link as an attachment to your email as shown below.

Gmail service for google sheets 7

 

FAQs about shorten multiple URLs sheet

1) How many maximum number links can I shorten with this Google URL shortener?

It uses Google API for shortening service and you can shorten 1,000,000 URLs per day. Check out the Quota

2) What is description column?

            Description column is optional and it can be used to know what the URL is pointing to.

3) Does it share the sheet as an attachment?

            No. It just shares the URL link to email ID associated with Google drive. From your email, you can click on the link and open the spreadsheet and resume your work. If you want to save the data before creating another set of short URLs. Go to File ->Download As-> Microsoft Excel format.

4) How many times can I send a link to my Gmail?

You can share this spreadsheet link 100 times per day.

Feature #2- URL Analytics

URL Analytics sheet is used to track the hits/visits/clicks on the affiliate links. It shows you an overview about how often your affiliate pages are visited by the customer.You have to give the list of shortened links in the column B. You can also add a description (optional) for the shortened links in the column A. Once you have done click the “Refresh Analytics Data” button on the right side as shown below

Refresh Analytcs 8

It’ll give you all time clicks, this month clicks, this week clicks, today clicks, last two hours clicks.

All time clicks- Show the overall clicks for the shortened affiliate links.

This month clicks- Show the last 30 days clicks from today.

This week clicks- Show the last 7 days clicks from today.

Today clicks- Show the last 24 hours clicks.

Last two hours clicks- Show the last two hours clicks count.

 

FAQs about URL Analytics

1) Does it track the long URL clicks?

No. Affiliate links tracker tracks only the count of Google shortened URLs.

2) Does it track only the shortened URLs from my Google account or shortened from sheet 1?

No. Affiliate Links Tracker uses Google API so you can track the status of all Google shortened URLs (Shortened from other Google accounts as well).

Feature #3- Deep Analytics

            In the URL Analytics tab, you can see only the count of clicks. If you want to do further analysis like visitors country, devices and referrers then you can do so in the Deep analytics tab.

Put the shortened links in A1 of Deep analytics tab. Click the button “Refresh Deep Analytics” as shown below

All Time

 

All time affiliate links 9

This Week

This week affiliate links 10

Once you are done you can see the overall count split by country, referrers, and platforms.

There are two main split ups in Deep analytics:

1) All Time

2) This week

In each split, you have

Country– Display the top 10 list of countries where your URL is visited.

Country Visit– Display the country visit. For e.g In the above image, the given link was visited 22 times from India.

Referrer-It defines the website from which the link was viewed.

Referrer Visit- It defines the referrer count. For e.g. In the above image, the link was visited 66 times from YouTube.

Platforms– It defines the operating systems from which link was visited.

Platform count– It defines operating system count. For e.g. From windows OS the link was visited 69 times.

 

FAQs about Deep Analytics

1) When I run the deep Analytics I couldn’t find any/some data in This Week section?

            It means your URL is not visited by the customer for the past 7 days.

2) When I run the deep Analytics I couldn’t find any data/some data in All Time and This Week section?

It means your URL is very new or not visited by users.

 

Feature #4- URL Expander

If you want to expand the list Google shortened URL then this feature will help you to do that. You need to copy paste the Google shortened URLs in Column A and description(optional) in Column C. Once you are done, click the “Expand URLs” button to generate the long URL links in Column B for all the shortened URLs.

Long URL 11

 

Affiliate Links Tracker Free Vs Paid

Features Free Version Paid Version
Bulk URLs shortener Yes  Yes
URL Analytics No  Yes
Deep Analytics  No  Yes
URL Expander  Yes  Yes

 

                                                           Get Free version                 Get Paid version

Check out the Video description of Affiliate links tracker below. If you want to watch the below video on youtube click here
Let me know if you need assistance/looking for new features to be added to Affiliate Links Tracker.

Leave a Reply