Consultas de muestra

En esta página, se recopilan algunos fragmentos de código SQL que muestran cómo usar los diferentes campos, métricas, segmentos y recursos. Puedes usar estas consultas tal como están o como puntos de partida para crear tus propias consultas personalizadas.

Campaña

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'

Grupo de anuncios

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'

Anuncio del grupo de anuncios

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'

Palabras clave

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'

Edad (datos demográficos)

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

Género (datos demográficos)

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

Cómo buscar constantes geográficas

Usa el recurso location_view para obtener un ID de geo_target_constant.

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

Ten en cuenta que la API muestra las ubicaciones según sus IDs de criterio. Para obtener sus nombres visibles, usa la API para consultar el recurso 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'