Home

awql - the AWQL command-line tool

Bash command-line tool to request Google Adwords API Reports with AWQL language and print results like mysql command line tool.

Auto-refreshed the Google access token. 2 ways for this, the classic with the Google oauth2 services and the second, by calling a web service of your choice
Save results in CSV files.
Navigate in your historic of queries with arrow keys in prompt mode
Caching datas in order to do not request Google Adwords services with queries already fetch in the day. This feature can be enable with option -c.
Add following SQL methods to AWQL grammar: LIMIT and ORDER BY in SELECT queries, DESC [FULL] and SHOW [FULL] TABLES [LIKE|WITH].
Add management of \G modifier to display result vertically (each column on a line)
* can be used as shorthand to select all columns from all tables