Paid_Organic_Query_Report

[Jóhannes Vollertsen]

I am working on implementing the paid organic reports via the api, to replace reports generated through the adwords interface. The api report definition (https://developers.google.com/adwords/api/docs/appendix/reports#paid-organic) seems to be missing a lot of the columns that are available through the adwords reports interface. All the organic columns such as "Organic Clicks", "Organic Queries", "Combined Clicks" etc are not mentioned at all, and I was wondering if there is a way to access those via the api. 

This report does not make a lot of sense without these columns, so my questions is:

Is there a way to access the missing columns today, and if not, when will they be accessible thorugh the API?

[Ray Tsang (AdWords API Team)]

Johannes,

I've been looking into this to make sure I provide a useful response.  Thank you for your patience.  I'll get back to you once I track this down.

Thanks!

[Jóhannes Vollertsen]

Hi Ray, 

I am just curious if there is any updates on this issue, as it's been nearly 2 weeks since your last update.

Cheers!

[Ray Tsang (AdWords API Team)]

Johannes,

It appears that some of the organic stats are not currently available in the report.  I've filed a feature request for this.  I will let you know once it's available.

Thanks!

Ray

[Ray Tsang (AdWords API Team)]

Johannes,

Actually - good news.  The columns are now available.  Please use the ReportDefinitionService to retrieve the latest set of columns, that contains:

• OrganicClicks (Long)
  
• OrganicClicksPerQuery (Double)
  
• OrganicImpressions (Long)
  
• OrganicImpressionsPerQuery (Double)
  
• OrganicQueries (Long)
  

We'll update the documents accordingly.

Cheers,

[Jóhannes Vollertsen]

That is great news! Thanks for the good support.

[Paul Ingles]

Hi,

I've just started experimenting with this new report and am seeing some interesting data for CombinedAdsOrganicClicksPerQuery and OrganicClicksPerQuery: both seem to be expressed as percentages rather than doubles? I'm downloading the report as a gzipped CSV through the Java SDK (if that helps).

OrganicImpressionsPerQuery is definitely expressed as a double though.

Have I done something silly or is this a known issue? I can't seem to find anything relating specifically to those fields.

uSwitch is a trading name of uSwitch Ltd. Registered in England and Wales (Company No. 03612689). Registered Address: Notcutt House, 36 Southwark Bridge Road, London, SE1 9EU

This communication and any attachments contains information which is confidential and may be subject to legal privilege. It is for intended recipients only. If you are not the intended recipient you must not copy, distribute, publish, rely on or otherwise use it without our consent. Some of our communications may contain confidential information which it could be a criminal offence for you to disclose or use without authority. If you have received this email in error please notify the sender immediately and delete the email from your computer.

uSwitch Ltd reserves the right to monitor all email communications for compliance with legal, regulatory and professional standards.

[Danial Klimkin]

Hello Paul,

Could you please start a new thread on the issue? Please let us know the exact report definition and target account ID so we could reproduce.

I am closing this thread as it's almost a year old.

-Danial, AdWords API Team.