Google Campaign Manager

Last updated on May 30, 2023
On This Page

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.

Prerequisites

Managing Access to your Google Campaign Manager Account (Optional)

You can add new users to or change the permissions of existing users in your Google Campaign Manager (GCM) account only if you have Admin rights. As the account administrator, you can:

  • Set up access for a user: Add the email address of the user requesting access. This must be an email address associated with a Google account. To grant access, follow the steps in this document.

  • Create or edit user profiles: A user profile grants a user access to a specific GCM account, and a user can have multiple profiles. To create user profiles or edit existing ones, follow the steps in this document.

  • Assign user roles: User roles are a set of permissions that determine the data that a user can view or edit for their GCM profile. Read User roles for details, such as creating a user role and the default roles available.

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 Navigation Bar.

  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.

Note: You cannot modify any field post-Pipeline creation.

  1. Click TEST & CONTINUE.

  2. 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.


See Also

Revision History

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

Date Release Description of Change
Oct-25-2022 2.00 Added the section, Managing Access to your Google Campaign Manager Account with information on the how a GCM administrator can provide access to other users.
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.
Was this page helpful?

Tell us what went wrong