ODBC Driver for Google Ads

Build 25.0.9434

AssetGroupAsset

AssetGroupAsset is the link between an asset and an asset group. Adding an AssetGroupAsset links an asset with an asset group.

Columns

Name Type Behavior Description
AssetGroupAssetAsset String ATTRIBUTE Immutable. The asset which this asset group asset is linking.
AssetGroupAssetAssetGroup String ATTRIBUTE Immutable. The asset group which this asset group asset is linking.
AssetGroupAssetFieldType String ATTRIBUTE The description of the placement of the asset within the asset group. For example: HEADLINE, YOUTUBE_VIDEO etc

The allowed values are AD_IMAGE, BOOK_ON_GOOGLE, BUSINESS_LOGO, BUSINESS_MESSAGE, BUSINESS_NAME, CALL, CALLOUT, CALL_TO_ACTION_SELECTION, DEMAND_GEN_CAROUSEL_CARD, DESCRIPTION, HEADLINE, HOTEL_CALLOUT, HOTEL_PROPERTY, LANDSCAPE_LOGO, LEAD_FORM, LOGO, LONG_HEADLINE, MANDATORY_AD_TEXT, MARKETING_IMAGE, MEDIA_BUNDLE, MOBILE_APP, PORTRAIT_MARKETING_IMAGE, PRICE, PROMOTION, SITELINK, SQUARE_MARKETING_IMAGE, STRUCTURED_SNIPPET, TALL_PORTRAIT_MARKETING_IMAGE, UNKNOWN, VIDEO, YOUTUBE_VIDEO.

AssetGroupAssetPerformanceLabel String ATTRIBUTE Output only. The performance of this asset group asset.

The allowed values are BEST, GOOD, LEARNING, LOW, PENDING, UNKNOWN.

AssetGroupAssetPolicySummaryApprovalStatus String ATTRIBUTE The overall approval status, which is calculated based on the status of its individual policy topic entries.

The allowed values are APPROVED, APPROVED_LIMITED, AREA_OF_INTEREST_ONLY, DISAPPROVED, UNKNOWN.

AssetGroupAssetPolicySummaryPolicyTopicEntries String ATTRIBUTE The list of policy findings.
AssetGroupAssetPolicySummaryReviewStatus String ATTRIBUTE Where in the review process the resource is.

The allowed values are ELIGIBLE_MAY_SERVE, REVIEWED, REVIEW_IN_PROGRESS, UNDER_APPEAL, UNKNOWN.

AssetGroupAssetPrimaryStatus String ATTRIBUTE Output only. Provides the PrimaryStatus of this asset link. Primary status is meant essentially to differentiate between the plain 'status' field, which has advertiser set values of enabled, paused, or removed. The primary status takes into account other signals (for assets its mainly policy and quality approvals) to come up with a more comprehensive status to indicate its serving state.

The allowed values are ELIGIBLE, LIMITED, NOT_ELIGIBLE, PAUSED, PENDING, REMOVED, UNKNOWN.

AssetGroupAssetPrimaryStatusDetails String ATTRIBUTE Output only. Provides the details of the primary status and its associated reasons.
AssetGroupAssetPrimaryStatusReasons String ATTRIBUTE Output only. Provides a list of reasons for why an asset is not serving or not serving at full capacity.

The allowed values are ASSET_APPROVED_LABELED, ASSET_DISAPPROVED, ASSET_LINK_PAUSED, ASSET_LINK_REMOVED, ASSET_UNDER_REVIEW, UNKNOWN.

AssetGroupAssetResourceName String ATTRIBUTE Immutable. The resource name of the asset group asset. Asset group asset resource name have the form: customers/{customer_id}/assetGroupAssets/{asset_group_id}~{asset_id}~{field_type}
AssetGroupAssetSource String ATTRIBUTE Output only. Source of the asset group asset.

The allowed values are ADVERTISER, AUTOMATICALLY_CREATED, UNKNOWN.

AssetGroupAssetStatus String ATTRIBUTE The status of the link between an asset and asset group.

The allowed values are ENABLED, PAUSED, REMOVED, UNKNOWN.

CustomerId Long ATTRIBUTE Output only. The ID of the customer.
Conversions Double METRIC The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions.
ConversionsValue Double METRIC The value of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions.
ValuePerConversion Double METRIC The value of conversions divided by the number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions.
Date Date SEGMENT Date to which metrics apply. yyyy-MM-dd format, for example, 2018-04-17.
DayOfWeek String SEGMENT Day of the week, for example, MONDAY.

The allowed values are FRIDAY, MONDAY, SATURDAY, SUNDAY, THURSDAY, TUESDAY, UNKNOWN, WEDNESDAY.

Month Date SEGMENT Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd.
Period String SEGMENT Predefined date range.

The allowed values are TODAY, YESTERDAY, LAST_7_DAYS, LAST_BUSINESS_WEEK, THIS_MONTH, LAST_MONTH, LAST_14_DAYS, LAST_30_DAYS, THIS_WEEK_SUN_TODAY, THIS_WEEK_MON_TODAY, LAST_WEEK_SUN_SAT, LAST_WEEK_MON_SUN.

Quarter Date SEGMENT Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, for example, the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd.
Week Date SEGMENT Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd.
Year Int SEGMENT Year, formatted as yyyy.

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) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434