More up-to-date information for your shopping data Anyone who works with Google Shopping knows that good campaigns need up-to-date product data. This Google Ads script is designed precisely for that purpose. It triggers the hourly update of your Merchant Center feed, ensuring that price and stock changes are reflected in…
Introduction Definition of N-Gram Analysis N-Gram analysis is a method in natural language processing (NLP) and computational linguistics used to examine text and data by analyzing sequences of N consecutive elements or tokens (e.g., words or letters). It helps to identify patterns, frequencies, and relationships between elements in larger text…
Use ChatGPT to create automated text quickly and easily. With Google Spreadsheets you can use it to generate product texts, meta titles and meta descriptions based on product data, but also for data from WebCrawlers and other analysis tools. Use the template in the article to quickly and easily create…
The article shows the transfer of Google Ads API data to Google BigQuery using custom reporting, which can be configured individually. Possible transmission routes You can transfer the Google Ads API data into BigQuery in several ways. One option is to create an ETL (Extract, Transform, Load) process using a…
Manually setting parameters is time-consuming and prone to errors. This article explains how to automatically set campaign names with UTM parameters in Google Ads using Google Ads Script.
Who hasn’t experienced this in everyday agency life? A client’s online shop releases new products, but no one at the ads agency notices because the people responsible for product maintenance don’t communicate regularly with the various agency partners. In the end, such new products are casually mentioned at the next…
Requirements For the implementation of this solution, you need: Objective To supplement data in Google Merchant Center, there’s the option of “supplemental feeds.” These trigger product updates based on an item number and other attributes. You can create such a feed using Google Spreadsheets, BigQuery, and an AppScript that retrieves…
Requirements To integrate the Matomo – Google Ads Conversion Importer you need access to the following products Activate Google Ads Account automatic tag marking Google Ads’ automatic tag marking is the basis on which Matomo’s goal completions are passed on to Google Ads. This must be activated in the Google…
In BigQuery, automatic data transfer is available for Google Merchant Center data. Unfortunately, this service has the problem that this connector has not been adapted for the Conent API for Shopping v2.1. Thus, the dataset generated there is incomplete and usable only to a limited extent. This article shows how…
For shop operators it is interesting where the user adds his products to the shopping cart. Does this happen on the search results page, in a category or in the classic product detail? With good Google Analytics 4 (GA4) data and BigQuery connectivity, this is easy to determine. Requirements Code…
