Sum of Product Revenue and quantity not the same in Looker Studio

Reports and working with data
1

Hi,

with the new update I can now display the products sold in Google Looker Studio. But the data is not correct:

Piwik:

Looker:

The orders are right, but the rest is wrong.

There is no filter in Looker and the date is the same as in piwik.

Thank you
Jeff

2

Hi Jeff!

We have to update the Looker Studio connector to reflect recent changes to the ecommerce module. Please keep an eye on the changelog.

1 Like
3

Hi,

I have updated to the 1.0.8 connector, but the values are still wrong. (same period and same filters)

If I just check the sum of revenue, I am getting different values. Even in looker, the sum of revenue is different if it is a scorecard or a time series chart.

In piwik: 44.391
In looker, scorecard : 29.620
In looker, time series chart : 42.242

Thank you
Jeff

4

Hi Jeff!

Hmm, it might be because of the sum of product revenue transformation in Piwik Pro. Would you mind sharing a screenshot of how the report is constructed? Dimensions, metrics, filters.

5

Hi,

I have the same issue with the 1.0.8 version (even the 1.0.6). Impossible to retrieve the same value for this important metric…

Christophe

6

We are also having issues with the Product quantity metric in Looker Studio. The Product quantity for each Product name and each Order ID is correct, but the total is way wrong (see attached image). It seems that the total Product quantity is adding the unique product quantity values (4 + 2 + 1 = 7).

When creating this same table in Piwik PRO the Sum of product quantity (Order) gives the correct total value = 21.

piwik-looker-studio

7

Hi Anthony,

I have just seen your message.

The report is pretty simple. Just revenu as a metric and date.

image
image230Ă—727 16.1 KB

Nothing on the report or page settings.

If I copy&paste the scorecard that displays the wrong revenu and change the metric from “Revenu” to “Orders”, the correct number of ordrers is displayed.

Thank you
Jeff

8

Hi Jeff, I dont know if you have already fixed the issue. But here is the solution to everyone else having the revenue issue.

  1. Create the overview field in Looker like you always would.
    image
    You will notice a revenue gap between Looker and Piwik interface

  2. Change it to table
    image

  3. Go to metrics, and use “Order ID” counted as second metric
    image
    You will notice the revenue is diplayed correct.

  4. Change back to overview
    image

9

Hi,

Coming back to the topic - is the issue with incorrect product revenue and quantity still replicable? Comparing similar/same report structures between the UI and Looker Studio doesn’t indicate discrepancies. I might be missing specific cases, so feel free to let me know (e.g. what you are trying to achieve, what is the report structure).

image
image1284Ă—513 56.2 KB

image
image984Ă—660 67.4 KB

Using the product quantity dimension on it’s own (as in without any transformation) might not be ideal as in the Piwik PRO Analytics (and same probably applies to product revenue) you’ll most likely get a set of all of the possible combinations of this dimension in conjunction with selected dimension and metric (e.g. order ID, product name).

I can see why it might be hard to figure out / why it could cause confusion - especially that Looker Studio allows for dimension combinations not allowed in Piwik PRO Analytics.

As a side note - looking at the original post from Jeff, the Total quantity metric can be replaced with sum of product quantity. Total quantity has been deprecated in the Analytics Query API and therefore we’ll most likely remove it from the connector in one of the upcoming updates.