Shouldn't Amazon Marketing Stream data match web reports 1:1?

[jasonwieland]

My AMS data doesn't quite match what I'm seeing in web reports.

For example, when looking at a historical date range of 3/21 - 3/22, I get results like:

SP Clicks: 7904 (AMS)
SP Clicks: 7825 (Web)

Sales and conversion data are also close but still off between 1-4%.

Here's an example query against the raw data loaded into BigQuery.

SELECT
sum(clicks) as clicks
FROM
xxx.raw_ams.sp_traffic`
WHERE
PARSE_TIMESTAMP('%Y-%m-%dT%H:%M:%S%Ez', time_window_start) >= TIMESTAMP('2025-03-21 00:00:00', 'America/Los_Angeles')
AND PARSE_TIMESTAMP('%Y-%m-%dT%H:%M:%S%Ez', time_window_start) < TIMESTAMP('2025-03-23 00:00:00', 'America/Los_Angeles')

Any help would be greatly appreciated. I feel like I'm missing something obvious and am stumped.

[kdwivedi13]

Thank you very much for your question. I truly appreciate it. However, this appears to be a troubleshooting issue that would be best addressed through our official support channels. To ensure we can provide the most effective assistance, I kindly request that you submit a Zendesk ticket by following this link. When submitting the ticket, please include:

1. The advertiser ID and region
2. Screenshots of the console, including timestamps
3. Any other information to help reproduce this issue

With these details, our support team will be better equipped to assist you. Thank you for your understanding and cooperation.