Agent skill

Shopify Admin Subscription Mrr Tracker

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

Read-only: for stores with subscription products, calculates MRR, ARR, active subscriber count, and rolling churn rate from subscription contracts.

MITAuto-check passed

Install Shopify Admin Subscription Mrr Tracker

skills CLI
$ npx skills add 40RTY-ai/shopify-admin-skills --skill shopify-admin-subscription-mrr-tracker -a claude-code

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

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

At a glance

Read-only: for stores with subscription products, calculates MRR, ARR, active subscriber count, and rolling churn rate from subscription contracts.

  • Works in 6 steps: OPERATION: subscriptionContracts — query → Classify each contract by status:… → Compute mrr_contribution for each active… → …
  • SKILL.md covers Purpose, Prerequisites, Parameters and Safety, plus 7 more sections
  • Calls shopify

What it does

Shopify Admin Subscription Mrr Tracker is an agent skill from 40RTY-ai/shopify-admin-skills. Read-only: for stores with subscription products, calculates MRR, ARR, active subscriber count, and rolling churn rate from subscription contracts.

Its SKILL.md is about 2.1k 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 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.

Example prompts

  • “/shopify-admin-subscription-mrr-tracker”

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: subscriptionContracts — query
  2. Classify each contract by status: ACTIVE, PAUSED, CANCELLED, EXPIRED, FAILED
  3. Compute mrr_contribution for each active (and paused if requested) contract using the model above
  4. Aggregate MRR / ARR / subscribers / ARPU
  5. For churn: count cancellations where updatedAt is within churn_window_days and status moved to CANCELLED; count contracts that existed and…
  6. Build a per-product breakdown so finance can see which subscription SKUs drive MRR

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 Subscription Mrr Tracker loads about 2.1k tokens when it runs. Until then it costs about 47 tokens; SKILL.md has 605 words of instructions outside code blocks.

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

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). 605 words, ~2,076 tokens.

Download SKILL.mdSave it as .claude/skills/shopify-admin-subscription-mrr-tracker/SKILL.md (or your agent's skills folder).
name
shopify-admin-subscription-mrr-tracker
description
Read-only: for stores with subscription products, calculates MRR, ARR, active subscriber count, and rolling churn rate from subscription contracts.
compatibility
Claude Code, Cursor, Codex, Gemini CLI
role
finance
toolkit
shopify-admin, shopify-admin-execution
api_version
2025-01
graphql_operations
subscriptionContracts:query
status
stable

Purpose

For stores selling subscription products via Shopify's native subscriptions, this skill aggregates active subscription contracts into the standard SaaS-style metrics finance teams care about: monthly recurring revenue (MRR), annualized recurring revenue (ARR), active subscriber count, average revenue per subscriber (ARPU), and a rolling churn rate. Read-only — no mutations.

Prerequisites

  • Authenticated Shopify CLI session: shopify store auth --store <domain> --scopes read_own_subscription_contracts
  • API scopes: read_own_subscription_contracts

Parameters

ParameterTypeRequiredDefaultDescription
storestringyes—Store domain (e.g., mystore.myshopify.com)
churn_window_daysintegerno30Rolling window for churn calculation (cancellations / starting subscribers)
as_ofstringnotoday (UTC)ISO date for "as of" snapshot label
include_pausedboolnofalseTreat PAUSED contracts as active recurring revenue
formatstringnohumanOutput format: human or json

Safety

ℹ️ Read-only skill — no mutations are executed. This skill is only meaningful if the store sells subscription products. If subscriptionContracts returns 0 contracts, the report exits with $0 MRR — that is the correct answer, not an error.

Recurring Revenue Model

For each subscription contract, the contribution to MRR depends on its billing interval:

billing_amount = sum(line.currentPrice × line.quantity) for each line in contract
mrr_contribution =
  billing_amount                       if interval = MONTH and intervalCount = 1
  billing_amount / intervalCount       if interval = MONTH (e.g., every 3 months → /3)
  billing_amount × 4.345               if interval = WEEK (avg weeks per month)
  billing_amount × 4.345 / intervalCount if interval = WEEK with intervalCount > 1
  billing_amount / 12                  if interval = YEAR
  billing_amount × 30 / intervalCount  if interval = DAY

Aggregations:

  • MRR = Σ mrr_contribution for all ACTIVE (and PAUSED if include_paused) contracts
  • ARR = MRR × 12
  • Active subscribers = unique customer.id count
  • ARPU = MRR / active subscribers
  • Churn rate (period) = contracts cancelled inside churn_window_days ÷ contracts that were active at the start of the window
  • Net new subscribers = new contracts inside the window − cancelled contracts inside the window

Workflow Steps

  1. OPERATION: subscriptionContracts — query Inputs: first: 250, select id, status, createdAt, updatedAt, nextBillingDate, customer { id, displayName }, currencyCode, billingPolicy { interval, intervalCount }, lines { edges { node { currentPrice { amount, currencyCode }, quantity, productId, variantId, title } } }, pagination cursor Expected output: All subscription contracts; paginate until hasNextPage: false

  2. Classify each contract by status: ACTIVE, PAUSED, CANCELLED, EXPIRED, FAILED

  3. Compute mrr_contribution for each active (and paused if requested) contract using the model above

  4. Aggregate MRR / ARR / subscribers / ARPU

  5. For churn: count cancellations where updatedAt is within churn_window_days and status moved to CANCELLED; count contracts that existed and were ACTIVE at as_of - churn_window_days

  6. Build a per-product breakdown so finance can see which subscription SKUs drive MRR

GraphQL Operations

graphql
# subscriptionContracts:query — validated against api_version 2025-01
query SubscriptionMRR($after: String) {
  subscriptionContracts(first: 250, after: $after) {
    edges {
      node {
        id
        status
        createdAt
        updatedAt
        nextBillingDate
        currencyCode
        customer {
          id
          displayName
          defaultEmailAddress { emailAddress }
        }
        billingPolicy { interval intervalCount minCycles maxCycles }
        deliveryPolicy { interval intervalCount }
        lines(first: 50) {
          edges {
            node {
              id
              productId
              variantId
              title
              quantity
              currentPrice { amount currencyCode }
            }
          }
        }
      }
    }
    pageInfo { hasNextPage endCursor }
  }
}

Session Tracking

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

On start, emit:

╔══════════════════════════════════════════════╗
║  SKILL: Subscription MRR Tracker             ║
║  Store: <store domain>                       ║
║  As of: <YYYY-MM-DD>                         ║
║  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):

