Conversion Rate 100 % - Lookerstudio's Scorecard Problem

API & integrations
1

In Piwik’s Goals section, each goal’s conversion rate shows relevant data such as:
Näyttökuva 2023-8-23 kello 16.02.02

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 %.
Näyttökuva 2023-8-23 kello 16.07.50

Any ideas how to get the right numbers to Lookerstudio? :slight_smile:

2

Hi!

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

3

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 :slight_smile:

1 Like
4

I tried different methods:

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

Näyttökuva 2023-8-25 kello 11.43.17
Näyttökuva 2023-8-25 kello 11.43.171202×292 10.2 KB

  1. Goal name uuid equal to Goal ID in Piwik

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

    Näyttökuva 2023-8-25 kello 11.47.00
    Näyttökuva 2023-8-25 kello 11.47.00722×75 3.57 KB

  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)
    Näyttökuva 2023-8-25 kello 11.41.48

5

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