Google Campaign Manager

Google Campaign Manager (DoubleClick Campaign Manager or DCM before rebranding in July, 2018) is a web-based ad management system for advertisers and agencies. It provides the set of tools for managing digital campaigns across websites and mobile devices. Specifically, you can:

  • Manage creatives and run ad campaigns via Trafficking.

  • View performance data for ads trafficked through the Campaign Manager via Reporting.

  • Check the overall behavior of your ad impressions in the Campaign Manager’s Verification tab.

You can replicate data from your Google Campaign Manager account to the Destination database or data warehouse using Hevo Pipelines.

For creating Pipelines using this Source, Hevo provides you a fully managed BigQuery data warehouse as a possible Destination. This option remains available till the time you set up your first BigQuery Destination irrespective of any other Destinations that you may have. With the managed warehouse, you are only charged the cost that Hevo incurs for your project in Google BigQuery. The invoice is generated at the end of each month and payment is recovered as per the payment instrument you have set up. You can now create your Pipeline and directly start analyzing your Source data. Read Hevo Managed Google BigQuery.


Configuring Google Campaign Manager as a Source

Perform the following steps to configure Google Campaign Manager as the Source in your Pipeline:

  1. Click PIPELINES in the Asset Palette.

  2. Click + CREATE in the Pipelines List View.

  3. In the Select Source Type page, select Google Campaign Manager.

  4. In the Configure your Google Campaign Manager Account page, click + ADD GOOGLE CAMPAIGN MANAGER ACCOUNT.

    Add GCM Account

  5. Select your linked Google account and click Allow in the Sign in with Google page to allow Hevo to read your campaign data.

  6. In the Configure your Google Campaign Manager Source page, specify the following:

    GCM Settings

    • Pipeline Name: A unique name for your Pipeline.

    • User Profile: The Campaign Manager profiles that you want to sync with Hevo.

    • Report Type: The type of report you want to generate. This can be Standard, Reach, or Floodlight. Read Report Types.

    • Dimensions: One or more dimensions that the report must include. These are displayed based on the Report Type you selected in the preceding step.

    • Metrics: One or more metrics that the report must include. These are displayed based on the Report Type you selected.

      Note: Only the metrics compatible with the selected Dimensions are enabled for selection.

  7. Click TEST & CONTINUE.

  8. Proceed to configuring the data ingestion and setting up the Destination.

Data Replication

Default Pipeline Frequency Minimum Pipeline Frequency Maximum Pipeline Frequency Custom Frequency Range (Hrs)
1 Hr 30 Mins 24 Hrs 1-24

Note: The custom frequency must be set in hours, as an integer value. For example, 1, 2, 3 but not 1.5 or 1.75.

Hevo starts ingesting your data from midnight of the day when you create the Pipeline.

If reports are already present in your Google Campaign Manager account prior to creating the Pipeline in Hevo, they are fetched based on profile ID, report type, and the authentication account that was set up when configuring the Google Campaign Manager Source, instead of Dimensions and Metrics.

Data Model

The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:

Note: A unique __hevo_id is created as a hash of Report ID, Profile ID, Date, and a collective hash of all dimensions that are present in the report. This is done for both existing and custom reports created using Hevo.

Table List of Metrics List of Dimensions Description
FLOODLIGHT List of Floodlight Report Metrics List of Floodlight Report Dimensions Floodlight uses a basic attribution model to provide conversion reports which include aggregated data-based Custom Floodlight Variables apart from generic variables other than dimensions and metrics.
REACH List of Reach Report Metrics List of Reach Report Dimensions Reports that show an estimate of how many unique users have interacted with your ads.
STANDARD List of Standard Report Metrics List of Standard Report Dimensions Custom report with standard parameters.

Note: Hevo uses Campaign Manager 360 API v3.5 to fetch all the dimensions, metrics, and filters.

Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Apr-11-2022 NA Added a note in the Data Model section about the API version that Hevo uses.
Oct-25-2021 NA Added the Pipeline frequency information in the Data Replication section.
Last updated on 19 Aug 2022

Tell us what went wrong