[Bug] Discrepancy in eCommerce Transaction Counts Between Segmented visits log and ecommerce Archive Reports in Matomo

[Chardonneaur]

What happened?

The issue reported is that the eCommerce reports in Matomo are not accurately measuring transactions. Specifically, when following the steps mentioned, there appears to be a discrepancy between the number of orders shown in the raw data report and the number displayed in the archive report. In other words, the detailed view in the raw data does not match the summarized view in the archive, which suggests that the data aggregation process might be flawed or that some transactions are not being recorded properly.

What should happen?

Ideally, both the raw data report and the archive report should show consistent information. If there is an order in the raw data, it should be reflected in the archive report. The number of orders in both views should be identical for any given channel type or segment. This consistency ensures that the reports are reliable and that the data is being recorded and processed accurately.

How can this be reproduced?

To reproduce the issue, follow these steps:

Select an eCommerce Website.

Click on eCommerce: Navigate to the eCommerce section in the Matomo analytics interface.

Go to Sales: Access the sales report within the eCommerce section.

Click on the segmented log feature icon.

Count the Number of Orders: Compare the number of orders displayed in the raw data report (detailed view) against the number shown in the archive report (summarized view).

Matomo version

5

PHP version

No response

Server operating system

No response

What browsers are you seeing the problem on?

Not applicable (e.g. an API call etc.)

Computer operating system

No response

Relevant log output

No response

Validations

• [X] Read our Contributing Guidelines.
• [X] Follow our Security Policy.
• [X] Check that there isn't already an issue that reports the same bug to avoid creating duplicates.
• [X] The provided steps to reproduce is a minimal reproducible of the Bug.

[sgiehl]

@Chardonneaur Which of the reports are you exactly referring to? If it is the initially loaded channel type report, those reports are based on different numbers. The report shows you the conversions that were attributed with a certain referrer, while the segmented visitor log segments by the referrer of a visit (which might differ from the attributed referrer of a conversion). So in this case the segment is sort of wrong. But as we currently don't have a segment for conversion attributions, the only thing we could quickly do is to deactivate the segmented log feature till such an segment would be available.

[Chardonneaur]

@sgiehl how difficult would it be to develop a segment for conversion attributions? And using that segment when the icon is clicked.

[sgiehl]

@Chardonneaur It's not too complex. Something like this should work: https://github.com/matomo-org/matomo/compare/conversionreferrertype?expand=1 But implementing it properly might require some more effort, as would also need to be implemented for other referrer segments.