How do I collect spend data by campaign data by country?

[Dmitrii Bevz]

The docs are so sophisticated and there are no clear simple use cases how to use, such a mess! 

I need simple user acquisition data - impressions, clicks, costs. And I want to have it splitted by campaign, ad_group (if possible), by country code. by customer_id. Could someone help me to figure out how I can get it?

I used the following query:

SELECT
  customer.id,
  segments.date,
  campaign.id,
  campaign.name,
  ad_group.id,
  ad_group.name,
  segments.geo_target_county,
  metrics.impressions,
  metrics.clicks,
  metrics.cost_micros
FROM
  geographic_view

But a lot of values are filled with nulls, and I see that this data doesn't match our overall performance, seems like a lot of segment.date are just missing

[Dmitrii Bevz]

No options?