How to pull segments.conversion_actions* from New Ads API? I am getting UNRECOGNIZED_FIELD error.

495 views
Skip to first unread message

Darshan Pradhan

unread,
Mar 9, 2019, 6:29:53 PM3/9/19
to AdWords API and Google Ads API Forum
Hi Support, 

I am looking to pull conversion_actions related fields from segments resource. The segments.conversion_actions  documentation states that is is selectable from most of the View resources. But I am getting following error , please see the details below and advice. 


2019-03-10 10:09:35,080 INFO  [Gax-3] logging.RequestLogger (RequestLogger.java:151) - FAILURE REQUEST DETAIL.
Request
-------
MethodName: google.ads.googleads.v0.services.GoogleAdsService/Search
Headers: {developer-token=REDACTED, login-customer-id=8730611186, x-goog-api-client=gl-java/11.0.1 gapic/ gax/1.35.0 grpc/1.16.1}
Body: customer_id: "REDACTED"
query: "SELECT segments.date,  segments.device, segments.conversion_action, segments.conversion_action_category, segments.conversion_action_name, ad_group_ad.ad.id,  ad_group_ad.status,  metrics.active_view_cpm, metrics.active_view_ctr, metrics.active_view_impressions, metrics.active_view_measurability, metrics.active_view_measurable_cost_micros, metrics.active_view_measurable_impressions, metrics.active_view_viewability, metrics.all_conversions, metrics.all_conversions_from_interactions_rate, metrics.all_conversions_from_interactions_value_per_interaction, metrics.all_conversions_value, metrics.all_conversions_value_per_cost, metrics.average_cost, metrics.average_cpc, metrics.average_cpe, metrics.average_cpm, metrics.average_cpv, metrics.average_position, metrics.clicks, metrics.conversions, metrics.conversions_from_interactions_rate, metrics.conversions_from_interactions_value_per_interaction, metrics.conversions_value, metrics.conversions_value_per_cost, metrics.cost_micros, metrics.cost_per_all_conversions, metrics.cost_per_conversion, metrics.cost_per_current_model_attributed_conversion, metrics.cross_device_conversions, metrics.ctr, metrics.current_model_attributed_conversions, metrics.current_model_attributed_conversions_from_interactions_rate, metrics.current_model_attributed_conversions_from_interactions_value_per_interaction, metrics.current_model_attributed_conversions_value, metrics.current_model_attributed_conversions_value_per_cost, metrics.engagement_rate, metrics.engagements, metrics.gmail_forwards, metrics.gmail_saves, metrics.gmail_secondary_clicks, metrics.impressions, metrics.interaction_rate, metrics.interactions, metrics.top_impression_percentage, metrics.value_per_all_conversions, metrics.value_per_conversion, metrics.value_per_current_model_attributed_conversion, metrics.video_quartile_100_rate, metrics.video_quartile_25_rate, metrics.video_quartile_50_rate, metrics.video_quartile_75_rate, metrics.video_view_rate, metrics.video_views, metrics.view_through_conversions FROM ad_group_ad WHERE segments.date DURING LAST_30_DAYS  AND ad_group_ad.status IN (ENABLED, PAUSED) AND metrics.impressions > 0 "
page_size: 1000


Response
--------
Headers: Metadata(content-type=application/grpc,request-id=-gqaZyUzn6ADVyNtPGMzLQ,date=Sat, 09 Mar 2019 23:09:34 GMT,alt-svc=quic=":443"; ma=2592000; v="46,44,43,39")
Body: null
Status: Status{code=INVALID_ARGUMENT, description=Request contains an invalid argument., cause=null}.
Request ID -gqaZyUzn6ADVyNtPGMzLQ failed due to GoogleAdsException. Underlying errors:
  Error 0: error_code {
  query_error: UNRECOGNIZED_FIELD
}
message: "Unrecognized fields in the query: \'segments.conversion_action_category\', \'segments.conversion_action\', \'segments.conversion_action_name\'."




 I have already tried fetching segments.conversion_action for these resources and I am get same error:

keyword_view

ad_group_audience_view

campaign_audience_view

age_range_view

parental_status_view

gender_view

ad_group_ad

googleadsapi...@google.com

unread,
Mar 11, 2019, 3:23:17 AM3/11/19
to AdWords API and Google Ads API Forum
Hi Darshan,

Thank you for providing detailed information on your issue. Upon replicating this issue on my end, I could also encounter the same error. However, to further investigate this, I will check this with the team and will provide you an update as soon as available.

Thanks and regards,
Luis
Google Ads API Team



