RE: Adwords Transfer Service not sending usable search impression share data

2019-01-08 Thread googleadsapi-forumadvisor via AdWords API and Google Ads API Forum
Hi Ryan, The UI is able to show subtotals for each row in the report, even if there are more detailed rows shown as well. In your example, the UI can request and return to you subtotals for each keyword, *as well as* show you a keyword+week breakdown. With the AdWords API, however, you'll only g

Re: Adwords Transfer Service not sending usable search impression share data

2019-01-04 Thread Ryan Lister
Hi Josh, As far as I'm aware, after the transfer service is enabled for an account, the tables that are sent are automatically generated and there is no user input allowing any changes. The data gets transferred in everyday, so we get all the statistics broken down by date (and by hour in the

RE: Adwords Transfer Service not sending usable search impression share data

2019-01-03 Thread googleadsapi-forumadvisor via AdWords API and Google Ads API Forum
Hi Ryan, Thanks for following up on our earlier discussion via the forum. If you were using the AdWords API directly, you could issue separate Keywords Performance Report requests to get the *SearchI

Re: Adwords Transfer Service not sending usable search impression share data

2019-01-03 Thread Ryan Lister
Thanks for your reply Alexander, our previous workaround was to use values of <10% as 5%. But this has led to wildly inaccurate numbers when aggregating up, for example over a date range. What would be ideal is to have the true value sent though, this way our reporting would be close to what is

Re: Adwords Transfer Service not sending usable search impression share data

2019-01-03 Thread Alexander
a workaround would be: CAST( REGEXP_REPLACE( SearchImpressionShare, '[%<>]', '' ) AS FLOAT64 ) On Thursday, January 3, 2019 at 10:35:37 AM UTC+1, Ryan Lister wrote: > > Hi Support, > > I am trying to build a reporting suite for AdWords by bringing the data > through to our BigQuery instance an

Adwords Transfer Service not sending usable search impression share data

2019-01-03 Thread Ryan Lister
Hi Support, I am trying to build a reporting suite for AdWords by bringing the data through to our BigQuery instance and linking it to an online dashboarding tool. The adwords data transfer service sends us the reports outlined here : https://cloud.google.com/bigquery/docs/adwords-transformation