Understanding the Discrepancies

Teams running Journey Builder and Email Studio often hit this issue. The root cause of these discrepancies can be attributed to various factors, including date ranges, data update frequencies, and the differences between send and event dates.

The Datorama reports update every 24 hours, which can lead to small variances. Additionally, the Account Send Summary rolls up to the send date, whereas Datorama reports can be filtered by event date or send date. This discrepancy can cause differences in the reported metrics.

To reconcile these differences, it is essential to understand the data sources and update frequencies. The Account Send Summary provides a comprehensive overview of email sends, while Datorama reports offer more detailed insights into email performance.

Resolving the Discrepancies

To resolve the discrepancies, follow these steps: first, verify the date ranges and ensure that the data is up-to-date. Then, use the Account Send Summary to get all sends for a period, and finally, pull the numbers and do the math yourself to calculate the average CTR.

By following these steps, you can ensure that your email metrics are accurate and reliable. Additionally, using Datorama Reports pivot tables can help you quickly pull the required information and identify any issues with your data.

Best Practices

Email Reporting Best Practices

// Verify date ranges and data update frequencies
// Use Account Send Summary to get all sends for a period
// Pull numbers and do the math yourself to calculate average CTR
// Use Datorama Reports pivot tables to quickly pull required information

Heads up: Be cautious of emails with negative delivery, click, and open rates, as these can significantly impact your overall averages.

Checklist

• Verify date ranges and data update frequencies
• Use Account Send Summary to get all sends for a period
• Pull numbers and do the math yourself to calculate average CTR
• Use Datorama Reports pivot tables to quickly pull required information
• Be cautious of emails with negative delivery, click, and open rates
• Submit a ticket to understand the cause of negative metrics
• Regularly review and reconcile email metrics to ensure accuracy

Frequently Asked Questions

What is the difference between send date and event date in Datorama reports?

The send date refers to the date the email was sent, while the event date refers to the date the email was opened or clicked.

How often do Datorama reports update?

Datorama reports update every 24 hours.

What is the purpose of the Account Send Summary?

The Account Send Summary provides a comprehensive overview of email sends, including metrics such as delivery, click, and open rates.

How can I quickly pull the required information from Datorama reports?

Using Datorama Reports pivot tables can help you quickly pull the required information and identify any issues with your data.

What should I do if I encounter emails with negative delivery, click, and open rates?

Submit a ticket to understand the cause of negative metrics and take corrective action to ensure data accuracy.