Use web queries

Search Ads 360 web queries help you download the latest Search Ads 360 data directly from a Microsoft Excel spreadsheet instead of manually downloading and importing a file into Excel. Like a report that you view in Search Ads 360, you can customize the scope, type, and range of data that appears in the report. But instead of requiring you to download a file, Search Ads 360 provides a URL that Excel can use to automatically download and refresh the report’s data. Search Ads 360 web queries:

• Reduce the time you spend generating reports in Search Ads 360.
• Enable you to create common report templates in Excel and populate them with the latest Search Ads 360 data.

For example, if you've created a customized campaign-performance report that you send to advertisers or clients weekly, you can create one Search Ads 360 web query for each of your advertisers and clients. For each web query, you set up an Excel spreadsheet that automatically refreshes every week. When you open each report after the weekly refresh, the reports are ready for delivery.

Set up a web query

1. In Search Ads 360, create a report and generate a web query URL.
2. In Excel, enter the web query URL.
3. Update settings and format columns in Excel.

Create a report and generate a web query URL

1. In the Search Ads 360 UI, navigate to a reporting table.
   For example, navigate to a campaign and click the Keywords tab.

2. Make sure the table contains the date range, columns, segments, filters, and so forth, that you want in your report.
   Learn how to customize the data in your tables and reports.

   When you use Excel 2010 or later to connect to a web query, the report can have a maximum of one million rows. For Excel 2007 users, please limit your reports to 25,000 rows to avoid Excel performance issues.

3. Above the reporting table, click the download icon  .
   The download settings appear.

4. Click the Create web query tab.

5. Enter the desired settings and click Create web query.
   A message above the table indicates that the web query was created.

6. Next to the message, click Get web query URL and copy the URL that appears.

Enter the web query URL in Excel

After you create the report and web query URL in Search Ads 360, you can connect to the web query in Excel, format your columns as needed, and choose how you want to keep the data up to date.

You can use Search Ads 360 web queries in Microsoft Office Excel 2007 for Windows (up to 25,000 rows) or Excel 2010 for Windows (up to one million rows).

1. In Excel, click the Data menu and select From Web.

   The New Web Query pop-up appears.

   Special instructions for Microsoft Office 365

   If you use Microsoft Office 365, select From Web (legacy) instead of "From Web".

   Special instructions for Microsoft Windows 10 Pro

   1. In Excel, right click the ribbon and go to Customize Ribbon.
   2. In the left hand menu choose All Tabs.
   3. Click on Data > Get external data and drag the menu group into menu in the ribbon.
      This adds a new Get Data menu that opens a browser window.
   4. Click the new menu item top open the browser window.

2. In the Address field, paste the web query URL from Search Ads 360 and click Go.

3. The first time you enter a web query URL, you may get a Security Alert notice that You are about to view pages over a secure connection.
   Select the check box and click OK.

4. If prompted, sign in to Search Ads 360.

5. Select the XML table: Click the yellow arrow icon in the upper righthand corner of the code box.

6. Click Import.

7. The first time you enter a web query URL, you may get a Microsoft Office Excel notice that The specified XML source does not refer to a schema.
   Select the check box and click OK.

8. In the Import Data pop-up, for Where do you want to put the data?, select XML table in existing worksheet and click OK.
   The Search Ads 360 data appears in the worksheet.

9. Use the data any way you want in Excel: create pivot tables, generate reports, and so forth.

10. Keep the data up to date:
    • Cell: Select a cell and click the refresh button in the toolbar.
    • Report: Click the Data menu and select Connections. Select the connection and click the Refresh button, or click Properties and choose from the automatic refresh options.

If you refresh an existing web query in Excel and authorization fails, an error message will appear. You'll need to go back to the Excel web query configuration settings and sign back in to Search Ads 360.

Manage existing web queries

You can see a list of existing web queries, copy the web query URL, or remove a web query.

1. Navigate to an advertiser.

   Steps for navigating to an advertiser

   1. Click the navigation bar to display navigation options.

   2. In the "Agency" list, click on the agency that contains the advertiser. You can search for an agency by name or scroll through the list.

   3. In the "Advertiser" list, click on the advertiser.

   4. Click Apply or press the Enter key.

   Search Ads 360 displays the advertiser page, which contains data for all of the advertiser’s engine accounts.

2. In the left navigation panel, click Downloads.

3. Click the Web queries tab above the table.
   The list of existing web queries appears. You can do any of the following:

   • Copy a web query URL: Click a Get URL link in the Web query URL column.

   • Remove a web query: Select the check box next to a web query name and click Remove above the table.

Known issues

• You can’t use multi-agency reports as web queries.

• You can't download an editable web query report, or upload web query reports back into Search Ads 360.

• An XML import error message may appear upon refreshing the web query in Excel when your Temporary Internet Files cache is full. To resolve this issue, clear the files in your Temporary Internet Files folder, reload the web query, and sign in to Search Ads 360 if needed (using the steps under Connect to the web query in Excel). You can also increase the size of the cache by adjusting your settings in Internet Explorer.

• If an advertiser has engine accounts in different currencies, Search Ads 360 will convert currency columns for web queries and non-editable reports to the advertiser currency, appending column headers with the converted currency's code.

Report issues

If you need to contact support and report issues with web queries, make sure to include the following information in your request:

• Operating system (for example, Windows XP, Windows 7)

• Internet Explorer version

• Excel version

• If applicable, the web query URL for the web query you're having problems with.

This will help support try to reproduce and confirm issues that you may have.