Google Ads Connector

Google Ads Connector

The high-performance Google Ads Connector provides read/write capabilities within your application, allowing you to perform numerous Google Ads operations with minimal coding or even no-coding at all. Integrate Google Ads data into applications such as SSIS, SQL Server, any ODBC-compatible application, or even directly within a programming language using this connector.

Download for SSIS Download for SQL Server and ODBC Documentation

Integrate Google Ads with these applications

All
Data Integration
Database
BI & Reporting
Productivity
Programming Languages
Automation & Scripting
ODBC applications

Actions supported by Google Ads Connector

Google Ads Connector supports following actions for REST API integration:

Get Campaign Keywords

Description

Get Campaign Keywords (For all AdGroup).

Parameters

You can provide the following parameters to this action:

  • CustomerId (without dash e.g. 2125557752)

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • CampaignId
  • CampaignName
  • CampaignResourceName
  • CampaignStatus
  • AdGroupId
  • AdGroupName
  • AdGroupResourceName
  • AdGroupStatus
  • CriterionId
  • CriterionStatus
  • CriterionApprovalStatus
  • CriterionResourceName
  • CriterionFinalUrls
  • CriterionFinalMobileUrls
  • KeywordText
  • KeywordMatchType
  • KeywordCpcBid
  • KeywordCpcBidMicros
  • KeywordCpmBid
  • KeywordCpmBidMicros
  • KeywordResourceName

Visit documentation for more information.

Get Campaigns

Description

Get Google Ads campaign data.

Parameters

You can provide the following parameters to this action:

  • CustomerId (without dash e.g. 2125557752)

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • Name
  • Status
  • StartDate
  • EndDate
  • CampaignBudgetAmount
  • CampaignBudgetAmountMicros
  • TargetCpa
  • TargetCpaMicros
  • MaximizeConversionsTargetCpa
  • MaximizeConversionsTargetCpaMicros
  • KeywordMatchType
  • ResourceName
  • BiddingStrategyType
  • FinalUrlSuffix
  • AdServingOptimizationStatus
  • AdvertisingChannelType
  • NetworkSettingsTargetGoogleSearch
  • NetworkSettingsTargetSearchNetwork
  • NetworkSettingsTargetContentNetwork
  • NetworkSettingsTargetPartnerSearchNetwork
  • NetworkSettingsTargetYoutube
  • NetworkSettingsTargetGoogleTvNetwork
  • ExperimentType
  • ServingStatus
  • DynamicSearchAdsSettingDomainName
  • DynamicSearchAdsSettingLanguageCode
  • DynamicSearchAdsSettingUseSuppliedUrlsOnly
  • TargetingSettingTargetRestrictions
  • GeoTargetTypeSettingPositiveGeoTargetType
  • GeoTargetTypeSettingNegativeGeoTargetType
  • PaymentMode
  • BaseCampaign
  • Labels
  • BiddingStrategySystemStatus
  • PrimaryStatus
  • PrimaryStatusReasons
  • CampaignBudget
  • ManualCpcEnhancedCpcEnabled
  • CampaignGroup
  • AdvertisingChannelSubType
  • TargetSpend
  • TargetSpendMicros
  • FrequencyCaps
  • VideoBrandSafetySuitability
  • AssetAutomationSettings
  • TargetImpressionShareLocation
  • TargetImpressionShareLocationFraction
  • TargetImpressionShareLocationFractionMicros
  • TargetImpressionShareCpcBidCeiling
  • TargetImpressionShareCpcBidCeilingMicros
  • UrlExpansionOptOut
  • AudienceSettingUseAudienceGrouped
  • PerformanceMaxUpgradePerformanceMaxCampaign
  • PerformanceMaxUpgradeStatus
  • OptimizationScore

Visit documentation for more information.

Get Customers

Description

Get Google Ads customer data.

Parameters

