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
4
votes
1 answer

Getting adwords history using awql

I am building an app where users can authorize and we take their data daily and also on initial authorization we pull the last 365 days of data. So far I can pull data, but it gives me totals of the last 365 days, I wanted to know if adwords api has…
user1903825
4
votes
1 answer

how can I get ipAddress info from criterion?

I'm working with Google Adwords and currently can't get specific info. On my Adwords account I set 'IP address exclusion' with 3 IPs. I want to get this IPs from my code: AdWordsUser user = new AdWordsUser(); var campaignService =…
Tsvi Girsh
  • 41
  • 1
3
votes
1 answer

How to get 'Hour and day of the week' report using AWQL

Using ad scheduling on AdWords in my Search Network only campaign I can see 'Hour and day of the week' report. It shows campaign performance values on a given day and time. I would like to utilize this data in AdWords script. Is it possible to…
Jakub Nurski
  • 473
  • 4
  • 18
2
votes
1 answer

Basic AWQL request - CAMPAING_PERFORMANCE split by "date" only

I face strange behavior on my Adwords API response, which brakes a logic of our reports. Here is my AWQL: SELECT Date,Ctr FROM CAMPAIGN_PERFORMANCE_REPORT DURING 20181206, 20181206 Response: Report Day,CTR 2018-12-06,0.00% 2018-12-06,3.23% Why do…
Axel186
  • 541
  • 5
  • 17
1
vote
2 answers

Google Ads Script (AWQL) get custom date range for reporting

I need to pull a google ads report that will get data from a fixed date (28th May) until today and push the data to a spreadsheet. I can't figure out how to define the date range for this query I've tried googling and reading the google…
Abhay
  • 827
  • 9
  • 34
1
vote
1 answer

Resolve 'Parsing Error: Please check your selector. (line XX)' Javascript/AWQL

First off, let me say that I am not a developer, nor do I really code beyond basic HTML. So I appreciate your patience. :) I'm working with a script that is for AdWords, but I believe it's more or less written in Javascript. (I've included the…
user2056189
  • 13
  • 4
1
vote
1 answer

AdWords Scripts. report ORDER BY not working

This function suppose to show in which hours adverts are clicked more often. It works fine however I have problem with sorting it by "HourOfDay". When I add ORDER BY HourOfDay to the end of the query I get en error. function…
DevWL
  • 17,345
  • 6
  • 90
  • 86
1
vote
1 answer

Pre defined conversion source report Adwords API AWQL

I have a basic access manager account and a production Adwords Account, I understand AWQL its a query language but what I dont get is where in the docs I get the exact filed names and FROM REPORT name ??? I have setup a report on my adwords account…
f4r4
  • 563
  • 8
  • 19
1
vote
1 answer

How to get daily cost report in one call with Adwords Api

I am developing a web app usign with Adwords Api. But I am in trouble with getting daily report only one call. I am using AWQL; If I run this query: SELECT CampaignName, Clicks, Impressions, Cost FROM CAMPAIGN_PERFORMANCE_REPORT DURING…
Savas Adar
  • 4,083
  • 3
  • 46
  • 54
1
vote
1 answer

google adwords API: how to retrieve all fields(AWQL)

ive been looking on Google Adwords API documentation but have no luck, my specific question is: I need to retrieve all available fields from a report but there no "SELECT *" statement on AWQL . And selecting every one of them manually is not an…
Luis Leal
  • 3,388
  • 5
  • 26
  • 49
1
vote
1 answer

Get custom column(s)/field(s) with Google Adwords script

I am currently working on a script to report information on our Ad Groups. We set up some customized columns and it would be great to get them while creating the reports. A basic code based on the documentation looks like this: var report =…
brclz
  • 806
  • 9
  • 23
1
vote
2 answers

How to specify a date range for the Google Adwords CLICK_PERFORMANCE_REPORT

I am trying to query the adwords api (v201603) and am using/extending the Java examples provided. The problem I am encountering is being able to specify a specific date to download the report data for the CLICK_PERFORMANCE_REPORT report. This…
Neil Stoneman
  • 61
  • 1
  • 4
0
votes
1 answer

Script does not export TopImpressionPercentage and AbsoluteTopImpressionPercentage as digits in Google Sheets

I’ve created a script that exports campaign results to a Google Sheets file. When I implemented the script on September 29th, the data was exported perfectly. See example below (notice that the last four numbers are right-aligned because they're…
user15402899
  • 63
  • 5
0
votes
1 answer

Google Ads Scripts AWQL "CONTAINS_ANY" operator doesn't work

I'm trying to extract Search queries by certain rules and I need to get Queries that contain one of the given strings: " WHERE " + " Impressions > " + IMPRESSIONS_THRESHOLD + " AND AverageCpc > " + AVERAGE_CPC_THRESHOLD + …
Evgeny Yuzhakov
  • 1
0
votes
2 answers

Drawn myself into a box with Google Ads API. Can't authenticate other users besides mine

I'm working on building a new tool for my customers that helps automate their ads and see daily / weekly reports and improvements. However, I'm having a humbling issue with the Google Ads API. I've set up a manager account, and my clients have…
Shane Harrison
  • 1
  • 1
1
2