Re: Campaign Performance Report - Missing Fields?

[Google Ads API Forum Advisor Prod]

Hi Peter,

Thank you for reaching out. If this is the case please send the requested 
information to our alias at googleadsapi-supp...@google.com.

Thanks and regards,
Xiaoming, Google Ads API Team



Xiaoming
Google Ads API Team
ref:_00D1U1174p._5004Q2H9btJ: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/GN1GV0QT039N000Et8Xjt5QZiLENHRgJPQpw%40sfdc.net.

Re: Campaign Performance Report - Missing Fields?

[Peter Petrov]

I do not have permissions to reply privately to authors (in this group).   

If I can get in touch with you via email that would be great. 
You have my email address here so you can drop me an email. 

I would like to email you an example where fields are omitted in the JSON 
data that is returned back. 
But it's real world PROD data so I don't want to post it here in the forum. 

Thanks once again.





On Monday, May 10, 2021 at 10:19:49 PM UTC-4 adsapiforumadvisor wrote:

> Hi Peter,
>
> I work with Xiaoming and let me continue the discussion for this concern.
>
> Allow me to provide my insights for the 2 items below: 
>
>
>
>- 
>
> *Not really, it's not so simple to tell, since we're managing a large 
>number of reports with 25-30 data fields each.  What you say here means I 
>have to go through every report, request it, pull it, see what is returned 
>and visually map the returned data fields to the requested data fields. 
>What makes things worse is that in the returned JSON the fields seem to be 
>omitted when they have no value (instead of returned with null value or 
>something like that). * 
>
>
>- 
> *Can I assume this is the general rule, i.e. does that rule always hold 
>true? I mean if I request xyz.this_one_field will I always get back 
>xyz.thisOneField? * 
>
>
>
>
> Based on this document 
> , 
> identifiers are transformed from *snake_case* (in protocol buffers) to 
> *lowerCamelCase* in JSON. With this, you will need to mapped the returned 
> fields in the API response to the fields in the API request. Also, to this 
> question "*I mean if I request xyz.this_one_field will I always get back 
> xyz.thisOneField*?", this is indeed how it works.
>
> As for the fields omitted when they have no value, could you provide the 
> complete request 
> 
>  
> and response 
> 
>  
> logs with request ID 
> 
>  
> and screenshot of this field in the UI to take a closer look? Please 
> provide this details via *Reply privately to author* option. 
>
> Regards,
> [image: Google Logo] 
> Ernie John Blanca Tacata 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q2H9btJ: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/408ef33f-5ce3-4fd7-b9be-02cd20d07aa9n%40googlegroups.com.

Re: Campaign Performance Report - Missing Fields?

[Google Ads API Forum Advisor Prod]

Hi Peter,

I work with Xiaoming and let me continue the discussion for this concern.

Allow me to provide my insights for the 2 items below:

Not really, it's not so simple to tell, since we're managing a large number of 
reports with 25-30 data fields each.
What you say here means I have to go through every report, request it, pull it, 
see what is returned and visually map the returned data fields to the requested 
data fields.
What makes things worse is that in the returned JSON the fields seem to be 
omitted when they have no value (instead of returned with null value or 
something like that).
Can I assume this is the general rule, i.e. does that rule always hold true?
I mean if I request xyz.this_one_field will I always get back xyz.thisOneField?


Based on this document, identifiers are transformed from snake_case (in 
protocol buffers) to lowerCamelCase in JSON. With this, you will need to mapped 
the returned fields in the API response to the fields in the API request. Also, 
to this question "I mean if I request xyz.this_one_field will I always get back 
xyz.thisOneField?", this is indeed how it works.

As for the fields omitted when they have no value, could you provide the 
complete request and response logs with request ID and screenshot of this field 
in the UI to take a closer look? Please provide this details via Reply 
privately to author option.

Regards,

Ernie John Blanca Tacata
Google Ads API Team
ref:_00D1U1174p._5004Q2H9btJ: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/qsxQO0QSX7SK003w79eSLkRX2_Ex2iOquwaA%40sfdc.net.

Re: Campaign Performance Report - Missing Fields?

[Peter Petrov]

Thanks. 
Yes, I asked since I didn't see that kind of mapping documented. 

*"The mapping I shared with you earlier is the field mapping between the 
AdWords API and Google Ads API."*
Yes, I understood that, thank you.

*"You could simply tell..."  *
Not really, it's not so simple to tell, since we're managing a large number 
of reports with 25-30 data fields each. 
What you say here means I have to go through every report, request it, pull 
it, see what is returned and *visually *map the *returned data fields* to 
the *requested data fields*.
What makes things worse is that in the returned JSON the fields seem to be 
omitted when they have no value (instead of returned with *null* value or 
something like that). 

