Try unique Push Traffic with bonus!
BroPush has a 1000000 clicks/daily of Real Exclusive Push Traffic from our publishers. Join us now and enjoy 230+ GEO's for your High-Roi advertising!

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

1win

noisyboy

Grand Guru
Joined
Nov 8, 2019
Messages
1,138
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
 
Last edited:
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