Insights on Performance Marketing and Tech

Python Script: Cluster Keywords into Topics using SERP Results

We’ve published a Python Script that uses the clustering method to group keywords together using Google’s search results. The new version is improved, and some cool graphical outputs are added to visualize keyword topics…

Python in PPC / SEO, SEO Tools

29 March 2021
12:28 pm

Electronic car models: Who will catch the Tesla Model 3 in DE Market?

What does the German market for electronic cars look like? Time to ask Google Trends. It’s not surprising that Tesla’s Model 3 is the one to beat after driving the performance model: A lot…

Google Trends

27 March 2021
8:23 am

Predicting Covid Cases using Google Trends on Symptoms

I realized by my own that it takes quite a while if a positive covid test result makes it into the official numbers. If you were in direct contact with a person that was…

Google Trends

25 March 2021
9:27 am

Export to BigQuery asap if you set up Google Analytics 4

Google’s BigQuery is a perfect fit as Marketing Analytics Data Warehouse (DWH). Even if you are not the tech affine marketing guy and you don’t have the power in your team to deal with…

Data Science in Digital Marketing, Google Analytics, Google BigQuery

17 March 2021
11:10 am

Python Script: Compare the content of 2 website sitemaps on n-gram level

Comparing competitor sites’ sitemaps at the n-gram level can help you find strategic vulnerabilities that will make you stand out. The n-gram is a contiguous sequence of “n” items of a given text or…

Python in PPC / SEO

15 March 2021
9:42 am

Python Script: Google autosuggest trends for niche keywords

You like Google Trends but you’re disappointed that it doesn’t work well for long tail keywords? Then keep on reading and use this python script to build your own “Google Trends” service by using…

PPC Tools, Python in PPC / SEO, SEO Tools

2 March 2021
12:29 pm

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…

Data Science in Digital Marketing, Google Analytics, Google BigQuery, Marketing Analytics

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