Use Google Sheets to manage data

In Search Ads 360, you can use Google Sheets to track and report on your campaign performance. Google Sheets can help you to automate and simplify your reporting in a way that is shareable and low latency, and allows you to schedule refreshes to your data, and add multiple reports in one file. Google Sheets can help you to reduce errors in your reporting because updates are made automatically to your charts, pivots, views, and tables that are created off the file.

Automatically refresh your data

You can create Google Sheets automated reports in Report Editor to help you to manage the different files in your reports (for example, linked charts, or pivot tables). Additionally you can manage your reporting easily by combining multiple reports into one file by adding separate tabs to the same Google Sheets file. Access to your reports using Google Sheets can be limited when scheduling the report to help make sure the data in your reports isn’t edited or viewed unless the user has access.

Schedule your data as an export to Google Sheets

Use the following steps to schedule your data as an export to Google Sheets:

1. Sign in to your Search Ads 360 account.
2. Select Reports at the top of your account, or click Campaigns/Ad Groups/Keywords from the page menu on the left, then click Reports.
3. Select the report you’d like to schedule, and when the report is open click the schedule icon.
4. Select the date and time, and select Google sheets from the dropdown.
5. Set a report schedule frequency, either one time or recurring (daily, weekly, monthly, weekdays, or first of the month).
6. If you’d like the report to refresh automatically, check the box next to “Automatically refresh report.”
7. Once you select “Automatically refresh report”, you will see another dropdown where you can choose to either
   1. Create a new report.
      • Provide a file name and choose a Google Drive for the new report.
        • If the tab name is an existing tab (the existing tab with the name will be replaced with the report).
        • If the tab name is new, a new tab will be created in the existing file.
   2. Add a new tab to an existing report in your Google Drive.
      • Choose an existing file and provide a tab name for the report.
8. Add the recipient emails for your export.
9. Set the access level for the recipients of the report.
10. Add Segments and additional row items and check the boxes to include those in the report.
11. Click Email Now.

Delete the Schedule

Use the following steps to delete the schedule:

1. Sign in to your Search Ads 360 account.
2. Select Reports at the top of your account, or click Campaigns/Ad Groups/Keywords from the page menu on the left, then click Reports.
3. Open any existing save report.
4. Click Schedule.
5. This should open up a dialog showing the saved schedule.
6. Click on the trash bin icon to delete it.