Google Ad Manager 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_publishers",
  "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": {
    "ad_unit_view": "HIERARCHICAL | TOP_LEVEL | FLAT",
    "columns": [
      "string"
    ],
    "custom_dimension_key_ids": [
      0
    ],
    "custom_field_ids": [
      0
    ],
    "dimension_attributes": [
      "string"
    ],
    "dimensions": [
      "string"
    ],
    "network_code": 1234567,
    "reports": [
      {
        "ad_unit_view": "HIERARCHICAL | TOP_LEVEL | FLAT",
        "columns": [
          "string"
        ],
        "custom_dimension_key_ids": [
          0
        ],
        "custom_field_ids": [
          0
        ],
        "dimension_attributes": [
          "string"
        ],
        "dimensions": [
          "string"
        ],
        "table": "line_item_report"
      }
    ],
    "timeframe_months": "TWENTY_FOUR | SIX | ALL_TIME | TWELVE | THREE",
    "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
`ad_unit_view`	Ad unit view for the report.
`columns`	Columns provide all trafficking statistics and revenue information available for the chosen Dimensions.
`custom_dimension_key_ids`	The list of custom dimension key IDs included in the report. Custom dimension keys can only be selected with the CUSTOM_DIMENSION dimension.
`custom_field_ids`	The list of custom field IDs included in the report. Custom fields can only be selected with their corresponding dimensions.
`dimension_attributes`	Dimension attributes provide additional fields associated with a Dimension. Dimension attributes can only be selected with their corresponding Dimensions.
`dimensions`	Report dimensions to include in the sync. The `date` dimension is mandatory for all the report types.
`network_code`	Network code is a unique, numeric identifier for your Ad Manager network.
`reports`	The list of reports. We create a table within the schema for each report.
`reports[0].ad_unit_view`	Ad unit view for the report.
`reports[0].columns`	Columns provide all trafficking statistics and revenue information available for the chosen dimensions.
`reports[0].custom_dimension_key_ids`	The list of custom dimension key IDs included in the report. Custom dimension keys can only be selected with the CUSTOM_DIMENSION dimension.
`reports[0].custom_field_ids`	The list of custom field IDs included in the report. Custom fields can only be selected with their corresponding dimensions.
`reports[0].dimension_attributes`	Dimension attributes provide additional fields associated with a dimension. Dimension attributes can only be selected with their corresponding dimensions.
`reports[0].dimensions`	Report dimensions to include in the sync. The `date` dimension is mandatory for all the report types.
`reports[0].table`	The name of the table within the schema storing the data for a given report.
`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.
`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_publishers",
  "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 Ad Manager client application.
`client_access.client_secret`	`Client Secret` of your Google Ad Manager 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.