// Google Ads · Apps Script
Scripts for Google Ads
Code, how-tos and tools from the Lynt PPC agency.
// average quality score per ad group
var report = AdWordsApp.report(
"SELECT Criteria, AdGroupName, QualityScore " +
" FROM KEYWORDS_PERFORMANCE_REPORT " +
" WHERE Impressions > 10" +
" DURING LAST_30_DAYS");
var rows = report.rows();
while (rows.hasNext()) {
var row = rows.next();
}Articles
- jakubkasparu.com ↗How to import order margin into Google Ads when your shop doesn't store the click ID2026
- jakubkasparu.com ↗Google Ads account hacked? Here's how it happens, and how we watch our clients' accounts for it.2026
- jakubkasparu.com ↗How we wired AI into our PPC workflow2026
- jakubkasparu.com ↗ChatGPT Ads launched in 31 European countries. None of them can open an account2026
- jakubkasparu.com ↗Four weeks until Content API for Shopping goes dark. The last call plan2026
- jakubkasparu.com ↗The Shopping search-term report Google won't give you2026
- jakubkasparu.com ↗How to expand your online shop abroad using data (and not get burned)2026
- jakubkasparu.com ↗Content API for Shopping shuts down on August 18, 2026. Catch the last train to Merchant API2026
// Google Merchant Center
AI boost for your product feed
Boostora rewrites product titles and descriptions, fills in color, material, size, GTIN and other attributes, and sends them to Merchant Center via the API every day. Products match more Shopping queries and the ads show complete details.
- average lift in Shopping impressions after better titles and descriptions
- +30%
- average CTR lift with complete attributes
- +26%
24 attributes audited in under 2 minutes, no sign-up.
<g:id>NK-AM90-42</g:id>before: <title>Nike Air Max 90</title>added: <title>Nike Air Max 90 Men's Running Shoes, Red/White</title>before: <g:color></g:color>added: <g:color>red/white</g:color>added: <g:gender>male</g:gender>added: <g:age_group>adult</g:age_group>added: <g:material>leather/textile</g:material>added: <g:product_highlight>Air cushioning in the heel</g:product_highlight>// ChatGPT Ads · chatgpt-feed.csv
Need a product feed for ChatGPT?
Boostora builds it from the feed you already have in Merchant Center. It follows the OpenAI format, carries the improved titles, descriptions and attributes, and updates every day.
For feeds that Merchant Center fetches from a URL.
- jakubkasparu.com ↗The content-gap analysis that pays for itself in a coffee's worth of API credit2026
- jakubkasparu.com ↗Merchant API comes to Google Ads Scripts: feed and campaigns in one place2026
- jakubkasparu.com ↗Where to start with Search campaigns on a huge site? Your GA4 already knows.2026
- jakubkasparu.com ↗AI Max replaces Dynamic Search Ads, and the auto-upgrade slips to February 20272026
- jakubkasparu.com ↗A year on the Microsoft Advertising API: SOAP is dying, the window is open2026
- jakubkasparu.com ↗You can now sign into the Microsoft Advertising API with a Google account2026
- jakubkasparu.com ↗A year on the Google Ads API: two hard deadlines and a lot of free leverage2026
- jakubkasparu.com ↗PPC automation was always possible. It just never paid for itself. Until now.2026
- AdWords scriptAdwords script for better A/B testing of Ads2017
- AdWords scriptOpenRefine: a fast and easy way to obtain keyword data from autocomplete2017
- AdWords scriptMCC script for controlling account performance and trends2017
- AdWords scriptScript for getting more keyword suggestions2017
- AdWords scriptExercises for IF, AND, VLOOKUP functions in Google Spreadsheet2017
- AdWords scriptApplication of AWQL in real reports2017
- AdWords scriptHow to use our AWQL generator2017
- AdWords scriptGet to know your e-commerce client’s customers2017
- AdWords scriptScript for PLA campaign history audit2017
- AdWords scriptNew columns in AWQL reports based on Adwords API v2016012016
Tools
- $ ad-previewSearch Ad PreviewGoogle Ads responsive search ads and Sklik text ads: preview, character limits, pins and assets.
- $ google-product-categoryGoogle Product CategoriesSearch Google's product taxonomy: IDs, full paths and translations into 23 languages.
- $ awql-to-gaqlAWQL → GAQLConvert AWQL queries and AdWords scripts to GAQL for the Google Ads API, based on Google's official mapping.
- $ keyword-combinatorKeyword CombinatorKeyword combinations with match types and ads, ready for Editor import.
- $ awql-generatorAWQL generatorBuild AdWords API report queries from fields and conditions.
- $ case-generatorCase GeneratorCASE formulas for Looker Studio from a list of rules.