Overview of Data in Intelligence Reports

Important Information about Data in Intelligence Reports

• Data retention — The first time you activate Intelligence Reports for Marketing Cloud Engagement, up to 90 days of historical data is available. From that point on, historical data is retained for 2 years. The 2 years is according to the event date, meaning any event that happens after 2 years doesn’t appear.
  

  Note Data older than 90 days can’t be processed. To avoid this limitation, open a support ticket as soon as you notice missing data.
• Data refresh — Data is refreshed every 24 hours. Each account has its own time for daily refresh, and it can’t be set.
• Data retrieval — If a failure in data retrieval from Marketing Cloud Engagement to Intelligence Reports occurs, the process retries every few hours. Any other data is reprocessed the following day. Such failures are monitored internally. The user isn’t notified of an error. However, even with an error, you can keep using Intelligence Reports and retrieve reports based on existing data.
• Data deletion — When you delete a contact record for one or more subscribers within Marketing Cloud Engagement, personal information for those contacts is removed from Intelligence Reports within 90 days. Also, when your Intelligence Reports subscription is terminated, your customer data is deleted in accordance with the Marketing Trust and Compliance Documentation.
• Data migration— Data migration between stacks isn’t supported in Intelligence Reports. If you must migrate, support can help with the migration; however historical data won’t be brought over. Contact your Salesforce account executive for more information.
• Time zone — Daily data is presented (aggregated) according to the time zone set in your enterprise’s business unit settings. All business units that belong to the enterprise reflect the enterprise’s time zone.
  • If you change the time zone, it doesn’t affect past data, only data collected after the change.
  • If you log into Intelligence Reports for Engagement after the change, the time zone is updated automatically. However, if you don’t log in right after the change, then it can take up to 7 days for the change to take place.

Available Data Elements

There are two types of data elements available: dimensions and measurements.

• Dimensions — Qualitative non-numerical data that you can't count, for example campaign name and campaign ID.
• Measurements — Quantitative numerical data that you can count, for example, number of clicks and emails opened.

If you’re using Advanced Intelligence Reports, you can also create calculated data element fields:

• Calculated Dimensions — Non-numerical fields or dimensions that you can create on top of your existing data. These queries can be referenced to from reports and pivot tables, and they can support a variety of functions and logical conditions.
• Calculated Measurements — Numerical custom calculations that you can create on top of your existing data. You can reference dimensions and measurements along with a number of different functions and operators.

For a full list of all the measurements and dimensions that are available, see Dimensions and Measurements.

Measurements are associated with dimensions of the same time. For example, opens are associated with the business unit name according to that same day. If you change the name of the business unit, the new data is associated with the new business unit name. And, you could see split data with the old name as well. When you assign an email to a campaign, this campaign assignment only picks up for new sends. It doesn’t pick up retroactive sends.