Site Logo

← All Managed Reports

Customers · Managed Reports

New-customer CAC report

Ad spend divided by first-time Shopify customers, by week and channel.

Growth teams that need acquisition cost without spreadsheet stitching. Ad spend divided by first-time Shopify customers, by week and channel. CAC = total ad spend ÷ Shopify first-time customers (numberOfOrders ≤ 1). Channel CAC uses the same new-customer count for each ad platform. Connect a Shopify store plus at least one ad account. Open this Managed Report in SyncRange, then export the same data to Google Sheets, BigQuery or Excel when you want to own the destination.

Start free Explore the demo

No warehouse setup · Docs

What is on this dashboard

  • Ad spend divided by first-time customers
  • Weekly CAC trend
  • CAC by Meta, Google, TikTok, and Bing
  • Shopify plus your connected ad accounts

Sources

Shopify + ads

Best for

Growth teams that need acquisition cost without spreadsheet stitching.

Interactive demo

Sample data · Change Group by to see the chart update

Create this report

Oct 1, 2026 – Oct 30, 2026 · 2 ad accounts

New customers

412

+8.5% vs prior period

Ad spend

USD 28,400.00

+3.2% vs prior period

New-customer CAC

USD 68.93

-4.1% vs prior period

CAC = ad spend ÷ first-time customers. Sample data for preview only.

New-customer CAC by day

By day

Date CAC New customers Ad spend
2026-10-30 50.82 17 864.00
2026-10-29 48.38 16 774.00
2026-10-28 70.80 15 1,062.00
2026-10-27 69.43 14 972.00
2026-10-26 67.85 13 882.00
2026-10-25 81.00 12 972.00
2026-10-24 51.88 17 882.00
2026-10-23 49.50 16 792.00
2026-10-22 46.80 15 702.00
2026-10-21 70.71 14 990.00
2026-10-20 83.08 13 1,080.00
2026-10-19 82.50 12 990.00
2026-10-18 52.94 17 900.00
2026-10-17 50.62 16 810.00

CAC by ad channel

Channel Ad spend New customers CAC
Meta Ads USD 16,200.00 412 USD 39.32
Google Ads USD 12,200.00 412 USD 29.61

How to set it up

Live in three steps

  1. 1

    Connect accounts

    Link Shopify + ads under Apps. Reports reuse the same connections as exporters.

  2. 2

    Launch the template

    Open Reports, choose New-customer CAC (Shopify + ads), pick accounts, and set how far back to sync.

  3. 3

    Explore KPIs

    Browse cards, charts, and tables. Group trends by day, week, fortnight, or month.

Want this data in your own Sheet or warehouse?

Send it to Google Sheets, BigQuery or Excel on a schedule. Start with this report, then export the same Shopify + ads data when you want to own it.

Export Shopify + ads Google Sheets BigQuery Excel

Why this report

Finished dashboards, not raw exports

SyncRange stores the data and opens KPIs in the app. Skip creating a BigQuery project or spreadsheet destination for this report.

Template ready

Metrics and layout ship with the product. No blank canvas.

Scheduled syncs

Backfill once, then refresh on a schedule or Sync now.

Same connections

Uses the accounts you already connect for exporters.

More templates

Try other reports

LTV by first order (Shopify)

Shopify

Lifetime value and repeat rate by first-order discount, product, channel, and landing page.

View report →

Sales overview (Shopify)

Shopify

Net sales, orders, AOV, and channel mix for your Shopify store.

View report →

Sales overview (Amazon Seller)

Amazon Seller

Order total, orders, and AOV for Amazon Seller.

View report →

Sales overview (Etsy)

Etsy

Receipt totals, orders, and AOV for Etsy.

View report →

Browse the full report gallery

Ready to create New-customer CAC (Shopify + ads)?

Start free, connect Shopify + ads, and launch this template from the in-app gallery.

Get started free Back to demo

Start syncing your ecommerce data in minutes Start free today. No credit card required.

Start free Install on Shopify