Agent skill

Shopify Admin Customer Acquisition Cost By Source

by 40RTY-ai in 40RTY-ai/shopify-admin-skills

Read-only: estimates customer acquisition cost (CAC) per traffic source by joining order count per landing site / referrer with configurable ad spend.

MITAuto-check passedMarketing & SEO

Install Shopify Admin Customer Acquisition Cost By Source

skills CLI
$ npx skills add 40RTY-ai/shopify-admin-skills --skill shopify-admin-customer-acquisition-cost-by-source -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install 40RTY-ai/shopify-admin-skills shopify-admin-customer-acquisition-cost-by-source --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/40RTY-ai/shopify-admin-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/customer-ops/shopify-admin-customer-acquisition-cost-by-source .claude/skills/shopify-admin-customer-acquisition-cost-by-source && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
shopify-admin-customer-acquisition-cost-by-source
GitHub stars
194
Token cost
~1.6k tokens
SKILL.md length
479 words
Files
1
Skills in repo
116
Repo updated
First seen
Licence
MIT

At a glance

Read-only: estimates customer acquisition cost (CAC) per traffic source by joining order count per landing site / referrer with configurable ad spend.

  • Works in 6 steps: OPERATION: orders — query → Group orders by normalized source.… → If new_customers_only: true, drop orders… → …
  • Tasks that involve Paid advertising
  • SKILL.md covers Purpose, Prerequisites, Parameters and Safety, plus 6 more sections
  • Calls shopify

What it does

Shopify Admin Customer Acquisition Cost By Source is an agent skill from 40RTY-ai/shopify-admin-skills. Read-only: estimates customer acquisition cost (CAC) per traffic source by joining order count per landing site / referrer with configurable ad spend.

Its SKILL.md is about 1.6k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts. Compatibility notes: Claude Code, Cursor, Codex, Gemini CLI

It sits in Marketing & SEO, covering Paid advertising. It works with Shopify. The repository describes itself as: Community-maintained AI agent skills for operating Shopify stores — workflows, optimization, reports and more. The licence is MIT.

When your agent uses it

  • Tasks that involve Paid advertising

Example prompts

  • “/shopify-admin-customer-acquisition-cost-by-source”

Requirements

  • Compatibility (from SKILL.md): Claude Code, Cursor, Codex, Gemini CLI

Workflow steps

6 steps, taken from the first numbered list in SKILL.md.

  1. OPERATION: orders — query
  2. Group orders by normalized source. Resolution order
  3. If new_customers_only: true, drop orders where customer.numberOfOrders > 1 so each customer is counted once
  4. Aggregate per source: orders_count, new_customers_count, revenue_attributed
  5. Join with ad_spend map: cac = ad_spend[source] / new_customers_count. Sources without spend data report cac: null (organic / unattributed)
  6. Filter to sources with orders_count >= min_orders_per_source

What it can do on your machine

Read from SKILL.md and the folder at commit 6765cb4. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Shell commands in SKILL.md call:

    • shopify

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

  • Compatibility

    Claude Code, Cursor, Codex, Gemini CLI

    From compatibility in the SKILL.md frontmatter.

Context cost

Shopify Admin Customer Acquisition Cost By Source loads about 1.6k tokens when it runs. Until then it costs about 50 tokens; SKILL.md has 479 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~50
When it runs · the whole SKILL.md, loaded when a task matches
~1.6k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from 40RTY-ai/shopify-admin-skills at commit 6765cb4, republished under its MIT licence (© 40RTY-ai). 479 words, ~1,642 tokens.

