shopify-admin-customer-acquisition-cost-by-source

Estimate customer acquisition cost per traffic source from Shopify order data.

174|18|Updated Apr 11, 2026
One-click install
npx skills add https://github.com/40RTY-ai/shopify-admin-skills --skill shopify-admin-customer-acquisition-cost-by-source
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: shopify-admin-customer-acquisition-cost-by-source
Source: https://github.com/40RTY-ai/shopify-admin-skills/tree/main/skills/customer-ops/shopify-admin-customer-acquisition-cost-by-source
Command: npx skills add https://github.com/40RTY-ai/shopify-admin-skills --skill shopify-admin-customer-acquisition-cost-by-source

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

It solves the problem of not knowing how much it costs to acquire new customers from each marketing traffic source using Shopify order attribution.

Core Features & Use Cases

  • CAC estimation by source: Combines attributed new-customer orders with caller-provided ad spend to compute cost per acquired customer.
  • Attribution-aware source resolution: Infers a source from customer first-visit data, referrer/landing URLs, UTM parameters, and falls back to direct when missing.
  • Read-only reporting with safeguards: Uses a query-only GraphQL operation and reports results as a CSV for downstream budgeting.

Use case example: If you spend $4,500 on Google, $3,200 on Meta, and $1,800 on TikTok over the same lookback window, the skill estimates how many new customers each source generated and the resulting CAC.

Quick Start

Use the shopify-admin-customer-acquisition-cost-by-source skill for your store domain with days_back=30 and ad_spend for sources like google, meta, and tiktok to produce a CSV of CAC by source.

Frequently Asked Questions about shopify-admin-customer-acquisition-cost-by-source

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I calculate customer acquisition cost by traffic source from Shopify orders?

To calculate customer acquisition cost by traffic source, attribute new-customer Shopify orders to landing pages or referrers, then divide those aggregated order counts by your provided ad spend amounts for each source.

How does Shopify order attribution resolve marketing traffic sources for CAC estimation?

Attribution-aware source resolution infers traffic sources from customer first-visit data, referrer and landing URLs, and UTM parameters, falling back to direct when source data is missing for CAC estimation.

Do I need authenticated Shopify read access to estimate CAC by source?

Yes, you need authenticated Shopify read access to order and customer data to estimate CAC by source. The process performs query-only GraphQL operations to aggregate new-customer orders without modifying store data.

Can I calculate CAC using first-order-only counting over a specific lookback window in Shopify?

Yes, you can calculate CAC using first-order-only counting over a configurable lookback window in Shopify. Set the days_back parameter to define the lookback period for attributing new-customer orders to ad spend.

What is the best way to use CAC by source data for paid-media optimization and budget planning?

The best way to use CAC by source data for paid-media optimization is to export the per-source CSV output and join it with your marketing spend data to identify which traffic sources yield the lowest cost per acquired customer.

Why does my CAC by source report show direct traffic instead of my UTM tracking parameters?

Your CAC by source report shows direct traffic instead of UTM tracking parameters when customer first-visit data, referrer URLs, or landing page URLs are missing or do not contain recognizable UTM tags for attribution resolution.