Hi, I am able to get the records based on your given query. But I want records based on "segments.month = '2024-05-01'" on the where clause instead of "segments.date = '2024-05-01'".
I'm getting empty records when I'm using the below query. SELECT conversion_action.id, conversion_action.name, metrics.all_conversions, metrics.all_conversions_value, conversion_action.category FROM conversion_action WHERE segments.month = '2024-05-01' Please provide an appropriate solution for this issue. Thanks On Monday, June 10, 2024 at 10:01:27 AM UTC+5:30 Google Ads API Forum Advisor wrote: > Hi, > > Thank you for reaching out to the Google Ads API support team. > > Please be informed that I have removed your response from the forums as it > contains the PII information. > > I understand that you're getting an empty response when querying the > conversion_action > <https://developers.google.com/google-ads/api/fields/v17/conversion_action> > report. I have tried to replicate the issue from my end using the customer > ID '7731521629' and I got a successful run on the query and results are > returned. Kindly see the below query with the minor changes: > > > SELECT conversion_action.id, conversion_action.name, metrics.all_conversions, > metrics.all_conversions_value, conversion_action.category FROM > conversion_action WHERE segments.date = '2024-05-01' > > Also, I would suggest you use the Query Builder > <https://developers.google.com/google-ads/api/fields/v17/conversion_action_query_builder> > > to build your query and Query Validator > <https://developers.google.com/google-ads/api/fields/v17/query_validator> > to validate your query. > > Hope this helps! Let us know if you have any further queries. > > This message is in relation to case > "ref:!00D1U01174p.!5004Q02tJG3i:ref" (ADR-00239033) > > Thanks, > > [image: Google Logo] Google Ads API Team > > > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/a07a7cb8-7e53-4f60-9e1a-1b257025e9f4n%40googlegroups.com.
