Google Campaign Manager 360 API Configuration

Request

POST https://api.fivetran.com/v1/connections

{
  "group_id": "group_id",
  "service": "double_click_campaign_manager",
  "trust_certificates": true,
  "trust_fingerprints": true,
  "run_setup_tests": true,
  "paused": false,
  "pause_after_trial": false,
  "sync_frequency": 1440,
  "data_delay_sensitivity": "NORMAL",
  "data_delay_threshold": 0,
  "daily_sync_time": "14:00",
  "schedule_type": "auto",
  "connect_card_config": {
    "redirect_uri": "https://your.site/path",
    "hide_setup_guide": true
  },
  "proxy_agent_id": "proxy_agent_id",
  "private_link_id": "private_link_id",
  "networking_method": "Directly",
  "hybrid_deployment_agent_id": "hybrid_deployment_agent_id",
  "destination_configuration": {
    "virtual_warehouse": "virtual_warehouse"
  },
  "config": {
    "reports": [
      {
        "enable_all_dimension_combinations": true,
        "report_configuration_ids": [
          "string"
        ],
        "custom_floodlight_variables": [
          "string"
        ],
        "conversion_dimensions": [
          "string"
        ],
        "metrics": [
          "string"
        ],
        "report_type": "FLOODLIGHT",
        "table": "string",
        "per_interaction_dimensions": [
          "string"
        ],
        "dimensions": [
          "string"
        ]
      }
    ],
    "conversion_dimensions": [
      "string"
    ],
    "report_type": "REACH | FLOODLIGHT | PATH_TO_CONVERSION | STANDARD",
    "per_interaction_dimensions": [
      "string"
    ],
    "sync_mode": "SPECIFIC_PROFILES | ALL_PROFILES",
    "report_configuration_ids": [
      "string"
    ],
    "enable_all_dimension_combinations": true,
    "custom_floodlight_variables": [
      "string"
    ],
    "timeframe_months": "TWENTY_FOUR | SIX | ALL_TIME | TWELVE | THREE",
    "user_profiles": [
      "string"
    ],
    "metrics": [
      "string"
    ],
    "dimensions": [
      "string"
    ],
    "schema": "schema_name",
    "table": "table_name"
  },
  "auth": {
    "refresh_token": "my_refresh_token",
    "client_access": {
      "client_secret": "my_client_secret",
      "client_id": "my_client_id"
    }
  }
}

Config parameters

Name	Description
`reports`	List of reports
`reports[0].enable_all_dimension_combinations`	Specifies whether to enable all reach dimension combinations in the report. Default value: `false`
`reports[0].report_configuration_ids`	You can select only one Floodlight Configuration ID per account.
`reports[0].custom_floodlight_variables`	Custom Floodlight variables enable you to capture information beyond the basics (visits and revenue) that you can collect with standard parameters in your tags.
`reports[0].conversion_dimensions`	Conversion Dimensions.
`reports[0].metrics`	Report metrics to include into a sync.
`reports[0].report_type`	Type of reporting data to sync. Default value: `STANDARD`.
`reports[0].table`	Destination table name. It must be unique within this connection and must comply with Fivetran's naming conventions.
`reports[0].per_interaction_dimensions`	Per Interaction Dimensions.
`reports[0].dimensions`	Report dimensions to include in a sync. The `date` dimension is mandatory for all report types. The `advertiser` dimension is mandatory for the `REACH` report type
`conversion_dimensions`	Conversion Dimensions.
`report_type`	Type of reporting data to sync. Default value: `STANDARD`.
`per_interaction_dimensions`	Per Interaction Dimensions.
`sync_mode`	Whether to sync all user profiles or specific ones. Default value: `AllAccounts`.
`report_configuration_ids`	You can select only one Floodlight Configuration ID per account.
`enable_all_dimension_combinations`	Whether to enable all reach dimension combinations in the report. Default value: `false`
`custom_floodlight_variables`	Custom Floodlight variables enable you to capture information beyond the basics (visits and revenue) that you can collect with standard parameters in your tags.
`timeframe_months`	Number of months' worth of reporting data you'd like to include in your initial sync. A change of this value will trigger a re-sync for enabled reports during the next connector sync. Default value: `TWELVE`.
`user_profiles`	IDs of specific User Profiles to sync. Must be populated if `sync_mode` is set to `SpecificAccounts`.
`metrics`	Report metrics to include into a sync.
`dimensions`	Report dimensions to include into a sync. The `date` dimension is mandatory for all the report types. The `advertiser` dimension is mandatory for `REACH` report type
`schema` (required)	Destination schema name. Schema name is permanent and cannot be changed after connection creation
`table` (required)	Destination table. Table is permanent and cannot be changed after connection creation

Authorization

There are two ways to authorize this connector type:

By specifying the values for the client_access and refresh_token parameters in the auth section.

POST https://api.fivetran.com/v1/connections

{
  "service": "double_click_campaign_manager",
  "group_id": "group_id",
  "auth": {
    "client_access": {
      "client_secret": "my_client_secret",
      "client_id": "my_client_id"
    },
    "refresh_token": "my_refresh_token"
  }
}

Auth Parameters

Name	Description
`refresh_token`	The long-lived `Refresh token` along with the `client_id` and `client_secret` parameters carry the information necessary to get a new access token for API resources.
`client_access`
`client_access.client_secret`	`Client Secret` of your Google Campaign Manager 360 client application.
`client_access.client_id`	`Client ID` of your Google Campaign Manager 360 client application.

By using the Connect Card or the Fivetran dashboard.