Affiliate cost and profit tracking sheet

[emp]

After trying out several designs, I came up with a small excel sheet to track my websites progress.

Download the Affiliate Tracking Excel Sheet here

All of this should be pretty self-explanatory, I will give some pointers though.

Sheet “Summary”
This is where all the data gets collected and a pretty diagram is shown. No need to change anything on this sheet, it will update automagically.

Sheets “Apr-Dec”
This is where you get to enter your data.

• Totals - updates automatically
• Blue box: Jan 07 Day 31 - You can enter the month for easy readability, enter running day of the month to get a daily average calculated.
• Arbi pages / Content / Additional costs
  I decided to track Arbi versus content providing pages, feel free to change the ad providers, the income providers, etc.. This version lists hosting, searchfeed and 7search as costs and google as income. Obviously, this is just for starters.

So, feel free to use and expand.
::emp::

 

[Barik]

I do really love this sheet. Thanks.

 

[trant]

Great spreadsheet, thanks.

 

[LazyHippy]

Looks good. Cheers for sharing that, should help me get a bit more organised!! +rep

 

[jelf]

ya very nice, thanks for your time.

I just added freezing the top line of cells so they dont move when I scroll.


cheers +rep

 

[ffblueocean]

I love people like you that share the knowledge! My hat is off to you!

 

[tradog]

nice work, thanks!!

 

[Wooody]

Perfect....

 

[emp]

Glad you guys like it.

I guess an improved version is in the air.
I'll let you know.

Same goes to you, if you "generalize" this sheet, please share for all.

::emp::

 

[Fewleftstanding]

Nice, thanks a lot! +1

 

[Jon]

Simple and sweet.

Great contribution Emp.

 

[geoline]

Simple and good looking
thanks a lot

 

[vitalfire]

good stuff, thank you!

 

[jened]

somehow someway i needs this to retrieve stats for me. it takes too long to enter manually and i give up after a few days.

 

[emp]

somehow someway i needs this to retrieve stats for me. it takes too long to enter manually and i give up after a few days.

That's the beauty with this sheet. No need to enter the data every day. Just do it whenever ya want.

I do it around once a week, sometimes twice.

::emp::

 

[jened]

That's the beauty with this sheet. No need to enter the data every day. Just do it whenever ya want.

I do it around once a week, sometimes twice.

::emp::

good point. it still takes time if you happen to have more than a couple ppc accounts most companies let you create reports. maybe i need to write a program to parse the report and load this xls hmmm

 

[annie0500]

Thanks for sharing. This is great!