On 03/10/19 07:27:39 darshan wrote:
Forgot to add : I have already tried fetching segments.conversion_action for these resources and I am get same error:
Body: customer_id: "9254837834"
query: "SELECT segments.date,  segments.device, segments.conversion_action, segments.conversion_action_category, segments.conversion_action_name, ad_group_ad.ad.id,  ad_group_ad.status,  metrics.active_view_cpm, metrics.active_view_ctr, metrics.active_view_impressions, metrics.active_view_measurability, metrics.active_view_measurable_cost_micros, metrics.active_view_measurable_impressions, metrics.active_view_viewability, metrics.all_conversions, metrics.all_conversions_from_interactions_rate, metrics.all_conversions_from_interactions_value_per_interaction, metrics.all_conversions_value, metrics.all_conversions_value_per_cost, metrics.average_cost, metrics.average_cpc, metrics.average_cpe, metrics.average_cpm, metrics.average_cpv, metrics.average_position, metrics.clicks, metrics.conversions, metrics.conversions_from_interactions_rate, metrics.conversions_from_interactions_value_per_interaction, metrics.conversions_value, metrics.conversions_value_per_cost, metrics.cost_micros, metrics.cost_per_all_conversions, metrics.cost_per_conversion, metrics.cost_per_current_model_attributed_conversion, metrics.cross_device_conversions, metrics.ctr, metrics.current_model_attributed_conversions, metrics.current_model_attributed_conversions_from_interactions_rate, metrics.current_model_attributed_conversions_from_interactions_value_per_interaction, metrics.current_model_attributed_conversions_value, metrics.current_model_attributed_conversions_value_per_cost, metrics.engagement_rate, metrics.engagements, metrics.gmail_forwards, metrics.gmail_saves, metrics.gmail_secondary_clicks, metrics.impressions, metrics.interaction_rate, metrics.interactions, metrics.top_impression_percentage, metrics.value_per_all_conversions, metrics.value_per_conversion, metrics.value_per_current_model_attributed_conversion, metrics.video_quartile_100_rate, metrics.video_quartile_25_rate, metrics.video_quartile_50_rate, metrics.video_quartile_75_rate, metrics.video_view_rate, metrics.video_views, metrics.view_through_conversions FROM ad_group_ad WHERE segments.date DURING LAST_30_DAYS  AND ad_group_ad.status IN (ENABLED, PAUSED) AND metrics.impressions > 0 "
page_size: 1000


Response
--------
Headers: Metadata(content-type=application/grpc,request-id=-gqaZyUzn6ADVyNtPGMzLQ,date=Sat, 09 Mar 2019 23:09:34 GMT,alt-svc=quic=":443"; ma=2592000; v="46,44,43,39")
Body: null
Status: Status{code=INVALID_ARGUMENT, description=Request contains an invalid argument., cause=null}.
Request ID -gqaZyUzn6ADVyNtPGMzLQ failed due to GoogleAdsException. Underlying errors:
  Error 0: error_code {
  query_error: UNRECOGNIZED_FIELD
}
message: "Unrecognized fields in the query: \'segments.conversion_action_category\', \'segments.conversion_action\', \'segments.conversion_action_name\'."


--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscribe@googlegroups.com
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 "AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscribe@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/6d9bcbb0-0e73-4406-a12b-be36527fb1c2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Darshan Pradhan

unread,
Mar 11, 2019, 11:36:37 PM3/11/19
to AdWords API and Google Ads API Forum
Thanks for taking a look at this Luis, I look forward to hearing from you soon on this issue. 

googleadsapi...@google.com

unread,
Mar 12, 2019, 12:34:15 PM3/12/19
to AdWords API and Google Ads API Forum
Hello Darshan, 

The segments.conversion_action fields are selectable in v1. Please check this section of the guide as a reference. Based on the logs shared, it looks like you're using v0. Could you please try these with the latest client library using v1 and let us know if you're having an issue?

Thanks,
Bharani, Google Ads API Team

Was your question answered? Please rate your experience with us by taking a short survey.
If not -- reply to this email and tell us what else we can do to help.

Take Survey

Also find us on our blog and discussion group:
http://googleadsdeveloper.blogspot.com/search/label/adwords_api
https://developers.google.com/adwords/api/community/

Darshan Pradhan

unread,
Mar 13, 2019, 12:12:44 PM3/13/19
to AdWords API and Google Ads API Forum
Thanks Bharani, I am able to pull segments.conversion_action fields using the new version 1. I have another question regarding fetching all the conversion_action for a customer account. I can't seem to pull those using the version 1. Can you please advise on that as well?

Darshan Pradhan

unread,
Mar 13, 2019, 1:03:12 PM3/13/19
to AdWords API and Google Ads API Forum
Here is a link to my question regarding pulling all conversion_action from a customer account. https://groups.google.com/forum/#!topic/adwords-api/Dm-ImYeZrXI

googleadsapi...@google.com

unread,
Mar 13, 2019, 3:34:06 PM3/13/19
to AdWords API and Google Ads API Forum
Hello Darshan, 

It looks like our team is already following up with you on the other thread. Please continue the discussion on that thread to avoid duplicates.

Thanks,
Bharani, Google Ads API Team
Reply all
Reply to author
Forward
0 new messages