You can provide the following parameters to this action:

  • CustomerId (without dash e.g. 2125557752)

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • DescriptiveName
  • Status
  • Manager
  • TestAccount
  • ResourceName
  • CallReportingSettingCallReportingEnabled
  • CallReportingSettingCallConversionReportingEnabled
  • CallReportingSettingCallConversionAction
  • ConversionTrackingSettingConversionTrackingId
  • ConversionTrackingSettingAcceptedCustomerDataTerms
  • ConversionTrackingSettingConversionTrackingStatus
  • ConversionTrackingSettingGoogleAdsConversionCustomer
  • RemarketingSettingGoogleGlobalSiteTag
  • PayPerConversionEligibilityFailureReasons
  • CurrencyCode
  • TimeZone
  • TrackingUrlTemplate
  • AutoTaggingEnabled
  • HasPartnersBadge
  • OptimizationScore
  • OptimizationScoreWeight
  • LocationAssetAutoMigrationDone
  • ImageAssetAutoMigrationDone
  • LocationAssetAutoMigrationDoneDateTime
  • ImageAssetAutoMigrationDoneDateTime

Visit documentation for more information.

Get Linked Customers (For Manager Account)

Description

Get Linked Customers (Must be using Manager Account).

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • ResourceNames

Visit documentation for more information.

Get Report: Campaign Performance (By Date)

Description

Get campaign performance data by date. If you like to customize this report then use get_query_result endpoint.

Parameters

You can provide the following parameters to this action:

  • Report Start Date (yyyy-MM-dd)
  • Report End Date (yyyy-MM-dd)
  • Campaign Id (Default: All)
  • Campaign Status (Default: All)
  • CustomerId (without dash e.g. 2125557752)

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Date
  • Year
  • Month
  • Day
  • Week
  • Quarter
  • DayOfWeek
  • CampaignId
  • CampaignName
  • Clicks
  • Conversions
  • Cost
  • CostMicros
  • CostPerConversion
  • CostPerConversionMicros
  • Impressions
  • InteractionRate
  • Interactions
  • AveragePageViews
  • BounceRate
  • SearchAbsoluteTopImpressionShare
  • SearchBudgetLostAbsoluteTopImpressionShare
  • SearchBudgetLostImpressionShare
  • SearchBudgetLostTopImpressionShare
  • SearchClickShare
  • SearchExactMatchImpressionShare
  • SearchImpressionShare
  • SearchRankLostAbsoluteTopImpressionShare
  • SearchRankLostImpressionShare
  • SearchRankLostTopImpressionShare
  • SearchTopImpressionShare
  • TopImpressionPercentage
  • VideoViews
  • ViewThroughConversions
  • Ctr
  • Engagements
  • AbsoluteTopImpressionPercentage
  • ActiveViewImpressions
  • AllConversions
  • AverageCost
  • AverageCostMicro
  • AverageCpc
  • AverageCpcMicro
  • AverageCpm
  • AverageCpmMicro
  • AverageCpv
  • AverageCpvMicro
  • AverageCpe
  • AverageCpeMicro
  • InvalidClicks
  • CostPerAllConversions
  • CostPerAllConversionsMicro
  • ContentImpressionShare
  • ContentBudgetLostImpressionShare
  • EngagementRate
  • VideoviewRate
  • VideoQuartileP75Rate
  • VideoQuartileP50Rate
  • VideoQuartileP25Rate
  • VideoQuartileP100rate
  • ActiveViewCpm
  • ActiveViewCpmMicro
  • ActiveViewCtr
  • UniqueUsers
  • AverageImpressionFrequencyPerUser

Visit documentation for more information.

Get Report: Campaign Performance (By Year and Month)

Description

Get campaign performance data by year and month. If you like to customize this report then use get_query_result endpoint.

Parameters

