Share on facebook
Share on twitter
Share on linkedin
Share on email

4 Ways You Can Use Advanced Date Ranges in Data Studio

Data Studio continues to be one of my favorite reporting tools. Between blending data, conditional formatting tables, community visualizations, and other features, there’s so much that we can do with reporting. The Data Studio feature that has been trending in my life lately is Advanced Date Range. It allows you to set custom date periods for both current date range and comparison date range. In my case, it has been a game changer for comparing time periods.

Why use Advanced Date Range?

Because it allows you to compare the exact day instead of date. 

Ok, hear me out. If in your industry seasonality matters then you know that just selecting “Compare to Previous Year” on Data Studio or any other reporting tool just doesn’t cut it. For example: Black Friday 2020 (Friday, November 27, 2020) vs Previous Year would compare Friday, November 27, 2020 vs Wednesday, November 27, 2019.  And that’s not what we want! Ideally, you want to compare  Black Friday 2020 vs Black Friday 2019 meaning, Friday, November 27, 2020 vs Friday, November 29, 2019.  Advanced Date Range allows you to do just that.

Where can I find the Advance Date Range?

Once you create your first chart, the sidebar will show you the data and style settings. You will see “Default Date Range” under the Data Settings. Both the Custom Current Date Range and Comparison Date Range will give you “Advanced” as an option. Click it!

Advanced Date Range - Data Studio
Advanced Date Range – Data Studio

Versus Previous Year Settings

Before we start, I should mention there are limitations to this feature. I’ve found that this kind of comparison only works with consistent and specific current dates. Selecting Fixed custom dates or having a Date Selector on your Report will not work. The settings below will work for charts that have current date ranges such as:

  • Today
  • Yesterday
  • Last 7 Days
  • Last 14 Days
  • Last 28 Days
  • Last 30 Days

Today vs Previous Year

Custom Default RangeToday
Comparison Date Range | Advanced (Start Date)Today minus 364 Days
Comparison Date Range | Advanced (End Date)Today minus 364 Days

Yesterday vs Previous Year

Custom Default RangeYesterday
Comparison Date Range | Advanced (Start Date)Today minus 365 Days
Comparison Date Range | Advanced (End Date)Today minus 365 Days

Last 7 Days (exclude Today) vs Previous Year

Custom Default RangeLast 7 Days (exclude Today)
Comparison Date Range | Advanced (Start Date)Today minus 371 Days
Comparison Date Range | Advanced (End Date)Today minus 365 Days

Last 30 Days (exclude Today) vs Previous Year

Custom Default RangeLast 30 Days (exclude Today)
Comparison Date Range | Advanced (Start Date)Today minus 394 Days
Comparison Date Range | Advanced (End Date)Today minus 365 Days

Is this another reason to love Data Studio? I certainly think so. I encourage you to try this out on your next report and see how precise you can get. There are other use cases for this feature such as Previous 30 Days, or 90 Days or Quarter. 

If you come up with new ways to maximize Advance Date Range’s potential, share them on the comment section below.

Share on social!

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn
Share on email
Email
Jayleen Nazario

Jayleen Nazario

Digital Marketing Specialist