• Skip to main content
  • Skip to primary sidebar

PPC Scripts

by Lynt services

  • About the Author
  • PPC Services
  • Workshops for PPC companies
  • English
  • Czech
You are here: Home / Archives for Jakub Kašparů

Jakub Kašparů

Adwords script for better A/B testing of Ads

February 15, 2017 od Jakub Kašparů 5 Comments

This script is really useful for long term ad A/B testing for bigger accounts.

Key functions:

  1. Track changes or additions to the Ad Group and calculate statistical significance for A/B testing from a specific date. You can see the date range for each test in the Dates list.
  2. Once the test has reached at least 95% significance, and the Ad Group has 2 or more ads, more than 50 clicks, and 500 impressions for the test period, you will find a list of the Ad Groups which are finished testing in the Results sheet.
  3. If/when you make any changes to the ads in the Ad Group (pausing an ad or creating a new one), the script will automatically detect the change and start gathering new data on the day the change is made.
  4. If the Results sheet is empty, then the A/B tests are still running and there are no results currently available.

[Read more…] about Adwords script for better A/B testing of Ads

Filed Under: Uncategorized

OpenRefine: a fast and easy way to obtain keyword data from autocomplete

February 15, 2017 od Jakub Kašparů 2 Comments

In 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 classification analysis of keywords or can even be incorporated into your PPC campaigns.

Ok, enough talking. Let’s get started!

What will you need?
OpenRefine Tool. I recommend the latest beta version 2.6, which has fixed a lot of the mistakes from the previous versions.
The list of keywords that we want to choose from. Initially we will draw from the following sources:
Search queries in AdWords.
Keyword suggestion tool in AdWords.
Keywords from Google Webmaster Tools.

[Read more…] about OpenRefine: a fast and easy way to obtain keyword data from autocomplete

Filed Under: Uncategorized

MCC script for controlling account performance and trends

February 15, 2017 od Jakub Kašparů 2 Comments

This script is really great for daily overview of your account’s performance.

Key functions:

  1. ROAS trends for yesterday, 7 days, 30 days for each account.
  2. Color indication if performance(ROAS or CPA) does not meet set targets in each date range.
  3. Performance information for conversions, cost, and impression share metrics.
  4. View the most important performance metrics side by side over 3 different time periods.
  5. Linear prediction of your cost at the end of the month. You can set-up the configuration for ROAS and Cost in the Settings list.
  6. Uses MCC parallel function. You can process up to 100 accounts per run.

[Read more…] about MCC script for controlling account performance and trends

Filed Under: Uncategorized

Script for getting more keyword suggestions

February 15, 2017 od Jakub Kašparů 24 Comments

This 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 column called Keywords.

In the settings of the script, input your source spreadsheet URL and the sheet name, which will be used in the final CSV name.

Paste the code into this column and run the script.

[Read more…] about Script for getting more keyword suggestions

Filed Under: Uncategorized

Exercises for IF, AND, VLOOKUP functions in Google Spreadsheet

February 15, 2017 od Jakub Kašparů 2 Comments

I 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 spreadsheet here.

 

Filed Under: Uncategorized

Application of AWQL in real reports

February 15, 2017 od Jakub Kašparů 11 Comments

In 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, which you can find here or, if you prefer, you can copy our template below which already has the AWQL report combined with the script and some additional functions:

[Read more…] about Application of AWQL in real reports

Filed Under: Uncategorized

How to use our AWQL generator

February 15, 2017 od Jakub Kašparů 8 Comments

AWQL 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 together a short list of the obstacles you might face with AdWords API and how to deal with them.

Choose the right report type

It may seem overly simple, but you need to think about what type of report you want. If you want to generate a report of the search queries then you need to choose Search Query performance report. If you want to see account data, choose Account Performance report. It’s not complicated, but it’s important to keep it in mind.

[Read more…] about How to use our AWQL generator

Filed Under: Uncategorized

Get to know your e-commerce client’s customers

February 15, 2017 od Jakub Kašparů 4 Comments

Before 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 certainly answer the following questions quite easily:

  1. What’s the time between orders?
  2. What’s the average profit per customer?
  3. What percent of customers return?

[Read more…] about Get to know your e-commerce client’s customers

Filed Under: Uncategorized

Script for PLA campaign history audit

February 15, 2017 od Jakub Kašparů 13 Comments

What 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 download history for the last 30 days).
  • Generates a CSV file that contains all the data.
  • You’ll find the CSV file in your Google Drive or script protocol.
  • You can then manipulate the data according to your needs in order to analyze it, regardless of the historic PLA campaign structure.

[Read more…] about Script for PLA campaign history audit

Filed Under: Uncategorized

New columns in AWQL reports based on Adwords API v201601

February 18, 2016 od Jakub Kašparů 5 Comments

At 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 Performance report. If these columns are in API reports, we can access them through Adwords scripts.

Let’s take a look at them:

  1. FirstPositionCpc – Estimate of the amount you might need to pay for your ad to be displayed in the first position
  2. EstimatedAddClicksAtFirstPositionCpc – Estimate of how many clicks per week you might get by changing your keyword bid to the value in FirstPositionCpc.
  3. EstimatedAddCostAtFirstPositionCpc – Estimate of how your cost per week might change when changing your keyword bid to the value in FirstPositionCpc.
  4. CreativeQualityScore – The quality score of the ad.
    1. Not applicable.
    2. Below average.
    3. Average.
    4. Above average.
  5. PostClickQualityScore – The quality score of the landing page.
    1. Not applicable.
    2. Below average.
    3. Average.
    4. Above average.
  6. SearchPredictedCtr – Clickthrough rate compared to that of other advertisers.
    1. Not applicable.
    2. Below average.
    3. Average.
    4. Above average.

[Read more…] about New columns in AWQL reports based on Adwords API v201601

Filed Under: Adwords scripts Tagged With: Adwords scripts

Primary Sidebar

Google Partner

Tools

AWQL Generator
Keyword Combinator
Datastudio Case generator

Recent Posts

  • Adwords script for better A/B testing of Ads February 15, 2017
  • OpenRefine: a fast and easy way to obtain keyword data from autocomplete February 15, 2017
  • MCC script for controlling account performance and trends February 15, 2017

Recent Comments

  • how to make a blog on OpenRefine: a fast and easy way to obtain keyword data from autocomplete
  • movie download sites on New columns in AWQL reports based on Adwords API v201601
  • latest movie download on Script for PLA campaign history audit

© Copyright 2016 Lynt services s.r.o.