Home > Technical & Creative Skills > Tracking Campaigns

Excel Spreadsheet Tracking? (5)

08-09-2014 09:47 PM #1 jaydenuk (Member)
Excel Spreadsheet Tracking?

Hi Guys,

I am looking to use someones Excel spreadsheet with formulas included so I can track my revenue with my ads etc.

I use Prosper202, but want to track down ads and watch revenue independent of Prosper202.

Does anyone have a template system which they are using on using on Excel that they can share for download please?

Cheers

08-11-2014 10:56 PM #2 caurmen (Administrator)

The basic spreadsheet I used to use was pretty simple: just each campaign I ran with a daily breakdown of profit, ROI and spend.

You can get more complex from there, but that plus the stats you can mine from Prosper will be solid.

For the calculations for profit and ROI, check my Math of AM post: http://stmforum.com/forum/showthread...ill-Make-Money

08-12-2014 12:19 AM #3 maynzie (Moderator)

Nice share Caurmen!

08-12-2014 04:12 AM #4 cmdeal (Veteran Member)

Everyone should read, understand and internalise caurmen's post on conversion mathematics before starting on campaigns.

08-12-2014 06:01 AM #5 imdutch (Member)

Quote Originally Posted by cmdeal View Post
Everyone should read, understand and internalise caurmen's post on conversion mathematics before starting on campaigns.
Exactly that - understand all the metrics first. Then, if you're ready for cheat sheets, Ngo published a helpful XLS template recently:

http://www.charlesngo.com/profittemplates/

Home > Technical & Creative Skills > Tracking Campaigns