You can provide the following parameters to this action:

  • Report Start Date (yyyy-MM-dd)
  • Report End Date (yyyy-MM-dd)
  • Campaign Id (Default: All)
  • Campaign Status (Default: All)
  • CustomerId (without dash e.g. 2125557752)

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Year
  • Month
  • Quarter
  • CampaignId
  • CampaignName
  • Clicks
  • Conversions
  • Cost
  • CostMicros
  • CostPerConversion
  • CostPerConversionMicros
  • Impressions
  • InteractionRate
  • Interactions
  • AveragePageViews
  • BounceRate
  • SearchAbsoluteTopImpressionShare
  • SearchBudgetLostAbsoluteTopImpressionShare
  • SearchBudgetLostImpressionShare
  • SearchBudgetLostTopImpressionShare
  • SearchClickShare
  • SearchExactMatchImpressionShare
  • SearchImpressionShare
  • SearchRankLostAbsoluteTopImpressionShare
  • SearchRankLostImpressionShare
  • SearchRankLostTopImpressionShare
  • SearchTopImpressionShare
  • TopImpressionPercentage
  • VideoViews
  • ViewThroughConversions
  • Ctr
  • Engagements
  • AbsoluteTopImpressionPercentage
  • ActiveViewImpressions
  • AllConversions
  • AverageCost
  • AverageCostMicro
  • AverageCpc
  • AverageCpcMicro
  • AverageCpm
  • AverageCpmMicro
  • AverageCpv
  • AverageCpvMicro
  • AverageCpe
  • AverageCpeMicro
  • InvalidClicks
  • CostPerAllConversions
  • CostPerAllConversionsMicro
  • ContentImpressionShare
  • ContentBudgetLostImpressionShare
  • EngagementRate
  • VideoviewRate
  • VideoQuartileP75Rate
  • VideoQuartileP50Rate
  • VideoQuartileP25Rate
  • VideoQuartileP100rate
  • ActiveViewCpm
  • ActiveViewCpmMicro
  • ActiveViewCtr

Visit documentation for more information.

Get Resource Attributes (For GAQL)

Description

Get attributes you can query (for all or selected resource) using GAQL.

Parameters

You can provide the following parameters to this action:

  • Resource
  • CustomerId (without dash e.g. 2125557752)

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Name
  • Category
  • DataType
  • ResourceName
  • NameForResponse

Visit documentation for more information.

Get Resource Data (Query Attributes, Segments, Metrics)

Description

Get Google Ads resource data without supplying GAQL, easy to use Query Builder to fetch data from any object by its Resource name.

Parameters

You can provide the following parameters to this action:

  • Filter
  • Resource
  • Attributes (Leave blank to select all)
  • Segments (Group By)
  • Metrics (Aggregate Fields)
  • Where Clause
  • OrderBy Clause
  • Limit Clause (i.e. Max Rows) - Blank means all rows
  • CustomerId (without dash e.g. 2125557752)

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • <<[Dynamic Column]|~|true|~|proper|~|.|~|_-.@|~|1,FUN_PROPERCASE>>
  • <<[Dynamic Column]|~|true|~|proper|~|.|~|_-.@|~|1|~|_micros$|~|,FUN_PROPERCASE>>

Visit documentation for more information.

Get Resource Metrics (For GAQL)

Description

Get metrics you can query (for all or selected resource) using GAQL, Numeric fields which can be aggregated (e.g. clicks, impressions).

Parameters

You can provide the following parameters to this action:

  • Resource
  • CustomerId (without dash e.g. 2125557752)

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Name
  • ResourceName

Visit documentation for more information.

Get Resource Segments (For GAQL)

Description

Get segments (Group By Fields) for all or selected resource using GAQL.

Parameters

You can provide the following parameters to this action:

  • Resource
  • CustomerId (without dash e.g. 2125557752)

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Name
  • ResourceName

Visit documentation for more information.

Get Resources (For GAQL)

Description

Get resources you can query for GAQL.

Parameters

You can provide the following parameters to this action:

  • CustomerId (without dash e.g. 2125557752)

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Name
  • ResourceName

Visit documentation for more information.

Query Google Ads data (Using GAQL - Google Ads Query Language)

Description

Get Google Ads report data using GAQL (Google Ads Query Language) SQL query. Use Query builder from this link to select fields, segments, and metrics https://developers.google.com/google-ads/api/fields/v18/overview_query_builder (Click on Resource type you like to query) for SELECT, FROM and ORDER BY.

Parameters

You can provide the following parameters to this action:

  • Enter Query (i.e. GAQL sql)
  • Filter
  • CustomerId (without dash e.g. 2125557752)

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

Make Generic API Request

Description

This is generic endpoint. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL.

Parameters

You can provide the following parameters to this action:

  • Url
  • Body
  • IsMultiPart
  • Filter
  • Headers

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

Make Generic API Request (Bulk Write)

Description

This is a generic endpoint for bulk write purpose. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL.

Parameters

You can provide the following parameters to this action:

  • Url
  • IsMultiPart
  • Filter
  • Headers

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

Download for SSIS Download for SQL Server and ODBC