RevenueStory's Report Builder capability allows you to create reports on your own. We have curated a few essential reports that you can create using Report Builder.
This Summary report displays the total revenue earned each month across different countries.
We are now going to see how to build this report.
Click RevenueStory > Report Builder.
Select Create a Summary Report.
Choose the primary Data Source as Invoices.
Select Paid on field (group them as Year and Month) from Invoices under Column grouping and Country from the Customers data source under Row grouping.
Select the Amount Paid field from Invoices to aggregate the report and apply sum function on it.
Click Build Report.
Next, let us add the Invoice Status (Paid) and Invoice paid on filter.
This is how the report will look like.
As a business owner, you'd want to see the revenue generated for each customer. We are now going to see how to build this report.
Click RevenueStory > Report Builder.
Select Create a Summary Report.
Select the primary Data Source as Invoices.
Select Company from the Customers data source under Row grouping.
Select the Amount Paid field from Invoices to aggregate the report and apply sum function on it.
Click Build Report. This is how the report will look like.
This report will allow you to see the total number of cancellations month wise from each plan.
Click RevenueStory > Report Builder.
Select Create a Summary Report.
Select the primary data source as Subscriptions.
Select Cancelled on field from Subscriptions (grouped them as Year and month) under Column grouping and Current plan from the Subscriptions data source under Row grouping.
Select the Subscription ID from Subscriptions data source to aggregate the report and apply *Count * function on it.
Click Build Report. This is how the report will look like.
The Due Invoices report allows you to view the invoices that are in Due State by customer. Let us now see how to create this report.
Click RevenueStory > Report Builder.
Select Create a Detailed Report.
Select Next Billing on, Subscription status, Subscription ID from the Subscriptions data source, Amount Due, Due Date, Invoice ID, Status from Invoices data source, Email from the Customers data source.
Select Build Report. Next, add the Invoice Status (Payment Due), Invoices Due Date, Subscription Status (Active) as filters.
This is how the final report will look.
This report displays the MRR trend across countries. To create this report:
This report displays the contraction or expansion MRR trend on a yearly basis. To create this report:
We are now going to filter the report to display the Expansion MRR or Contraction MRR. Select MRR Impact Status from Yearly Subscription History. Apply the filter.
