Ad_Group_Ad Segment.date

[Oswaldo Santana]

I have the next query :

SELECT

    ad_group_ad.ad.type,

    ad_group_ad.status,

    ad_group_ad.ad.name,

    ad_group_ad.ad.id,

    metrics.impressions,

    metrics.clicks,

    metrics.interactions,

    metrics.average_cpv,

    metrics.average_cost,

    metrics.cost_micros,

    metrics.conversions,

    metrics.cost_per_conversion,

    metrics.conversions_value,

    metrics.conversions_from_interactions_rate,

    metrics.average_cpc,

    metrics.value_per_conversion,

    metrics.all_conversions_from_interactions_rate,

    metrics.ctr,

    metrics.all_conversions,

    metrics.all_conversions_value,

    metrics.value_per_all_conversions,

         metrics.cost_per_all_conversions,

         metrics.cost_per_conversion,

         metrics.video_views,

         metrics.video_quartile_25_rate,

         metrics.video_quartile_50_rate,

         metrics.video_quartile_75_rate,

         metrics.video_quartile_100_rate,

         segments.month

    FROM

    ad_group_ad

    """

Everything runs smoothly, nevertheless my program crashes when I change the segments.month to segments.week or segments.date

I've tried segments.date using DATE RANGES and the same result.

Hope someone can help me!

Thank you!

[Google Ads API Forum Advisor Prod]

Hi Oswaldo,

I have responded to you directly in our already existing thread so please respond there if you have any additional questions.

Regards,
Mitchell
Google Ads API Team

ref:_00D1U1174p._5001UV0CZV:ref