Analysis / Ecommerce and retail
Analyze subscription commerce renewal cohorts
Analyze uploaded subscription renewals by cohort and cycle, separating pauses, cancellations and incomplete windows without native Connection claims.
Ecommerce operator · Retail analyst
Bring this question into Chat
Your starting prompt.
Using [uploaded subscription and renewal exports], group subscriptions by start month and compare eligible renewal completion, pauses, cancellations and net sales over [cycles]. Distinguish active, paused and unresolved states, showing denominators and incomplete renewal windows. Produce a cohort review with recorded cancellation reasons where available. Use exports or a configured custom Action for data access, and avoid claiming a native subscription platform Connection.
Copy this starting point, then replace the placeholders with your own inputs.
Method and review
Keep the assumptions visible.
Reconcile orders, refunds, costs and fulfillment at a consistent grain. Use supplied exports when a native Connection is unavailable, and distinguish revenue from contribution.
For this task, check
Paused subscriptions and billing retries need explicit rules before renewal rates are comparable.
This starting prompt has no published worked example yet. Begin with a small sample and check the calculations before relying on the result.
Before you begin
- Bring exports you are allowed to upload, or data your Workspace can already query.
- Choose the reporting period and agree what each record represents.
Work with permitted files or queryable data. Verify the result against the original records.
Take the next step
Make it your investigation.
Copy the prompt above, create or open your Workspace, and paste it into Chat. Add the inputs you have permission to use and adapt the assumptions with your agent.
Start exploringYour prompt is carried by copy and paste. Signing up does not submit it or start this work automatically.
Or start with your own agent
The setup prompt includes this public task. Your agent will help you connect when needed and use the access you approve.