New Member
4 0 0

## Basic conversion costs/calculations per session + CPC

Hi all,

I've been running my Shopify site for a few months now, and have a few stats I can use to calculate my revenue x sessions x ads average order value x conversion rate.

I'm just wanting to run my calculations past some members and see if they are right.

Using some example figures below just to illustrate how my spreadsheet is working:

Assuming a .87% conversion rate and an average order value of \$120:

If I receive 8 orders per month and ~680 sessions per month, the average per session value is \$1.40

So, assuming the majority of my traffic is paid, the net revenue per click/session for Google is .13cents and Facebook \$1.22

I feel like I'm making a miscalculation or not factoring something in, or I am completely mis-calculating things!? Basically, I'm wanting to try and work out how much paid traffic I would need to generate the revenue I want to achieve. With a .87% conversion rate, if I wanted to achieve \$5000 revenue per month for example, and 70% of my traffic is paid, what is my ad spend versus revenue? How much traffic to I need to generate?

Can anyone provide a basic formula or provide links to any online calculators/spreadsheets?

Thanks so much!!

Replies 4 (4)
Shopify Partner
145 10 25

## Re: Basic conversion costs/calculations per session + CPC

I would also like to see a formula or response to this question.
Jay Friedmann | Developer @ Stronger eCommerce
Want a skilled Shopify developer? Reach out at jay@strongerecommerce.com
Shopify Partner
21 0 15

## Re: Basic conversion costs/calculations per session + CPC

Hi @Bickford,

I would recommend tracking Cost per Purchase and breaking it down per marketing channel instead of focusing on CPC.

Cost Per Purchase (Total): \$80

Required purchases for \$5000 revenue: 5000 / 120 = 42

Cost for generating \$5000 revenue on both platforms: 42 * 80 = \$3360

Cost for generating \$5000 revenue on Google: 42 * 60 = \$2520

Cost for generating \$5000 revenue on Facebook: 42 * 100 = \$4200

Makes sense?

Shopify Partner
2138 153 530

## Re: Basic conversion costs/calculations per session + CPC

You need to use ROAS, which is all conversion value divided by ad spend.

If your conversion value is \$960 (120*8) and your ad spend is \$952 (680*1.4) You are at nearly at a loss.

You need to lower your bidding by half, exclude search terms, improve ranking etc... to increase your return of investment.

Your ad spend should be 500%, ie \$1000 conversion value and \$200 ad spend = 5 or 500%

Hope this helps.

Need Data Feed or Google Shopping support? Get in touch.
Pathfinder
107 10 25

## Re: Basic conversion costs/calculations per session + CPC

Hi Bickford,

Cost per conversion = Cost/ Conversions =  (cost/click) / (clicks/conversions) = CPC/Conversion Rate =

Ads investment = Cost per Conversion* Number of conversions = Cost per Conversion*(Revenue / conversion_value) = (CPC / Conversion Rate) * (Revenue / conversion_value)

Google Cost per Conversion = 1.27/0.0087=\$146

FB Cost per conversion = 0.18/0.0087=\$20

Assuming a conversion value is \$120, For a revenue of \$5000:

On Google you'd need to invest 146*(5000/120)=\$6083

On Facebook you'd need to invest 20*(5000/120)=\$833

Keep in mind that CPC , conversion rates etc. vs ads budget is close to linear when your audience is large enough comparing to the budget, if it's small and frequency is effecting ad quality then the formula will tell a different story.

All the best!

Sam