How can I get a key event conversion rate for a specific event?

[Aventuri]

I am having trouble in getting that.

I have a table with campaigns (dimension),  sessions, key events, key events conversion rate (metrics).
I need to know the session conversion rate of every campaign, for just one of the several key events, not for all.

I set a event name filter that filters for just that event but all i got is a "no data" table.

Please help!

[FernandoBG]

If I understood your issue, you can't find a way to filter conversion rates, right?

I am having a similar problem: I have a chart with the metric "user key events rate" working well with no filter (all events). But when I apply a filter (filter certain events using Event name, for example), the numbers do not make sense.

I applied this alternative solution - I saw the solution in this video

. Created a scorecard with the absolute number (in this case, Total Users)
. Created a scorecard with the metric Event Count and filtered by the events I needed
. Blended both scorecards (select both > right click > blend data)

Looker created a new scorecard with a calculated field. I don't know why, but it always creates with the formula "sum(Total users)/ sum(Event count).

Once you fix the formula, you have the conversion rate you need. 

DISCLAIMER: Adding a dimension filter that affects these numbers will probably mess up the formula. 

I applied Data filters and it worked ok.

I hope this alternative solution helps you!

[Aventuri]

Yes, but I need that in a table, not in a scorecard. The table shows the conversion rate for just one of the several key events, for every campaign that I run. Sounds pretty simple but in Looker Studio very few things are simple. 

I have queried chat GPT, that provided a formula, that contained some errors. After a long trial/error session I think that I got it right. However, your disclaimer applies to my case so now I am concerned about the accuracy of the data I got.