This Google Sheets add-on helps you view and edit Google Ads (adwords) data more easily in Google Sheets™.

✔ User-friendly Google Ads report configurator.
✔ Schedule reports to update automatically.
✔ Get email notifications when your reports are ready.
✔ Edit reports with the sidebar or in the sheet.
✔ Create reports with data from multiple accounts.

This add-on provides support for unlimited Google Ads accounts and reports, up to hourly automated refreshes, and email support. Only Google's quotas and Sheets limits apply. 

► Create Google Ads™ reports
Reports can be created manually in the configuration sheet or using the add-ons sidebar. To use the sidebar, select "Extensions'' > "Google Ads™ reporting by Adformatic" > "Create report" in the menu bar.
This will display a sidebar on the right side with which you can easily create a report configuration. The sidebar helps with the following:
✔ Look up Google Ads account information.
✔ Selecting fields, segments and metrics.
✔ Apply filters.
✔ Determine the sorting of the report.

When you are done, click on the button "Add report to sheet" and your report configuration will appear in the sheet called “Google Ads report configuration” (if this sheet does not already exist, it will be created).
You can go through these steps again to add another Google Ads™ report. You can also edit the reports in the sheet or copy the information in the sheet to a new column to create a new report.

► Edit Google Ads™ reports
There are two ways to edit reports after you have created them. In the add-on menu you can select "Edit report". A sidebar will open with a list of the report names currently in your sheet. You can select one and the sidebar will load your report configuration to the sidebar.
Another option is to edit the report configuration directly in the sheet.

► Run Google Ads™ reports
Go to "Extensions" > "Google Ads™ reporting by Adformatic" > "Run reports" in the menu to run all the reports you have created.

► Schedule Google Ads™ reports to run automatically
Reports can be scheduled to run automatically. To do this, go to "Extensions" > "Google Ads™ reporting by Adformatic" > "Set schedule".
A dialog will open in which you can indicate three things:
✔ Turning a schedule on and off.
✔ Choose the frequency, day and time.
✔ Set whether you want to receive an email if the execution of a report fails.

If you also set alerts, then these will run on the same schedule.
While both, reporting and alerts, can be run in one spreadsheet, using separate spreadsheets is recommended.

► Google Ads™ alerts
This add-on provides a collection of pre-defined, but customizable, Google Ads™ alerts. To access them, navigate to the add-on menu and select "Extensions" > "Google Ads™ reporting by Adformatic" > "Alerts". A sidebar will open to guide you through the setup process.

These alerts are currently available:
1. No conversions alert: Checks how many days ago the last conversion (included in the conversions column) occurred. An alert is sent if the number of days is above the threshold.
2. No impressions alert: Checks how many hours ago the last impression for an account occurred. This checks writes basic data of the last 24 hours to the sheet "No impressions alert" and sends an alert if the number of hours is above the threshold.
3. Account performance alert: Checks yesterday's account performance for clicks, cost and conversions. It compares yesterday's performance with the average performance on the same weekday in the previous weeks. An alert is sent if the deviation is above the threshold.
4. Monthly budget alert: Checks this month's spend until yesterday against the budget available until yesterday. A budget state is calculated and an alert is sent if the difference becomes too great. You can set the thresholds yourself.

This add-on requires access to your Google Ads account. Your Google Ads™ data is safe with Google and is never seen by Adformatic. 

FREE TRIAL - 14 DAYS
By using this add-on for Google Sheets you automatically enter a 14 days free trial. If you wish to continue using the add-on after the free trial, please subscribe at https://portal.adformatic.com/subscribe/google-ads-add-on-for-google-sheets

By installing this add-on, you agree to Adformatic's:
- Terms and conditions: https://adformatic.com/en/terms-and-conditions/
- Privacy Statement: https://adformatic.com/en/privacy/

Google Ads™ is a trademark of Google LLC
Google Sheets™ is a trademark of Google LLC