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
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
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:
-
N/A
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.