How to find YouTube autocomplete keywords

YouTube is undoubtedly the most popular video platform in the world. Its logic is quite similar to Google Search when a user looks for results, but they get video recommendations rather than indexed quality pages. Now that even more and more people are using this platform and looking for different types of media, extending your […]

Cluster massive amounts of keywords in PPC

Sample size is crucial for making decisions in PPC… One big goal of keyword clustering is to bring sample sizes up to enable decisions on stable numbers. Why should you cluster keywords or Search Terms in PPC? Sample size is crucial for making decisions in PPC. Maybe you want to block some parts of your […]

How to structure keywords using entity lookups in BigQuery

BigQuery is quite powerful to analyze your PPC or SEO data. Databases are optimized to run JOIN statements between large tables. In this post, we’ll describe how to transform the “Problem” of Keyword Tagging or Entity Recognition that it can be handled with pure SQL within Google BigQuery. Even for big keyword lists. Why entities […]

Google Ads Scripts to Improve Your PPC Performance

Google Ads scripts are here to stay. Specific scripts for PPC tasks should be at the top of your to-do list. Search Engine Journal, Frederick Vallaeys If you’re an Ads manager, you most certainly know that monitoring tasks and daily optimization of your campaigns can become a long and tedious task. To get rid of […]

N-gram analysis in PPC

N-gram analysis of your PPC data will give you insights to take actions that will save you tons of money! Become a PPC Super Hero by using data science Approaches for PPC problems. N-gram analysis will inspire you with insights and action plans which were hidden before. What are n-grams and how to create them […]

Ads script for negative keyword conflicts in PPC

At the end of the day, ads scripts keep your campaigns running like a lean, mean, well-oiled machine. Nils Rooijmans, Wordstream Negative keywords prevent ads from appearing to irrelevant search queries. However, in some cases, they may block your normal keywords from showing to valuable traffic. This issue often arises when you choose a wrong […]

What exactly changed in the Search Term Report in September 2021?

Intro: Google changed the Search Term Performance Report Google announced in September 2021 that there will be some major changes to their Search Term Performance Reports. This time, Google is going the opposite way than last time: There should be more search term data than ever before in order to provide more insights for campaign […]

The Rise of Python since 2004

Which Programming Language you should learn? In these days, you will find a lot of new code examples of Python solutions for marketing areas like SEO or PPC. When you are interested in becoming a data scientist, you are probably to pick Python to start with because there are so many modules out there and […]

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 and analyze both your company and competitors. As PEMAVOR, we also frequently used Google Trends data in past projects. But there […]

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 more clearly. Why should you use this python script?Today, it’s advantageous to optimize full keyword topics rather than single search terms. […]