I got results this morning - with a different query, but nevertheless. Do you know which AdWords API version your tool is using? Maybe your tool is using an outdated version, and doesn't handle the API response correctly. I remember v201603 retired late January.
Hope this helps. On Wednesday, March 22, 2017 at 7:32:35 PM UTC+1, Alexander Volk wrote: > > > I'm using a data integration tool called Data Virtuality to pull data from > the AdWords API. The tool structures translates calls to different sources > into SQL. > > Below is an example query that is set up to retrieve Youtube Network data. > This query stopped delivering data on Jan. 30th with no change to it or any > perceivable change to the API. There are also still active YouTube > campaigns in the queried MCC. > > Has there been any change that I might not be aware of? > > Thanks in advance for any help! > > > SELECT > > cast(CustomerDescriptiveName as string(200)) as Advertiser > ,"Date" > > ,cast(AdNetworkType1 as string(200)) as AdNetworkType1 > > ,cast(AdNetworkType2 as string(200)) as AdNetworkType2 > > ,CAST( TO_CHARS( TO_BYTES( "CampaignName", 'iso-8859-15' ) > , 'UTF-8' ) as string(200) ) as "CampaignName" > > ,cast(CampaignStatus as string(200)) as CampaignStatus > > ,CAST( TO_CHARS( TO_BYTES( "AdGroupName", 'iso-8859-15' ) , > 'UTF-8' ) as string(200) ) as "AdGroupName" > > ,cast(AdGroupStatus as string(200)) as AdGroupStatus > > ,Device > > ,Clicks > > ,Impressions > > ,cast(Cost as double) /1000000 as cost > > ,VideoViews > > ,VideoQuartile25Rate > > ,VideoQuartile50Rate > > ,VideoQuartile75Rate > > ,Slot > > FROM > > xm_adwords.customer_id cust > > ,table ( > > call xm_adwords.getCRITERIA_PERFORMANCE_REPORT ( > > cust.customerid, > > timestampadd (SQL_TSI_DAY,- 30,curdate ()) > > ,timestampadd (SQL_TSI_DAY,- 1,curdate ()) > > ,'AccountDescriptiveName, > > AccountTimeZoneId, > > AdgroupID, > > AdgroupName, > > Adgroupstatus, > > AdNetworkType1, > > AdNetworkType2, > > AdType, > > CampaignId, > > CampaignName, > > CampaignStatus, > > Clicks, > > Cost, > > CreativeDestinationUrl, > > CustomerDescriptiveName, > > Date, > > Description1, > > Description2, > > Device, > > DisplayURL, > > ExternalCustomerId, > > Headline, > > ImageCreativeName, > > Impressions, > > Name, > > VideoViews, > > VideoQuartile25Rate, > > VideoQuartile50Rate, > > VideoQuartile75Rate, > > VideoQuartile100Rate, > > Slot' > > ) > > ) kpi > > where > > canManageclients = false > > > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and Google+: https://googleadsdeveloper.blogspot.com/ https://plus.google.com/+GoogleAdsDevelopers/posts =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] 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 Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/af2ed7f5-80d0-4253-ab56-15530e5c7b8d%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
