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.