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. |