广告词API活动服务。查询()为有效字段返回无效的谓词字段名称

2024-09-30 01:24:11 发布

您现在位置:Python中文网/ 问答频道 /正文

我很难获得一个简单的AWQL语法来处理AdWords API CampaignService。我试图收集一份在一个日期范围内有超过10个印象的所有活动ID的列表:

campaignService = authorizedClient.GetService('CampaignService', version='v201406')

awql = "SELECT CampaignId WHERE Impressions > 10 DURING 20150120,20150223"

results = campaignService.query(awql)

上述语法给出以下错误:

^{pr2}$

每当我按如下方式调整Awql语法时,都会得到一个成功的结果:

campaignService = authorizedClient.GetService('CampaignService', version='v201406')

# Works
awql = "SELECT CampaignId"
results = campaignService.query(awql)

# Works
awql = "SELECT CampaignId DURING 20150120,20150223"
results = campaignService.query(awql)

# Doesn't Work
awql = "SELECT CampaignId WHERE Impressions >10 DURING 20150120,20150223"
results = campaignService.query(awql)

我尝试过使用impressionImpressionimpressions,但这些方法都不起作用。我可以通过AdWords用户界面确认,在这段时间内,该客户的活动有印象。在

为什么CampaignService不让我用Impressions作为WHERE过滤器进行查询?在

编辑:我在这里找到了一个针对活动的filterable fields列表,但是在文档示例here中,它使用Impressions显示了它们?在

CampaignPage p = campaignService.query("SELECT CampaignId,CampaignName
                WHERE Ctr > 0.05 AND Impressions < 100
                DURING 20120201,20120228 ORDER BY CampaignName DESC LIMIT 0,50");

Tags: 列表version语法wherequeryselectresults印象

热门问题