Discrepancy between Adobe Customer Journey Analytics and Adobe Experience Platform Query

Forum|Forum|10 months ago
March 6, 2025
3 replies
813 views

Hi, I had an existing connection where I added a dataset with backfill. After backfill I see correct no. of records at connection level. But when I utilize the attributes in a canvas I see the total count of event different from what I see using query service. Any suggestions, help is highly appreciated

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by AGoodDoc

Update : This occurred because of incorrect collection of daterange

manojsingh-tech

Level 2

Check these steps

Data View settings – Verify the time zone, including datasets and lookback windows.

Date range in Canvas – Ensure it covers your backfill period.

Metric differences – Query Service counts rows; CJA may count events or people differently.

Filters/segments – Check if any are applied in the Canvas.

Duplicates or join key issues – Confirm FPID or join keys are correct.

Backfill processing – Make sure the dataset is fully processed.

Query vs. CJA scope – Query Service is raw data; CJA applies processing rules.

Most mismatches are due to Data View config or date ranges.

Josh__Stephens

Community Advisor

When you mention canvas, are you referring to the Journey Canvas? I'd recommend building a Freeform table with the dataset ID (or name if you've build a derived field) and the number of events. As mentioned, as long as your date range encompasses the full range of events in your dataset, I'd expect these to have parity.

A

AGoodDocAuthorAccepted solution

Level 2

Update : This occurred because of incorrect collection of daterange

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded