Like math? You better learn to.

Which option?

  • Option A

    Votes: 230 24.1%

  • Option B

    Votes: 409 42.9%

  • Option C

    Votes: 122 12.8%

  • Just tell me, I'm too stupid to figure it out.

    Votes: 192 20.1%
  • Total voters
    953


Didn't have a decent spreadsheet like yours so messed up the calculation on Option C and threw my vote there. Thanks for the sheet it should really help in the future.
 
I agree; the spreadsheet is very helpful. The math exercise is very good, too, especially for noobs who need specific guidance. Thanks for taking the time to do this.:music06:
 
Thanks for the spreadsheet, Mike! I'm a Business Major so I should have thought of it.
Probably explains why I'm still so Goddamn poor, lol.
 
SEO_Mike said:
Since this thread keeps getting replied to a random times, I'll add mine.

+rep to me for saving my own ass :D I lost this spreadsheet somehow and thank god I uploaded it here. Yay! Sometimes even a blind squirrel finds a nut.
Click to expand...

Lol that is hilarious. I'll +rep you just for that once the 24 hours are over.
 
how can i make some money, with investment ? i have read some things, but even so, i am to newbie ^^
 
No offense to anyone that missed this but this is BASIC math.... I do much much more complicated stuff every day and I don't know how I would have been profitable without it.... But I am a math major and perhaps compensate with my lack of good marketing with great mathematical optimization.
 
I'm happy to see the spreadsheet is still helping people out. It is basic math and I have friends that wear out calculators doing it. Fortunately, I'm lazy and like to let my computer do all that work with just minimal input.
 
miketpowell said:
No offense to anyone that missed this but this is BASIC math.... I do much much more complicated stuff every day and I don't know how I would have been profitable without it.... But I am a math major and perhaps compensate with my lack of good marketing with great mathematical optimization.
Click to expand...


Time for you to make a thread about some of that complicated optimization math then. I'm serious. And no offence to the OP.
 
Going to post some assignments for those that want to try out their skills. Will start out with one at the easy level. Will add assignments for different levels as we go on.

CPC = cost pr click
aCPC = average cost pr click
CTR = click through rate
CPM = cost pr thousand impressions


Assignment 1 (level: newbie)
Assume you have two campaigns:
  1. teeth whitening
  2. government grants


Statistics for the teeth whitening campaign:

  • Ad impressions: 2 000 000
  • Ad CTR: 1.25 %
  • Landing page CTR: 15 %
  • End page conversions: 75 %
  • Payout: $30 pr conversion
  • Ad aCPC: $1.50
  • Ad cost scheme: CPC


Statistics for the government grants campaign:

  • Ad impressions: 2 000 000
  • Ad CTR: 0.95 %
  • Landing page CTR: 35 %
  • End page conversions: 50 %
  • Payout: $40 pr conversion
  • Ad cost scheme: CPM
  • CPM: $ 50
  • If it were on CPC cost scheme, the average CPC would be: $ 4.75
  • Assume that it is not possible to run the campaign with CPC


Assume no other costs.
What costs are there to each campaign? How much revenue does each campaign generate? What are the profits and what campaign is the most profitable?
If you want to give it a go yourself I suggest you start calculating now before you read spoilers in posts below.
 
You must log in or register to reply here.
Top Bottom