---
schema_version: "1"
id: b2b172587d1316160f7269ec3173b121ef7ad1a9070a319c8fa7efb42614294a
title: Reporting Reach at Multiple Entity Levels
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/dato_data_reach_reporting_entity.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.dato_data_reach_reporting_entity.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: d638954734f54d217ff28b30cbc19feb80268e35de5bbf21ad112145a1d9676c
description: To see reach at multiple levels or different frequencies in Intelligence for example, daily, weekly, or monthly, you create multiple APIs or TotalConnect data streams, differing the entity dimensions or date range per data stream.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# Reporting Reach at Multiple Entity Levels

To see reach at multiple levels or different frequencies in Intelligence for example, daily, weekly, or monthly, you create multiple APIs or TotalConnect data streams, differing the entity dimensions or date range per data stream.

To use one reach value across entities, you can create a calculated dimension using the CONTEXT functions. CONTEXT functions return different measurements based on the dimensional values in the query. With CONTEXT, you can use one measurement regardless of the dimensional or date range level in a table or pivot—for example, a pivot table reporting Campaign Reach at the Campaign level, and Media Buy Reach at the Media Buy level.

To create a calculated measurement using a CONTEXT\_DIMENSIONS() formula:

```
if(CONTEXT_DIMENSIONS () contains ‘ [Media_Buy_Name] ’ ) {
          return [Media_Buy_Reach];
}
else if (CONTEXT_DIMENSIONS () contains ‘[Campaign_Name]’ ){
         return [Campaign_Reach];
}
```

NOTE - To pull reach beyond 31 days and up to 90 days, your account must have an API User. API User is a premium feature available for purchase.