获取资产属性和指标
使用集合让一切井井有条
根据您的偏好保存内容并对其进行分类。
素材资源属性
您可以向 SearchAds360Service 发送 Search Ads 360 查询语言查询,获取素材资源及其属性的列表。资产由 asset
实体表示,该实体公开了许多特定于资产的字段。
以下查询会列出广告客户账号中的所有素材资源及其资源名称和类型。
SELECT
asset.id,
asset.name,
asset.resource_name,
asset.type
FROM asset
请注意,您可以向上述查询添加类型专用属性,以读取特定于素材资源的属性,例如 SitelinkAsset
或 MobileAppAsset
。
例如,以下查询会通过过滤 MobileAppAsset
的 asset.type
值,列出账号中所有 MobileAppAsset
对象的移动应用 ID。
SELECT
asset.id,
asset.name,
asset.resource_name,
asset.mobile_app_asset.app_store
FROM asset
WHERE asset.type = 'MOBILE_APP'
素材资源指标
您可以通过以下几个资源查看资产指标:
借助这些资源,您可以在各个级别查询素材资源指标。
例如,在查询 ad_group_asset
资源时,可以使用 ad_group.id
字段对结果进行细分,从而检索 ad_group
和 asset
的每个唯一组合的指标:
SELECT
ad_group.id,
asset.id,
metrics.clicks,
metrics.impressions
FROM ad_group_asset
WHERE segments.date DURING LAST_MONTH
ORDER BY metrics.impressions DESC
如未另行说明,那么本页面中的内容已根据知识共享署名 4.0 许可获得了许可,并且代码示例已根据 Apache 2.0 许可获得了许可。有关详情,请参阅 Google 开发者网站政策。Java 是 Oracle 和/或其关联公司的注册商标。
最后更新时间 (UTC):2025-08-29。
[null,null,["最后更新时间 (UTC):2025-08-29。"],[[["\u003cp\u003eRetrieve a list of assets and their attributes, including resource name and type, using Search Ads 360 Query Language.\u003c/p\u003e\n"],["\u003cp\u003eAccess type-specific attributes, such as mobile app IDs, by filtering the \u003ccode\u003easset.type\u003c/code\u003e value in your query.\u003c/p\u003e\n"],["\u003cp\u003eQuery asset metrics at the ad group, campaign, or customer level through respective resources like \u003ccode\u003ead_group_asset\u003c/code\u003e, \u003ccode\u003ecampaign_asset\u003c/code\u003e, and \u003ccode\u003ecustomer_asset\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eSegment asset metric results by fields like \u003ccode\u003ead_group.id\u003c/code\u003e to analyze performance for specific combinations of assets and ad groups, campaigns, or customers.\u003c/p\u003e\n"]]],["Assets and their attributes can be retrieved by sending a Search Ads 360 Query Language query to the SearchAds360Service, using the `asset` entity. Type-specific attributes can be added to queries. Asset metrics are available through `ad_group_asset`, `campaign_asset`, and `customer_asset` resources, enabling queries at various levels. For example, metrics can be retrieved for each unique combination of `ad_group` and `asset` using `ad_group_asset` resource.\n"],null,["# Fetching Asset Attributes and Metrics\n\nAsset attributes\n----------------\n\nYou can get a list of assets and their attributes by sending a [Search Ads 360\nQuery Language query](/search-ads/reporting/query/query-language) to the SearchAds360Service.\nAssets are represented by the [`asset`](/search-ads/reporting/api/reference/fields/v0/asset) entity, which exposes a\nnumber of asset-specific fields.\n\nThe following query lists all assets in an advertiser's account along with\ntheir resource name and type. \n\n SELECT\n asset.id,\n asset.name,\n asset.resource_name,\n asset.type\n FROM asset\n\nNote that there are type-specific attributes that you could add to the above\nquery to read properties specific to assets such as\n[`SitelinkAsset`](/search-ads/reporting/api/reference/rpc/google.ads.searchads360.v0.common#unifiedsitelinkasset) or\n[`MobileAppAsset`](/search-ads/reporting/api/reference/rpc/google.ads.searchads360.v0.common#mobileappasset).\n\nFor example, the following query lists the mobile app IDs for all\n[`MobileAppAsset`](/search-ads/reporting/api/reference/rpc/google.ads.searchads360.v0.common#mobileappasset) objects in an account by\nfiltering the [`asset.type`](/search-ads/reporting/api/reference/fields/v0/asset#asset.type) value for\n[`MobileAppAsset`](/search-ads/reporting/api/reference/rpc/google.ads.searchads360.v0.common#mobileappasset). \n\n SELECT\n asset.id,\n asset.name,\n asset.resource_name,\n asset.mobile_app_asset.app_store\n FROM asset\n WHERE asset.type = 'MOBILE_APP'\n\nAsset metrics\n-------------\n\nAsset metrics are made available through a few resources:\n\n- [`ad_group_asset`](/search-ads/reporting/api/reference/fields/v0/ad_group_asset)\n- [`campaign_asset`](/search-ads/reporting/api/reference/fields/v0/campaign_asset)\n- [`customer_asset`](/search-ads/reporting/api/reference/fields/v0/customer_asset)\n\nWith these resources, asset metrics can be queried at each respective level.\nFor instance, when querying the `ad_group_asset` resource, the `ad_group.id`\nfield can be used to segment the results, thereby retrieving metrics for each\nunique combination of `ad_group` and `asset`: \n\n SELECT\n ad_group.id,\n asset.id,\n metrics.clicks,\n metrics.impressions\n FROM ad_group_asset\n WHERE segments.date DURING LAST_MONTH\n ORDER BY metrics.impressions DESC"]]