What do I need to build my very own URL Shortening Service for clean Social Media links using a WordPress backend? (I would like to jump straight to the point of “building”. Therefore, I suggest readers looking for the Why…
This is how you redirect a subdomain that is hosted on Strato to a third-party service. The DNS configuration of subdomains at Strato is not very well described in the documentation of the web hoster. Therefore, here you will learn…
Google changed the Google Ads Interface – again. This is how you return to the old interface. If you recently logged into Google Ads and muttered “What the hell!” to yourself, you’re not alone. Google has relaunched the Google Ads…
This is how Scraping / Crawling of Single Page Applications (SPAs) works – quick and easy. Challenges of Single Page Applications Single page applications (SPAs) are a particular challenge in the field of web scraping. They are mostly written in…
Keep an eye on these URL parameters when analyzing and debugging Google Analytics 4 HTTP Requests. As a follow up on the latest GA4 Tracking testing without tools article this is article goes more into depth concerning what parameters to…
You want to import Klaviyo reports and metrics automaticylly via Power Query into your Dashboards and Workbooks? With this guide / code, you can import metrics via Power Query into Power Bi or Excel via the Klaviyo API and use…
This is how you get the numbers from your Klaviyo account into your Power Bi and Excel reports via the API. In this short tutorial you will learn how to get Klaviyo metrics into your Power Bi or Excel dashboards…
The Web.Headers() function is my latest discovery in the Power Query (Excel or Power Bi) ecosystem, but it unfortunately comes with too many limitations! Query web data via Power Query / Power Bi incl. HTTP response headers In the era…
This is how you connect a Sharepoint folder to your Excel files so you can combine multiple files for your reports. Microsoft Sharepoints (via Sites and Teams) can now be used as a kind of small-time DWH (Data Warehouse). To…
Converting a Freshdesk API Key so it gets accepted for authentication purposes. Challenge: Freshdesk API Authentication If you want to pull reports from Freshdesk or modify tickets remotely, the best way to do this is via Freshdesk API. The interface…
Efficient Data Collection and Optimal Tag Management: An Exploration of the Benefits of Server Side Tag Management in conjunction with Google Tag Manager and Google Analytics. What is the Difference Between Server Side Tag Management and Client Side Tag Management?…