Diese Seite enthält einige SQL-Code-Snippets, die zeigen, wie die verschiedenen Felder, Messwerte, Segmente und Ressourcen verwendet werden. Sie können diese Abfragen unverändert oder als Ausgangspunkt für die Erstellung eigener benutzerdefinierter Abfragen verwenden.
Kampagne
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'
Anzeigengruppe
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'
Anzeige in der Anzeigengruppe
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'
Keywords
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'
Geokonstanten ermitteln
Verwenden Sie die Ressource location_view, um eine geo_target_konstante ID abzurufen.
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
Beachten Sie, dass die API Standorte anhand ihrer Kriteriums-IDs zurückgibt. Um die Anzeigenamen abzurufen, verwenden Sie die API, um die Ressource geo_target_constant abzufragen.
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'