Insights on Performance Marketing and Tech

How to build a User-based Content Recommendation System for your Website with BigQuery (ML)

Build a great website experience for your customer’s real journey. Alternatively, don’t wait them to return to your website: Send the recommendations per e-mail or integrate them into your product. Ensure your leads to…

Google Analytics, Google BigQuery

21 April 2021
9:21 am

PEMAVOR Search Trends Tool: How is it done?

Google Trends is an excellent tool for marketing purposes. It shows how frequently a specific search term is entered into Google’s search engine over a period of time. Also, it allows you to monitor…

Google Trends, Python in PPC / SEO

20 April 2021
11:33 am

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

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…