[Bug] Incorrect figures in customer reports

[klbrnd]

What happened?

unfortunately, the customer reports do not show the same figures as the normal reports. for example, for the sources. there seems to be a problem with the transfer or sorting

What should happen?

correct figures in customer reports

How can this be reproduced?

check campaign source and source in customer report. they are not identical.

Matomo version

5.1.2

PHP version

No response

Server operating system

No response

What browsers are you seeing the problem on?

Chrome

Computer operating system

windows

Relevant log output

No response

Validations

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

[sgiehl]

Hey @klbrnd,

would you mind attaching some screenshots of the reports where you found not matching numbers?
This would help us a lot in identifying a possible problem.

Thanks

[klbrnd]

Hello! Here are the screenshots. The first (campaign-sources_1.jpg) shows the figures under campaigns and the second shows the figures in the custom reports. As you can see, the numbers are different for the same time period. I hope this helps. Let me know if you need anything else. BR

[randy-innocraft]

Hi @klbrnd,

I don't think the screenshots were uploaded properly. Could you please try again? Thanks.

[klbrnd]

Hi! Here come the screenshots again.

[randy-innocraft]

Hi @klbrnd,

Could you please create a custom report by filtering the campaign source to the one which is mismatched and check again?
For example:

If this is the case, you will need to change the row limit - https://matomo.org/faq/custom-reports/faq_25655/

[klbrnd]

Hi! That works now for this source (and it works in the other customer report as well).

But i did the same test for another source. Unfortunately it still shows different numbers.

[AltamashShaikh]

@klbrnd Was the custom report created recently ? Asking this Q as you are viewing the data from 2024-01-01, if the custom report is created recently, you might need to run this console command to archive reports data for older dates.

./console customreports:archive --idsites={idsite} --date=2024-01-01,today --idreport={idreport} --disable-segments --periods=day,week,month,year,range