From Google Sheets to BigQuery: A Simple Data Transfer Approach
Spreadsheets will never die. And as a data analyst or analytics engineer, you should know how to move data…
Artisma
Artisma
Creating Google Ads Data Transfer in BigQuery
Google Ads offers a vast amount of data, but efficiently managing and analyzing this data can be challenging. BigQuery…
Manual Server-Side GTM Deployment on Google Cloud Run in Less Than 30 Minutes
When choosing a deployment method, there are multiple options, each with its benefits and challenges. For example: For my…
Server-side GTM Q&A – common sense version
Are you considering deploying server-side Google Tag Manager (sGTM) and looking for useful information? Many people still have misconceptions…
sGTM Tip: Consolidate Tags Like a Pro Using Lookup Tables
Sometimes, you find a client-side GTM (cGTM) container with multiple conversion tags with similar configurations, like three purchase Google…
Facebook Conversion API: Or How I Wrote Our Own Tag
Marketing on Facebook remains a widespread method for acquiring customers. Our clients have long used Facebook Pixel — a…
BigQuery Tip – Updating Data in Sharded Tables
If you work with sharded tables like GA4 export to BigQuery, you may encounter a situation where raw or…