══════════════════════════════════════════════
SUBSCRIPTION MRR REPORT  (as of <date>)
  Active contracts:        <n>
  Paused contracts:        <n>
  Cancelled (last <n>d):   <n>
  ─────────────────────────────
  MRR:                     $<amount>
  ARR:                     $<amount>
  Active subscribers:      <n>
  ARPU:                    $<amount>
  Churn rate (<n>d):       <pct>%
  Net new (<n>d):          <n>

  Top subscription products by MRR:
    "<title>"   Subs: <n>   MRR: $<n>
    "<title>"   Subs: <n>   MRR: $<n>

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

For format: json, emit:

json
{
  "skill": "subscription-mrr-tracker",
  "store": "<domain>",
  "as_of": "<YYYY-MM-DD>",
  "active_contracts": 0,
  "paused_contracts": 0,
  "cancelled_in_window": 0,
  "mrr": 0,
  "arr": 0,
  "active_subscribers": 0,
  "arpu": 0,
  "churn_rate_pct": 0,
  "net_new": 0,
  "currency": "USD",
  "by_product": [],
  "output_file": "subscription_mrr_<date>.csv"
}
Show full SKILL.md (228 more words)Show less

Output Format

CSV file subscription_mrr_<YYYY-MM-DD>.csv with columns: contract_id, status, customer_id, customer_email, created_at, next_billing_date, interval, interval_count, billing_amount, mrr_contribution, currency, product_titles

Error Handling

ErrorCauseRecovery
THROTTLEDAPI rate limit exceededWait 2 seconds, retry up to 3 times
subscriptionContracts emptyStore has no subscription productsExit cleanly — report $0 MRR; this is the correct value, not an error
Multi-currency contractsDifferent currencyCode per contractGroup MRR per currency; do not sum across currencies — surface separately in output
Pre-paid contracts (maxCycles set)Customer paid upfront for N cyclesStill contributes to MRR while ACTIVE, but the contract will end after maxCycles; flag in output

Best Practices

  • This skill is only meaningful if the store actually sells subscription products. If you don't run subscriptions, MRR will be $0 — that's correct.
  • Run on the first day of every month so MRR snapshots align with finance's monthly close cadence.
  • Track MRR week-over-week to catch payment-failure spikes early — FAILED contracts that don't recover become churn within 30 days.
  • Pre-paid annual subscriptions inflate ARR without inflating cash flow in any given month — keep them separate when reporting to investors who want a cash-flow view.
  • Pair with churn-risk-scorer (transactional churn) to triangulate subscription churn vs. one-time-purchase churn — they deserve separate retention strategies.
  • Multi-currency stores: report MRR per currency; converting via spot FX rates produces a misleading number that fluctuates with exchange rates rather than business performance.

