Understanding the Data View Update Process

The data view in Journey Builder is updated periodically, but the exact timing can vary. Ideally, it is recommended to wait at least 24 hours for the data to be accurate. However, in some cases, the data may be available sooner, but it is not guaranteed to be 100% accurate.

The root cause of this issue is the periodic update process of the data view, which can lead to delays in reflecting the latest data.

As suggested by a community member, you can modify the example query found in the Salesforce documentation to retrieve sent email details. However, it is essential to keep in mind the potential delay in data reflection.

To increase the accuracy of the data, it is recommended to wait for at least 24 hours or even up to 7 days for the data to be definitive.

Querying Sent Email Details

While waiting for the data to be updated, you can use the following SQL query as a starting point to retrieve sent email details:

example_query.sql

SELECT * FROM SentData WHERE JourneyID = 'YOUR_JOURNEY_ID' AND SendTime > DATEADD(mi, -5, GETDATE())

Note that this query is just an example and may need to be modified to fit your specific use case.

Heads up: The query may not return accurate results if the data has not been updated recently.

Best Practices

Checklist for Querying Sent Email Details

• Wait for at least 24 hours for the data to be accurate
• Use the example query as a starting point and modify it to fit your specific use case
• Keep in mind the potential delay in data reflection
• Consider waiting up to 7 days for the data to be definitive
• Test and verify the accuracy of the data before using it for reporting or other purposes

What is the recommended wait time for data to be accurate?

At least 24 hours