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

How can I separate the date and the data? I want to extract in a one row.

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

Is it possible extract two different data from a one row(META_VALUE)?

(You can check my data sheet sample at the bottom.)

 

I want to make 'Date' to Time Dimension. "player" to Metric and count it.

스크린샷 2017-05-24 오후 3.46.53.png

 (*I can't change or edit the sheet)

 

USER_ID /META_KEY                                                /META_VALUE

1First_NameSEO
1Class"subscribed"
1Date2016-12-11 16:20:03
2First_NameROY
2Class"subscribed","player"
2Date2017-01-11 09:10:22

 

How can I separate the date and the data? I want to extract in a one row.

Participant ✭ ☆ ☆
# 2
Participant ✭ ☆ ☆

I would start with creating a calculated field in Data Studio and use RegExp_Extract 

 

https://support.google.com/datastudio/answer/7050487?hl=en

 

https://support.google.com/datastudio/answer/6299685?hl=en&ref_topic=7368785