---
title: Summary Data
slug: currys-hol/summary-data
docTags: 
createdAt: 2025-05-30T08:26:32.720Z
---

## What is 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. 

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.

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

## Create a Summary Data report for Return on Advertising Spend (ROAS)

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

- Create a new panel below the last panel we just worked on
- title it `Return on Advertising Spend Analysis`;
- ensure your date range is **Last 3 Full days**; 
- select the **Freeform table** visualisation.

You see an empty Freeform panel, consisting of an empty Freeform table.

1. Drag **Tracking Code (Lookup)** from **Dimensions** and drop the dimension onto the empty Freeform table.
2. Drag **Purchases (participation)** from **Metrics**, and drop the metric onto the **Events** column to replace that column in the Freeform table.
3. Also drag the following metrics into the same Freedom table: 
   - ***Price Total (participation),***
   - ***Impressions (Summary),***
   - ***Clicks (Summary)***
   - ***Cost (Summary).***

Your panel should look like: 

![](https://api.archbee.com/api/optimize/Kr9jNQk3X89PNSZafWHK9-PxDutPNVxQR327arM8OJ--20250610-031251.png)

:::hint{type="warning"}
To keep your changes, save your project by going to **Project > Save **(or press Ctrl+S on Windows, or Command + S on Mac).
:::

You want to use the power of reporting on summary data and report on cost per impression and return on ad spend (ROAS). To report on these metrics, you have to create two calculated metrics:

1. Create 2 new calculated metrics:
   1. **Cost per impression** Calculated metric:
      1. Click the **+** icon near **Metrics** to create a new calculated metric. 
      2. Specify `[Your name] Cost per Impression` for the **Name**.
      3. Select **Currency** for **Format**.
      4. Specify 4 for **Decimal places**.
      5. In the **Definition **box drag  `Cost (Summary)`
      6. Drag `Impressions (Summary)` below Cost (Summary)
      7. The Summary should be `Cost (Summary) ÷ Impressions (Summary)` 
      8. Select **Save**.
   2. **Return on Ad spend** Calculated metric:
      - Click the **+** icon near **Metrics** to create a new calculated metric. 
      - Specify `[Your name] Return on Ad Spend` for the **Name**.
      - Select **Currency** for **Format**.
      - Select 2 for **Decimal places**.
      - In the **Definition **box drag  `Price Total (participation)`
      - Drag `Cost (Summary)` below Cost (Summary)
      - Change the operator from `÷ `to `-`
      - The Summary should be `Price Total (participation) − Cost (Summary)`**.**
      - Select **Save**.
2. Add your calculated metrics to your reports. From **Metrics**, drag and drop the new calculated metrics (`Cost per Impression` and `Return on Ad Spend`) as an additional column to the Freeform table.
3. Amend the column settings:
   1. Hover the column **Cost per Impression**, click on the gear icon.
   2. Disable **Percent **checkbox.
   3. Enable **Conditional formatting**.
      1. Select **Auto-generated**.
      2. Select a preferred **Conditional formatting palette**.
4. Do the same for **Return on Ad Spend.**

Your panel should now look like:

![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/K6yTjiYdsQ0fJUpdFismc_image.png)

:::hint{type="warning"}
To keep your changes, save your project by going to **Project > Save **(or press Ctrl+S on Windows, or Command + S on Mac).
:::

If you want to report on** Campaign Name** rather than *Tracking Code (Looukp)*, take the following steps:

1. Duplicate the `Return on Advertising Spend Analysis` Freeform table visualization.
2. Rename the duplicated visualization to `Summary Data Report (using Campaign Name`).
3. Replace the **Tracking Code (Lookup) **dimension with the **Campaign Name (Lookup)** dimension.

You can report correctly on **Campaign Name (Lookup)** because of the derived field pre-created, and the summary data group component configuration for Campaign Name. For more information on this process see the [Experience League > Data view steps](https://experienceleague.adobe.com/en/docs/analytics-platform/using/cja-usecases/data-views/summary-data).

Your final project should look like the one shown below:

![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/k2Wdyr5bmqqX6X_GoTASF_image.png)

:::hint{type="warning"}
To keep your changes, save your project by going to **Project > Save **(or press Ctrl+S on Windows, or Command + S on Mac).
:::

:::hint{type="success"}
You've now successfully reported on your Marketing ROAS using Summary data in Customer Journey Analytics!
:::