Insights on Performance Marketing and Tech

Get the latest and most creative solutions for applied MarTech by subscribing to our newsletter. Sum of all Stefan Neefischer’s newest deep dives.

Subscribe to Stefan Neefischer’s Deep Dive Newsletter

All Data Science in Digital Marketing5 Google Ads Audits3 Google Ads Bidding3 Google Ads Optimization4 Google Ads Script2 Google Analytics1 Google Analytics 3601 Google BigQuery1 Google Display5 Keyword Negativation in Google Ads7 Keyword Scaling2 Keyword Tagging2 Marketing Analytics1 Newsletter1 PPC Tools2 Python in PPC / SEO8 SEO Audit Scripts5 SEO Tools9

BigQuery ML with Scheduled Queries and Partitioned Tables

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

Yesterday at 1:10 pm

Google’s BigQuery is a perfect 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 via Google App Script or Ads Script. External data can be imported to enhance this data…

Semantic Keyword Clustering in Python

Python in PPC / SEO, SEO Tools

20 Feb at 10:10 am

I 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 are not able to group by meaning and semantic relationships. One way to deal with semantics is building up e.g. word2vec models…

Free Online Tool: Group Your SEO Keywords Into Topics

SEO Tools

17 Feb at 10:28 am

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 I have good news for you! In this post I will describe how to use our free online grouping…

FREE Tool: Daily Monitoring Of PageSpeed Insights

SEO Audit Scripts, SEO Tools

12 Feb at 1:02 pm

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 way. For that reason we build a small solution that is automating the job for us…

N-Gram Analysis on Keyword Planner Data

PPC Tools, SEO Tools

9 Feb at 9:59 pm

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 be short how-to on applying n-Gram analysis on search queries extracted from Google keyword planner. The…

Free SERP Ranking Checker for 100 Keywords Per Day

SEO Audit Scripts, SEO Tools

6 Feb at 5:52 pm

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 automated solution – Totally FREE!Get your free Spreadsheet Copy here. Scrape the Google SERPs for your…

Google Dropped Modified Broad – What Does It Mean?

Google Ads Optimization

5 Feb at 8:47 am

Google made a recent announcement in their post “Making it easier to reach the right customers on Search”. But did the changes really make it easier and more profitable? Here are my notes on what Google’s announcement really means. Google wants to make more money out of 15% of the…