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 cancelations month wise from each plan.
Click RevenueStory > Report Builder.
Select Create a Summary Report.
Select the primary data source as Subscriptions.
Select Canceled 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:
Click RevenueStory > Report Builder.
Select Create a Summary Report.
Select "Monthly Subscription History" as your base datasource.
In Row grouping, add Country from Customers datasource.
In Column grouping, add MRR Changed Date from Monthly Subscription History and group by Month and Year.
In Summarization (aggregation/measure), add MRR (Monthly) from Monthly Subscription History and aggregate using the Sum function.
Click Build Report
This report displays the contraction or expansion MRR trend on a yearly basis. To create this report:
Click RevenueStory > Report Builder.
Select Create a Summary Report.
Select "Yearly Subscription History" as your base datasource.
In Row grouping, Country and Customers from the Customers datasource.
In Column grouping, add MRR Changed Date from Yearly Subscription History and group by Year. ( this is the historical date associated with MRR)
In Summarization (aggregation/measure) add MRR (Yearly) from Yearly Subscription History and aggregate using the Sum function.
Click Build 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.