Category Archives: Google AdWords

AdWords Campaign Report

Core Add-in, Google AdWords Connector
adwords-campaigns-reportDownload your Google AdWords campaign activity for the past 30 days directly into Microsoft Excel. Analytics Edge makes it easy with this report and the Connector for Google AdWords — just one click. No programming, no manual downloads. Change the date range and run again for specific periods of interest without ever leaving Excel.

Download the workbook: GoogleAdWordsCampaignSummary-2-0.xlsx

Sort

The Sort tab lets you determine the sort order of the results of your query. Select the column and click the Ascending or Descending button to add a sorting rule. Sorting rules are applied in order, where matching values in the first sorted column are ordered by the next rule.

ad-sort

By default, the report should sort in the order that the columns appear.

Customers

ad-customersThis Analytics Edge wizard lets you download the list of customer ids for your account. With regular AdWords accounts, it will list your account, but for MCC accounts, it will list all customer accounts associated with the MCC account.

The only option for this report is to select your account.

License

The Google Analytics Connector for Analytics Edge should automatically activate a 30 day free trial period. If you purchase a license, enter the purchased licensed code in the Google AdWords > License wizard and Submit to activate the new license.

license

Accounts

ad-accountsFor security reasons, Analytics Edge stores your account information on your computer, not in the workbooks. Accounts are stored using Reference names, and the queries use a Reference name to identify which account to use.

Before you can log into an account, you must enter a Reference name in the field provided, then click the Add Account button.

After your have logged in, the account credentials will be stored (encrypted) on your computer so you can refresh reports without having to login each time.

Multiple accounts can be stored, and you can change which account gets used by default. If your reports make multiple queries and always refer to the ‘Default account’, you can switch the default account to report on on different account.

If you have an MCC account, your customers are listed in the dropdown at the bottom. This is for your information only, and changing the selector has no effect.

Core Add-in users: Use the ‘Save Default in Macro’ button to force a specific workbook macro to always use a specific account as the default.

Dates

You can select from preset date ranges similar to what is available in the AdWords web interface, or you can pick a combination of start and end, start and duration, or end and duration.

ad-dates

Dates can be selected by specific calendar dates using pop-up calendars, by selecting a preset date offset, or by entering a date value. Date values can also be obtained from Excel cell references by clicking the button at the right.

The preset date offset is useful for making reports relative to today’s date: the most recent calendar month, for example.

Specific date values could be manually entered in the format of yyyy-mm-dd, or click the button to the right of the field to use an Excel cell reference to a date in your worksheet.

Filters

To add filters to your report, select a combination of the column, criteria and value, and then click the Add button. Multiple filters will be AND-ed, meaning the report will contains rows that pass all the filters.

OR logic is not available from the API — make multiple queries and combine the results.

ad-filters

Note that for fields that use a fixed set of values, a selector drop-down will appear.

Fields

The fields available for each report are listed in three groupings: Segments (used to group metrics), Attributes (settings or other fixed data) and Metrics (numerical performance data).

When you select a report, the default fields will be selected for you (listed at the right). You can add or remove fields from this list as desired.

ad-fields

Note that the display name for each field is shown, consistent with the web interface, and they are listed in alphabetical order. The list of available fields varies depending on the report your selected.

Select from the list at the left and double-click the field name, or click the [ >> ] button to add the field name to the selected list at the right.

Your report results will be sorted based on the order of the columns, with the first column sorted in ascending order, then the second column, and so on. To reorder the list of fields, simply drag and drop them in the list at the right.

Reports

The Analytics Edge Google AdWords Connector provides access to all the reports available from the AdWords API. When you open the Reports wizard, you will see a number of tabs: Reports, Fields, Filters, Dates and Sort.

ad-reports-maintabs

The Reports tab organizes the available reports in a similar fashion to the Google AdWords web interface, with the side tabs and selection buttons.

Starting in v3.7.1, Accounts and Customer IDs can use Excel cell references or manually entered values. Customer ID’s can also use Analytics Edge [Range] names to perform multi-customer queries similar to the Google Analytics’ connector’s multi-view queries.

Reports Sub-menu

Down the left hand side, you will see some side tabs that group reports similar to those available in the Google AdWords web interface, including the Main Tabs, Settings, Ad extensions, Dimensions, Display Network, Shared Library, and Other.

When you select a report, the default Fields and Filters will be automatically selected on the other tabs, so you can simply click Finish to get a default report. You can modify those selections if you want.

For the Dimensions reports, you can also select the Level of Detail using one of the three buttons at the bottom.

ad-reports-dimensions

 

 

* Google AdWords Help

The AdWords Connector for Analytics Edge makes it easy to download Google AdWords data directly into Microsoft Excel.

Before you can make a query, you must log in through the Accounts wizard.

ribbon-menu

If you have multiple customers in an MCC Account, you can get a list with the Customers query.

To run a report, select the Reports wizard. This wizard lets you pick from one of many standard reports similar to what you see in the AdWords interface, and you can customize the fields, filters, dates and sorting options. See the Reports help document for details.

ad-reports