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

Google Sheet Date and Data Studio report

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I use a Google Sheet as a source data for a Data Studio Report and the date format that show up is a number. I did not find a way to convert to  "dd/mm/yy" format. The dates are in yyyy/mm/dd in data source.

 

 

 

1 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Solange I
May 2017

Google Sheet Date and Data Studio report

Participant ✭ ☆ ☆
# 2
Participant ✭ ☆ ☆

Screen shots of  your source and Data Studio Report would be helpful so we can see.

 

You can also take a peak at https://support.google.com/datastudio/answer/6401549?hl=en

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Solange I
May 2017

Google Sheet Date and Data Studio report

Participant ✭ ☆ ☆
# 2
Participant ✭ ☆ ☆

Screen shots of  your source and Data Studio Report would be helpful so we can see.

 

You can also take a peak at https://support.google.com/datastudio/answer/6401549?hl=en

Re: Google Sheet Date and Data Studio report

Top Contributor
# 3
Top Contributor

You can also modify your Sheet to include a date column that's adapted to the DS format; see attached below

Screenshot 2017-05-19 13.51.03.png

 

VP & Chief Evangelist at Hub'Scan | Contact me
Level 80 Digital Analytics Warrior, KPI Therapist and Keeper of the One True Tagging Plan