How To View Revenue By Monthly Cohort

Understanding Monthly Revenue Cohorts in Google Analytics 4

Monthly cohort analysis of revenue is crucial for understanding customer lifetime value and identifying which customer groups generate the most revenue over time. By analyzing revenue patterns across different customer cohorts, businesses can better understand customer behavior, optimize acquisition strategies, and improve retention efforts. We'll show you how to create this powerful report in Google Analytics 4.

Basic Report Structure

  • Report Type: Free Form Exploration
  • Primary Dimension: First User Month
  • Secondary Dimension: Month
  • Metrics: Total Revenue
  • Visualization: Cohort table

Steps to Create the Report

  1. Open GA4 and navigate to Explore section
  2. Click the Blank template to start a new exploration
  3. Under the Dimensions click the + button and search for First User Month and Month, check the checkbox beside them and click Confirm
  4. Under the Metrics click the + button and search for Total Revenue, check the checkbox beside it and click Confirm
  5. Drag First User Month to the Rows section
  6. Drag Month to the Columns section
  7. Drag Total Revenue to the Values section
  8. In the settings tab, set your date range to cover at least 6-12 months
  9. Apply a filter to exclude null values if necessary
  10. Optional: Add conditional formatting to highlight significant changes in revenue

Required Dimensions and Metrics

  • First User Month: Shows when users first engaged with your site
  • Month: Displays subsequent months of user activity
  • Total Revenue: Shows the revenue generated by each cohort over time
  • User Count (optional): Helps calculate average revenue per user
  • Purchase Count (optional): Shows purchase frequency by cohort

Actionable Insights

  1. Identify which cohorts have the highest lifetime value and analyze the acquisition channels for these users
  2. Spot trends in revenue decay rates to optimize retention strategies
  3. Compare seasonal cohorts to understand the impact of acquisition timing on long-term value
  4. Use cohort performance data to adjust customer acquisition spending
  5. Identify opportunities for reactivation campaigns based on cohort revenue patterns

Answers Similar Questions

  1. GA4 customer cohort revenue tracking
  2. Track monthly revenue by user acquisition date GA4
  3. Google Analytics 4 revenue cohort analysis
  4. Customer lifetime value cohort report GA4
  5. GA4 monthly customer revenue segmentation

Turn Your GA4 Confusion Into Clarity in 20 Seconds

Stop wasting time in GA4's maze of menus - get all your important data served up on a single, easy-to-read page.

Free 14-Day Trial. No Credit Card Required.

OnePageGA Dashboard