Workflow · Sales and growth · Opening soon
Feature usage by plan
See feature usage by plan from your Mixpanel exports. Count accounts on each plan that used each feature this month.
Someone typed
“show how many accounts on each plan used each feature this month”
The agent read it as
Show how many accounts on each plan used each feature this month in Mixpanel feature usage this month and Mixpanel accounts table.
What the agent built
4 steps, each one an ordinary Mammoth step you can open and change.
File
Mixpanel feature usage this month
CSV export · 44 rows
File
Mixpanel accounts table
CSV export · 20 rows
Step
Make account key
Step 1
Step
Make usage account key
Step 2
Join
Add account plans
44 of 44 paired
Step
Count accounts by plan and feature
Step 4
Result
Feature Usage by Plan
15 rows
Schedule
Runs when you say
Proposed
- FileMixpanel feature usage this monthCSV export · 44 rows
- FileMixpanel accounts tableCSV export · 20 rows
- StepMake usage account keyStep 2
- StepMake account keyStep 1
- JoinAdd account plans44 of 44 paired
- StepCount accounts by plan and featureStep 4
- ResultFeature Usage by Plan15 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 15 rows came out, and the join paired 44 of 44 rows.
- Download Mixpanel feature usage this month sample (44 rows)Mixpanel: Events > Export CSV for this month, grouped by account and feature
- Download Mixpanel accounts table sample (20 rows)Mixpanel: Users > Export CSV with account properties
What you get back
The result of that run, the rows to look at first.
Feature Usage by PlanSample data15 rows
| Feature | Plan | Accounts |
|---|---|---|
| dashboard | starter | 4 |
| exports | starter | 2 |
| alerts | growth | 3 |
| reports | growth | 5 |
| alerts | business | 3 |
| reports | business | 3 |
| automations | business | 2 |
| automations | growth | 2 |
| reports | starter | 3 |
| alerts | starter | 2 |
| dashboard | growth | 5 |
| exports | growth | 3 |
How do you show how many accounts on each plan used each feature this month?
Export your feature usage this month from Mixpanel and your accounts table from Mixpanel. Match each usage row to an account, add the plan, then count accounts by plan and feature. The result shows feature usage by plan for this month.
How it works
How to use the Feature Usage by Plan workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Feature Usage by Plan: questions
What export should you use?
Use the feature usage export for this month and the accounts table export. The usage file should list feature events or feature usage rows, and the accounts file should include account keys and plan names.
What happens to rows that do not match?
Rows that do not match a key stay out of the matched result for that step. You can review them and decide whether the key needs to be changed or the source file needs to be updated.
How do you change the rules?
Edit the steps in words, such as which column is the account key, how usage rows should match accounts, and how the plan should be grouped. Then run the workflow again with the updated exports.
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Measure how fast the pipeline turns into revenue, and where people drop out of your funnel.
- Customer segmentation by revenueSegment Stripe customers into revenue tiers from exported customer, charge, and threshold files, then count customers and revenue in each tier.See the workflow Built by the agent
- Sales velocityEach rep's open deals, win rate, deal size, sales cycle and velocity, and the team'sSee the workflow Template
- Funnel analysisHow many people reach each step of your funnel, in order, and where they drop offSee the workflow Template
- Sales forecast from pipelineForecast this quarter’s sales from a HubSpot export, using stage probability, close month, and closed won revenue.See the workflow Built by the agent
- Survey results analysisSummarize Typeform survey responses by question and respondent segment, with score averages and response counts.See the workflow Built by the agent
- Time to first valueMeasure how many days new accounts take to reach their first key action, grouped by signup week, from a Mixpanel events export.See the workflow Built by the agent