Hi Anthony,
Thanks for the answer. Sorry, i was in middle of completing the development 
rest of the reports and couldn't respond.
Please find my response and additional questions below.

*1. As you said, I don't find any metrics in "ad_group_criterion 
<https://developers.google.com/google-ads/api/fields/v3/ad_group_criterion>" 
resource. Can you please clarify, is the keyword performance is same as 
criteria performance report as the attributes are matching?*

*2. When i execute the below "Ad Group Performance Report" & "Campaign 
Performance Report" queries, getting exception "INVALID_ARGUMENT" (below 
are the detailed exception for both reports). Can you please let me know 
what is the issue with queries? I am not getting this with "Keyword 
(keyword_view) & Ad Performance (ad_group_ad)"*


*Ad Group Performance Report Query:*


SELECT 

ad_group.id, campaign.id, segments.date, ad_group.name, ad_group.type, 
ad_group.status, campaign.name, 

ad_group.tracking_url_template, ad_group.labels, 
metrics.absolute_top_impression_percentage, 

metrics.active_view_impressions, 
metrics.active_view_measurable_cost_micros, 

metrics.active_view_measurable_impressions, 
metrics.all_conversions_from_interactions_rate, 

metrics.all_conversions, metrics.all_conversions_value, 
metrics.average_cost, 

metrics.average_cpe, metrics.average_cpv, metrics.clicks, 
metrics.conversions_from_interactions_rate, 

metrics.conversions, metrics.conversions_value, metrics.cost_micros, 
metrics.cost_per_all_conversions, 

metrics.cost_per_conversion, 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.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 

WHERE 

segments.date >= START_DATE AND 

segments.date <= END_DATE 

ORDER BY 

ad_group.id ASC;


*Ad Group Performance Report Response & Exception:*


Response

--------------


Headers: 
Metadata(content-type=application/grpc,request-id=34M-s_ITnDxzKzB1duyWUA,date=Mon,
 
22 Jun 2020 23:21:37 GMT,alt-svc=h3-29=":443"; ma=2592000,h3-27=":443"; 
ma=2592000,h3-25=":4

43"; ma=2592000,h3-T050=":443"; ma=2592000,h3-Q050=":443"; 
ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043=":443"; 
ma=2592000,quic=":443"; ma=2592000; v="46,43")

Body: null

Failure message: errors {

  error_code {

request_error: UNKNOWN

  }

  message: "The error code is not in this version."

  trigger {

string_value: "Day.day"

  }

}

errors {

  error_code {

request_error: UNKNOWN

  }

  message: "The error code is not in this version."

  trigger {

string_value: "A_ad_group__AdGroupAssociation.entity_id"

  }

}

errors {

  error_code {

request_error: UNKNOWN

  }

  message: "The error code is not in this version."

  trigger {

string_value: "AdGroupAssociation.ad_group_id"

  }

}

errors {

  error_code {

request_error: UNKNOWN

  }

  message: "The error code is not in this version."

  trigger {

string_value: "AdGroupAssociation.entity_type"

  }

}


Status: Status{code=INVALID_ARGUMENT, description=Request contains an 
invalid argument., cause=null}.

Generic Exception: com.google.api.gax.rpc.InvalidArgumentException: 
io.grpc.StatusRuntimeException: INVALID_ARGUMENT: Request contains an 
invalid argument.

com.google.api.gax.rpc.InvalidArgumentException: 
io.grpc.StatusRuntimeException: INVALID_ARGUMENT: Request contains an 
invalid argument.

at 
com.google.api.gax.rpc.ApiExceptionFactory.createException(ApiExceptionFactory.java:49)


*Campaign Performance Report Query:*


SELECT 

campaign.id, segments.date, campaign.name, campaign.status, 
campaign.advertising_channel_sub_type, 

campaign.tracking_url_template, campaign.url_custom_parameters, 
campaign.labels, 

