TDV Adapter for Google Ads

Build 22.0.8462

ChangeEvent

Describes the granular change of returned resource of certain resource types. Changes made through UI, API and new versions of Editor by external users (including external users, and internal users that can be shown externally) in the past 30 days will be shown. The change shows the old values of the changed fields before the change and the new values right after the change. ChangeEvent could have up to 3 minutes delay to reflect a new change.

Table Specific Information

Select

Google Ads does not allow every column to be selected in a single query as some data will conflict if selected together. Therefore, when issuing a query that selects all columns, only the default metrics, segments, and attributes will be returned. In general, these defaults are the same fields that are exposed through the Ads console.

To use the nondefault fields, explicitly select them in your query.

Filters can also be used in the WHERE clause. The supported operators are the =, !=, >, >=, <, <=, LIKE, NOT LIKE, IN, and NOT IN operators. All filters must be joined by the AND keyword as OR is not supported by the Ads API.

The ChangeEvent table has extra limitations. You need to provide a time no older than 30 days, and a limit, for example:

  SELECT ChangeEventCampaign, CustomerId FROM ChangeEvent WHERE ChangeEventChangeDateTime DURING LAST_14_DAYS LIMIT 10

Columns

Name Type Behavior Description
ChangeEventAdGroup String ATTRIBUTE Output only. The AdGroup affected by this change.
ChangeEventAsset String ATTRIBUTE Output only. The Asset affected by this change.
ChangeEventCampaign String ATTRIBUTE Output only. The Campaign affected by this change.
ChangeEventChangeDateTime Date ATTRIBUTE Output only. Time at which the change was committed on this resource.
ChangeEventChangeResourceName String ATTRIBUTE Output only. The Simply resource this change occurred on.
ChangeEventChangeResourceType String ATTRIBUTE Output only. The type of the changed resource. This dictates what resource will be set in old_resource and new_resource.

The allowed values are AD, AD_GROUP, AD_GROUP_AD, AD_GROUP_ASSET, AD_GROUP_BID_MODIFIER, AD_GROUP_CRITERION, AD_GROUP_FEED, ASSET, ASSET_SET, ASSET_SET_ASSET, CAMPAIGN, CAMPAIGN_ASSET, CAMPAIGN_ASSET_SET, CAMPAIGN_BUDGET, CAMPAIGN_CRITERION, CAMPAIGN_FEED, CUSTOMER_ASSET, FEED, FEED_ITEM, UNKNOWN, UNSPECIFIED.

ChangeEventChangedFields String ATTRIBUTE Output only. A list of fields that are changed in the returned resource.
ChangeEventClientType String ATTRIBUTE Output only. Where the change was made through.

The allowed values are GOOGLE_ADS_API, GOOGLE_ADS_AUTOMATED_RULE, GOOGLE_ADS_BULK_UPLOAD, GOOGLE_ADS_EDITOR, GOOGLE_ADS_MOBILE_APP, GOOGLE_ADS_RECOMMENDATIONS, GOOGLE_ADS_SCRIPTS, GOOGLE_ADS_WEB_CLIENT, INTERNAL_TOOL, OTHER, SEARCH_ADS_360_POST, SEARCH_ADS_360_SYNC, UNKNOWN, UNSPECIFIED.

ChangeEventFeed String ATTRIBUTE Output only. The Feed affected by this change.
ChangeEventFeedItem String ATTRIBUTE Output only. The FeedItem affected by this change.
ChangeEventNewResource String ATTRIBUTE Output only. The new resource after the change. Only changed fields will be populated.
ChangeEventOldResource String ATTRIBUTE Output only. The old resource before the change. Only changed fields will be populated.
ChangeEventResourceChangeOperation String ATTRIBUTE Output only. The operation on the changed resource.

The allowed values are CREATE, REMOVE, UNKNOWN, UNSPECIFIED, UPDATE.

ChangeEventResourceName String ATTRIBUTE Output only. The resource name of the change event. Change event resource names have the form: customers/{customer_id}/changeEvents/{timestamp_micros}~{command_index}~{mutate_index}
ChangeEventUserEmail String ATTRIBUTE Output only. The email of the user who made this change.
CustomerId Long ATTRIBUTE Output only. The ID of the customer.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
ManagerId Long Id of the manager account on behalf of which you are requesting customer data.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462