Agent skill

Shopify Admin Churn Risk Scorer

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

Read-only: scores customers by churn probability based on purchase recency, frequency decay, and expected repurchase intervals.

MITAuto-check passedSales & Support

Install Shopify Admin Churn Risk Scorer

skills CLI
$ npx skills add 40RTY-ai/shopify-admin-skills --skill shopify-admin-churn-risk-scorer -a claude-code

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

GitHub CLI
$ gh skill install 40RTY-ai/shopify-admin-skills shopify-admin-churn-risk-scorer --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-churn-risk-scorer .claude/skills/shopify-admin-churn-risk-scorer && 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-churn-risk-scorer
GitHub stars
194
Token cost
~1.5k tokens
SKILL.md length
455 words
Files
1
Skills in repo
116
Repo updated
First seen
Licence
MIT

At a glance

Read-only: scores customers by churn probability based on purchase recency, frequency decay, and expected repurchase intervals.

  • Works in 5 steps: Average Purchase Interval (API) = total… → Days Since Last Order (DSLO) = today -… → Overdue Ratio = DSLO / API → …
  • Tasks that involve Customer success
  • SKILL.md covers Purpose, Prerequisites, Parameters and Safety, plus 7 more sections
  • Calls shopify

What it does

Shopify Admin Churn Risk Scorer is an agent skill from 40RTY-ai/shopify-admin-skills. Read-only: scores customers by churn probability based on purchase recency, frequency decay, and expected repurchase intervals.

Its SKILL.md is about 1.5k 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 Sales & Support, covering Customer success. 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 Customer success

Example prompts

  • “/shopify-admin-churn-risk-scorer”

Requirements

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

Workflow steps

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

  1. Average Purchase Interval (API) = total days between first and last order / (order_count - 1)
  2. Days Since Last Order (DSLO) = today - last_order_date
  3. Overdue Ratio = DSLO / API
  4. Churn Risk Score (0-100)
  5. Customer Lifetime Value (CLV) = total spend / customer age in years × expected remaining years

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 Churn Risk Scorer loads about 1.5k tokens when it runs. Until then it costs about 40 tokens; SKILL.md has 455 words of instructions outside code blocks.

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

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). 455 words, ~1,496 tokens.

Download SKILL.mdSave it as .claude/skills/shopify-admin-churn-risk-scorer/SKILL.md (or your agent's skills folder).
name
shopify-admin-churn-risk-scorer
description
Read-only: scores customers by churn probability based on purchase recency, frequency decay, and expected repurchase intervals.
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

Predicts which customers are at risk of churning by analyzing their purchase patterns against their historical buying frequency. Calculates an expected next-purchase date for each repeat customer, then scores churn risk based on how overdue they are. Read-only — no mutations.

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
days_backintegerno365Historical window for purchase pattern analysis
min_ordersintegerno2Minimum orders to calculate purchase interval (need 2+ for frequency)
risk_thresholdfloatno1.5Multiplier of avg purchase interval before flagging as at-risk
formatstringnohumanOutput format: human or json

Safety

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

Churn Risk Scoring Model

For each customer with min_orders or more purchases:

  1. Average Purchase Interval (API) = total days between first and last order / (order_count - 1)
  2. Days Since Last Order (DSLO) = today - last_order_date
  3. Overdue Ratio = DSLO / API
  4. Churn Risk Score (0-100):
    • Overdue ratio ≤ 1.0 → Score 0-20 (Active)
    • Overdue ratio 1.0–1.5 → Score 20-50 (Cooling)
    • Overdue ratio 1.5–2.5 → Score 50-80 (At Risk)
    • Overdue ratio > 2.5 → Score 80-100 (Likely Churned)
  5. Customer Lifetime Value (CLV) = total spend / customer age in years × expected remaining years

Workflow Steps

  1. OPERATION: orders — query Inputs: query: "created_at:>='<NOW - days_back days>'", first: 250, select createdAt, totalPriceSet, customer { id, email, firstName, lastName }, pagination cursor Expected output: All orders with customer association

  2. Group orders by customer, calculate per customer:

    • Order dates (sorted chronologically)
    • Average purchase interval
    • Days since last order
    • Total spend
    • Order count
  3. OPERATION: customers — query (enrichment) Inputs: Customer IDs for at-risk and likely-churned segments Expected output: Contact details, tags, total spend

  4. Calculate churn risk score and classify into segments

  5. Estimate revenue at risk = sum of (annual_spend × churn_probability) for at-risk customers

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

GraphQL Operations

graphql
# orders:query — validated against api_version 2025-01
query OrdersForChurnAnalysis($query: String!, $after: String) {
  orders(first: 250, after: $after, query: $query) {
    edges {
      node {
        createdAt
        totalPriceSet { shopMoney { amount currencyCode } }
        customer {
          id
          email
          firstName
          lastName
          numberOfOrders
        }
      }
    }
    pageInfo { hasNextPage endCursor }
  }
}
graphql
# customers:query — validated against api_version 2025-01
query AtRiskCustomers($ids: [ID!]!) {
  nodes(ids: $ids) {
    ... on Customer {
      id
      email
      firstName
      lastName
      totalSpentV2 { amount currencyCode }
      numberOfOrders
      tags
      createdAt
    }
  }
}

Session Tracking

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

On start, emit:

╔══════════════════════════════════════════════╗
║  SKILL: Churn Risk Scorer                    ║
║  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):

