• Skip to main content
  • Skip to primary sidebar

PPC Scripts

by Lynt services

  • About the Author
  • PPC Services
  • Workshops for PPC companies
  • English
  • Czech
You are here: Home / Uncategorized / How to use our AWQL generator

How to use our AWQL generator

February 15, 2017 od Jakub Kašparů 8 Comments

AWQL generator uses the AdWords Query language, which allows you to easily pull data from AdWords and combine it with other simple functions in your Google Spreadsheet.

I’ve put together a short list of the obstacles you might face with AdWords API and how to deal with them.

Choose the right report type

It may seem overly simple, but you need to think about what type of report you want. If you want to generate a report of the search queries then you need to choose Search Query performance report. If you want to see account data, choose Account Performance report. It’s not complicated, but it’s important to keep it in mind.

Most common AWQL reports:

  1. Account Performance
  2. Ad Performance
  3. Ad Group Performance
  4. Campaign Performance
  5. Final URL
  6. Keywords Performance
  7. Paid and Organic Query
  8. Search Query Performance

You can find every available report type here: https://developers.google.com/adwords/api/docs/appendix/reports

Choose the right metrics and dimensions

When selecting which columns will be displayed in your Google Spreadsheet (see photo below), it’s very important to put them in the order in which you want them to be displayed in the results.

 

The above example will result in two columns in the report; column A will be Clicks and column B will be CampaignName. So be sure to keep this in mind while making your selection 🙂

 

Other unusual things

 

  1. Keywords are called Criteria in Adwords API.
  2. If you want to get results separated by days or months, you need to select DayOfWeek or MonthOfYear in your field selection.

 

Don’t forget the date range

When you are choosing the date range there are two ways to do it. The first is to use one of the values from the dropdown list, like LAST_30_DAYS, THIS_MONTH, and so on. But, if you would like to see the monthly performance for the last year, you need to use our custom date range function and enter the number of days back from today.

 

These are the most common problems you will find with this tool. You can find the tool at: https://ppc-scripts.eu/awql-generator/

Filed Under: Uncategorized

Reader Interactions

Comments

  1. quickbooks enterprise solutions support says

    August 6, 2017 at 1:40 am

    XY

    Reply
  2. Stef says

    October 11, 2017 at 2:32 pm

    Is it also possible to have “this year” or use a specific date range?

    Reply
  3. Yacon Root Extract says

    October 21, 2017 at 2:16 pm

    I love this site. It’s an amazing blog.

    Reply
  4. harmonynursery.co.uk says

    November 25, 2017 at 8:42 pm

    Many thanks for yet another educational website. Where altogether different might I receive that type of info coded in this kind of ideal means? For sale objective that we’re only at this point operating upon, and I’ve been recently for the peek outside to get like data.

    Reply
  5. Rosette says

    December 27, 2017 at 3:22 am

    Great site. Just had a quick read.

    Reply
  6. Drusilla says

    December 28, 2017 at 2:18 am

    Great site. Just had a quick read.

    Reply
  7. Wilfred says

    February 21, 2018 at 10:50 am

    Hi there, I discovered your blog via Google even as searching for a comparable topic, your web site came up, it appears great. I’ve bookmarked it in my google bookmarks.

    Reply
  8. how to make a blog says

    February 21, 2018 at 5:26 pm

    You are certainly right, I’d really like to know more information on this subject! I am also fascinated by free new movies online as I believe it really is quite unique presently. Keep up the good work!

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *


Primary Sidebar

Google Partner

Tools

AWQL Generator
Keyword Combinator
Datastudio Case generator

Recent Posts

  • Adwords script for better A/B testing of Ads February 15, 2017
  • OpenRefine: a fast and easy way to obtain keyword data from autocomplete February 15, 2017
  • MCC script for controlling account performance and trends February 15, 2017

Recent Comments

  • how to make a blog on OpenRefine: a fast and easy way to obtain keyword data from autocomplete
  • movie download sites on New columns in AWQL reports based on Adwords API v201601
  • latest movie download on Script for PLA campaign history audit

© Copyright 2016 Lynt services s.r.o.