All Collections
Solution Templates
Rolling 30 Day Usage Report
Rolling 30 Day Usage Report

🏷️ Tags: Analytics 🔬Analysis Level: Intermediate

Updated over a week ago

🌟 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

  1. Identifying important changes in customer behavior can be challenging for teams without trend analyses.

  2. Conducting trend analyses can be complex and demanding.

  3. 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:

  1. 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.

  2. 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

  1. 📥 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.

Did this answer your question?