Data Studio
3.1K members online now
3.1K 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.