An Excel Web query allows you to bring data from a web page into an Excel worksheet. It will find any tables on the web page and lets you select the data you want to put into your worksheet, allowing for dynamic updates from the web page. 

 

For example, Search Ads 360 web queries make it easy to 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.

 

1. Launch Internet Explorer browser

2. Click on the gear icon (found in the upper-right corner) and click Internet Options.

 

 

3. Under Security Tab, click Trusted Sites.

4. Click Sites button.

 

 

 

5. Remove any link found under the Add this website to the zone: field and replace with *.google.com

6. Click Add button.

7. Make sure to uncheck Require server verification (https:) for all sites in this zone.

 

 

8. Click Close and the subsequent OK button to close out Internet Options. 

9. Exit/showdown your Internet Explorer browser.

 

Now that you’ve completed the workaround process to bypass the bug, follow the next set of steps to build your web query report.

 

1. This time, open/launch Chrome or Mozilla Firefox browser and sign in to the web site/page (i.e. Search Ads 360) to extract the URL of its Web query report.  Save a copy of this URL somewhere (i.e. Notepad or Word doc).

2. Open/launch a new Excel worksheet.

3. We need to make sure you have From Web (Legacy) as an option for its import wizards.  Click File from the menu bar and click Options.

 

 

 

4. Under Data, make sure that your Excel setting has From Web (Legacy) box checked as an option to import then click OK.

 

 

5. Next, navigate to the Search Bar in excel, type "from web" and click From Web (Legacy) from the dropdown.

 

 

6. A new Internet Explorer iframe window should open within Excel. Copy/paste the previously saved web query URL in the address field and click Go.

      a. Enter your credentials if prompted.

 

 

7. Once your data table shows, click Import.

8. Select which cell you would like to import your data, and you can then click Ok.

 

 

Next set of instructions will illustrate how we can automatically refresh the web query report when opened.

 

1. From the menus bar, click Data and then Properties.

 

 

2. Check Refresh data when opening a file and click Ok.

 

 

3. As an alternative option to refresh your data, right click on any cell in Excel and click Refresh.

 

 

4. Don’t forget to save your account-specific web query report once everything has been completed.




Generating / copying a web query URL from the New SA360 (SA4).

 

 

Create a report and generate a web query URL

1. Sign in to your new Search Ads 360.
2. Navigate to a reporting table.
   For example, from the page menu on the left, click Campaigns.
3. Make sure the table contains the date range, columns, filters, etc., that you want in your report.
4. Above the reporting table, click Download  and click Web Query from the dropdown.
5. In the "Download" window, select the options that you want and name the report.
6. Click Download.
   Search Ads 360 creates a report and generates a URL for the report.

 

 

Copy a web query URL from an existing report

Web query URLs are available on the Reporting page along with all of your saved reports.

1. Sign in to your new Search Ads 360.
2. In the  upper right corner of Search Ads 360, click the reports icon ,  and then click Reports.
   The reports with web queries will have a "Copy URL" link.
3. Optional. To see only the reports that have web queries, click Add filter, click Format, select the Web Query checkbox, and click Apply.
4. Find the report that you want and click Copy URL.