Download SKILL.mdSave it as .claude/skills/shopify-admin-customer-acquisition-cost-by-source/SKILL.md (or your agent's skills folder).
name
shopify-admin-customer-acquisition-cost-by-source
description
Read-only: estimates customer acquisition cost (CAC) per traffic source by joining order count per landing site / referrer with configurable ad spend.
compatibility
Claude Code, Cursor, Codex, Gemini CLI
role
customer-ops
toolkit
shopify-admin, shopify-admin-execution
api_version
2025-01
graphql_operations
orders:query
status
stable

Purpose

Estimates customer acquisition cost (CAC) for each traffic source by combining the number of new-customer orders attributed to a landing page / referrer with a configurable ad spend input per source. Output answers: "for every dollar spent on source X, how many new customers did we acquire and at what unit cost?" Read-only — no mutations. Provides the data foundation for paid-media budget reallocation.

Prerequisites

  • Authenticated Shopify CLI session: shopify store auth --store <domain> --scopes read_orders,read_customers
  • API scopes: read_orders, read_customers

Parameters

ParameterTypeRequiredDefaultDescription
storestringyes—Store domain (e.g., mystore.myshopify.com)
days_backintegerno30Lookback window for orders to attribute
ad_spendobjectno{}Map of source name → spend in store currency, e.g. {"google": 4500, "meta": 3200, "tiktok": 1800}
new_customers_onlyboolnotrueCount only first-order customers as "acquired"
min_orders_per_sourceintegerno5Minimum orders for a source to be reported
formatstringnohumanOutput format: human or json

Safety

ℹ️ Read-only skill — no mutations are executed. Safe to run at any time. Ad spend values are caller-provided; this skill does not pull from any ad platform.

Workflow Steps

  1. OPERATION: orders — query Inputs: query: "created_at:>='<NOW - days_back days>'", first: 250, select customer { id, numberOfOrders }, customerJourneySummary { firstVisit { landingPage referrerUrl source } }, landingPageUrl, referrerUrl, totalPriceSet, pagination cursor Expected output: All orders in the window with referral and customer attribution; paginate until hasNextPage: false

  2. Group orders by normalized source. Resolution order:

    • customerJourneySummary.firstVisit.source if present
    • Else parse domain from referrerUrl
    • Else parse landingPageUrl UTM params (utm_source)
    • Else bucket as direct
  3. If new_customers_only: true, drop orders where customer.numberOfOrders > 1 so each customer is counted once

  4. Aggregate per source: orders_count, new_customers_count, revenue_attributed

  5. Join with ad_spend map: cac = ad_spend[source] / new_customers_count. Sources without spend data report cac: null (organic / unattributed)

  6. Filter to sources with orders_count >= min_orders_per_source

Show full SKILL.md (185 more words)Show less

GraphQL Operations

graphql
# orders:query — validated against api_version 2025-01
query OrdersWithAttribution($query: String!, $after: String) {
  orders(first: 250, after: $after, query: $query) {
    edges {
      node {
        id
        name
        createdAt
        landingPageUrl
        referrerUrl
        customerJourneySummary {
          firstVisit {
            landingPage
            referrerUrl
            source
            sourceType
            utmParameters {
              source
              medium
              campaign
            }
          }
        }
        totalPriceSet {
          shopMoney {
            amount
            currencyCode
          }
        }
        customer {
          id
          numberOfOrders
        }
      }
    }
    pageInfo {
      hasNextPage
      endCursor
    }
  }
}

Session Tracking

Claude MUST emit the following output at each stage. This is mandatory.

On start, emit:

╔══════════════════════════════════════════════╗
║  SKILL: Customer Acquisition Cost by Source  ║
║  Store: <store domain>                       ║
║  Started: <YYYY-MM-DD HH:MM UTC>             ║
╚══════════════════════════════════════════════╝

After each step, emit:

[N/TOTAL] <QUERY|MUTATION>  <OperationName>
          → Params: <brief summary of key inputs>
          → Result: <count or outcome>

On completion, emit:

For format: human (default):

══════════════════════════════════════════════
CAC BY SOURCE  (<days_back> days)
  Orders analyzed:        <n>
  New customers acquired: <n>
  Total ad spend (input): $<amount>
  Blended CAC:            $<amount>

  By Source (sorted by CAC ascending):
    google      Customers: <n>  Spend: $<n>   CAC: $<n>
    meta        Customers: <n>  Spend: $<n>   CAC: $<n>
    direct      Customers: <n>  Spend: —      CAC: organic
    referral    Customers: <n>  Spend: —      CAC: organic

  Output: cac_by_source_<date>.csv
══════════════════════════════════════════════

For format: json, emit:

json
{
  "skill": "customer-acquisition-cost-by-source",
  "store": "<domain>",
  "period_days": 30,
  "orders_analyzed": 0,
  "new_customers": 0,
  "blended_cac": 0,
  "currency": "USD",
  "by_source": [],
  "output_file": "cac_by_source_<date>.csv"
}

Output Format

CSV file cac_by_source_<YYYY-MM-DD>.csv with columns: source, orders_count, new_customers_count, revenue_attributed, ad_spend, cac, currency

Error Handling

ErrorCauseRecovery
THROTTLEDAPI rate limit exceededWait 2 seconds, retry up to 3 times
Empty ad_spendNo spend providedReport orders / customers per source with cac: null
Missing customerJourneySummaryOlder orders or guest checkoutFall back to referrerUrl → landingPageUrl → direct
All orders from directNo referrer capturedLikely tracking misconfiguration — surface as warning

Best Practices

  • Provide ad spend for the same window as days_back — mismatched windows produce misleading CAC numbers.
  • Pair with customer-cohort-analysis to validate that low-CAC sources also produce high-LTV customers.
  • Sources reported as direct often hide attribution leakage — investigate UTM tagging and referrer policies before drawing conclusions.
  • Treat output as estimated CAC — Shopify's first-touch attribution does not capture cross-device journeys, so sources that rely on view-through (display, video) will be undercounted.
  • Re-run weekly to catch CAC drift before campaigns become unprofitable.

© 40RTY-ai, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in skills/customer-ops/shopify-admin-customer-acquisition-cost-by-source of 40RTY-ai/shopify-admin-skills.

Open the folder on GitHubat commit 6765cb4

Compare with similar skills

Shopify Admin Customer Acquisition Cost By Source next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Shopify Admin Customer Acquisition Cost By Source compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Shopify Admin Customer Acquisition Cost By Source this skill40RTY-ai/shopify-admin-skills194—~1.6kAutomated safety check: PassMIT
Ad Conversion Tracking Setupminhnv0807/ai-business-skills609—~3.7kAutomated safety check: PassMIT
Shopifythatrebeccarae/claude-marketing161—~2.4kAutomated safety check: NotesMIT
Ecommerce Marketing Strategy BuilderLeoYeAI/openclaw-master-skills2.2k1 repos~4.6kAutomated safety check: PassMIT
Profit Margin Calculator Shopifynexscope-ai/eCommerce-Skills1.1k—~641Automated safety check: PassMIT
Shopify Marketingnexscope-ai/eCommerce-Skills1.1k—~3.8kAutomated safety check: PassMIT

Similar skills

  • Ad Conversion Tracking Setup

    minhnv0807/ai-business-skills

    Sets up and verifies conversion tracking before ad spend: Meta Pixel and CAPI, Google Ads, GA4, TikTok, server-side GTM, consent mode, UTMs and a pre-launch checklist.

    609 GitHub stars~3.7k tokensUpdated 29 days ago
    Marketing & SEOAuto-check passed
  • Shopify

    thatrebeccarae/claude-marketing

    Shopify e-commerce platform marketing expertise. An agent skill from thatrebeccarae/claude-marketing.

    161 GitHub stars~2.4k tokensUpdated 4 mo ago
    Marketing & SEOAuto-check: notes
  • Ecommerce Marketing Strategy Builder

    LeoYeAI/openclaw-master-skills

    Full-stack e-commerce marketing strategy builder. An agent skill from LeoYeAI/openclaw-master-skills.

    2.2k GitHub starsUsed in 1 repo~4.6k tokens
    Marketing & SEOAuto-check passed
  • Profit Margin Calculator Shopify

    nexscope-ai/eCommerce-Skills

    Shopify/DTC profit margin calculator for sellers. An agent skill from nexscope-ai/eCommerce-Skills.

    1.1k GitHub stars~641 tokensUpdated 1 mo ago
    Marketing & SEOAuto-check passed
  • Shopify Marketing

    nexscope-ai/eCommerce-Skills

    Comprehensive Shopify marketing strategy and execution. An agent skill from nexscope-ai/eCommerce-Skills.

    1.1k GitHub stars~3.8k tokensUpdated 1 mo ago
    Marketing & SEOAuto-check passed
  • Ecommerce Ppc Strategy Planner

    LeoYeAI/openclaw-master-skills

    Cross-platform PPC strategy planner for ecommerce businesses.

    2.2k GitHub starsUsed in 1 repo~5.5k tokens
    Marketing & SEOAuto-check passed

More from 40RTY-ai/shopify-admin-skills

All 116 skills in this repo
  • Shopify Admin Abandoned Cart Recovery

    40RTY-ai/shopify-admin-skills

    Query checkouts abandoned in the last N days, generate unique discount codes per customer, and tag them for re-engagement.

    194 GitHub stars~1.9k tokensUpdated 1 mo ago
    Auto-check passed
  • Shopify Admin Address Correction

    40RTY-ai/shopify-admin-skills

    Update the shipping address on an unfulfilled order before it ships.

    194 GitHub stars~1.5k tokensUpdated 1 mo ago
    Auto-check passed
  • Shopify Admin Agentic Crawler Access

    40RTY-ai/shopify-admin-skills

    Edit the theme's robots.txt.liquid to explicitly allow AI crawlers (GPTBot, ClaudeBot, PerplexityBot, Google-Extended, OAI-SearchBot, Amazonbot) so AI assistants are permitted to read the catalog.

    194 GitHub stars~1.8k tokensUpdated 1 mo ago
    Auto-check passed
  • Rewrite thin product descriptions into structured, fact-rich copy (materials, fit, use-cases, the words shoppers actually type) so AI agents have something concrete to quote and match.

    194 GitHub stars~1.6k tokensUpdated 1 mo ago
    Auto-check passed
  • Shopify Admin Agentic Image Alt Text

    40RTY-ai/shopify-admin-skills

    Generate and set descriptive alt text on product images so AI agents (which can't 'see' pixels) can understand and recommend what each product looks like.

    194 GitHub stars~1.6k tokensUpdated 1 mo ago
    Auto-check passed
  • Shopify Admin Agentic LLMs Txt

    40RTY-ai/shopify-admin-skills

    Generate and publish an /llms.txt guide (brand summary, flagship products, key policies, contact) via a theme template so AI assistants get a curated, machine-readable map of the store.

    194 GitHub stars~1.8k tokensUpdated 1 mo ago
    Auto-check passed

Works with

Categories

Questions about Shopify Admin Customer Acquisition Cost By Source

What does Shopify Admin Customer Acquisition Cost By Source do?

Read-only: estimates customer acquisition cost (CAC) per traffic source by joining order count per landing site / referrer with configurable ad spend. Shopify Admin Customer Acquisition Cost By Source is an agent skill from 40RTY-ai/shopify-admin-skills. Read-only: estimates customer acquisition cost (CAC) per traffic source by joining order count per landing site / referrer with configurable ad spend.

When should I use Shopify Admin Customer Acquisition Cost By Source?

Shopify Admin Customer Acquisition Cost By Source fits situations like: tasks that involve Paid advertising.

How do I install Shopify Admin Customer Acquisition Cost By Source in Claude Code?

Run `npx skills add 40RTY-ai/shopify-admin-skills --skill shopify-admin-customer-acquisition-cost-by-source -a claude-code`. Or copy the skill folder (skills/customer-ops/shopify-admin-customer-acquisition-cost-by-source in 40RTY-ai/shopify-admin-skills) into .claude/skills/shopify-admin-customer-acquisition-cost-by-source in your project. Claude Code loads it when a task matches its description.

How do I install Shopify Admin Customer Acquisition Cost By Source in Codex?

Run `npx skills add 40RTY-ai/shopify-admin-skills --skill shopify-admin-customer-acquisition-cost-by-source -a codex`. Or copy the skill folder (skills/customer-ops/shopify-admin-customer-acquisition-cost-by-source in 40RTY-ai/shopify-admin-skills) into .agents/skills/shopify-admin-customer-acquisition-cost-by-source in your project. Codex loads it when a task matches its description.

Can I use Shopify Admin Customer Acquisition Cost By Source in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add 40RTY-ai/shopify-admin-skills --skill shopify-admin-customer-acquisition-cost-by-source -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/shopify-admin-customer-acquisition-cost-by-source, .gemini/skills/shopify-admin-customer-acquisition-cost-by-source, .github/skills/shopify-admin-customer-acquisition-cost-by-source and .opencode/skills/shopify-admin-customer-acquisition-cost-by-source in your project.

What does Shopify Admin Customer Acquisition Cost By Source need to run?

Going by SKILL.md and its folder, Shopify Admin Customer Acquisition Cost By Source needs the command-line tools its instructions call (shopify). Compatibility (from SKILL.md): Claude Code, Cursor, Codex, Gemini CLI.

Does Shopify Admin Customer Acquisition Cost By Source access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Shopify Admin Customer Acquisition Cost By Source safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Shopify Admin Customer Acquisition Cost By Source use?

Shopify Admin Customer Acquisition Cost By Source is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Shopify Admin Customer Acquisition Cost By Source use?

About 1.6k tokens (SKILL.md is roughly 6.6k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Shopify Admin Customer Acquisition Cost By Source?

Skills that share tags, products or a category with Shopify Admin Customer Acquisition Cost By Source: Ad Conversion Tracking Setup (minhnv0807/ai-business-skills, 609 stars), Shopify (thatrebeccarae/claude-marketing, 161 stars), Ecommerce Marketing Strategy Builder (LeoYeAI/openclaw-master-skills, 2.2k stars) and Profit Margin Calculator Shopify (nexscope-ai/eCommerce-Skills, 1.1k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Shopify Admin Customer Acquisition Cost By Source?

40RTY-ai (a GitHub organization) maintains it in 40RTY-ai/shopify-admin-skills, which has 194 GitHub stars. The repository holds 116 skills in this directory. The repository was last updated on August 14, 2026.

Source: 40RTY-ai/shopify-admin-skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.