• Welcome to affLIFT!
    We are happy you have decided to check out our awesome affiliate marketing forum. Register your account today to join our amazing community!
  • With over 2.5 billion impressions and 3.3 million daily conversions, you are making a huge mistake if you are not already running traffic with Clickadu!
    Join Clickadu Today

Guide How to Calculate Clickloss/Click Loss Percentage on Zone/Source Level?

kaminari

noisyboy

Grand Guru
Joined
Nov 8, 2019
Messages
947
If you run PPV traffic, then you might have already faced clickloss issues in the past. Clickloss is basically a discrepancy between the amount of traffic you paid for and what you received. Lord @Nick explains it in-depth in his guide here: The Ultimate Guide to Clickloss.

So, I was recently trying out a new traffic source and Clickloss% was so bad (around 40%). So for every $100 worth of traffic I purchased, I was getting only $60 worth of traffic. That's bad. So I had to block zones with a very percentage of clickloss for me to be able to continue the campaigns on this traffic source. So here's how I exactly did it using Excel (you can use Google Sheets too):


Step 1:

Download the zones/sources data of your campaign from your tracker as well as your traffic source.

Step 2:

Organize the data from your tracker and your traffic source like this:

shw3j8wyav-png.17089


The first 2 columns are the data from Voluum (my tracker) and the last 2 columns are data from my traffic source.

Step 3:

Because the list of zones from my traffic source's report is not in the same order of my tracker's list, we will have to match
 
To view the premium content in our affiliate marketing forum (including this awesome thread), you must first register and upgrade your account. Register today and become a part of our amazing community!
Top