Like math? You better learn to. - Page 4 - WickedFire - Affiliate Marketing Forum

miketravel · 03-10-2010, 05:37 AM

thank you, I was just about to start a search for something like this

teguh123 · 03-12-2010, 03:00 AM

A way to do it is to see your EPC.

Your EPC should be $20 times 4%=$.80

Option A cost $.40 epc
Option B cost $.20 epc so it is the best

What does cpm means? Cost per million? $.35 per million impression>?

Quote:

Originally Posted by SEO_Mike

For the math retards out there and people that claim to hate math, you need to get on the ball. If you want to make money in this industry, math is the single most important skill available. Yes simple math. Not coding, not design work, not even content building but plain old math.

Here's why:

You have $500 to spend and you're considering different places to spend it. The offer you are promoting pays $20, and the CPA company claims that it converts at 4%

Option "A" - Banner that gets 5,000,000 impressions monthly, costs $500, and has an average CTR (according to the site owner) of 0.025%

Option "B" - PPC campaign where the clicks will cost $0.20 each

Option "C" - CPM banner on a popular site, costs $0.35 CPM. Over the course of one month, you can expect to get a maximum of 1,000,000 impressions

So, what are some of the numbers you need to know to make an informed decision?

Also, which option is the best?

I'll post the answer later today.

knukk · 03-12-2010, 02:15 PM

Quote:

Originally Posted by teguh123

What does cpm means? Cost per million? $.35 per million impression>?

CPM stands for Cost Per Mille, which means Cost Per Thousand.

teguh123 · 03-14-2010, 09:35 AM

Thanks Knukk.

teguh123 · 03-15-2010, 12:14 AM

Wait a minute. That option C is still not comparable. So for 1000 impression you pay .35

In one month you would pay $350 right because you get 1 million impression.

The thing is you don't know your clickthrough. So you don't know how many people click your links? So how do you compare? Test and try I guess.

Hav3n · 03-22-2010, 06:22 PM

This has really taken the guess work out for me.

Awesome spreadsheet Mike. +rep

sgfinancialfree · 03-27-2010, 04:06 AM

You earn a total of $1000 from option A. Minus the cost of $500. Your profits are $500.

Option B you earn $2000 and minus the $500 cost, you earn $1500

Option C you earn $800,000 minus $350, you earn $799,650

Hope my maths is correct.

teguh123 · 03-28-2010, 04:14 AM

I should learn more math from you guys. So how does Option C earn $800k again?

indianman · 03-28-2010, 07:14 PM

Quote:

Originally Posted by teguh123

I should learn more math from you guys. So how does Option C earn $800k again?

Did you win the Physics Olympiad once?

1,000,000 * 0.1/100 * 4/100 * $20 = $800

mohsinmajestic · 04-14-2010, 07:32 AM

Option A..

bogdan147 · 04-14-2010, 06:56 PM

Quote:

Originally Posted by indianman

Did you win the Physics Olympiad once?

1,000,000 * 0.1/100 * 4/100 * $20 = $800

quite amusing

thx for the spredsheed.. gold for me as I am not all that good at math +rep

YouDontKnowMe · 04-19-2010, 01:06 AM

I know option B has the best ROI, but what if you only get a couple of clicks? Options A and C give you an expected amount of traffic, whereas B provides no info on this.

Otherwise, this is a good exercise IMO.

teguh123 · 04-20-2010, 09:33 AM

Quote:

Originally Posted by indianman

Did you win the Physics Olympiad once?

1,000,000 * 0.1/100 * 4/100 * $20 = $800

Only because I am diligent. Anyone can do even better. Also I learn math the right way. When my employee ask, how the hell I still remember how to compute probability of having 4 six in 10 dice draw, I told him the truth. You must not remember anything in Math. All are common sense.

Now let me try to understand the above complicated calculation.

Each offer pays $20. So we got $20/lead. However, conversion is 4%. So we got $20/lead * 4 lead/100 click and after crossing things out you got let's see, I got to summon my calc, 80 cents/click. That's our EPC. Wow. I am learning something. Thanks a lot.

