Google Ads
Google Ads ETL connector for data replication
Last updated
Google Ads ETL connector for data replication
Last updated
Sign in to Daton
Select GoogleAds from Integrations page
Provide Integration Name, Replication Frequency, Attribution window and History. Integration name would be used in creating tables for the integration and cannot be changed later
You will be redirected to GoogleAds login for authorizing Daton to extract data periodically
Post successful authentication, you will be prompted to create table names and link a resource.
Select a combination of Attributes, Metrics and Dimensions
Submit the integration
Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
Users would be able to edit/pause/re-activate/delete integration anytime
Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
Official Documentation: https://developers.google.com/google-ads/api/fields/v10/overview
The Campaign.status column retrieves the current status of a campaign, and data in the campaigns table (resource) in the Google Ads API is fetched for all possible statuses. The possible statuses for a campaign are:
ENABLED
PAUSED
REMOVED
UNKNOWN
UNSPECIFIED
However, when validating data against the UI, you may not retrieve campaigns with the statuses "REMOVED," "UNKNOWN," or "UNSPECIFIED," which could lead to data discrepancies. To address this, you can either filter out these campaigns using the Campaign.status column or ensure you fetch data for all campaigns directly from the UI.
| Resource name | Description | Documentation |
|---|---|---|