Missing column to fetch SearchImpressionShare and other related fields

[Niranjan Kumar]

Hi,

We were earlier fetching Google Adwords Report using java APIS with the following fields:-

Date,Cost,Impressions,Clicks,CostPerConversion,Ctr,ActiveViewCtr,AverageCpv,ConversionRate,AdGroupId,AdGroupName,AdGroupStatus,CampaignId,CampaignName,CampaignStatus,Conversions,Engagements,AveragePosition,CpcBid,AdNetworkType1,AdNetworkType2,Device

Now as per new business requirement following fields need to be fetched in addition to which we were earlier fetching:-

SearchAbsoluteTopImpressionShare,SearchExactMatchImpressionShare,SearchImpressionShare,SearchRankLostAbsoluteTopImpressionShare,SearchRankLostImpressionShare,SearchRankLostTopImpressionShare,SearchTopImpressionShare

There is One Compulsory field missing, and we are not able to find out which is that field

Here is the exception stack trace

[hdfs@stage google]$ java -cp 'lib/googleAdwordsSDK-0.0.1-SNAPSHOT.jar:lib/*' sdf.googleAdwordsSDK.GoogleAdwordsCLI --function StreamReport --properties ads.properties

log4j:WARN No appenders could be found for logger (org.apache.hadoop.util.Shell).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
HTTP Response Code: 400, FieldPath: SearchImpressionShare, Type: ReportDefinitionError.INVALID_FIELD_NAME_FOR_REPORT
 at com.google.api.ads.adwords.lib.utils.v201809.DetailedReportDownloadResponseException$Builder.build(DetailedReportDownloadResponseException.java:35)
 at com.google.api.ads.adwords.lib.utils.AdHocReportDownloadHelperImpl.handleResponse(AdHocReportDownloadHelperImpl.java:117)
 at com.google.api.ads.adwords.lib.utils.AdHocReportDownloadHelperImpl.downloadReport(AdHocReportDownloadHelperImpl.java:60)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:498)
 at com.google.api.ads.common.lib.utils.AdsUtilityInvocationHandler.handleInvocation(AdsUtilityInvocationHandler.java:46)
 at com.google.common.reflect.AbstractInvocationHandler.invoke(AbstractInvocationHandler.java:84)
 at com.sun.proxy.$Proxy23.downloadReport(Unknown Source)
 at com.google.api.ads.adwords.lib.utils.AdHocReportDownloadHelper.downloadReport(AdHocReportDownloadHelper.java:46)
 at com.google.api.ads.adwords.lib.utils.v201809.ReportDownloader.downloadReport(ReportDownloader.java:65)
 at sdf.googleAdwordsSDK.GoogleAdwordsConnector.streamReport(GoogleAdwordsConnector.java:137)
 at sdf.googleAdwordsSDK.GoogleAdwordsCLI.streamGoogleAdwordsReport(GoogleAdwordsCLI.java:122)
 at sdf.googleAdwordsSDK.GoogleAdwordsCLI.run(GoogleAdwordsCLI.java:81)
 at sdf.googleAdwordsSDK.GoogleAdwordsCLI.main(GoogleAdwordsCLI.java:26)
java.lang.RuntimeException: One of the compulsary Field is missing. Please refer README.
 at sdf.googleAdwordsSDK.GoogleAdwordsCLI.streamGoogleAdwordsReport(GoogleAdwordsCLI.java:133)
 at sdf.googleAdwordsSDK.GoogleAdwordsCLI.run(GoogleAdwordsCLI.java:81)
 at sdf.googleAdwordsSDK.GoogleAdwordsCLI.main(GoogleAdwordsCLI.java:26)

Any Help will be much appreciated!

[Google Ads API Forum Advisor Prod]

Hi Niranjan,

Thank you for reaching out.

Upon investigatng the logs you provided, I can see that the SearchImpressionShare field is not supported in the report type you are downloading. You may refer to the link for the list of report types that support this field. You may opt to remove this field for your report or change the report type you are trying to download.

If the issue still persist, could you provide the report type you are using so I could investigate further?

Regards,
Dannison
Google Ads API Team

ref:_00D1U1174p._5001UHEN2t:ref