How To Visualize GA4 Data By Seasonality in Looker Studio

The problem with most Google Analytics reports is that they don't align with your actual business cycle. By default, Google Analytics only groups data by daily, weekly, or monthly insights; however, most businesses operate on a seasonal basis. You can easily compare a few months to the year before or prior period, but what if you want to see how each season or quarter performs compared to the rest of the year?

This custom Looker Studio report lets you do just that and more

Here's How to Set It Up:

  1. Select Vertical Bar Chart
  2. Select Your Data Source
  3. Click Dimension and select "Add calculated field"
  4. Paste the following codeCASE
    WHEN Month IN (12, 1, 2, 3) THEN "4. Winter"
    WHEN Month IN (4, 5) THEN "1. Spring"
    WHEN Month IN (6, 7, 8) THEN ""2. Summer""
    WHEN Month IN (9, 10, 11) THEN "3 Fall"
    END
  5. Update the numbers in () to match your seasons/or business cycle
  6. Update labels in quotes to match your seasonality number in front to help organize how they show from left to right.
  7. Under the default range filter, select custom, then select a 12-month period you want to look at.
  8. (Optional) Add a control field to look at your data by landing page, item name, traffic source, etc.

Logan Williams

Logan Williams is the founder of Eleventh Peak Digital. As a technical SEO expert trained in website development, he specializes in optimizing sites from code to copy to help clients grow leads. You can find Logan's latest thoughts on LinkedIn.

Recent Insights