Google Search Ads 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": "google_search_ads_360",
  "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": {
    "accounts": [
      "string"
    ],
    "accounts_sync_mode": "ALL_ACCOUNTS | SPECIFIC_ACCOUNTS",
    "advertisers": [
      "string"
    ],
    "advertisers_sync_mode": "ALL_ADVERTISERS",
    "reports": [
      {
        "attributes": "[\"campaign.id\", \"campaign.name\"]",
        "custom_column_ids": [
          "string"
        ],
        "metrics": "[\"metrics.clicks\", \"metrics.impressions\"]",
        "report_type": "campaign",
        "rollback_window": 30,
        "segments": "[\"segments.date\", \"segments.device\"]",
        "table": "campaign_report"
      }
    ],
    "timeframe_months": "TWENTY_FOUR | SIX | ALL_TIME | TWELVE | THREE",
    "schema": "schema_name"
  },
  "auth": {
    "client_access": {
      "client_id": "my_client_id",
      "client_secret": "my_client_secret"
    },
    "refresh_token": "my_refresh_token"
  }
}

Config parameters

Name	Description
`accounts`	Specific accounts to sync. Must be populated if `accountsSyncMode` is set to `SPECIFIC_ACCOUNTS`.
`accounts_sync_mode`	Whether to sync all accounts or specific.
`advertisers`	Specific advertisers to sync. Must be populated if `advertisersSyncMode` is set to `SPECIFIC_ADVERTISERS`.
`advertisers_sync_mode`	Whether to sync all or specific advertisers.
`reports`	The list of reports. Each report corresponds to a table within the schema to which connector syncs the data.
`reports[0].attributes`	The report attributes included to sync. Labeled `Fields` in the Fivetran dashboard.
`reports[0].custom_column_ids`	The report custom column IDs included to sync.
`reports[0].metrics`	The report metrics included to sync.
`reports[0].report_type`	The type of report. Labeled `Resource type` in the Fivetran dashboard.
`reports[0].rollback_window`	The custom window size for rollback syncs (between 2 and 90).
`reports[0].segments`	The report segments included to sync.
`reports[0].table`	The name of a table within the schema to which connector syncs the data of 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

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": "google_search_ads_360",
  "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 Search Ads 360 client application.
`client_access.client_secret`	`Client Secret` of your Google Search Ads 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.