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

Funnel conversion filterable by dimensions

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hey dear Data Studio Community,

 

I've got some trouble trying to put together a conversion funnel. I'm extracting some data using a personalized big query request which outputs data organized like this :

 

 Screen Shot 2017-03-09 at 20.07.37.png

 

In data studio,  the data is received like this : 

 

Screen Shot 2017-03-09 at 20.21.03.png

 

The trouble is that when aggregating the data, it averages the transformation rate regardless of the volume associated (number of users). Then, the Safari transformation (50% let's say) with its 2 users will by bluntly averaged with the chrome transformation (25% let's say) and its 300 users, outputing in my graph a conversion rate of 32.5%.

 

How can I organize things so that the pourcentages doesn't get tricked by aggregation ? I guess I could create a calculated field in data studio to obtain the transformation instead of processing it in my query. I tried something like number_of_users / max(number_of_users) but this doesn't work.

 

Thank you very much in advance for your help !

 

Arthur