示例查询
使用集合让一切井井有条
根据您的偏好保存内容并对其进行分类。
本页面汇总了一些 SQL 代码段,展示了如何使用不同的字段、指标、细分和资源。您可以直接使用这些查询,也可以将其用作构建自定义查询的起点。
广告系列
SELECT
campaign.name,
campaign_budget.amount_micros,
campaign.status,
campaign.advertising_channel_type,
metrics.clicks,
metrics.impressions,
metrics.ctr,
metrics.average_cpc,
metrics.cost_micros,
campaign.bidding_strategy_type
FROM campaign
WHERE segments.date DURING LAST_7_DAYS
AND campaign.status != 'REMOVED'
广告组
SELECT
ad_group.name,
campaign.name,
ad_group.status,
ad_group.type,
metrics.clicks,
metrics.impressions,
metrics.ctr,
metrics.average_cpc,
metrics.cost_micros
FROM ad_group
WHERE segments.date DURING LAST_7_DAYS
AND ad_group.status != 'REMOVED'
广告组广告
SELECT
ad_group_ad.ad.expanded_text_ad.headline,
ad_group_ad.ad.expanded_text_ad.headline2,
ad_group_ad.ad.expanded_text_ad.headline3,
ad_group_ad.ad.final_urls,
ad_group_ad.ad.expanded_text_ad.description1,
ad_group_ad.ad.expanded_text_ad.description2,
campaign.name,
ad_group.name,
ad_group_ad.ad.type,
metrics.clicks,
metrics.impressions,
metrics.ctr,
metrics.average_cpc,
metrics.cost_micros
FROM ad_group_ad
WHERE segments.date DURING LAST_7_DAYS
AND ad_group_ad.status != 'REMOVED'
关键字
SELECT
ad_group_criterion.keyword.text,
campaign.name,
ad_group.name,
ad_group_criterion.keyword.match_type,
ad_group_criterion.final_urls,
metrics.clicks,
metrics.impressions,
metrics.ctr,
metrics.average_cpc,
metrics.cost_micros
FROM keyword_view
WHERE segments.date DURING LAST_7_DAYS
AND ad_group_criterion.status != 'REMOVED'
年龄(受众特征)
SELECT
ad_group_criterion.age_range.type,
campaign.name,
ad_group.name,
ad_group_criterion.bid_modifier,
metrics.clicks,
metrics.impressions,
metrics.ctr,
metrics.average_cpc,
metrics.cost_micros,
campaign.advertising_channel_type
FROM age_range_view
WHERE segments.date DURING LAST_7_DAYS
性别(受众特征)
SELECT
ad_group_criterion.gender.type,
campaign.name,
ad_group.name,
ad_group_criterion.bid_modifier,
metrics.clicks,
metrics.impressions,
metrics.ctr,
metrics.average_cpc,
metrics.cost_micros,
campaign.advertising_channel_type
FROM gender_view
WHERE segments.date DURING LAST_7_DAYS
如何查找地理位置常量
使用 location_view 资源获取 geo_target_constant ID。
SELECT
campaign.name,
campaign.id,
campaign_criterion.criterion_id,
campaign_criterion.location.geo_target_constant,
location_view.resource_name,
metrics.cost_micros,
metrics.impressions,
metrics.cost_micros
FROM
location_view
WHERE
segments.date DURING LAST_7_DAYS
请注意,该 API 会按条件 ID 返回地理位置。如需获取其显示名称,请使用 API 查询 geo_target_constant 资源。
SELECT
geo_target_constant.canonical_name,
geo_target_constant.country_code,
geo_target_constant.id,
geo_target_constant.name,
geo_target_constant.status,
geo_target_constant.target_type
FROM geo_target_constant
WHERE geo_target_constant.resource_name = 'geoTargetConstants/1014044'
如未另行说明,那么本页面中的内容已根据知识共享署名 4.0 许可获得了许可,并且代码示例已根据 Apache 2.0 许可获得了许可。有关详情,请参阅 Google 开发者网站政策。Java 是 Oracle 和/或其关联公司的注册商标。
最后更新时间 (UTC):2025-08-29。
[null,null,["最后更新时间 (UTC):2025-08-29。"],[[["\u003cp\u003eThis page provides SQL code snippets for querying various Google Ads data, such as campaigns, ad groups, and keywords.\u003c/p\u003e\n"],["\u003cp\u003eThese snippets can be used as-is or customized to build your own queries for extracting specific data points.\u003c/p\u003e\n"],["\u003cp\u003eThe queries primarily focus on performance metrics (clicks, impressions, cost, etc.) and attributes of different Google Ads components.\u003c/p\u003e\n"],["\u003cp\u003eExamples are provided for retrieving data for specific date ranges and filtering by status, like campaigns or ad groups that are not removed.\u003c/p\u003e\n"],["\u003cp\u003eThe page also includes guidance on querying geographical data using location and geo target constant resources.\u003c/p\u003e\n"]]],["The content provides SQL queries for retrieving data from various advertising resources. These queries retrieve information on campaigns, ad groups, ads, keywords, and demographics (age and gender), including metrics like clicks, impressions, and costs. Each query filters data from the last 7 days and excludes removed items. There are additional queries to show how to get location information by the geo constant ID, and how to query for more details on those IDs.\n"],null,["# Sample queries\n\nThis page collects some SQL code snippets that show how to use the different\nfields, metrics, segments and resources. You can use these queries as is or as\nstarting points on for constructing your own customized queries.\n\nCampaign\n--------\n\n SELECT\n campaign.name,\n campaign_budget.amount_micros,\n campaign.status,\n campaign.advertising_channel_type,\n metrics.clicks,\n metrics.impressions,\n metrics.ctr,\n metrics.average_cpc,\n metrics.cost_micros,\n campaign.bidding_strategy_type\n FROM campaign\n WHERE segments.date DURING LAST_7_DAYS\n AND campaign.status != 'REMOVED'\n\nAd Group\n--------\n\n SELECT\n ad_group.name,\n campaign.name,\n ad_group.status,\n ad_group.type,\n metrics.clicks,\n metrics.impressions,\n metrics.ctr,\n metrics.average_cpc,\n metrics.cost_micros\n FROM ad_group\n WHERE segments.date DURING LAST_7_DAYS\n AND ad_group.status != 'REMOVED'\n\nAd Group Ad\n-----------\n\n SELECT\n ad_group_ad.ad.expanded_text_ad.headline,\n ad_group_ad.ad.expanded_text_ad.headline2,\n ad_group_ad.ad.expanded_text_ad.headline3,\n ad_group_ad.ad.final_urls,\n ad_group_ad.ad.expanded_text_ad.description1,\n ad_group_ad.ad.expanded_text_ad.description2,\n campaign.name,\n ad_group.name,\n ad_group_ad.ad.type,\n metrics.clicks,\n metrics.impressions,\n metrics.ctr,\n metrics.average_cpc,\n metrics.cost_micros\n FROM ad_group_ad\n WHERE segments.date DURING LAST_7_DAYS\n AND ad_group_ad.status != 'REMOVED'\n\nKeywords\n--------\n\n SELECT\n ad_group_criterion.keyword.text,\n campaign.name,\n ad_group.name,\n ad_group_criterion.keyword.match_type,\n ad_group_criterion.final_urls,\n metrics.clicks,\n metrics.impressions,\n metrics.ctr,\n metrics.average_cpc,\n metrics.cost_micros\n FROM keyword_view\n WHERE segments.date DURING LAST_7_DAYS\n AND ad_group_criterion.status != 'REMOVED'\n\nAge (Demographics)\n------------------\n\n SELECT\n ad_group_criterion.age_range.type,\n campaign.name,\n ad_group.name,\n ad_group_criterion.bid_modifier,\n metrics.clicks,\n metrics.impressions,\n metrics.ctr,\n metrics.average_cpc,\n metrics.cost_micros,\n campaign.advertising_channel_type\n FROM age_range_view\n WHERE segments.date DURING LAST_7_DAYS\n\nGender (Demographics)\n---------------------\n\n SELECT\n ad_group_criterion.gender.type,\n campaign.name,\n ad_group.name,\n ad_group_criterion.bid_modifier,\n metrics.clicks,\n metrics.impressions,\n metrics.ctr,\n metrics.average_cpc,\n metrics.cost_micros,\n campaign.advertising_channel_type\n FROM gender_view\n WHERE segments.date DURING LAST_7_DAYS\n\nHow to look up geo constants\n----------------------------\n\nUse [location_view](/search-ads/reporting/api/reference/fields/v0/location_view) resource to get a\ngeo_target_constant ID. \n\n SELECT\n campaign.name,\n campaign.id,\n campaign_criterion.criterion_id,\n campaign_criterion.location.geo_target_constant,\n location_view.resource_name,\n metrics.cost_micros,\n metrics.impressions,\n metrics.cost_micros\n FROM\n location_view\n WHERE\n segments.date DURING LAST_7_DAYS\n\nNote that the API returns locations by their criterion IDs.\nTo get their display names, use the API to query the\n[geo_target_constant](/search-ads/reporting/api/reference/fields/v0/geo_target_constant) resource. \n\n SELECT\n geo_target_constant.canonical_name,\n geo_target_constant.country_code,\n geo_target_constant.id,\n geo_target_constant.name,\n geo_target_constant.status,\n geo_target_constant.target_type\n FROM geo_target_constant\n WHERE geo_target_constant.resource_name = 'geoTargetConstants/1014044'"]]