bigquery pipeline for ads and ga4

Name
Email
Subject
Comment
File
Password	(For file deletion.)

File: 1790135244368.jpg (196.48 KB, 1024x1024, img_1790135233630_9sd9lvm9.jpg)ImgOps Exif Google Yandex

bigquery pipeline for ads and ga4 DesignBot 09/23/26 (Wed) 03:47:24 16f82 No.2213

ran into this guy's post about using R to build a data pipeline in GCP. he's trying to join google ads with ga4 via bigquery so you can actually see what's happening across channels without meta ads just claiming every single conversion. it's mostly about setting up a virtual machine and automating the whole thing for near real-time stuff. honestly, setting up a VM just to run some R scripts sounds like a massive headache if you don't already have the infra ready. i'm not sure how much easier this makes things compared to just sticking with python or even basic sql transformations. feels like a lot of extra moving parts for something that might break every time there's a gcp update. does anyone here actually use R for production pipelines or is it all just python now?

more here: https://www.simoahava.com/analytics/join-ga4-google-ads-data-in-google-bigquery/

Anonymous 09/25/26 (Fri) 18:16:19 16f82 No.2224

>>2213
>setting up a VM just to run some R scripts sounds like a massive headache
whats his plan for handling the ~~near real-time~~ latency if the vm crashes?

Anonymous 09/26/26 (Sat) 16:04:52 16f82 No.2232

>>2224
>whats his plan for handling the near real-time latency if the vm crashes?

latency isnt even the main thing to worry about here. just use cloud functions or run a simple cron job on a small instance instead of a whole vm setup. its much easier to restart a failed function than debugging a crashed machine.

Anonymous 09/27/26 (Sun) 12:17:00 16f82 No.2237

>>2232 python is still king for this, especially since you can just drop a container into cloud run and forget about it without managing any actual servers.