Im running a lot of traffic sources, multiple ads with different CPC's/CPM's also a lot of upsell, very hard to track in
What do you guys suggest? How do you go by tracking stuff like this?
Also how do you go by tracking individual placements? thanks.
I hear a lot of people use excel, if anyone could share their excel template and some tips i would really appreciate it. thanks
First thing I'd strongly suggest is to reduce everything down to one or two universal metrics, so that you can compare them. Once you have the formula to do that, everything else is just math and plumbing.
I normally go for EPC and CPC, as they're very simple to compare.
If you're running a lot of traffic sources you presumably have a fairly large budget - given that I'd also strongly recommend hiring someone to do your reporting for you. That's a great task for an outsourcer, can save you hours a day, and means you can focus on high-value tasks enabled by having all your stats clear.
I would look at the eCPM, profit margin (%) and total profit per campaign.
Great idea from Caurmen to outsource this. Or to automate it within your system.
You shouldn't spend hours a day on reporting.
Thanks for the feedback, yes im defiantly going to be automating this soon. Thing is im just reaching this success. This is why im a little lost. I want to create me system first so then i can teach someone how to do it.
Does anyone have a template they wouldn't mind sharing?
Thanks
@trexking - Unfortunately this isn't really the kind of thing that's template-friendly: the template would differ too much from person to person depending on what you're tracking, which traffic source you're using, what your preferred base metrics are, etc. Someone tracking straight-up CPL in Popads, ZeroPark and a couple of other pop sources is going to have a very different spreadsheet to someone tracking a CPS / CPL / Revshare mix across Bing, Google and FB, for example.
Andyvon shared a basic campaign tracking template a while ago, but for what you're discussing I think it'd need so much modification you'd be as well starting from scratch.
Sorry! And please, if anyone does have a template that might be useful for trexking, please do share it!
Hello trexking,
Just like @cbrughmans, I work mainly with the eCPM because I prefer to bid on a CPM basis and the eCPM tells me how much I can bid to keep my margin positive (even if sometimes, it can be interesting to bid higher depending on the strategy). But as also work on a CPC basis in some platform, I have no other choice than measuring the eCPC for those ones. It's the most accurate way to do it.
The %margin is really important because it can tell you your risk margin: if you have a campaign that is spending 50€, you are earning 200€ therefore your margin is 150€, your %margin is 300% that shows you that you have room for investing more: bid higher, test a wider targeting, take some risks, etc.
Cheers!