© 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/finance/shopify-admin-subscription-mrr-tracker of 40RTY-ai/shopify-admin-skills.

Open the folder on GitHubat commit 6765cb4

Compare with similar skills

Shopify Admin Subscription Mrr Tracker 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 Subscription Mrr Tracker compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Shopify Admin Subscription Mrr Tracker this skill40RTY-ai/shopify-admin-skills194—~2.1kAutomated safety check: PassMIT
ShopifyShopify/Shopify-AI-Toolkit592—~4.2kAutomated safety check: PassMIT
E-commerce Visual Copywritingfeichanggege/ecommerce-visual-copywriting-skill867—~1.3kAutomated safety check: PassMIT
Reviewing Pull RequestsShopify/shopify-app-js541—~1.9kAutomated safety check: PassMIT
Better Designmarvkr/better-design254—~1.2kAutomated safety check: PassMIT
Liquid Theme A11ybenjaminsehl/liquid-skills120—~3.2kAutomated safety check: PassNone

Similar skills

  • Shopify

    Shopify/Shopify-AI-Toolkit

    Official

    Build anything on Shopify. An agent skill from Shopify/Shopify-AI-Toolkit.

    592 GitHub stars~4.2k tokensUpdated 2 days ago
    Backend & APIsAuto-check passed
  • E-commerce Visual Copywriting

    feichanggege/ecommerce-visual-copywriting-skill

    Turns product details, packaging, target platform and audience into an executable e-commerce image plan with copy, storyboards, image prompts and a compliance review.

    867 GitHub stars~1.3k tokensUpdated 23 days ago
    Writing & ContentAuto-check passed
  • Reviewing Pull Requests

    Shopify/shopify-app-js

    Official

    Reviews pull requests for Shopify/shopify-app-js with comprehensive analysis including semver compliance (MAJOR/MINOR/PATCH classification), single responsibility validation, pattern consistency…

    541 GitHub stars~1.9k tokensUpdated today
    DevelopmentAuto-check passed
  • Better Design

    marvkr/better-design

    Build, improve, and review production interfaces with the Better Design MCP.

    254 GitHub stars~1.2k tokensUpdated 17 days ago
    Frontend & DesignAuto-check passed
  • Liquid Theme A11y

    benjaminsehl/liquid-skills

    Implement WCAG 2.2 accessibility patterns in Shopify Liquid themes.

    120 GitHub stars~3.2k tokensUpdated 2 mo ago
    Frontend & DesignAuto-check passed
  • 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

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 Subscription Mrr Tracker

What does Shopify Admin Subscription Mrr Tracker do?

Read-only: for stores with subscription products, calculates MRR, ARR, active subscriber count, and rolling churn rate from subscription contracts. Shopify Admin Subscription Mrr Tracker is an agent skill from 40RTY-ai/shopify-admin-skills. Read-only: for stores with subscription products, calculates MRR, ARR, active subscriber count, and rolling churn rate from subscription contracts.

How do I install Shopify Admin Subscription Mrr Tracker in Claude Code?

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

How do I install Shopify Admin Subscription Mrr Tracker in Codex?

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

Can I use Shopify Admin Subscription Mrr Tracker 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-subscription-mrr-tracker -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-subscription-mrr-tracker, .gemini/skills/shopify-admin-subscription-mrr-tracker, .github/skills/shopify-admin-subscription-mrr-tracker and .opencode/skills/shopify-admin-subscription-mrr-tracker in your project.

What does Shopify Admin Subscription Mrr Tracker need to run?

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

Does Shopify Admin Subscription Mrr Tracker 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 Subscription Mrr Tracker 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 Subscription Mrr Tracker use?

Shopify Admin Subscription Mrr Tracker 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 Subscription Mrr Tracker use?

About 2.1k tokens (SKILL.md is roughly 8.3k 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 Subscription Mrr Tracker?

Skills that share tags, products or a category with Shopify Admin Subscription Mrr Tracker: Shopify (Shopify/Shopify-AI-Toolkit, 592 stars), E-commerce Visual Copywriting (feichanggege/ecommerce-visual-copywriting-skill, 867 stars), Reviewing Pull Requests (Shopify/shopify-app-js, 541 stars) and Better Design (marvkr/better-design, 254 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Shopify Admin Subscription Mrr Tracker?

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.