awqlinator

An intuitive query interface for AWQL (AdWords Query Language)

Usage no npm install needed!

<script type="module">
  import awqlinator from 'https://cdn.skypack.dev/awqlinator';
</script>

README

npm version Build Status

AWQLinator

A package for Javascript which makes dealing with AWQL more friendly than string interpolation. It offers a simple interface for querying Google AdWords.

How does it look?

import { AWQLinator } from "awqlinator";

const awql = new AWQLinator("ACCOUNT_PERFORMANCE_REPORT");

const report = awql
  .select("Clicks", "Impressions")
  .where("Clicks", ">", "20")
  .during("TODAY")
  .toAwql();

// => SELECT Clicks,Impressions FROM ACCOUNT_PERFORMANCE_REPORT WHERE Clicks > 20

Features

  1. Strongly typed with Typescript.
  2. Compose queries easily
  3. Simple and intuitive query API

What it does not offer

  • The ability to actually send the queries to AdWords.

Since this is very simple to do with any request library (fetch, axios, etc.), I have decided to leave this as an exercise to the user.

Installation

$ npm install --save awqlinator