Insights on Performance Marketing and Tech

BigQuery ML with Scheduled Queries and Partitioned Tables

Google’s BigQuery is a great fit as Marketing Analytics Data Warehouse. Google Analytics 360 uses BigQuery. If you are using free Google Analytics and Google Ads, you can also import their data into BigQuery…

1 March 2021
1:10 pm

Semantic keyword clustering in Python

We already shared some clustering approaches using TF-IDF Vectorizer for grouping keywords together. This works great for grouping keywords together that share the same text strings, but you aren’t able to group by meaning…

Python in PPC / SEO, SEO Tools

20 February 2021
10:10 am

Free online tool: Group your SEO keywords into topics

We already shared a python keyword grouping script some weeks ago and get some great feedback for it. If you struggle with python programming, but still want to use this approach, we have good…

SEO Tools

17 February 2021
10:28 am

FREE Tool: Daily monitoring of PageSpeed insights

A lot of people are using PageSpeed Insights in these days to improve their website speed. Every change on your website (e.g. new plugins, updates, etc.) can affect the page speed in a negative…

SEO Audit Scripts, SEO Tools

12 February 2021
1:02 pm

N-gram analysis on Keyword Planner data

You can discover interesting search patterns for your SEO strategy by analyzing n-grams in big keyword lists. Here is a real life example of how easy and fast it can be done. This will…

PPC Tools, SEO Tools

9 February 2021
9:59 pm

Free SERP Ranking Checker for 100 Keywords Per Day

Check the SERP Rankings for 100 keywords per day with Google Custom Search Engine + App Script and save the results to Google Sheets. Schedule it for daily runs and you get a fully…

SEO Audit Scripts, SEO Tools

6 February 2021
5:52 pm

Google dropped Modified Broad What does it mean?

Google made a recent announcement in their post “making it easier to reach the right customers on Search”. However, did the changes really make it easier and more profitable? Here are our notes on…

Google Ads Optimization

5 February 2021
8:47 am

Build Automated SEO Audits with Slack+Python

Get notified when a Python SEO audit job returned some issues and attach detailed information in a file to the Slack notification to make actions right away. Many of you were curious to know…

Python in PPC / SEO, SEO Audit Scripts

4 February 2021
11:45 am

Python script: SEO content analysis of your competitor

Analyzing the content of your competitors can provide you with valuable insights about your own operations and goals. This basic Python script can give you information on N-rams in seconds. How to analyze your…