Like math? You better learn to.

[TweetyBird]

I've just started looking at PPC and was trying to develop a spreadsheet that would work for me. I've seen some spreadsheets that would challenge Einstein, so this one here is a breath of fresh air. Its a great start because its simple and straight to the point. Thanks!

 

[Neutrino999]

Just had a quick look at the spreadsheet and it looks great. Simple, structured, easy to understand. I used to hate math in school, but then started dabling with currency trading and boy did excel become dear to me Thanks very much!

 

[BWright]

Option A: $1000 on $500 spend = 200% ROI

Option B: $80 on $20 spend = 400% ROI

Option C: $800 on $350 spend = 229% ROI

BTW, math is awesome, stats specifically

This may be a dumb question, but I thought when calculating ROI, shouldn't it be profit/investment? I see here you are using revenue/investment. I guess my main question would be is 0% ROI breaking even or is 100% is breaking even?

 

[smithk]

I will Option A

 

[Expert]

Agreed. Get your math right and everything else follows

 

[JessicaS]

Yippy!!!!!

Most of the people voted for B.

All I love maths since my childhood.

 

[BitWriter]

Got it right with B.

 

[Emdat]

Well said buddy, thanks for sharing with us!

 

[Emdat]

Its really nice one. Thanks for sharing with us!

 

[Emdat]

Well I go with B - $0.20 CPC

 

[Wicked Weasel]

PPC is the safest bet. I probably wouldn't do neither one of those anyway.

 

[firstpagegoogle]

Wow, the spreadsheet is actually really nice, thanks for that.

 

[TheCheesePolice]

Provided that anyone still reads this, I have a question - how do you verify that the CTR is correct? I mean, what if you have a completely different demographic/banner than the last advertiser?

 

[Blogpost]

i will go with option - B.

 

[seounit]

According how you state this exercise, and assuming that 1,000,000 impressions will cost you about $350 with let's say 0.25% of clicks and getting a 4% conversion, that is 100 "sales" x $20 $2,000

I think is the best option is C, with a killer banner.

 

[Topmaster]

I gave my $500 via Western Union to the random guy who PMed me saying he had a cool new offline lead generation course that would make me millions!

 

[djcooke]

Print adds $9000 = 6 phone calls 4 sales $15000 gross 7 net = don't quit the day job

CPC = $1.70 = WTF I hate google so much I had to buy a few shares

SEO = 2nd year in after quitting the day job making more and working.... in sweats scratching my balls until I feel like going outside

That is the math I bet most of you are doing...

Thanks for the spreed sheet I like the 9900% ROI it came with on pops!

 

[(O_o)]

 

[edugurus]

This math is so stressful to take it in head. However, when it's time for the real money then I can do maths well. This post helped me to figure out that I am in the right direction. Thank you very much!

 

[skkhan]

This is crazy. I am impressed to see all that post.