Stack Overflow
Stack Overflow

Questions tagged [awql]

AWQL (AdWords Query Language) is a SQL-like language for performing queries against most common AdWords API services. AWQL is inspired by SQL, though it does not support the full SQL vocabulary. Notable omissions are the JOIN and GROUP BY clauses. AWQL also provides a DURING clause not found in SQL which takes a date range as a parameter

24 questions
0
votes
1 answer

Adwords API - How to exclude NULL values from an Adwords report using AWQL

I am trying to download a SHOPPING_PERFORMANCE_REPORT with the following fields: OfferId ProductTitle Brand Date Impressions For a small subset of records I'm getting empty/blank data for OfferId, ProductTitle, and Brand (only Date and Impressions…
Aaron Ireland
  • 26
  • 3
0
votes
1 answer

How to extract conversion results based on different attribution models from the Google Adwords API

I need to extract data from the adwords API to allow me to see the impact of different attribution models on conversion. I'm visualising my adwords data in the Klipfolio tool. My adwords account is set up to use the position based model but I'd also…
user3156990
  • 97
  • 1
  • 10
0
votes
0 answers

Which ad_group_criterion fields to combine with ad_group_audience_view in Google Ads Beta API

I am looking into the Google Ads (Beta) API and I want to query for the ad_group_audience_view values, but I am not sure which ad_group_criterion fields are relevant for this view. E.g. for the topic_view, a related field in ad_group_criterion was…
Nick Russler
  • 4,608
  • 6
  • 51
  • 88
0
votes
1 answer

AWQL Error / Can't seem to retrieve any data

I'm in the process of hooking my site into the AdWords API. I seem to be having an issue requesting any kind of data at all from the API. The errors I receive are all AWQL syntax issues (e.g. Error in query: unexpected input DURING. Here is my…
scgough
  • 5,099
  • 3
  • 30
  • 48
0
votes
1 answer

AWQL report where condition syntax

I need to expand an AWQL report query. The query is currently "SELECT Id, AveragePosition, CpcBid, KeywordMatchType, Labels, AdGroupId, AccountDescriptiveName, Criteria " + " FROM KEYWORDS_PERFORMANCE_REPORT " + " WHERE…
Stefan Fischer
  • 363
  • 4
  • 19
0
votes
1 answer

AWQL AdWords API : how to retrieve CampaignStatus?

I'm using https://www.awql.me to build request and the first one below works, I'm successfully able to retrieve all campaigns with datas from past 7 days : SELECT CampaignId, CampaignName, Clicks, Impressions FROM CAMPAIGN_PERFORMANCE_REPORT DURING…
Blq56
  • 153
  • 2
  • 10
0
votes
1 answer

How do I fetch best performing ads from adwords api

I am trying to fetch top performing ads using attributes like impressions, clickx etc I tried google adwords reporting api first, but reporting api do not support ORDER BY clause. And I couldn't find any AdsService in the service list. Closest I…
Tachyons
  • 2,131
  • 1
  • 21
  • 35
0
votes
2 answers

How can I specify an AdWords account when using campaignSelector in AdWords scripts?

I've attempted to write a script that will: Iterate through all the accounts in an MCC and select those which have 'SEM' in the name. Iterate through campaigns in an account and select those which meet certain conditions. Email a list of these…
Corrado_
  • 1
  • 1
0
votes
1 answer

Is there any way to retrieve area report for a google adword campaign using awql?

I am trying to get a report for my campaign where I need the impressions and clicks for each area for my campaign. I tried all fields in GEO_PERFORMANCE_REPORT but it doesn't retrieve the area. I also tried to get data from…
Faesal
  • 679
  • 6
  • 19
1
2