What is the formula for Cost Per Call
CPC = Spend / Calls
How would you figure out a week over week variance?
WoW Variance = Current Week - Previous Week / Previous Week
What is the formula for Cost Per Order
CPO = Spend / Orders
What is the formula for conversion %?
Conversion % = Orders/Calls
Handled % = Handled Calls/Calls
David
If Client A has $105,000 in media activity and received 7,825 calls, what is their CPC?
$13.42 = $105k / 7,825
How would you figure out a % variance of performance between a new creative and an old creative?
Variance % = (New - Old) / Old
If Client C has $289,689.45 in media activity and received 8,567 orders, what is their CPO?
CPO = Media Activity / Orders
$33.81 = $289,689.54 / 8,567
If you had 5,000 handled calls out of 15,000 calls, what is the handled percentage?
Handled % = Handled Calls/Calls
33% = 5,000 / 15,000
This person has a fear of worms....to the point of it being considered a phobia
Monica
Client B has a $57.42 CPC and 789 calls, how much media activity did they have?
Media activity = $45,304
$57.42 * 789 = $45,304
During week 2/3, Cient A's media activity was $50,000, during week 2/10, media activity grew to $102,000. What is the % variance WoW?
% Variance = ($102,000 - $50,000) / $50,000
104% increase
Client B has a $125.75 CPO with 15,000 orders. How much media activity did Client B have?
$125.75 * 15,000 = $1,886,250
Double check!
$1,886,250 / 15,000 = $125.75
If Client A had a 55% conversion rate with 20,000 calls, how many orders did they receive?
20,000 * .55 = 11,000
Doube-check --> 11,000/20,000 = 55%
This person has a chicken named "Duck".
Sarah
Client C has $853,140 in media activity with a $60.25 CPC, how many calls did they have?
Calls = 14,160
$835,150 / $60.25
Client B increased media activity week over by 25%. If week 2/3 was $5,000 - how much is week 2/10?
Week 2/10 = $5,000 * .25 = $1,250
$1,250 + $5,000 = $6,250
Double Check --> 25% = ($6,250 - $5,000) / $5,000
If Client A has a CPO of $55.36 with $105,250 in Media Activity, how many orders did they get?
Orders = 1,901
$105,250 / $55.36
Client B has a 44% handled call rate. With 56,000 handled calls, how many calls did they receive?
56,000 / .44 = 127,273
Double Check --> 56,000 / 127,273 = 44%
This person's least favorite animal is a manatee.
Mike M