Google Campaign Manager 360 API Configuration

For more information about authentication, accessing the Fivetran REST API, and request and response formats, see Getting Started with the Fivetran REST API.

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,
    "all_fields": 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"
  },
  "destination_schema_names": "FIVETRAN_NAMING",
  "external_secrets_manager_id": "esm_id",
  "config": {
    "conversion_dimensions": [
      "string"
    ],
    "custom_floodlight_variables": [
      "string"
    ],
    "dimensions": [
      "string"
    ],
    "enable_all_dimension_combinations": true,
    "metrics": [
      "string"
    ],
    "per_interaction_dimensions": [
      "string"
    ],
    "report_configuration_ids": [
      "string"
    ],
    "report_type": "REACH | FLOODLIGHT | PATH_TO_CONVERSION | STANDARD",
    "reports": [
      {
        "conversion_dimensions": [
          "string"
        ],
        "custom_floodlight_variables": [
          "string"
        ],
        "dimensions": [
          "string"
        ],
        "enable_all_dimension_combinations": true,
        "metrics": [
          "string"
        ],
        "per_interaction_dimensions": [
          "string"
        ],
        "report_configuration_ids": [
          "string"
        ],
        "report_type": "REACH | FLOODLIGHT | PATH_TO_CONVERSION | STANDARD",
        "rollback_window": 30,
        "table": "string"
      }
    ],
    "sync_mode": "SPECIFIC_PROFILES | ALL_PROFILES",
    "timeframe_months": "TWENTY_FOUR | SIX | ALL_TIME | TWELVE | THREE",
    "user_profiles": [
      "string"
    ],
    "schema": "schema_name",
    "table": "table_name"
  },
  "auth": {
    "client_access": {
      "client_id": "my_client_id",
      "client_secret": "my_client_secret"
    },
    "refresh_token": "my_refresh_token"
  }
}

Config parameters

Name	Description
`conversion_dimensions`	Conversion Dimensions.
`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.
`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
`enable_all_dimension_combinations`	Whether to enable all reach dimension combinations in the report. Default value: `false`
`metrics`	Report metrics to include into a sync.
`per_interaction_dimensions`	Per Interaction Dimensions.
`report_configuration_ids`	You can select only one Floodlight Configuration ID per account.
`report_type`	Type of reporting data to sync. Default value: `STANDARD`.
`reports`	List of reports
`reports[0].conversion_dimensions`	Conversion Dimensions.
`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].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
`reports[0].enable_all_dimension_combinations`	Specifies whether to enable all reach dimension combinations in the report. Default value: `false`
`reports[0].metrics`	Report metrics to include into a sync.
`reports[0].per_interaction_dimensions`	Per Interaction Dimensions.
`reports[0].report_configuration_ids`	You can select only one Floodlight Configuration ID per account.
`reports[0].report_type`	Type of reporting data to sync. Default value: `STANDARD`.
`reports[0].rollback_window`	The custom window size for rollback syncs (between 1 and 90).
`reports[0].table`	Destination table name. It must be unique within this connection and must comply with Fivetran's naming conventions.
`sync_mode`	Whether to sync all user profiles or specific ones. Default value: `AllAccounts`.
`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`.
`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_id": "my_client_id",
      "client_secret": "my_client_secret"
    },
    "refresh_token": "my_refresh_token"
  }
}

Auth Parameters

Name	Description
`client_access`
`client_access.client_id`	`Client ID` of your Google Campaign Manager 360 client application.
`client_access.client_secret`	`Client Secret` of your Google Campaign Manager 360 client application.
`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.

By using the Connect Card or the Fivetran dashboard.