Then there is 1 million impression. How did you get the .1/100 again? It must be the CTR but where is it mentioned that the CTR is .1/100? That's what I was missing.

indianman · 04-25-2010, 07:22 PM

Quote:

Originally Posted by teguh123

Now let me try to understand the above complicated calculation.

Each offer pays $20. So we got $20/lead. However, conversion is 4%. So we got $20/lead * 4 lead/100 click and after crossing things out you got let's see, I got to summon my calc, 80 cents/click. That's our EPC. Wow. I am learning something. Thanks a lot.

Then there is 1 million impression. How did you get the .1/100 again? It must be the CTR but where is it mentioned that the CTR is .1/100? That's what I was missing.

Here: Like math? You better learn to.

Quote:

Originally Posted by teguh123

Only because I am diligent. Anyone can do even better. Also I learn math the right way. When my employee ask, how the hell I still remember how to compute probability of having 4 six in 10 dice draw, I told him the truth. You must not remember anything in Math. All are common sense.

Explain!

mpbiz · 05-19-2010, 02:23 AM

thanks mike for takin me to school god damn i need to up my math game

A-Bomb · 05-19-2010, 02:48 PM

Great thread

PinHead1424 · 05-19-2010, 03:30 PM

I was an English major, should I be in this business at all? (j/k of course)

Hey A-Bomb put some cleavage in there for me. Try this:

( o )\/( o ), then I can just sit and imagine seeing that side view tit from behind!

BTW, Excel is my best friend.

gromero280 · 06-10-2010, 08:37 PM

I just started doing AM and I had no idea that math was involved in all this... I was one of the idiots that fell into the EBook scam and didn't really learn shit... cause all this time, I thought that to make it into a business, all you needed was traffic to your site, never considered all this stuff... need to keep reading.

Thanks Mike

ivielleserrano · 06-14-2010, 02:48 AM

I really hate mathematics, but as a start of my curiosity in internet marketing, I think I should learn to love it. I pick the wrong choice. =) But for now, let's see what happen if I will use option B from now on.

LosAngeles · 06-14-2010, 07:37 AM

What kind of mathematics do online marketers actually use? I met a guy at AdTech in San Fran at the PPC.Biz party who was brilliant with math. Really knew how to use statistics and data to enhance his media buying.

John rife · 06-18-2010, 04:06 PM

The spreadsheet was good. Thanks

snowingsomewher · 06-23-2010, 08:38 PM

Need to set aside time to read this entire mofo. Great topic.

Samantha87 · 07-05-2010, 10:22 PM

I've learned more here today on WickedFire than I have the past 3 months reading endless crap articles and b.s. from self-proclaimed "gurus".. This spreadsheet rocks, Thanks again guys!

theleonz · 07-07-2010, 05:59 AM

Thanks for the spread sheet, I've been trying to make my own decent one for awhile. Up until now, all of my math has been by hand. +rep

clickhunt · 07-15-2010, 05:54 PM

Thanks for the spreadhseet. Also thanks to all for the interesting discussions re. the different assignments, it was quite illustrating.

b1tr0t · 07-20-2010, 07:44 PM

You know... when I first saw that headline I saw, "Like meth?"

I figured I was in for some long nights, getting into IM, but that seemed a little extreme.

netguru88 · 07-26-2010, 10:36 AM

I'd go for B. Don't let the numbers fool ya. Conversion not impressions is the name of the game!

aparadekto · 08-29-2010, 01:12 AM

Wow this really reminded me I should review all my campaigns and all my options...

TheOutsourcer · 09-25-2010, 11:39 AM

That excel sheet calculator EXCELLENT! /hug

This reminds me of a keyword research tactic.

Get 1000 keywords (exact match) and paste them in excel.
*0.3 (traffic from 1st position of google)
*0.2$ ($ / adsense click, average $ / hoplink etc)
*CTR (5-10-15% etc)

igetthatalot · 10-20-2010, 04:03 AM

Appreciate the spreadsheet Mike.

HiMyNameIsTom · 11-08-2010, 05:12 PM

Quote:

Originally Posted by SEO_Mike

Well, if you decide to go with A, you'll make $1500 on the initial $500 investment.

