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

Date format in CSV errors

Follower ✭ ✭ ☆
# 1
Follower ✭ ✭ ☆

Hi 

 

I'm testing Google Data Studio as an alternative reporting tool. I've implemented multiple data sources (GA, AdWords, Search Console) and so far so good. Now i'm trying to import third party data (FB) into datastudio and this is where it's getting complicated for me. I've created a CSV file in google sheets a long with the correct format of the dates (YYYYMMDD)

 

Schermafbeelding 2017-02-15 om 09.55.46.png

 

However, when setting the correct format type for the date field, i keep getting the following error:

 

Schermafbeelding 2017-02-15 om 09.51.43.png

 

So I click continue, but i do not know how to correct this error. For scorecards and tables i can receive some output but this is the total amount (summed) of the values inside the CSV file. So the problems clearly lies with the date format, but when I upload the same CSV file into Analytics (cost import) with the same date format no problems occur.

 

I tried different kind of date formats, and even used text as a format type but this not seems to help me that much.e

 

Does anyone knows how to fix it?

 

 

Kind regards, 

 

Paul