metrics.absolute_top_impression_percentage, 
metrics.active_view_impressions, 
metrics.active_view_measurable_cost_micros, 

metrics.active_view_measurable_impressions, 
metrics.all_conversions_from_interactions_rate, 

metrics.all_conversions, metrics.all_conversions_value, 
metrics.average_cost, metrics.average_cpe, metrics.average_cpv, 

metrics.clicks, metrics.conversions_from_interactions_rate, 
metrics.conversions, metrics.conversions_value, 

metrics.cost_micros, metrics.cost_per_all_conversions, 
metrics.cost_per_conversion, metrics.engagement_rate, 

metrics.engagements, metrics.gmail_forwards, metrics.gmail_saves, 
metrics.gmail_secondary_clicks, 

metrics.impressions, metrics.interaction_rate, metrics.interactions, 
metrics.invalid_click_rate, 

metrics.invalid_clicks, metrics.top_impression_percentage, 
metrics.value_per_all_conversions, 

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 

campaign 

WHERE 

segments.date >= START_DATE AND 

segments.date <= END_DATE 

ORDER BY 

campaign.id ASC;


*Campaign **Performance Report Response & Exception:*


Response

--------------

 

Headers: 
Metadata(content-type=application/grpc,request-id=eiERLBfpRfjFnVp8MG20hg,date=Mon,
 
22 Jun 2020 23:25:57 GMT,alt-svc=h3-29=":443"; ma=2592000,h3-27=":443"; 
ma=2592000,h3-25=":4

43"; ma=2592000,h3-T050=":443"; ma=2592000,h3-Q050=":443"; 
ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043=":443"; 
ma=2592000,quic=":443"; ma=2592000; v="46,43")

Body: null

Failure message: errors {

  error_code {

    request_error: UNKNOWN

  }

  message: "The error code is not in this version."

  trigger {

    string_value: "Day.day"

  }

}

errors {

  error_code {

    request_error: UNKNOWN

  }

  message: "The error code is not in this version."

  trigger {

    string_value: "A_campaign__CampaignAssociation.entity_id"

  }

}

errors {

  error_code {

    request_error: UNKNOWN

  }

  message: "The error code is not in this version."

  trigger {

    string_value: "CampaignAssociation.campaign_id"

  }

}

errors {

  error_code {

    request_error: UNKNOWN

  }

  message: "The error code is not in this version."

  trigger {

    string_value: "CampaignAssociation.entity_type"

  }

}


Status: Status{code=INVALID_ARGUMENT, description=Request contains an 
invalid argument., cause=null}.

Generic Exception: com.google.api.gax.rpc.InvalidArgumentException: 
io.grpc.StatusRuntimeException: INVALID_ARGUMENT: Request contains an 
invalid argument.

com.google.api.gax.rpc.InvalidArgumentException: 
io.grpc.StatusRuntimeException: INVALID_ARGUMENT: Request contains an 
invalid argument.

        at 
com.google.api.gax.rpc.ApiExceptionFactory.createException(ApiExceptionFactory.java:49)


Thanks in advance!

Best Regards,
KB

On Thursday, June 4, 2020 at 6:39:28 AM UTC-7, adsapiforumadvisor wrote:
>
> Hi KB, 
>    
>    1. The ad_group_criterion 
>    
> <https://developers.google.com/google-ads/api/fields/v3/ad_group_criterion> 
> report 
>    is the closest to the Criteria Performance Report. However, this report 
>    contains no metrics. 
>    2. While there is no documentation for the mapping of Google Ads API 
>    and its UI, you can use this mapping 
>    <https://developers.google.com/adwords/api/docs/guides/uireports> for 
>    AdWords API reports as a reference. 
>
> Regards,
> Anthony
> Google Ads API Team
>
> ref:_00D1U1174p._5004Q20VhwV:ref
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/5bdcc6df-ed9c-44bd-abe5-215f40a1fb13o%40googlegroups.com.

Reply via email to