API no longer delivering YouTube data?

[Alexander Volk]

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

[Zweitze]

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.

[Vishal Vinayak (Adwords API Team)]

Hi Alexander,

Zweitze is right. Your tool's connection to AdWords API might break because of a number of reasons, using outdated version of the API being one. I would recommend getting in touch with DataVirtuality Support to check if there's something broken on their side. 

Rergards,
Vishal, AdWords API Team