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/9403c5b9-8349-4d3e-a88e-e7683bd3b778%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
