How do you track & project all your affiliate marketing revenue?

[Penguin]

Here's how I do it: Affiliate Marketing Revenue Tracker Template

If you have any ideas for how I could improve it further, please let me know!

 

[Penguin]

Oh, here's the direct link if you don't want to share it: https://docs.google.com/spreadsheet/ccc?key=0AuugEtf-Gn9idE1wNHdLZ0ZJSldvRncwTWhXdUVtY1E&usp=sharing

 

[wooja]

cpvlab.com with tracking pixels embedded with your providers = automated revenue + ROI tracking of all your campaigns

 

[emp]

Only tracking revenue is kinda bullshit

::emp::

 

[Ibanez | Jan]

Only tracking revenue is kinda bullshit

::emp::

This.

Projecting revenue is usually bullshit as most campaigns are too unstable.
Offer gets capped, advertiser goes full retard and doesn't pay the bills, FB swipes all your accounts, copycat starts fucking up your bids and ROI and your nice little projection is worth shit.

 

[emp]

OK.. basically, for each campaign, you need to track:

Revenue

Daily revenue (adcents, aff offer 1, aff offer 2, etc..)

Cost

Daily spending by channel (adwords, facebook, etc..)

Initial spending (Website setup, domain costs, development, etc..)

Occasional spending (articles, banners, promotions, etc...)

Then, remember kids:

profit = revenue - cost

::emp::

 

[Penguin]

cpvlab.com with tracking pixels embedded with your providers = automated revenue + ROI tracking of all your campaigns

Yes, but this assumes all of your affiliate programs support tracking code injection, tracking pixels, tracking pixel URLs and/or postback URLs.

 

[Penguin]

Only tracking revenue is kinda bullshit

::emp::

I agree. I am not proposing that this is all you track. I track far more than this, but this is how I track overall revenues.

 

[paper]

CPVLab is the best tool for this purpose.

 

[juntao65]

Excel sheets.

I used to have it all automated, and on click of a button I'd get my rev/spend for whatever date range. But later realized I missed out on too many little things compared to when I did it manually. Not to mention all the time wasted making sure the scripts are working right for each network/traffic source.

 

[Penguin]

CPVLab is the best tool for this purpose.

What makes it better than LinkTrackr?

 

[Penguin]

Excel sheets.

I used to have it all automated, and on click of a button I'd get my rev/spend for whatever date range. But later realized I missed out on too many little things compared to when I did it manually. Not to mention all the time wasted making sure the scripts are working right for each network/traffic source.

What kind of little things are you referring to exactly?

 

[Satyrs]

Only tracking revenue is kinda bullshit

::emp::

agreed. You have nothing to bench against other than what a network tells you if you dont track on your own.

google docs is the easy way. What you use depends on how much you got goin on.

 

[ztume]

What makes it better than LinkTrackr?

More information. Cost, ROI, profit and etc.

Just testing Voluum.com which is free open beta until March. Seems legit but pretty expensive after open beta (min $99/m).

 

[Paper_Chase]

Best way to do this is to run all your offers through your own install of Cake or HasOffers. Then you can use their API's to pull revenue numbers into a custom dashboard. If you set up your offers correctly, you will be able to view revenue by vertical, country, price format, media type etc.

The hard part is tracking costs from various different sources. If you run all your traffic through CPV lab that helps, but unfortunately they don't have an API yet...