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

How to extract from JSON String in Data Studio?

Follower ✭ ✭ ☆
# 1
Follower ✭ ✭ ☆

Does anyone have a regex formula or some other formula to extract parameters from a JSON string in Data Studio?

 

For example, what type of formula would I write to extract the value for age_max from: 

 {"age_max":65,"age_min":18,"geo_locations":{"countries":["US"],"location_types":["home","recent"]},"publisher_platforms":["facebook"],"facebook_positions":["feed"],"device_platforms":["mobile","desktop"]}

 

How to extract from JSON String in Data Studio?

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Convert JSON to CSV (https://konklone.io/json/), than import generated CSV to Google Sheets thereafter import the sheet to datastudio.