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
2.4K members online now
2.4K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Is it possible to get the date range from a week as a calculated field?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I need to create a dimension that shows the week range of my data in my Google Adwords, something like:

 

Week                       Impressions

 

Feb-26 to Mar-4       1000

Mar-5 to Mar-11        10000000

 

Doing this using a spreadsheet would be relatively simple, but I´ve tried doing this direct on Google DataStudio by creating a new calculated field, but apparently can´t add or subtract days from dates.

 

Is there a way I can get this dimension?

 

 

Thank you! 

Is it possible to get the date range from a week as a calculated field?

Participant ✭ ✭ ☆
# 2
Participant ✭ ✭ ☆

I don't know of any way to do this, but I wonder if you can create a dimension called "week starting date"?