This answer is actually a $1000 return on the $500 investment (meaning a $1000-$500 = $500 profit), correct? It seems like other people have mentioned this; can you clarify whether that's right or not SEO_Mike? (I know, gotta look at the math again heh...)

thalom · 11-09-2010, 08:11 PM

This is a great thread....

Schlabbersack · 11-12-2010, 12:35 AM

Mike,

Thank you for this absolutely rocking spreadsheet!

LOVE IT!

This is why I love WickedFire...

NefariousFlame · 11-19-2010, 04:22 AM

Awesome spreadsheet, I wish I could understand and comprehend it. I've got so much to learn. I couldn't even guess an answer because of all the business lingo ROI, CTR....?????

charityblake · 11-19-2010, 05:34 AM

ha ha This post makes my brain numeracy

Kerkat · 11-19-2010, 09:45 PM

Whatever the answer is you have proved the point, too many don't know how to do basic calculations.

johnt · 11-21-2010, 04:33 AM

+ rep. good spreadsheet. Lately I've made it a point to build dashboards to monitor campaign performance. Keeps me informed on what is working and what is not working. Now I just need more LCDs

imkevintan · 11-24-2010, 02:11 PM

Just downloaded the spreadsheet and it's golden. I can appreciate it and it's something all of us marketers should have on hand at all times. I'm going to play with the numbers a bit and pay more attention to the numbers. Thanks again.

tgglenn · 11-28-2010, 05:13 AM

MATH is a four-letter word!!

Duncan MacLeod · 12-14-2010, 06:49 PM

This is a great thread! I have a degree in math, though I admit these problems were a little bit of a challenge for me as I haven't used my degree in my field of work for 12 years. Also, My focus was on more theoretical math (think 4th dimensional calculus) rather than applied business math. I'm kicking myself now for not taking those classes.

Thank you for the spreadsheet!! Now to my calculator

DanielLambert · 12-14-2010, 07:27 PM

I'll admit my maths isn't the best but I've been studying hard and pretty proud to say that I managed to work out the correct answer

S-Kwire · 12-16-2010, 05:54 PM

Many thanks for the spreadsheet, Mike. This will come in handy...

Davin Black · 12-28-2010, 05:03 PM

Quote:

Originally Posted by tgglenn

MATH is a four-letter word!!

So is "CASH."

Just sayin'

Art72 · 01-17-2011, 09:21 PM

shit...clicked 'A' before i read the damn question!

Thanks for the spreadsheet!!!

NicheSpotter · 02-02-2011, 08:10 PM

+Rep for the spread sheet, I was literally just about to write one up after seeing this thread

dolby · 02-17-2011, 01:53 PM

c is pretty reliable..when..with...has the minimum risk..and has the chance of maximum trafic

joserizal · 02-20-2011, 08:51 AM

Option B is best!

clothbottom1 · 03-03-2011, 05:40 AM

I like maths, and mainly trigonometry. !!!!

seoserviceshop · 03-09-2011, 02:31 AM

hey i really hated the math when am school

Bender. · 03-27-2011, 04:13 PM

Thanks, Mike, liking that SS

Nice thread in general... I was gonna do the math at first but then I scrolled down and couldn't help myself.

View Poll Results: Which option?
Option A	190	23.51%
Option B	344	42.57%
Option C	107	13.24%
Just tell me, I'm too stupid to figure it out.	167	20.67%
Voters: 808. You may not vote on this poll

03-10-2010, 05:37 AM	#151 (permalink)
miketravel Junior Member Join Date: Mar 2010 Posts: 2 iTrader: 0 / 0%	thank you, I was just about to start a search for something like this Share Share this post on Digg Del.icio.us Technorati Twitter

03-14-2010, 09:35 AM	#154 (permalink)
teguh123 Senior Member Join Date: Sep 2007 Posts: 515 iTrader: 2 / 100%	Thanks Knukk. Share Share this post on Digg Del.icio.us Technorati Twitter __________________ Pursue Happiness Eliminate Poverty Reach Enlightenment - Get Rich Bang Bitches No body forces you to get married. They just prohibit all popular better alternatives.