*"the only difference is that one uses snake naming convention and the 
other uses camel"*
Can I assume this is the general rule, i.e. does that rule always hold true?
I mean if I request xyz.*this_one_field *will I always get back xyz.
*thisOneField*? 

Or... are there exceptions to this rule?  

Thanks once again.




On Monday, May 10, 2021 at 3:56:23 PM UTC-4 adsapiforumadvisor wrote:

> Hi Peter,
>
> Thank you for reaching out. Actually this is a good question. However, 
> there isn’t any mapping for the field names in different return formats. 
> You could simply tell they are the same attributes by looking at the names. 
> For example, metrics.average_cpc and metrics.averageCpc are the same 
> thing and the only difference is that one uses snake naming convention and 
> the other uses camel. The mapping I shared with you earlier is the field 
> mapping between the AdWords API and Google Ads API.
>
>
>
> Thanks and regards,
> Xiaoming, Google Ads API Team
>  
>
> [image: Google Logo] 
> Xiaoming 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q2H9btJ: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/df973082-12cf-448f-abdc-90663935df2en%40googlegroups.com.

Re: Campaign Performance Report - Missing Fields?

[Google Ads API Forum Advisor Prod]

Hi Peter,

Thank you for reaching out. Actually this is a good question. However, there 
isn’t any mapping for the field names in different return formats. You could 
simply tell they are the same attributes by looking at the names. For example, 
metrics.average_cpc and metrics.averageCpc are the same thing and the only 
difference is that one uses snake naming convention and the other uses camel. 
The mapping I shared with you earlier is the field mapping between the AdWords 
API and Google Ads API.

Thanks and regards,
Xiaoming, Google Ads API Team


Xiaoming
Google Ads API Team
ref:_00D1U1174p._5004Q2H9btJ: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/5sQ-s0QSWQ06009INOSe_cSSOLG-ObH1kBtQ%40sfdc.net.

Re: Campaign Performance Report - Missing Fields?

[Peter Petrov]

Thanks.

So  metrics.conversions_from_interactions_rate is what used to be  
ConversionRate ? 

The doc you linked to provides mappings from report definition (or say 
AWQL) field names to new GAQL field names. Correct? 

What about the field names returned in the JSON data e.g. one requests 
metrics.average_cpc but gets back metrics.averageCpc ? 

Is there any document/csv which defined these mappings too (*field name we 
request* mapped to *field name we get back* in the JSON) ? 

This whole field name management seems confusing. 

E.g. in the old API 201809 we had (for the same field) 3 names 

"convRate" - name returned in XML data 
"Conv. rate" - name returned in CSV data 
"ConversionRate" - name of the field we request 

Now we need to store two more field names for the same field right? 

1) the field name we request via GAQL 
2) the field name we get back in the JSON data 

Do I understand this model correctly? Am I on the right track? 

Thanks in advance. 

Regards,
Peter















On Monday, May 10, 2021 at 11:27:21 AM UTC-4 adsapiforumadvisor wrote:

> Hi Peter,
>
> Thank you for reaching out. The AveragePosition has been deprecated. 
> However, you are still able to fetch the ConversionRate field which is 
> mapped to metrics.conversions_from_interactions_rate in the Google Ads API. 
> Please see the complete mapping for fields here 
> .
>
> Thanks and regards,
> Xiaoming, Google Ads API Team
>  
>
> [image: Google Logo] 
> Xiaoming 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q2H9btJ: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/6f1b8d7e-02f5-4849-93ee-63bd72072993n%40googlegroups.com.

RE: Campaign Performance Report - Missing Fields?

[Google Ads API Forum Advisor Prod]

Hi Peter,

Thank you for reaching out. The AveragePosition has been deprecated. However, 
you are still able to fetch the ConversionRate field which is mapped to 
metrics.conversions_from_interactions_rate in the Google Ads API. Please see 
the complete mapping for fields here.

Thanks and regards,
Xiaoming, Google Ads API Team


Xiaoming
Google Ads API Team
ref:_00D1U1174p._5004Q2H9btJ: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/IOQ-W0QSWDL700I2eODIs2T8Gu3DTTT0WE8w%40sfdc.net.

Campaign Performance Report - Missing Fields?

[Peter Petrov]

In the old AdWords reporting API (*v201809*) 
I was pulling e.g. a CAMPAIGN performance report (by date) 
and I had these two fields available (in the data returned back). 


*avgPosition*

*convRate*

These fields are *average position* and *conversion rate*.

But in the new API (REST) when I look here e.g. 

https://developers.google.com/google-ads/api/fields/v7/campaign_query_builder

or here 

https://developers.google.com/google-ads/api/fields/v6/campaign_query_builder

I am not finding these two fields. 

Are these fields still available and how do I request them 
via a GAQL query in the v6 or v7 REST API?

Thanks in advance.




-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/fc11ede8-7eac-494b-ad11-b5d81cb9c5a7n%40googlegroups.com.