skills.rest
40RTY-ai
40RTY-aiOFFICIAL
Explore all skills by this author →
WebsiteGitHub

shopify-admin-subscription-mrr-tracker

Calculate MRR, ARR, subscriber counts, ARPU, and churn from Shopify subscription contracts.

174|18|Updated Apr 11, 2026
Search Tags:#subscriptions#graphql#shopify#churn#mrr#revenue analytics#csv reporting
One-click install
npx skills add https://github.com/40RTY-ai/shopify-admin-skills --skill shopify-admin-subscription-mrr-tracker
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: shopify-admin-subscription-mrr-tracker
Source: https://github.com/40RTY-ai/shopify-admin-skills/tree/main/skills/finance/shopify-admin-subscription-mrr-tracker
Command: npx skills add https://github.com/40RTY-ai/shopify-admin-skills --skill shopify-admin-subscription-mrr-tracker

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

It solves the finance-team problem of turning Shopify subscription contract data into consistent SaaS-style recurring revenue metrics like MRR, ARR, subscriber counts, ARPU, and rolling churn.

Core Features & Use Cases

  • Read-only Subscription Metrics: Computes MRR and ARR from subscription contract billing policies without performing any mutations.
  • Subscriber and ARPU Reporting: Derives active subscriber counts and ARPU using unique customer IDs from contract lines.
  • Rolling Churn + Product Breakdown: Calculates churn over a configurable window and produces a per-product MRR view for what drives revenue.

Quick Start

Run this skill for your Shopify store as a monthly snapshot to generate a CSV report of subscription MRR, ARR, active subscribers, ARPU, and churn.

Frequently Asked Questions about shopify-admin-subscription-mrr-tracker

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

FAQPage Schema
How do I calculate Shopify subscription MRR from subscription contracts?▼

Shopify subscription MRR is calculated by applying a deterministic billing-interval model to convert contract line pricing into monthly-equivalent recurring revenue.

How do I track active subscribers and ARPU for Shopify subscription products?▼

Active subscribers and ARPU are tracked by deriving unique customer IDs from subscription contract lines to compute average revenue per user.

Can I generate CSV reporting for Shopify churn and ARR?▼

Yes, CSV reporting is generated by computing rolling churn over a configurable window and calculating annual recurring revenue for monthly finance snapshots.

Do I need read_own_subscription_contracts access for Shopify revenue analytics?▼

Yes, authenticated read access to read_own_subscription_contracts is required to query subscription contract billing policies and compute finance-grade metrics.

How does the subscription MRR tracker handle paused contracts?▼

Paused contracts are supported through an optional inclusion setting, allowing you to decide whether they count toward active subscriber counts and MRR totals.

Can I break down Shopify subscription MRR by product for retention analysis?▼

Yes, a per-product MRR view is generated to identify what drives revenue and support ongoing retention analysis during your monthly close.

Related Skills

Explore More Finance & Accounting Skills→
gerald-icagerald-ica

shopify-development

Develop Shopify apps, UI extensions, themes, and Functions with OAuth and GraphQL.

Community
Advanced
Xipher-LabsXipher-Labs
6

saas-metrics-dashboard

Compute SaaS metrics and diagnose unit economics from CSV or YAML inputs.

Official
Intermediate
aisa-groupaisa-group
90

paypal-integration

Integrate PayPal REST APIs for checkout, subscriptions, IPN verification, and refunds.

Official
Advanced
40RTY-ai40RTY-ai
174

shopify-admin-discount-ab-analysis

Compares Shopify discount codes by redemption counts and revenue for date ranges via GraphQL queries.

Official
Intermediate