03-15-2010, 12:14 AM	#155 (permalink)
teguh123 Senior Member Join Date: Sep 2007 Posts: 515 iTrader: 2 / 100%	Wait a minute. That option C is still not comparable. So for 1000 impression you pay .35 In one month you would pay $350 right because you get 1 million impression. The thing is you don't know your clickthrough. So you don't know how many people click your links? So how do you compare? Test and try I guess. Share Share this post on Digg Del.icio.us Technorati Twitter __________________ Pursue Happiness Eliminate Poverty Reach Enlightenment - Get Rich Bang Bitches No body forces you to get married. They just prohibit all popular better alternatives.

03-22-2010, 06:22 PM	#156 (permalink)
Hav3n Senior Member Join Date: Mar 2010 Location: GA Posts: 1,423 iTrader: 46 / 100%	This has really taken the guess work out for me. Awesome spreadsheet Mike. +rep Share Share this post on Digg Del.icio.us Technorati Twitter

03-27-2010, 04:06 AM	#157 (permalink)
sgfinancialfree Financial Freedom Join Date: Mar 2010 Posts: 1 iTrader: 0 / 0%	You earn a total of $1000 from option A. Minus the cost of $500. Your profits are $500. Option B you earn $2000 and minus the $500 cost, you earn $1500 Option C you earn $800,000 minus $350, you earn $799,650 Hope my maths is correct. Share Share this post on Digg Del.icio.us Technorati Twitter

03-28-2010, 04:14 AM	#158 (permalink)
teguh123 Senior Member Join Date: Sep 2007 Posts: 515 iTrader: 2 / 100%	I should learn more math from you guys. So how does Option C earn $800k again? Share Share this post on Digg Del.icio.us Technorati Twitter __________________ Pursue Happiness Eliminate Poverty Reach Enlightenment - Get Rich Bang Bitches No body forces you to get married. They just prohibit all popular better alternatives.

04-14-2010, 07:32 AM	#160 (permalink)
mohsinmajestic Senior Member Join Date: Apr 2010 Posts: 1,899 iTrader: 423 / 100%	Option A.. Share Share this post on Digg Del.icio.us Technorati Twitter

04-19-2010, 01:06 AM	#162 (permalink)
YouDontKnowMe Loki Join Date: Apr 2010 Location: USA Posts: 519 iTrader: 46 / 100%	I know option B has the best ROI, but what if you only get a couple of clicks? Options A and C give you an expected amount of traffic, whereas B provides no info on this. Otherwise, this is a good exercise IMO. Share Share this post on Digg Del.icio.us Technorati Twitter

05-19-2010, 02:23 AM	#165 (permalink)
mpbiz Senior Member Join Date: Apr 2010 Location: southern california Posts: 1,115 iTrader: 3 / 100%	thanks mike for takin me to school god damn i need to up my math game Share Share this post on Digg Del.icio.us Technorati Twitter

05-19-2010, 02:48 PM	#166 (permalink)
A-Bomb ( o )( o ) Join Date: Dec 2009 Location: Ft. Lauderdale Posts: 23 iTrader: 0 / 0%	Great thread Share Share this post on Digg Del.icio.us Technorati Twitter

05-19-2010, 03:30 PM	#167 (permalink)
PinHead1424 Both in the Pants/Head Join Date: May 2010 Location: Colorado Springs Posts: 25 iTrader: 0 / 0%	I was an English major, should I be in this business at all? (j/k of course) Hey A-Bomb put some cleavage in there for me. Try this: ( o )\/( o ), then I can just sit and imagine seeing that side view tit from behind! BTW, Excel is my best friend. Share Share this post on Digg Del.icio.us Technorati Twitter

06-10-2010, 08:37 PM	#168 (permalink)
gromero280 Junior Member Join Date: Jun 2010 Posts: 3 iTrader: 0 / 0%	I just started doing AM and I had no idea that math was involved in all this... I was one of the idiots that fell into the EBook scam and didn't really learn shit... cause all this time, I thought that to make it into a business, all you needed was traffic to your site, never considered all this stuff... need to keep reading. Thanks Mike Share Share this post on Digg Del.icio.us Technorati Twitter

