AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
1.7K members online now
1.7K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Google Data Studio Reports YOY

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I want to run a scorecard report that compares this month so far to the same date range the previous year. However if I compare 'This Month' to 'Previous Year', it compares the first 6 days of September 2016 to all 30 days of September 2015, so it's not a fair comparison. How do I run the report that I want?

Re: Google Data Studio Reports YOY

Follower ✭ ✭ ✭
# 2
Follower ✭ ✭ ✭
Could you do last 4 weeks vs 4weeks last year instead?

Or... just take (SeptSessions) / (6/30) to factor up for the month....
TODATE("30/" + MONTH +"/"+ YEAR, DD-MM-YYYY-, YYYY-MM-DD) - TODATE("01/" + MONTH +"/"+ YEAR, DD-MM-YYYY-, YYYY-MM-DD) +1

Also you can you GoogleSheets and add predicted data for all of Sept see this example
https://youtu.be/p941a8k2TpM?list=PLFwbZ-mNsefWTL5EFcbmXCvPizGew9Jed&t=719

Thanks

Phil.