Google BigQuery

How to run N-gram analysis in BigQuery

April 27, 2023

N-grams essentially indicate the frequency of a word or sequence within our keyword list. Utilizing N-Gram data enables you to identify the most popular and repetitive keywords. Therefore, you can…

Google Cloud use cases for marketing

November 15, 2022

Stefan Neefischer

Google BigQuery

No Comments

The world is changing fast. In the past, marketers had to rely on intuition to understand their customers. Today, they can use the tools to collect and analyze customer data…

How to pull Google Auction Insight Data in an automated way

May 11, 2022

Stefan Neefischer

Data Science in Digital Marketing, Google Ads Script, Google BigQuery

No Comments

Data-driven decisions for the digital world are everything today. First, you need to understand your competitors. Then, you can overtake them. However, this is possible only with data. The Auction…

How to structure keywords using entity lookups in BigQuery

November 29, 2021

Stefan Neefischer

Data Science in Digital Marketing, Google BigQuery, Keyword Tagging

No Comments

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…

N-gram analysis in PPC

November 15, 2021

Stefan Neefischer

Data Science in Digital Marketing, Google BigQuery, Python in PPC / SEO

No Comments

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…

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

April 21, 2021

Selin Neefischer

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

No Comments

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.…

Export to BigQuery asap if you set up Google Analytics 4

March 17, 2021

Selin Neefischer

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

No Comments

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…

BigQuery ML with Scheduled Queries and Partitioned Tables

March 1, 2021

Selin Neefischer

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

No Comments

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…

Google BigQuery

How to run N-gram analysis in BigQuery

Google Cloud use cases for marketing

How to pull Google Auction Insight Data in an automated way

How to structure keywords using entity lookups in BigQuery

N-gram analysis in PPC

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

Export to BigQuery asap if you set up Google Analytics 4

BigQuery ML with Scheduled Queries and Partitioned Tables

Categories

Recent Posts