// Author
Jakub Kašparů
Co-owner of the PPC agency Lynt. Writes at jakubkasparu.com.
- Adwords script for better A/B testing of AdsThis script is really useful for long term ad A/B testing for bigger accounts. Key functions: Track changes or additions to the Ad Group and calculate statistical significance…2017
- OpenRefine: a fast and easy way to obtain keyword data from autocompleteIn my post we will look at how you can use OpenRefine to retrieve data from Google’s autocomplete. Using this method, you can get more usable keyword ideas, which can be used for…2017
- MCC script for controlling account performance and trendsThis script is really great for daily overview of your account’s performance. Key functions: ROAS trends for yesterday, 7 days, 30 days for each account. Color indication if…2017
- Script for getting more keyword suggestionsThis script is useful for getting more search suggestions. It will generate a CSV with many keywords for you to use. To begin, you will need a simple spreadsheet with only one…2017
- Exercises for IF, AND, VLOOKUP functions in Google SpreadsheetI have prepared two videos with exercises for you to become more familiar with Google Spreadsheet functions. The videos are below, and you can download a copy of the exercise…2017
- Application of AWQL in real reportsIn this article I would like to show you how you can use the AWQL generator we developed in our company. First, you will need to get an AWQL report. You can use our generator,…2017
- How to use our AWQL generatorAWQL generator uses the AdWords Query language, which allows you to easily pull data from AdWords and combine it with other simple functions in your Google Spreadsheet. I’ve put…2017
- Get to know your e-commerce client’s customersBefore you start your new e-commerce campaign you should have a look at your client’s customers behavior. You might not have much experience with RFM analysis, but you can…2017
- Script for PLA campaign history auditWhat the script does: Downloads the complete performance history of all products for a given period of time (you can set the number of days back on line 4, i.e. typing “30” will…2017
- New columns in AWQL reports based on Adwords API v201601At the end of January Google released a new version of Adwords API, which brings, besides API changes, new columns (metrics) to the Keywords Performance report and Criteria…2016