Agent skill

Shopify Admin Customer Cohort Analysis

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

Read-only: groups customers by first-purchase month and tracks repeat purchase rate and revenue per cohort.

MITAuto-check passedData & Analytics

Install Shopify Admin Customer Cohort Analysis

skills CLI
$ npx skills add 40RTY-ai/shopify-admin-skills --skill shopify-admin-customer-cohort-analysis -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-cohort-analysis --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-cohort-analysis .claude/skills/shopify-admin-customer-cohort-analysis && 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-cohort-analysis
GitHub stars
194
Token cost
~1.3k tokens
SKILL.md length
362 words
Files
1
Skills in repo
116
Repo updated
First seen
Licence
MIT

At a glance

Read-only: groups customers by first-purchase month and tracks repeat purchase rate and revenue per cohort.

  • Works in 3 steps: OPERATION: customers — query → OPERATION: orders — query → Group customers by first-order month…
  • Tasks that involve Product analytics
  • SKILL.md covers Purpose, Prerequisites, Parameters and Safety, plus 6 more sections
  • Calls shopify

What it does

Shopify Admin Customer Cohort Analysis is an agent skill from 40RTY-ai/shopify-admin-skills. Read-only: groups customers by first-purchase month and tracks repeat purchase rate and revenue per cohort.

Its SKILL.md is about 1.3k 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 Data & Analytics, covering Product analytics. 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 Product analytics

Example prompts

  • “/shopify-admin-customer-cohort-analysis”

Requirements

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

Workflow steps

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

  1. OPERATION: customers — query
  2. OPERATION: orders — query
  3. Group customers by first-order month (cohort); for each cohort, calculate repeat purchase rate and total revenue in months 1, 2, 3+

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 Cohort Analysis loads about 1.3k tokens when it runs. Until then it costs about 37 tokens; SKILL.md has 362 words of instructions outside code blocks.

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

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). 362 words, ~1,345 tokens.

Download SKILL.mdSave it as .claude/skills/shopify-admin-customer-cohort-analysis/SKILL.md (or your agent's skills folder).
name
shopify-admin-customer-cohort-analysis
description
Read-only: groups customers by first-purchase month and tracks repeat purchase rate and revenue per cohort.
compatibility
Claude Code, Cursor, Codex, Gemini CLI
role
customer-ops
toolkit
shopify-admin, shopify-admin-execution
api_version
2025-01
graphql_operations
customers:query, orders:query
status
stable

Purpose

Groups customers by the month of their first purchase and tracks how each cohort performs over time: how many customers repurchase, how many orders they place, and how much revenue each cohort generates in subsequent months. Cohort analysis is the gold standard for measuring retention and the health of a subscription or loyalty program. Read-only — no mutations.

Prerequisites

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

Parameters

ParameterTypeRequiredDefaultDescription
storestringyes—Store domain (e.g., mystore.myshopify.com)
cohort_monthsintegerno6Number of months of cohorts to analyze
follow_monthsintegerno3Number of months to follow each cohort after acquisition
formatstringnohumanOutput format: human or json

Safety

ℹ️ Read-only skill — no mutations are executed. Safe to run at any time.

Workflow Steps

  1. OPERATION: customers — query Inputs: query: "created_at:>='<NOW - cohort_months months>'", first: 250, select id, createdAt, numberOfOrders, pagination cursor Expected output: Customers acquired in the cohort window

  2. OPERATION: orders — query Inputs: query: "created_at:>='<NOW - cohort_months + follow_months months>'", first: 250, select customer { id }, createdAt, totalPriceSet, pagination cursor Expected output: All orders to build per-customer purchase timeline

  3. Group customers by first-order month (cohort); for each cohort, calculate repeat purchase rate and total revenue in months 1, 2, 3+

GraphQL Operations

graphql
# customers:query — validated against api_version 2025-01
query CohortCustomers($query: String!, $after: String) {
  customers(first: 250, after: $after, query: $query) {
    edges {
      node {
        id
        createdAt
        numberOfOrders
        amountSpent {
          amount
          currencyCode
        }
        defaultEmailAddress {
          emailAddress
        }
      }
    }
    pageInfo {
      hasNextPage
      endCursor
    }
  }
}
graphql
# orders:query — validated against api_version 2025-01
query CohortOrders($query: String!, $after: String) {
  orders(first: 250, after: $after, query: $query) {
    edges {
      node {
        id
        createdAt
        totalPriceSet {
          shopMoney {
            amount
            currencyCode
          }
        }
        customer {
          id
        }
      }
    }
    pageInfo {
      hasNextPage
      endCursor
    }
  }
}
Show full SKILL.md (149 more words)Show less

Session Tracking

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

On start, emit:

╔══════════════════════════════════════════════╗
║  SKILL: Customer Cohort Analysis             ║
║  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):

══════════════════════════════════════════════
CUSTOMER COHORT ANALYSIS
  Cohort months analyzed:  <n>
  Total customers tracked: <n>

  Cohort      Acquired  M+1 Repeat  M+2 Repeat  M+3 Repeat
  ──────────────────────────────────────────────────────────
  2026-01     <n>       <pct>%       <pct>%       <pct>%
  2026-02     <n>       <pct>%       <pct>%       <pct>%
  Output: cohort_analysis_<date>.csv
══════════════════════════════════════════════

For format: json, emit:

json
{
  "skill": "customer-cohort-analysis",
  "store": "<domain>",
  "cohorts": [],
  "output_file": "cohort_analysis_<date>.csv"
}

Output Format

CSV file cohort_analysis_<YYYY-MM-DD>.csv with columns: cohort_month, customers_acquired, repeat_purchasers, repeat_rate_pct, total_revenue, revenue_per_customer, month_offset

