Summary data

Summary data is time-series data that is not tied to an individual person ID. Summary data represents aggregated data at a different level of aggregation, for example campaigns. You can use this data in Customer Journey Analytics to support various use cases. For example, data containing a date and a single metric value, or data containing multiple dimensions and metrics.

This summary data can then be used to present high-level performance indicators or perform analysis. Examples of summary data can be advertising impressions, email opens, advertising spend, cost of good sold, S&P indices, and more. You can also use summary data to upload targets or goals on an hourly or daily basis.

Example

An example of using summary data is combining summarized advertising campaign data with on-site clickstream data for reporting.

Summary data

Your summary data contains the following advertising campaign data.

Event data

Your on-site clickstream data contains the following events.

Combined data

As explained in Combined event dataset, when defining a connection, Customer Journey Analytics creates an overall combined event dataset. When you configure your data view for dimensions originating from a summary dataset, options are available to group and hide dimensions as a preparation for reporting in Workspace. Specifically for summary data, the summary data is combined with event data, based on the summary data group component configuration.

Reporting

Combining the summarized event data and on-site clickstream data enables you to report in Workspace on return on ad spend (ROAS).

Lookup data

If you want to report using a dimension defined in an additional lookup dataset (for example, campaign name), you have to follow these additional steps:

See the Ingest and report on summary data use case for a detailed article on how to make use of, report on, and analyze summary data in Customer Journey Analytics.

Prerequisites

To use summary data properly in your reports and analysis, a number of prerequisites apply. The following sections detail these prerequisites.

Granularity and timezone

When configuring the dataset containing the summary data in Customer Journey Analytics, you notice that the granularity is automatically derived from the data. The selections for Timestamp and Timezone dropdown are disabled as both are derived from the schema definition.

Granularity

You cannot mix and match the hourly and daily granularity of your summary data in one dataset (or with different datasets), using one summary data schema. For example, if you do have daily and hourly granular summary data for advertising campaign data, you need two schemas: one for the daily and one for the hourly summary data. And then upload the relevant granular data into datasets associated with the proper schema (for example, upload hourly data into a dataset associated with the hourly summary data schema).

Timezone

The timezone of your summary data is defined at the summary schema level in Experience Platform. The timezone applies to hourly granular data only.

To ensure, the proper timezone is used for your hourly granular summary data, you must ensure the schema used for summary data has the proper timezone configured.

To configure the granularity and timezone for your summary data schema, you have to use the following API call as there is no equivalent user interface available.

curl -X POST \
https://platform.adobe.io/data/foundation/schemaregistry/tenant/descriptors \
 -H "Authorization: Bearer {$ACCESS_TOKEN}" \
 -H 'Content-Type: application/json' \
 -H 'x-api-key: {$API_KEY}' \
 -H 'x-gw-ims-org-id: {$ORG_ID}' \
 -H 'x-sandbox-name: {$SANDBOX_NAME}' \
 -d '{
    "@type": "xdm:descriptorTimeSeriesGranularity",
    "xdm:sourceSchema": "{$SCHEMA_ID}",
    "xdm:sourceVersion": 1,
    "xdm:granularity": "{$GRANULARITY}",
    "xdm:ianaTimezone": "{$TIMEZONE}"
 }'

Component settings

Ensure the component settings for a summary data group are the same. See Summary data group component settings for more details.