══════════════════════════════════════════════
CHURN RISK REPORT  (<days_back> days analyzed)
  Repeat customers scored:  <n>
  ─────────────────────────────
  Active (score 0-20):      <n> (<pct>%)
  Cooling (score 20-50):    <n> (<pct>%)
  At Risk (score 50-80):    <n> (<pct>%)   ⚠️
  Likely Churned (80-100):  <n> (<pct>%)   🔴

  Revenue at risk:         $<amount>/year

  Top at-risk by value:
    <name> (<email>)  Score: <n>  Last order: <date>  Lifetime: $<n>

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

Output Format

CSV file churn_risk_<YYYY-MM-DD>.csv with columns: customer_id, email, first_name, last_name, order_count, total_spent, avg_purchase_interval_days, days_since_last_order, overdue_ratio, churn_risk_score, risk_segment, expected_annual_value

Error Handling

ErrorCauseRecovery
THROTTLEDAPI rate limit exceededWait 2 seconds, retry up to 3 times
Single-purchase customersCan't calculate intervalExclude from scoring (need 2+ orders)
Guest ordersNo customer linkageSkip — cannot build customer profile

Best Practices

  • Pair with customer-win-back skill to take action on At-Risk and Likely Churned segments.
  • Use with rfm-customer-segmentation for a more holistic view of customer health.
  • High-value churning customers (top 20% by spend) should get personalized outreach.
  • Export At-Risk segment to email marketing platform for automated win-back sequences.
  • Adjust risk_threshold based on your product type: consumables (1.3), fashion (1.5), furniture (2.0).

© 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-churn-risk-scorer of 40RTY-ai/shopify-admin-skills.

Open the folder on GitHubat commit 6765cb4

Compare with similar skills

Shopify Admin Churn Risk Scorer 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 Churn Risk Scorer compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Shopify Admin Churn Risk Scorer this skill40RTY-ai/shopify-admin-skills194—~1.5kAutomated safety check: PassMIT
Checkout Purchasekeypo-us/keypo-cli182—~880Automated safety check: NotesNone
Afaafadtc/afa-dtc-skills168—~3.2kAutomated safety check: PassCustom licence
Expansion Retentiontech-leads-club/agent-skills7k—~5.6kAutomated safety check: PassCustom licence
Competitive Pricing Strategynexscope-ai/eCommerce-Skills1.1k—~2.8kAutomated safety check: PassMIT
Compliancevivy-yi/xiaohongshu-skills481—~1.7kAutomated safety check: PassNone

