Power BI Connector for Google Ads

Build 24.0.9062

ChangeStatus

Describes the status of returned resource. ChangeStatus 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 ChangeStatus table has extra limitations. You need to provide a time no older than 30 days, and a limit, for example:

  SELECT ChangeStatusCampaign, CustomerId FROM ChangeStatus WHERE ChangeStatusLastChangeDateTime DURING LAST_14_DAYS LIMIT 10

Columns

Name Type Behavior Description
ChangeStatusAdGroup String ATTRIBUTE Output only. The AdGroup affected by this change.
ChangeStatusAdGroupAd String ATTRIBUTE Output only. The AdGroupAd affected by this change.
ChangeStatusAdGroupAsset String ATTRIBUTE Output only. The AdGroupAsset affected by this change.
ChangeStatusAdGroupBidModifier String ATTRIBUTE Output only. The AdGroupBidModifier affected by this change.
ChangeStatusAdGroupCriterion String ATTRIBUTE Output only. The AdGroupCriterion affected by this change.
ChangeStatusAdGroupFeed String ATTRIBUTE Output only. The AdGroupFeed affected by this change.
ChangeStatusAsset String ATTRIBUTE Output only. The Asset affected by this change.
ChangeStatusAssetGroup String ATTRIBUTE Output only. The AssetGroup affected by this change.
ChangeStatusCampaign String ATTRIBUTE Output only. The Campaign affected by this change.
ChangeStatusCampaignAsset String ATTRIBUTE Output only. The CampaignAsset affected by this change.
ChangeStatusCampaignCriterion String ATTRIBUTE Output only. The CampaignCriterion affected by this change.
ChangeStatusCampaignFeed String ATTRIBUTE Output only. The CampaignFeed affected by this change.
ChangeStatusCampaignSharedSet String ATTRIBUTE Output only. The CampaignSharedSet affected by this change.
ChangeStatusCombinedAudience String ATTRIBUTE Output only. The CombinedAudience affected by this change.
ChangeStatusCustomerAsset String ATTRIBUTE Output only. The CustomerAsset affected by this change.
ChangeStatusFeed String ATTRIBUTE Output only. The Feed affected by this change.
ChangeStatusFeedItem String ATTRIBUTE Output only. The FeedItem affected by this change.
ChangeStatusLastChangeDateTime Date ATTRIBUTE Output only. Time at which the most recent change has occurred on this resource.
ChangeStatusResourceName String ATTRIBUTE Output only. The resource name of the change status. Change status resource names have the form: customers/{customer_id}/changeStatus/{change_status_id}
ChangeStatusResourceStatus String ATTRIBUTE Output only. Represents the status of the changed resource.

使用できる値は次のとおりです。ADDED, CHANGED, REMOVED, UNKNOWN, UNSPECIFIED

ChangeStatusResourceType String ATTRIBUTE Output only. Represents the type of the changed resource. This dictates what fields will be set. For example, for AD_GROUP, campaign and ad_group fields will be set.

使用できる値は次のとおりです。AD_GROUP, AD_GROUP_AD, AD_GROUP_ASSET, AD_GROUP_BID_MODIFIER, AD_GROUP_CRITERION, AD_GROUP_FEED, ASSET, ASSET_GROUP, CAMPAIGN, CAMPAIGN_ASSET, CAMPAIGN_CRITERION, CAMPAIGN_FEED, CAMPAIGN_SHARED_SET, COMBINED_AUDIENCE, CUSTOMER_ASSET, FEED, FEED_ITEM, SHARED_SET, UNKNOWN, UNSPECIFIED

ChangeStatusSharedSet String ATTRIBUTE Output only. The SharedSet affected by this change.
CustomerId Long ATTRIBUTE Output only. The ID of the customer.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062