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.
You can select from preset date ranges similar to what is available in the Bing Ads web interface, or you can pick a combination of start and end, start and duration, or end and duration.
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.
To add filters to your report, select an attribute to filter, then select values desired and add them to the filter by clicking the [ >> ] button. Multiple filters will be AND-ed, meaning the report will contains rows that pass all the filters.
Note that for fields that use a fixed set of values, a selector drop-down will appear. For fields that can accept free-form text, a text box will appear. To enter multiple values in a text box, enter them on separate lines.
The Scope tab allows you to restrict the report to specific accounts, campaigns or ad groups. Selecting an Ad Account will cause a Campaigns tab to appear with the campaigns in that ad account. Likewise, selecting a campaign will cause an Ad Groups tab to appear.
Selecting an item on the left side, then clicking the [ >> ] button will add it to the scope list on the right. The report will be restricted to the combination of items selected. Note that selecting a combination of items of different levels (account, campaign, ad group) may yield unexpected results.
The fields available for each report are listed in two groupings: Attributes 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, as well as reset to the default selections.
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 click the [ >> ] button to add the field name to the selected list at the right. To reorder the list of fields, simply drag and drop them in the list at the right.
The Analytics Edge Bing Ads Connector provides access to all the reports available from the Bing Ads API. When you open the Reports wizard, you will see a number of tabs, the first of which is Reports.
The Reports tab organizes the available reports in a similar fashion to the Bing Ads web interface, and consists of side tabs and selection buttons.
Down the left hand side, you will see some side tabs that group reports. When you select a report, the default Fields will be automatically selected on the other tab. You can modify those selections if you want.
For 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.
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.
This Analytics Edge wizard lets you download the list of customer ids for your account.
The only option for this report is to select your account.
The Bing Ads Connector for Analytics Edge makes it possible to download data directly from the Bing Ads API into Microsoft Excel. The connector provides access to a variety of standard and customized reports.
Before you can make a query, you must log in through the Accounts wizard.