SELECT
campaign.name,campaign.optimization_score,metrics.impressions,metrics.cost_micros,
metrics.conversions_value,
metrics.interaction_rate,metrics.interactions,metrics.average_cost,metrics.cost_per_conversion,
metrics.conversions,
metrics.conversions_from_interactions_rate,segments.date,
campaign.status,
campaign.id,campaign_budget.amount_micros,
campaign.name,campaign.status, campaign.start_date,campaign.end_date,
campaign_budget.has_recommended_budget,metrics.clicks,metrics.average_cpc,metrics.ctr,
campaign_budget.recommended_budget_amount_micros from campaign
where segments.date DURING TODAY AND campaign.status = 'ENABLED'
AND campaign.advertising_channel_type='SEARCH'