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

Create new dimension based on metric value

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I am working with dirty GA data where GA ecommerce was set up to have the same product name be used for different products. ex: the same 'product' dimension for when product X was purchased for $49.00 and product Y was purchased for $600. 

 

I would like to create a calculated field which results in a new dimension where 'new dimension XYZ' = when average price = $49.00

 

I'm at a loss at figuring this out, any thougts?

Create new dimension based on metric value

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Hi @Jonathan C,

 

I'm not certain DataStudio would be able to do this for you - it may be better to calculate this using a custom dimension in GA, then use this in DS instead?

 

How many products are you working with and how many price variations are there? I am trying to think of a better way to do this, but struggling also Smiley Happy

 

Let us know if your having any success!

 

Ben