Re: SELECT segments.conversion_action FROM ad_group_ad

Hi Wei, Thank you for reaching out. The fields 'ctr', 'cost_micros', 'average_cpc', 'clicks', 'conversions_from_interactions_rate', 'impressions', 'average_cost', 'average_cpm', 'cost_per_conversion' are not yet supported when you have segments.conversion_action_name in the SELECT clause. I hav

Re: SELECT segments.conversion_action FROM ad_group_ad

Thank you! You solved one of my problem. Can't believe I didn't notice the order clause lol. However, I want to make a report has necessary columns like imps clicks ctr cvr ...etc, and combine with coversion_action_name. Cuz we set some tailored conversion in the platform when we run ads like Cu

RE: SELECT segments.conversion_action FROM ad_group_ad

Hi Wei, Thank you for reaching out. You are receiving this error "The following field must be present in SELECT clause: 'metrics.impressions'." as you had put 'ORDER BY metrics.impressions DESC ' in your query. If you remove this ORDER BY clause, the issue should be fixed. Please let me know if