When we’re analyzing placement stats we need to know both the ad spend and revenue to make decisions.

Trouble is, a vast majority of traffic sources don’t offer the option of passing cost data back to the tracker. And manually updating stats in the tracker can take ages, and is not very accurate, etc.

My buddy Egor (username egor) had whipped up an excel formula that has allowed us to combine two sets of data: revenue data from the tracker + cost data from the traffic source.

I’ve made it more user-friendly – you can download the spreadsheet from here:

https://www.dropbox.com/s/6bh5ofraz5ttyma/matching-data-sets.xlsx?dl=0

(EDIT: Tim requested for a version that includes CTR so here it is:

https://www.dropbox.com/s/xi02jtxet0j6hg7/matching-data-sets-wCTR.xlsx?dl=0)

(2nd EDIT: Justin has kindly made a more versatile version with a CPM column, which makes it easy to copy and paste the resulting data into the kill-whitelist ...

This thread has 20 more replies.
WANT TO SEE THE REST?

Join STM Forum