# Conversion Rate 100 % - Lookerstudio's Scorecard Problem

**URL:** <https://community.piwik.pro/t/conversion-rate-100-lookerstudios-scorecard-problem/2767>\
**Category:** API & integrations\
**Created:** [August 23, 2023, 1:11pm UTC](https://community.piwik.pro/t/conversion-rate-100-lookerstudios-scorecard-problem/2767 "2023-08-23T13:11:34Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![analyticskeener](https://avatars.discourse-cdn.com/v4/letter/a/b487fb/32.png) [@analyticskeener](https://community.piwik.pro/u/analyticskeener)\
**Post date:** [August 23, 2023, 1:11pm UTC](https://community.piwik.pro/t/conversion-rate-100-lookerstudios-scorecard-problem/2767/1 "2023-08-23T13:11:34Z")

</div>

In Piwik’s Goals section, each goal’s conversion rate shows relevant data such as:  
 ![Näyttökuva 2023-8-23 kello 16.02.02](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/c/c57e152be5dd903c510ef3b40323482edbd1135a.png)

Once I try to preview the data in Google Lookerstudio by selecting goal conversion rate and a filter that includes only certain goal the scorecard shows 100 %.  
 ![Näyttökuva 2023-8-23 kello 16.07.50](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/8/810fb9e46e17ad421d9212275aeff546b37d45ea.png)

Any ideas how to get the right numbers to Lookerstudio? 🙂

---

<div class="post-metadata">

**Author:** ![sararekowska](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/sararekowska/32/1582_2.png) [@sararekowska](https://community.piwik.pro/u/sararekowska)\
**Post date:** [August 24, 2023, 9:05am UTC](https://community.piwik.pro/t/conversion-rate-100-lookerstudios-scorecard-problem/2767/2 "2023-08-24T09:05:11Z")

</div>

Hi!

Could you share the exact filter definition you used in Looker Studio?

---

<div class="post-metadata">

**Author:** ![Emilia](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/emilia/32/2361_2.png) [@Emilia](https://community.piwik.pro/u/Emilia)\
**Post date:** [August 29, 2023, 10:09am UTC](https://community.piwik.pro/t/conversion-rate-100-lookerstudios-scorecard-problem/2767/3 "2023-08-29T10:09:31Z")

</div>

Hi! Are you working on the ‘Goal name’ dimension? While analyzing goals, you shouldn’t use the goal name as a dimension together with the goal conversion rate. The counting mechanism will limit data to sessions during which the goal was achieved and the goal conversion rate will always show 100%.

Please, let me know if this tip helps 🙂

---

<div class="post-metadata">

**Author:** ![analyticskeener](https://avatars.discourse-cdn.com/v4/letter/a/b487fb/32.png) [@analyticskeener](https://community.piwik.pro/u/analyticskeener)\
**Post date:** [August 31, 2023, 7:01am UTC](https://community.piwik.pro/t/conversion-rate-100-lookerstudios-scorecard-problem/2767/4 "2023-08-31T07:01:25Z")

</div>

I tried different methods:

1. Goal name uuid equal to Goal name in Piwik.

 ![Näyttökuva 2023-8-25 kello 11.43.17](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/8/8ef4319ffecf23e278b48f7a03190c6016335963.png)

1. Goal name uuid equal to Goal ID in Piwik

2. OR custom event name equal to custom event name in PIwik.  

3. Custom metric counting the conversion rate: (I know this is not the pattern that should be used when counting conversion rate which is “goal (completions/sessions)\*100” but this pattern gives somewhat little bit more realistic results for conversion rate than other patterns)  
 ![Näyttökuva 2023-8-25 kello 11.41.48](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/9/99fc93c20315e92d653ed78600520c9f7badccce.png)

---

<div class="post-metadata">

**Author:** ![analyticskeener](https://avatars.discourse-cdn.com/v4/letter/a/b487fb/32.png) [@analyticskeener](https://community.piwik.pro/u/analyticskeener)\
**Post date:** [August 31, 2023, 10:11am UTC](https://community.piwik.pro/t/conversion-rate-100-lookerstudios-scorecard-problem/2767/5 "2023-08-31T10:11:20Z")

</div>

How to get the conversion rate for Lookerstudio scorecard for a single conversion? Thanks 🙂