Adding 'segments.date' to my query prevents 'ad_group_ad.ad.name' from being returned

[Serhat G]

As the title says, the return value of my query is lacking `ad_group_ad.ad.name` when I include `segments.date` in the query as well. As soon as I remove it, `ad_group_ad.ad.name` show up in the response.

I cannot simply exclude one of the columns as both of them are essential for me at this point.

Here is my entire query:

"""

                SELECT ad_group_ad.ad.id,

                    ad_group.id,

                    campaign.id,

                    segments.date,

                    ad_group_ad.status,

                    ad_group_ad.ad.type,

                    ad_group_ad.ad.name,

                    ad_group_ad.ad.call_ad.headline1,

                    ad_group_ad.ad.call_ad.headline2,

                    ad_group_ad.ad.expanded_text_ad.headline_part1,

                    ad_group_ad.ad.expanded_text_ad.headline_part2,

                    ad_group_ad.ad.expanded_text_ad.headline_part3,

                    ad_group_ad.ad.legacy_responsive_display_ad.long_headline,

                    ad_group_ad.ad.legacy_responsive_display_ad.short_headline,

                    ad_group_ad.ad.text_ad.headline,

                    ad_group_ad.ad.text_ad.description1,

                    ad_group_ad.ad.text_ad.description2,

                    ad_group_ad.ad.expanded_text_ad.description2,

                    ad_group_ad.ad.expanded_text_ad.description,

                    ad_group_ad.ad.final_urls,

                    customer.currency_code,

                    metrics.impressions,

                    metrics.cost_micros,

                    metrics.cost_per_all_conversions,

                    metrics.cost_per_conversion,

                    metrics.clicks,

                    metrics.gmail_secondary_clicks,

                    metrics.conversions,

                    metrics.conversions_from_interactions_rate,

                    metrics.all_conversions_from_interactions_rate,

                    metrics.engagement_rate,

                    metrics.interactions,

                    metrics.interaction_rate,

                    metrics.percent_new_visitors,

                    metrics.top_impression_percentage,

                    metrics.value_per_all_conversions,

                    metrics.value_per_conversion

                FROM ad_group_ad

                WHERE segments.date BETWEEN '2022-06-01' AND ' 2022-06-01 '

"""

This issue has occurred with any date range I have tried.

Please let me know if there are any other details that I may share to help clarify the problem. Thank you!

[Google Ads API Forum Advisor]

Hi Serhat,

Thank you for reaching out. I am Carmela, a member of the Google Ads API team.

Moving forward, for further investigation of this issue and so our team can try this on our end, could you provide the complete request and response logs with request ID and request header generated on your end?

You can provide it via Reply privately to author option. If this option is not available, then send it instead on this email address googleadsa...@google.com.

Regards,

Carmela Google Ads API Team

ref:_00D1U1174p._5004Q2bcVJh:ref