Similar skills

  • Checkout Purchase

    keypo-us/keypo-cli

    A skill your agent uses when the user asks to buy a product from the Shopify store.

    182 GitHub stars~880 tokensUpdated 6 mo ago
    Sales & SupportAuto-check: notes
  • Afa

    afadtc/afa-dtc-skills

    AFA DTC 全链路独立站操盘系统——系统入口、一级路由器、工作流编排器,统筹品牌基建/付费获客/有机增长/变现留存/运营扩张五大业务线。触发词: 独立站, DTC, 电商, Shopify, 全链路操盘, 独立站诊断, 独立站增长, 90 天增长计划, 不知道从哪开始, 多个问题一起, 帮我做全盘规划, 一件代发, 测品, 测试店, ecommerce, online store, DTC…

    168 GitHub stars~3.2k tokensUpdated 2 days ago
    Sales & SupportAuto-check passed
  • Expansion Retention

    tech-leads-club/agent-skills

    When the user wants to reduce churn, build expansion revenue, automate customer success, or optimize net revenue retention.

    7k GitHub stars~5.6k tokensUpdated 2 days ago
    Sales & SupportAuto-check passed
  • Competitive Pricing Strategy

    nexscope-ai/eCommerce-Skills

    Build an evidence-based competitive pricing strategy for ecommerce products.

    1.1k GitHub stars~2.8k tokensUpdated 1 mo ago
    Sales & SupportAuto-check passed
  • Compliance

    vivy-yi/xiaohongshu-skills

    A skill your agent uses when needing to understand and comply with Xiaohongshu's platform rules, avoid violations, and maintain account health and safety

    481 GitHub stars~1.7k tokensUpdated 8 mo ago
    Sales & SupportAuto-check passed
  • Shopify

    Anil-matcha/awesome-muse-connectors

    Work with your Shopify store: view orders, products, customers; create products and discounts (with confirmation).

    1.3k GitHub stars~1.1k tokensUpdated 5 days ago
    Sales & SupportAuto-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 Churn Risk Scorer

What does Shopify Admin Churn Risk Scorer do?

Read-only: scores customers by churn probability based on purchase recency, frequency decay, and expected repurchase intervals. Shopify Admin Churn Risk Scorer is an agent skill from 40RTY-ai/shopify-admin-skills. Read-only: scores customers by churn probability based on purchase recency, frequency decay, and expected repurchase intervals.

When should I use Shopify Admin Churn Risk Scorer?

Shopify Admin Churn Risk Scorer fits situations like: tasks that involve Customer success.

How do I install Shopify Admin Churn Risk Scorer in Claude Code?

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

How do I install Shopify Admin Churn Risk Scorer in Codex?

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

Can I use Shopify Admin Churn Risk Scorer 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-churn-risk-scorer -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-churn-risk-scorer, .gemini/skills/shopify-admin-churn-risk-scorer, .github/skills/shopify-admin-churn-risk-scorer and .opencode/skills/shopify-admin-churn-risk-scorer in your project.

What does Shopify Admin Churn Risk Scorer need to run?

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

Does Shopify Admin Churn Risk Scorer 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 Churn Risk Scorer 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 Churn Risk Scorer use?

Shopify Admin Churn Risk Scorer 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 Churn Risk Scorer use?

About 1.5k tokens (SKILL.md is roughly 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 Churn Risk Scorer?

Skills that share tags, products or a category with Shopify Admin Churn Risk Scorer: Checkout Purchase (keypo-us/keypo-cli, 182 stars), Afa (afadtc/afa-dtc-skills, 168 stars), Expansion Retention (tech-leads-club/agent-skills, 7k stars) and Competitive Pricing Strategy (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 Churn Risk Scorer?

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.