How to Calculate Date Difference on Looker Studio (2025)

Описание: Learn how to create a custom date formula in Looker Studio to calculate the recency of customer purchases. Follow along as you see a step-by-step guide on how to calculate the days since the last purchase for each customer using the day difference function.

Highlights:
[00:22] Understand the importance of knowing the recency of customer purchases
[00:42] Create a new field called 'Days since the last purchase' with a simple formula
[00:58] Use the day difference function to calculate the number of days since the last purchase for each customer