Google Search Ads 360

The Google Search Ads 360 Connector provides automated ingestion of ad campaign conversion reporting.

Prerequisites

This data source requires a Google Account credential. The Google Account must have access to Search Ads 360 reporting. Google Service Account credentials are not supported.

Scheduling

The Google Search Ads 360 Connector can be scheduled to ingest data once per day at a user-defined hour and timezone. By default, the connector will run once at 6am PT. See Daily Scheduling for more information.

Parameters

report_type
The following report types are supported:
  • account
  • ad
  • advertiser
  • adGroup
  • adGroupTarget
  • bidStrategy
  • campaign
  • campaignTarget
  • conversion
  • feedItem
  • floodlightActivity
  • keyword
  • negativeAdGroupKeyword
  • negativeAdGroupTarget
  • negativeCampaignKeyword
  • negativeCampaignTarget
  • paidAndOrganic
  • productAdvertised
  • productGroup
  • productLeadAndCrossSell
  • productTarget
  • visit

Switchboard Script Syntax

import google_search_ads_360_ad_raw from {
    type: "google_search_ads_360;
    key: "google_token_key";
    report_type: "ad";
} using {
    status: string;
    engineStatus: string;
    creationTimestamp: datetime;
    lastModifiedTimestamp: datetime;
    agency: string;
    agencyId: integer;
    advertiser: string;
    advertiserId: integer;
    account: string;
    accountId: integer;
    accountEngineId: string;
    accountType: string;
    campaign: string;
    campaignId: integer;
    campaignStatus: string;
    adGroup: string;
    adGroupId: integer;
    adGroupStatus: string;
    ad: string;
    adId: integer;
    adEngineId: integer;
    isUnattributedAd: boolean;
    adHeadline: string;
    adHeadline2: string;
    adHeadline3: string;
    adDescription1: string;
    adDescription2: string;
    adDisplayUrl: string;
    adLandingPage: string;
    adType: string;
    adPromotionLine: string;
    adLabels: string;
    adPathField1: string;
    adPathField2: string;
    effectiveLabels: string;
    dfaActions: integer;
    dfaRevenue: float;
    dfaTransactions: integer;
    dfaWeightedActions: float;
    dfaActionsCrossEnv: float;
    dfaRevenueCrossEnv: float;
    dfaTransactionsCrossEnv: float;
    dfaWeightedActionsCrossEnv: float;
    avgCpc: float;
    avgCpm: float;
    avgPos: float;
    clicks: integer;
    cost: float;
    ctr: float;
    impr: integer;
    adWordsConversions: float;
    adWordsConversionValue: float;
    adWordsViewThroughConversions: integer;
    visits: integer;
    date: date;
};