Exclusive Dating offers and Smartlink are available for your traffic on CPL (SOI, DOI), PPS, and RevShare payout models.

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

Partners.House

YourAverageDegen

Grand Guru
Joined
Nov 8, 2019
Messages
1,254
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