Shopify PPC in Google Sheets: ROAS, CAC, and Total Ad Cost

Shopify PPC ROAS. Here Is What It Cannot Tell Me.

Spend $20, generate $100 in Shopify revenue from that campaign. Google defines ROAS as conversion value divided by ad spend: that is 5x. Quick, useful signal. I still use it.

The problem is when your team treats ROAS as proof the campaign is profitable.

A shopper can click your ad, then apply a discount code at checkout. A second promotion can stack, free shipping kicks in, a Shopify refund hits three weeks later, and platform fees come off every transaction. None of that shows up in ROAS. ROAS ends at revenue. Your margin starts there.

Your campaign at 2x ROAS on a high-margin product with no active promos can return more real profit than one at 5x ROAS on a product with a 25% return rate and two coupon codes circulating on deal forums. The ratio looked better in the second case. The business did not.

Start With CAC and Order Value, Then Work Forward to ROAS

The right sequence is: know your CAC, set your margin target, then calculate the order value that makes both possible. ROAS becomes an output, not the number you chase.

If your customer acquisition cost is $20 and you need a 5x return on that cost, the order value needs to be at least $100. Below that, the math does not work before you even account for COGS, refunds, or stacked discounts.

And the "lead" definition matters here too. Is your CAC calculated on every click, or on completed purchases that were not refunded? Those are different numbers. Meta's cost-per-result and your real CAC are using different definitions of "acquired customer." Your calculation has to use yours consistently or the comparison means nothing.

Low-priced products are harder to scale with paid traffic for this reason. Your $35 order disappears fast when ad costs move up. At $100, there is room to absorb acquisition cost, shipping pressure, discounts, and returns without going negative.

Before judging campaign performance, make sure your Shopify sales report is showing clean net revenue, not gross revenue with refunds still outstanding.

Total Ad Cost Keeps the Store Honest

I use TACoS for Amazon advertising (it is the primary metric in our Amazon advertising metrics framework), and the same logic applies to Shopify PPC.

Your formula: total ad spend divided by your total Shopify revenue including organic. Not just the revenue the ad platform claims to have driven.

Under 10% means the store is running efficiently and there is probably room to spend more. If competitors are at 15% and you are at 8%, pulling back costs you market share.

Up to 15% is defensible on your high-margin products where market share capture matters.

Above 15% means ads are funding too much of the business. For low-price, low-margin products, 10% is the ceiling. Beyond that, you are paying to rent sales rather than building a business.

Pull your total monthly Shopify revenue from your sheet (SUMIF from the orders tab) and divide by your actual ad spend across Meta and Google. If you run both Amazon and Shopify, the cross-channel workbook covers how to calculate TACoS across both platforms from one sheet. That ratio is what tells you whether the campaigns are amplifying the business or propping it up.

GA4 ecommerce measurement supports purchase data including transaction value, coupon usage, and item details, which you can use to reconcile what GA4 shows against what Shopify reports. The Shopify marketing attribution article covers how UTM data connects to actual order rows in your sheet.

When the Ad Stops Working

You scaled spend on something that was working, and then with the same ads and same budget, conversions dropped.

Ad fatigue is what happened: the same creative shown to your audience too long. Adjusting the bid does not fix it.

The approach I use: 20 to 30 variations of the same ad running simultaneously: black and white, color, comic illustration, sepia tone, traditional font, modern font, different headlines against the same visual. Let the algorithm find the winner.

And when a winner surfaces, build 20 to 30 variations of that one. The cycle keeps something fresh rotating at all times. Speed matters more than polish: a variation live in two hours running against real audience data beats one perfected over three weeks that launches after the fatigue has already cost you.

Pick One Attribution Source and Commit

Meta, Shopify, GA4, and TikTok all count your sales differently. Pick one source and commit to it.

GA4 is the right call because it sits outside any individual platform's reporting incentive. Meta has reasons to show your campaign performing well. GA4 does not. Set it as your primary source, configure the GA4 purchase event to fire on every Shopify order completion, and stop trying to reconcile four dashboards into one number manually.

The Sheet That Replaces Four Dashboards

When you connect your Shopify store and order data flows into Google Sheets through our Shopify to Google Sheets connection, each row carries the UTM source that drove it, provided tracking was set up before the sale. The Shopify Order object includes order totals, discounts, line items, and refunds. Those fields let you build the view next to ad spend. The free P&L spreadsheet template shows how revenue, cost, and refund tabs sit alongside each other when you are building this workbook from scratch.

For daily monitoring after a campaign launches, your Shopify sales tracker shows whether conversion rate or order volume is moving in the right direction while the campaign runs. If product cost changes the allocation decision, Shopify COGS tracking keeps gross profit per SKU visible in the same workbook. If a campaign is moving inventory faster than expected, your Shopify inventory management tab shows whether stock levels can support the spend before you scale.

When This Sheet Adds Nothing

Under $5K a month in total Shopify ad spend, the platform dashboards are enough. A weekly check of Meta and Google with a rough CAC calculation monthly is all you need.

We are the wrong call if you need automated bid management or AI budget allocation. Our connection pulls Shopify order data into Sheets where your team runs the analysis and makes the call. Automated bidding is a different tool.

The sheet earns its cost when you are running campaigns across two or more channels and need one place that calculates TACoS, real CAC, and net revenue without trusting any single platform's attribution. That is the moment when four separate dashboards stop being workable.

Before you increase spend, ask yourself one question: can this offer still work if acquisition cost rises?