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.

[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

[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

[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
 

[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.

[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

[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.

[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 googleadsa...@google.com.

Thanks and regards,
Xiaoming, Google Ads API Team

Xiaoming Google Ads API Team

ref:_00D1U1174p._5004Q2H9btJ:ref