Describes the granular change of returned resources of certain resource

View-Specific Information

Select

Google Ads does not allow every column to be selected in a single query, as some data conflicts if selected together. Therefore, when issuing a query that selects all columns, only the default metrics, segments, and attributes are 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 using the following supported operators: =, !=, >, >=, <, <=, LIKE, NOT LIKE, IN, NOT IN . Note that all filters must be joined by AND, as OR is not supported by the Ads API.

The ChangeEvent view has additional API restrictions. When executing the following query:

SELECT * FROM ChangeEvent

the provider automatically applies the following constraints:

• A filter on the ChangeEventChangeDatetime column restricted to the last 30 days (the maximum allowed range, as data older than 30 days cannot be retrieved through this view).
• A LIMIT clause capped at 10,000 records (the maximum allowed per request).

Note: These constraints are applied automatically to prevent an API error. You can restrict the results even further by passing smaller filters, such as a shorter date range or a lower 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	Datetime	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 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.
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_RECOMMENDATIONS_SUBSCRIPTION, GOOGLE_ADS_SCRIPTS, GOOGLE_ADS_WEB_CLIENT, INTERNAL_TOOL, OTHER, SEARCH_ADS_360_POST, SEARCH_ADS_360_SYNC, UNKNOWN.
ChangeEventNewResource	String	ATTRIBUTE	Output only. The new resource after the change. Only changed fields will be
ChangeEventOldResource	String	ATTRIBUTE	Output only. The old resource before the change. Only changed fields will
ChangeEventResourceChangeOperation	String	ATTRIBUTE	Output only. The operation on the changed resource. The allowed values are CREATE, REMOVE, UNKNOWN, UPDATE.
ChangeEventResourceName	String	ATTRIBUTE	Output only. The resource name of the change event.
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 more granular control over the data returned from the data source.

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