06-14-2010, 02:48 AM	#169 (permalink)
ivielleserrano Junior Member Join Date: Jun 2010 Location: Pampanga, Philippines Posts: 4 iTrader: 0 / 0%	I really hate mathematics, but as a start of my curiosity in internet marketing, I think I should learn to love it. I pick the wrong choice. =) But for now, let's see what happen if I will use option B from now on. Share Share this post on Digg Del.icio.us Technorati Twitter

06-14-2010, 07:37 AM	#170 (permalink)
LosAngeles Banned Join Date: Mar 2010 Location: Los Angeles, CA Posts: 27 iTrader: 0 / 0%	What kind of mathematics do online marketers actually use? I met a guy at AdTech in San Fran at the PPC.Biz party who was brilliant with math. Really knew how to use statistics and data to enhance his media buying. Share Share this post on Digg Del.icio.us Technorati Twitter

06-18-2010, 04:06 PM	#171 (permalink)
John rife Football Fan Join Date: Aug 2009 Location: London Posts: 119 iTrader: 3 / 100%	The spreadsheet was good. Thanks Share Share this post on Digg Del.icio.us Technorati Twitter __________________ Get all your scripts here

06-23-2010, 08:38 PM	#172 (permalink)
snowingsomewher Member Join Date: Sep 2009 Location: Los Angeles Posts: 55 iTrader: 0 / 0%	Need to set aside time to read this entire mofo. Great topic. Share Share this post on Digg Del.icio.us Technorati Twitter

07-05-2010, 10:22 PM	#173 (permalink)
Samantha87 Junior Member Join Date: Jul 2010 Posts: 16 iTrader: 0 / 0%	I've learned more here today on WickedFire than I have the past 3 months reading endless crap articles and b.s. from self-proclaimed "gurus".. This spreadsheet rocks, Thanks again guys! Share Share this post on Digg Del.icio.us Technorati Twitter

07-07-2010, 05:59 AM	#174 (permalink)
theleonz Member Join Date: Jul 2010 Location: earth Posts: 34 iTrader: 0 / 0%	Thanks for the spread sheet, I've been trying to make my own decent one for awhile. Up until now, all of my math has been by hand. +rep Share Share this post on Digg Del.icio.us Technorati Twitter

07-15-2010, 05:54 PM	#175 (permalink)
clickhunt Junior Member Join Date: Feb 2010 Location: Usually Europe (might change tomorrow) Posts: 10 iTrader: 0 / 0%	Thanks for the spreadhseet. Also thanks to all for the interesting discussions re. the different assignments, it was quite illustrating. Share Share this post on Digg Del.icio.us Technorati Twitter

07-20-2010, 07:44 PM	#176 (permalink)
b1tr0t Member Join Date: Nov 2009 Posts: 32 iTrader: 0 / 0%	You know... when I first saw that headline I saw, "Like meth?" I figured I was in for some long nights, getting into IM, but that seemed a little extreme. Share Share this post on Digg Del.icio.us Technorati Twitter

07-26-2010, 10:36 AM	#177 (permalink)
netguru88 Scrapebox and SEnuke guru Join Date: Jun 2010 Location: In the realm of the gurus! Posts: 205 iTrader: 39 / 100%	I'd go for B. Don't let the numbers fool ya. Conversion not impressions is the name of the game! Share Share this post on Digg Del.icio.us Technorati Twitter

08-29-2010, 01:12 AM	#178 (permalink)
aparadekto Ninja Wizzard Join Date: Aug 2010 Posts: 221 iTrader: 7 / 100%	Wow this really reminded me I should review all my campaigns and all my options... Share Share this post on Digg Del.icio.us Technorati Twitter

09-25-2010, 11:39 AM	#179 (permalink)
TheOutsourcer Junior Member Join Date: Sep 2010 Posts: 12 iTrader: 0 / 0%	That excel sheet calculator EXCELLENT! /hug This reminds me of a keyword research tactic. Get 1000 keywords (exact match) and paste them in excel. 0.3 (traffic from 1st position of google) 0.2$ ($ / adsense click, average $ / hoplink etc) *CTR (5-10-15% etc) Share Share this post on Digg Del.icio.us Technorati Twitter