Error Handling

ErrorCauseRecovery
THROTTLEDAPI rate limit exceededWait 2 seconds, retry up to 3 times
Insufficient historyStore newer than cohort windowAnalyze available months only
Guest checkout ordersNo customer recordExclude from cohort tracking

Best Practices

  • A healthy ecommerce business typically sees 20–40% of first-month customers repeat within 90 days — use this as a benchmark.
  • Declining repeat rates in recent cohorts may signal product quality issues, CX friction, or increased competition.
  • Use follow_months: 6 for subscription-oriented businesses where the repeat window is longer.
  • Pair with customer-spend-tier-tagger — customers from high-repeat cohorts are your best candidates for the Gold/Platinum tier.

© 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-cohort-analysis of 40RTY-ai/shopify-admin-skills.

Open the folder on GitHubat commit 6765cb4

Compare with similar skills

Shopify Admin Customer Cohort Analysis 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 Cohort Analysis compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Shopify Admin Customer Cohort Analysis this skill40RTY-ai/shopify-admin-skills194—~1.3kAutomated safety check: PassMIT
Analytics Tracking Automationjtrackingai/analytics-tracking-automation142—~2.8kAutomated safety check: PassApache-2.0
13 Data Analysis Globalminhnv0807/ai-business-skills609—~4kAutomated safety check: PassMIT
PostHog CLI Queriesdebugtheworldbot/keyStats1.5k—~1.2kAutomated safety check: PassMIT
Retentioneering Contributingretentioneering/retentioneering-tools927—~1.8kAutomated safety check: PassApache-2.0
Retentioneering Product Analyticsretentioneering/retentioneering-tools927—~1.6kAutomated safety check: PassApache-2.0

Similar skills

  • Analytics Tracking Automation

    jtrackingai/analytics-tracking-automation

    A skill your agent uses when you need GA4 + GTM tracking delivery from site discovery through publish, or when the right phase entry point is still unclear.

    142 GitHub stars~2.8k tokensUpdated 5 mo ago
    Data & AnalyticsAuto-check passed
  • 13 Data Analysis Global

    minhnv0807/ai-business-skills

    A skill your agent uses when raw data exists — Meta, Google, TikTok, GA4, Shopify, a CRM export, or a spreadsheet — and has to become insight and decisions: descriptive, diagnostic, predictive, and…

    609 GitHub stars~4k tokensUpdated 29 days ago
    Data & AnalyticsAuto-check passed
  • PostHog CLI Queries

    debugtheworldbot/keyStats

    Runs HogQL queries against this project's PostHog data from the terminal using posthog-cli, with bundled scripts for dashboard metadata the CLI itself has no command for.

    1.5k GitHub stars~1.2k tokensUpdated 8 days ago
    Data & AnalyticsAuto-check passed
  • Retentioneering Contributing

    retentioneering/retentioneering-tools

    Help the user turn their Retentioneering ideas, friction reports, bug findings, or feature needs into high-quality upstream contributions: from capturing and validating the idea, through minimal…

    927 GitHub stars~1.8k tokensUpdated 3 days ago
    Data & AnalyticsAuto-check passed
  • Retentioneering Product Analytics

    retentioneering/retentioneering-tools

    Analyze event logs, clickstreams, user paths, product funnels, retention, behavioral segments, transition graphs, step matrices, sequence patterns, and customer journeys using Retentioneering.

    927 GitHub stars~1.6k tokensUpdated 3 days ago
    Data & AnalyticsAuto-check passed
  • Official

    Plans which analytics events and properties a new feature needs, checks them against the existing event registry, and verifies them per environment.

    5.1k GitHub stars~2.2k tokensUpdated yesterday
    Data & AnalyticsAuto-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

Questions about Shopify Admin Customer Cohort Analysis

What does Shopify Admin Customer Cohort Analysis do?

Read-only: groups customers by first-purchase month and tracks repeat purchase rate and revenue per cohort. Shopify Admin Customer Cohort Analysis is an agent skill from 40RTY-ai/shopify-admin-skills. Read-only: groups customers by first-purchase month and tracks repeat purchase rate and revenue per cohort.

When should I use Shopify Admin Customer Cohort Analysis?

Shopify Admin Customer Cohort Analysis fits situations like: tasks that involve Product analytics.

How do I install Shopify Admin Customer Cohort Analysis in Claude Code?

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

How do I install Shopify Admin Customer Cohort Analysis in Codex?

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

Can I use Shopify Admin Customer Cohort Analysis 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-cohort-analysis -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-cohort-analysis, .gemini/skills/shopify-admin-customer-cohort-analysis, .github/skills/shopify-admin-customer-cohort-analysis and .opencode/skills/shopify-admin-customer-cohort-analysis in your project.

What does Shopify Admin Customer Cohort Analysis need to run?

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

Does Shopify Admin Customer Cohort Analysis 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 Cohort Analysis 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 Cohort Analysis use?

Shopify Admin Customer Cohort Analysis 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 Cohort Analysis use?

About 1.3k tokens (SKILL.md is roughly 5.4k 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 Cohort Analysis?

Skills that share tags, products or a category with Shopify Admin Customer Cohort Analysis: Analytics Tracking Automation (jtrackingai/analytics-tracking-automation, 142 stars), 13 Data Analysis Global (minhnv0807/ai-business-skills, 609 stars), PostHog CLI Queries (debugtheworldbot/keyStats, 1.5k stars) and Retentioneering Contributing (retentioneering/retentioneering-tools, 927 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 Cohort Analysis?

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.