SELECT
ad_group_criterion.criterion_id,
ad_group_criterion.keyword.text,
ad_group_criterion.status,
ad_group_criterion.labels,
ad_group.name,
ad_group.status,
ad_group.id,
campaign.name,
campaign.id,
metrics.impressions,
metrics.conversions,
metrics.cost_per_conversion,
ad_group_criterion.effective_cpc_bid_micros,
metrics.clicks,
metrics.ctr,
metrics.average_cpc
FROM keyword_view
WHERE segments.date DURING YESTERDAY
AND campaign.status = 'ENABLED'
AND ad_group.status = 'ENABLED'
AND ad_group_criterion.status = 'ENABLED'