As PPC account managers, we’ve always had to do a lot of reporting to keep our stakeholders informed. Now with the continued rise in automation, reporting has taken on new importance as one of the key ways we can monitor what the machines are doing. For example, we can use reports to monitor which queries are considered close company email list variants for exact match keywords. But while reporting is a key PPC management task, it can also be one of the most time-consuming. That is, unless you use your own automation layers like the ones I’ll share here. There are plenty of great free and paid solutions that make reporting easier (you can find some in Aaron Levy’s free PPC tools roundup). But most people overlook Ad Scripts because they’re worried that this may be too advanced for them.
The good news is that there are some great scripts out there already written by experts, and if you know how to copy-and-paste and follow a few simple instructions, you can use a script to automatically put your Google Ads reports into a spreadsheet. In this column, you’ll find three free scripts I’ve written that can send different types of ads data into a Google Sheet. The beauty of Sheets is that they are a great connector to other systems. Once you company email list have the data you want in a Google spreadsheet, it’s relatively easy to connect it with your favorite dashboard software or a client reporting tool. Or, simply use it as the basis for making optimization decisions to improve your account. Deciding which of these three scripts is best for you depends on the desired output and your level of comfort with writing SQL, digging up field names in Google’s documentation, and manipulating data yourself in the spreadsheet after it’s been imported automatically.
Script 1: You Know How to Write Simple SQL If you just need a quick dump of Google Ads data into a Google Sheet, check out the add-on for Google Sheets first. It’s by far the easiest way to get started. But in my own experience, it doesn’t cover all the report types available in the API so if you’re familiar with SQL and need something more than what the add-on company email list provides, try this script. You get to write an AWQL query and the script simply executes the query and puts the resulting rows in a new Google Sheet. You can even use one script to run multiple queries and send the output to different tabs in the same spreadsheet. You could use this to create a massive report that contains every piece of data Google has about your ads. Example of Google Ads data in a Google spreadsheet.