How to Calculate the Conversion Rate of Two Events in Google Data Studio

[@MeasureSchool]

0:00 - Introduction 1:04 - Set Up Your a Table Connected to Your Data Source 1:50 - Define Which Two Events You Would Like to Find the Conversion Rate For 2:30 - The Problem 4:20 - The Solution 7:18 - Blend Your Data Sources 8:30 - Create a Custom Field with Your Blended Data Source 10:30 - Other Use Cases

[@emaugustBRDLC]

I have been trying to figure out how to compute the conversion for a while now - this blended data approach solves it for me - thank you!

[@spilledteaconsulting]

You guys are my heroes! Spent forever trying to work out how to do this today.

[@MeasureSchool]

Great to hear!

[@udunknow2172]

Thanks for the guide! Definitely going to be making use of this

[@robertorios9746]

Life saver! Blend data was an eye opener!

[@MeasureSchool]

Glad you like it!

[@garrettreynolds6828]

Excellent - I have seen this explained before but in a pretty confusing way and the examples were not useful whereas this version is much clearer and is very useful in how it explains the technique as well as giving great examples

[@LeslieInlow]

This was so helpful! Thank you so much!!

[@natashanishida6798]

YOU ARE AMAZING! Yes, with CAPS LOCK, haha! It's been a lot since I needed this and tried in several ways. You, sir, saved my life :)

[@dhruvindilshob6246]

In Case I want to plot this conversions for a period - Like Study it on a Daily or weekly Basis, how can i add Date to to the blended data?

[@jodilee7907]

Awesome video! Thank you so much!

[@DarshanKulkarniIndia]

Thanks. Well explained. Just one more request on how to this for a table when we have multiple values and want to show the conversion rate of all in each row. If you could make one video for that pls.

[@TheAlexmanius]

I have same problem, did you solve it?

[@analyticsteam5202]

Thanks guys, really useful. Keep up the good work!

[@ameamenagbolo1077]

Very useful indeed, i really like it!

[@juanjosemedina5898]

Thank you so much for your video, Ahmads. I would like to create a time series chart with that kind of conversion rate between two filtered metrics. How could I make it work out?

[@jwaddin]

me too!

[@jorgevaccaro]

Thank you so freaking much! Great tip man, you did my day!

[@testsingbae5685]

Really helpful . Please make a video on Calculated Metrics and build custom based on business objectives

[@MichaelTKleven-MC]

Fantastic! Thanks.

[@VoltaireParis]

thanks a lot Ahmad : I think that will be THE trick I need to pass beyond an obstacle on my GDS Report : great ! I am impatient to try this.

[@김경화-w8h7k]

Fantastic!!!!!!!!!

[@kailim3253]

Thanks so much! Is there a way to do a time series of conversion rate with this method? I tried to blend 2 charts, but cant seem to do conversion rate over time (i.e., the chart keeps showing CR at 0% over time)

[@josiehill1146]

so helpful - as always :)

[@zimarzii]

hi I have a lot of banner ads on my site I set two events for each of these banners (impression and click) Now I want to get the click-through impression ratio separately for each banner. The problem is that I have an event action dimension that has the impression and click parameter of all banners and a total event as a metric Do I have to calculate this ratio for each banner separately with Data Blending and create Field, or is there an easier way?

[@kevindrescher1862]

I seem to not have the Option to add Event Action/Event Label to my Datastudio. Do I have to enable this somewhere?

[@desktopsupport6575]

Amazing! Thank you very much :)

[@seemag4]

Awesome video however I have question, is there any way to create a calculated metric ie unique events( filtered to certain event)/ total unique pageviews to the page

[@parhumm]

Awesome!

[@patitorodri]

GREAT! Thank you

[@eshwarbg]

Hi. I want to compare conversion rates from this month to previous month, and understand why there is a dip this month. What all factors can I consider for reporting? Please help.

[@tsykin]

super useful!

[@alvar_p4l543]

When it comes to CR if your goals aren't properly set up, is it better to take unique events over total events divided by the total of sessions? This kinda bugs me.

[@hieunhudinh6418]

Thankyou bro. it is very good video

[@MeasureSchool]

All good!

[@giaki74]

Amazing, thank's!

[@MeasureSchool]

no problem!

[@WBoratto]

Thank you a lot!

[@Xan63]

Thank you!! Can we create a chart from a blended metric, eg, the conversion rate?

[@MeasureSchool]

Yes, absolutely

[@noemicserpes2680]

Thanks, this video is very useful!

[@iismaryasih6478]

is there a way to put conversion result in the same table itself?

[@MeasureSchool]

if it's part of your dataset

[@71pwr]

no idea why that's how it works. but THANK YOU

[@BretonSamuel]

Thx a lot! It s great !

[@Sankhaja1402]

Thanks a lot 👍

[@thehoopsgeek]

Nice video! But I don't think that this is the conversion rate of Product Clicks to ATC, just the ratio of two events. For example, if a customer clicks on one product and adds it 4 times to the cart by clicking the ATC button 4 times, we would have a "conversion rate" of 400%. Am I missing something?

[@GusMD84]

What's the benefit of blended data? Couldn't you do the same (set calculated metrics) from the main source? I'm for sure missing something very important?

[@MeasureSchool]

you could, but if you don't have access to the data source you could blend it directly in DS

[@sourabhdadhich5285]

can we show negative conversion rate percentage

[@MeasureSchool]

yes, if you make it part of your dataset

[@TristanBailey]

Thanks for the blended data tip. Don’t think there is a clear way to guess that UI way to do that. Very please to learn.

[@MeasureSchool]

Glad it was helpful!

[@rodrigoblanc4558]

Didn't work for me when using this technique on a graphic :( The result is astronomical for some reason.

[@alexandregomes3645]

thank u!

[@gizmoffm]

So great! Thanks

[@gizmoffm]

So great! Thanks

[@gizmoffm]

So great! Thanks