Updated August, 2016, to reflect changes in Google Ads Editor and added support for the expanded text ad format.
In the Summer of 2015, Google removed the HTML export feature from Google Ads Editor. We made heavy use of this functionality in order to share new campaigns with clients for approval. To replace it, I created a Google Sheet with scripts that format text ads and/or keywords organized by ad group and campaign, formatted for review by a client. Google has since added HTML export back, but the export includes a lot of detail and is overkill for some purposes. My tool provides a simple view of keywords and ads, which is helpful when you
If this sounds like something you might benefit from, please give it a try and let me know what you think. The functionality is pretty limited, for example campaign settings and negative keywords are not included. I focused on the elements that tend to require client review and approval. If you want to export every detail, the native Google Ads Editor functionality is a better option.
I’d love to hear ideas for how to make this tool better (in the comments section below). I can’t promise I’ll do everything, but you are also welcome to customize your own version for your purposes.
There are two versions of the worksheet. v0.1.2 is the original version, and supports regular text ads. v0.2 has been updated to support expanded text ads. Sorry, there isn’t a version that supports both formats – you’ll have to use them separately if you want to export both types of ads.
They are read-only. You will need to create your own copy in order to use the sheets, since they require edit permissions in order to function. If you are logged in to a Google account, you will have the option to ‘Make a copy …’ under the File menu. This saves a copy to your My Drive folder, with full permissions. I will likely be fixing bugs and adding features, so check back periodically for new versions.
Shoutout to Michael Maguire and his fantastic blog and ebook about extending Google Sheets with Apps Script. If it weren’t for him, I’d probably still be beating my head against VBA/Excel.
I know there’s still plenty of room for improvement in my code, so any feedback is appreciated. Please put feedback/suggestions in the comments.
The latest developments in digital marketing include Meta feature updates, Google downgrading ranking on vastly…
ChatGPT traffic in the GA house! Plus new features in GA4 and understanding GTM first-party…
This article details the process of building two BigQuery tables for path analysis, with a…