Google Campaign Manager 360: Tips and best practices#

Configuring the dimension filter with a JSON expression#

When configuring a Google Campaign Manager 360 datastream, you can configure a dimension filter for most datastream types. Enter a JSON expression into the dimension filter to collect data on certain fields. Use the dimension filter to collect highly-specific data from your data source.

To configure data collection from a datastream, follow these steps:

  1. Go to the Datastreams page.

  2. Open the Google Campaign Manager 360 datastream by clicking on its name.

  3. In the top navigation panel, click Settings.

  4. In Dimension Filter, enter a valid JSON expression.

  5. Click Save.

Examples of a JSON expression#

Typically, a JSON expression would take the following format.

{
   "kind": "dfareporting#dimensionValue",
   "dimensionName": string,
   "value": string,
   "id": string,
   "matchType": string
}

You can use multiple expressions within a single JSON expression.

For example, use a JSON expression to retrieve data from a Google Campaign Manager 360 datastream.

The values to retrieve are as follows:

  • Two specific values (8069163 and 8067471) for the dimension activityId.

  • These two vales are associated with another specific value (Adverity), which belongs to the dimension site.

To retrieve this set of data, enter the following JSON expression into Dimension Filter.

[
   {
     "dimensionName": "activityId",
     "kind": "dfareporting#dimensionFilter",
     "value": "8069163"
   },
   {
     "dimensionName": "activityId",
     "kind": "dfareporting#dimensionFilter",
      "value": "8067471"
   },
   {
     "dimensionName": "site",
     "kind": "dfareporting#dimensionFilter",
     "id": "5147781",
     "value": "Adverity"
   }
]

Previewing an image#

It is not possible to preview an image for this connector.