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

Google Doubleclick for publishers Date in DS

Follower ✭ ✭ ☆
# 1
Follower ✭ ✭ ☆


Google DFP has an export to Google Sheets functionality, from there its possible to export into DS(Although you need to trim the Totals from the bottom of the file)
The Date(European) DFP exports is not recognised by Data studio. eg '19/06/17' is not recognised.
Using a function like CONCAT(20, SUBSTR(Date, 7, 2), SUBSTR(Date, 4, 2), SUBSTR(Date, 1, 2)) to convert it to the YYYYMMDD format doesn't even work.