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

Compare previous month in Data Studio

[ Edited ]
Badged Google Partner
# 1
Badged Google Partner

I see you can set the date range for the last 30 days, but can you also apply data from previous month to get a look at how its changed?

 

Compare previous month in Data Studio

Explorer ✭ ☆ ☆
# 2
Explorer ✭ ☆ ☆

Hey @Luke M, if you have a "Date Range Dimension" in place, you should definitely be able to show a "Previous period" series in a time series chart.

 

More info here: https://support.google.com/datastudio/answer/6401549?hl=en

 

Do you see that "Previous period" option in your time series settings?

Re: Compare previous month in Data Studio

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

You can easily do it. Just create new Dimension by copying your Actual Date Column. And change the Date format to Month. USe this as a dimension in your chart.  Smiley Happy 

Re: Compare previous month in Data Studio

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

I don't fully understand GDS behavior when it compares previous periods.

Why I'm having these "empty" values when I add Date dimension on a table?

 

Capture.PNG

 

Green table has delta values for every row, but rest of tables are only showing values on oldest (Date) row/s. What's the reason?

If I show Date as Auto, I even get no delta values at all.

 

I've tried to play with different date metrics, but I'm always getting same results.

I'm using a MySQL connector as a data source.

 

Thanks!

Compare previous month in Data Studio

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Hi David!

Any luck understanding this?

I'm connecting to a MySQL instance in GCP, my date in Datastudio is date type YYYYMMDD, and still I'm not able to get the delta working. Everything is blank.

 

I tried that connecting to GA, and it works perfectly.

I'm afraid it's a bug when connecting to MySQL.

 

Azu

Re: Compare previous month in Data Studio

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭
This is great. Thank you . Ho do we add "Month over month"? See my example below.

http://prntscr.com/kaj4ct