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

Can I create a new dimension based on metric headers?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I'm using a script to record data into a Google sheet, and in interest of keeping within the 2 million cell limit every date is recorded as the column header for my metric I'm recording.

I figure since all of the data is there, this should be possible to do.

 

So now trying to visualize the data in Data Studio by date, I need to create a date dimension based on the headers for my metrics, and then show the dimension i'm recording by date.