🌟 Introduction
The Rolling 30 Day Usage Report template provides a simple way to calculate two usage periods (0-30 days and 30-60 days) by a selected dimension. This template is designed to analyze product usage over a rolling 30-day period and compare the usage metrics on a month-over-month basis.
💼 Business Impact
Identifying important changes in customer behavior can be challenging for teams without trend analyses.
Conducting trend analyses can be complex and demanding.
This template addresses these challenges by providing data teams with a simplified and user-friendly approach to comparing two rolling periods for a time dataset. The template also enables the integration of change insights into relevant areas where they are most needed, ensuring that actionable information is readily available to decision-makers and stakeholders.
📥 Data In
Source: Database
Example: Product Events Records
📤 Data Out
The Rolling 30 Day Usage Report delivers the following insights:
What is the rolling 30-day usage of events? This metric provides an overview of the total number of usage events recorded within the most recent 30-day period.
What is the month-over-month comparison of those events? This metric compares the number of events in the last 30 days with the number of events in the previous 30-60 days period, providing a month-over-month comparison of usage events.
📊 Metrics
The Rolling 30 Day Usage Report includes the following metrics:
Number of Events in Last 30 Days
Number of Events in 30-60 Days
Month-over-Month Number Change
Month-over-Month Percentage Change
📝 Template Setup
Next, you'll need to make several key selections:
Step 1: Data Input
📥 In this step, replace the placeholder Events Source with the actual source of your events data.
Step 2: Destination
Our suggestion is to configure your output to a Google Sheets file or a database. Choose the destination that best suits your needs.