10-20-2010, 04:03 AM	#180 (permalink)
igetthatalot Junior Member Join Date: Oct 2010 Location: Australia Posts: 10 iTrader: 0 / 0%	Appreciate the spreadsheet Mike. Share Share this post on Digg Del.icio.us Technorati Twitter

11-09-2010, 08:11 PM	#182 (permalink)
thalom Junior Member Join Date: Oct 2010 Posts: 15 iTrader: 0 / 0%	This is a great thread.... Share Share this post on Digg Del.icio.us Technorati Twitter

11-12-2010, 12:35 AM	#183 (permalink)
Schlabbersack Banned Join Date: Feb 2010 Posts: 58 iTrader: 1 / 100%	Mike, Thank you for this absolutely rocking spreadsheet! LOVE IT! This is why I love WickedFire... Share Share this post on Digg Del.icio.us Technorati Twitter

11-19-2010, 04:22 AM	#184 (permalink)
NefariousFlame Junior Member Join Date: Nov 2010 Posts: 26 iTrader: 0 / 0%	Awesome spreadsheet, I wish I could understand and comprehend it. I've got so much to learn. I couldn't even guess an answer because of all the business lingo ROI, CTR....????? Share Share this post on Digg Del.icio.us Technorati Twitter

11-19-2010, 05:34 AM	#185 (permalink)
charityblake Member Join Date: Aug 2010 Posts: 34 iTrader: 0 / 0%	ha ha This post makes my brain numeracy Share Share this post on Digg Del.icio.us Technorati Twitter

11-19-2010, 09:45 PM	#186 (permalink)
Kerkat Member Join Date: Nov 2010 Posts: 64 iTrader: 1 / 100%	Whatever the answer is you have proved the point, too many don't know how to do basic calculations. Share Share this post on Digg Del.icio.us Technorati Twitter

11-21-2010, 04:33 AM	#187 (permalink)
johnt Senior Member Join Date: Aug 2010 Posts: 157 iTrader: 4 / 100%	+ rep. good spreadsheet. Lately I've made it a point to build dashboards to monitor campaign performance. Keeps me informed on what is working and what is not working. Now I just need more LCDs Share Share this post on Digg Del.icio.us Technorati Twitter

11-24-2010, 02:11 PM	#188 (permalink)
imkevintan Senior Member Join Date: Nov 2010 Location: Penang, Malaysia Posts: 104 iTrader: 0 / 0%	Just downloaded the spreadsheet and it's golden. I can appreciate it and it's something all of us marketers should have on hand at all times. I'm going to play with the numbers a bit and pay more attention to the numbers. Thanks again. Share Share this post on Digg Del.icio.us Technorati Twitter __________________ Facebook: imkevintan Twitter: @imkevintan Blog: www.imkevintan.com

11-28-2010, 05:13 AM	#189 (permalink)
tgglenn Junior Member Join Date: Nov 2010 Location: Alabama Posts: 8 iTrader: 0 / 0%	MATH is a four-letter word!! Share Share this post on Digg Del.icio.us Technorati Twitter

12-14-2010, 06:49 PM	#190 (permalink)
Duncan MacLeod Junior Member Join Date: Dec 2010 Location: North Carolina, US Posts: 6 iTrader: 0 / 0%	This is a great thread! I have a degree in math, though I admit these problems were a little bit of a challenge for me as I haven't used my degree in my field of work for 12 years. Also, My focus was on more theoretical math (think 4th dimensional calculus) rather than applied business math. I'm kicking myself now for not taking those classes. Thank you for the spreadsheet!! Now to my calculator Share Share this post on Digg Del.icio.us Technorati Twitter

12-14-2010, 07:27 PM	#191 (permalink)
DanielLambert Senior Member Join Date: Nov 2009 Location: UK Posts: 360 iTrader: 7 / 100%	I'll admit my maths isn't the best but I've been studying hard and pretty proud to say that I managed to work out the correct answer Share Share this post on Digg Del.icio.us Technorati Twitter