Access Google Adwords in Excel

Integrated features:

  • Adwords Query Language (AWQL)
  • Campaigns
  • Keywords
  • Keyword search volumes
  • Keyword ideas

AWQL

AWQL is really cool. Using AWQL, you can pretty much query any data from your Adwords account. If you’re a serious Adwords pro, you need to learn AWQL!

Examples

SELECT
CampaignId, 
CampaignName, 
Clicks, 
Impressions
FROM CAMPAIGN_PERFORMANCE_REPORT
WHERE Impressions < 100
DURING 20131001,20131031

Get costs for each campaign from the last week:

SELECT
Date, 
Cost,
CampaignName
FROM CAMPAIGN_PERFORMANCE_REPORT
DURING LAST_WEEK_SUN_SAT

Developer Token

To use Google Adwords in SeoTools you need a developer token.

How to get a developer token.

See

Official Documentation

Guides

Get help with this function in the community →