วีดีโอ

Great tutorial! I have spent hours trying to find the correct table. I'm connected to my MCC account. Do you know where google ads "Account Status" is stored? Like enabled, canceled, etc.? Or if you can see if an account is "Hidden"? Is this data not transfered to bigquery? That wouldn't make sense. Any help is appreciated.

Hi there i connected BQ with powerbi but that was two months ago and the data is starting to be exluded the first days how can i get this backfill of months before and when it updated the data every day don´t exclude historical data of google ads? please save me lol

So, if I want to look at year on year data in a Looker Studio chart, I'd have to just use INTERVAL -720 DAY in the command?

Amazing video, though if you remove low-performing keywords from the campaign, can you apply the updated version to the campaign directly? or we should give a list to marketers and then they modify through the account ?

Bless you bud. May Our Lord Cthulhu consume you last

Google tokens system is very bad!

A wonderful video which solve my problems perfectly ! Thank you !!

wonderful work. Keep Growing. Keep Sharing. 🙂

Hello, How i can send msg private for you? Tks

Campaign Basic Stats table does not have the Cost field. Do you have to specify to include that in the data transfer? I am trying to edit my data transfer and do not see the option.

I'm not convinced that partitioning over the event_timestamp is the right thing to do Since the timestamp changes for each batch of events sent to BigQuery, so your session id will identify a group of events sent at once, rather than a group of events in a single session. I think this might be sufficient, though it won't be unique so you'd still need to combine with user_pseudo_id: (SELECT value.int_value FROM UNNEST(event_params) WHERE key = 'ga_session_id' ) AS ga_session_id

Does this {_cmp} automatically track the name of the campaign? I did not understand. Is it dynamic, and will it change/match according to my campaign name?

Hello Roman, how u doing? First of all thanks for the series of videos, it really helped me understand how to use the ga4 table, but I still have one problem and wanna know if you can help me. I have some events that have the same timestamp and when I do the max() thing with the parameters I loose these events, for what I read these events are batched and are sent multiple at once, and by that they have the same timestamp, do you know any way of bypass this problem?

You're a hero bro! Everything I managed to find online on the topic is junk compared to this!

Thank you very much for your video

So the dataset created on the next day, right? Or dataset create immediately, but it was empty on the first day?

Hi friends I have a Google Ads Manager account, and I applied for basic access almost a month ago, but I still haven't received any response. Does anyone have an idea of how long it typically takes to get basic access?

How to get session source medium and session campaign level data from big query which matches add pannel

How to match the data of session source medium and session campaign level session data by date wise

Hey! Amazing content! You wrapped up everything. Thank you!

Wouldn't it be better to do the loop this way? // Queremos deixar apenas 1 anúncio ativo, o de maior CTR if (ad_array.length > 1) { // Verifica se há mais de 1 anúncio para processar for (var i = 0; i < ad_array.length - 1; i++) { // Itera até o penúltimo anúncio ad_array[i].pause(); // Pausa os anúncios exceto o último (de maior CTR) } } } }

Can you share the whole code please?

I've linked my Bigquery project to my GA4 but I only see pseduonymous_users table and not the events table. Any tip, please?

your source code on your github contains a config.json file. I don't recall that being mentioned in the video but it is necessary for __init__.py to work. Where did that file come from and what should be specified in it?

Ca: MutateError.UNSPECIFIED: Specified version 'v10' not supported. at getReportRowForDuring (Code:337:24) at getReportRowForDate (Code:326:10) at main (Code:91:17) please help me

Hey there! There was an update from Universal Analytics to G4 Google Analytics, is there a resource that you could point to that would help with connecting to their API?

Hi, thank u so much for your video. I am searching for google ads script lately and found your video, which so amazing. I have one question, is it possible to set the schedule google ads script so it is running every second to check the campaign performance? ^^

really good examples. Also great that you stick to same examples throughout the series

thank you a lot!

Hi, Can you please help what session source in GA4 is equivalent to what source in bigquery?

Is it possible to grab "Session Google Ads campaign_name" from table or its different from "Google Ads campaign_name" , I am confused as in GA4 reports it's shows "Session Google Ads campaign_name " , How we can grab google ad data at session level?

Fantastic series Roman - thank you for putting together this great tutorial series! The conversion tracking works like a charm - we have event_name = generate_lead. Quick question, I am trying to add a landing page field to the session table by using this - FIRST_VALUE(page_location) OVER (PARTITION BY ga_session_id ORDER BY event_ts) AS lp_page_location. Selecting from the event_aggregated table. But getting this error - "Syntax error: Expected end of input but got identifier "event_aggregated" at [1:1]". what will fix this.

thank you man, you're a hero!!!

Hi, this is a nice series, I have one query: Do you think BigQuery is helpful to fetch UA property data to GA4 property? In UA analytics, we had old data, so can we import all history to the new GA4 property?

Thanks for sharing this info. Super practical and helpful.

thanks, veryuseful tips)

Hey, I have a table and I have events in that. I am trying to connect them to my PowerBI from Big query and somehow it is not popping up in my PowerBI, Do you have any idea why ?

Hi Thanks so much. Is there any way to backfill the GA4 data in Big query? I need to backfill the raw data that is exported everyday into big query. Thanks

Unfortunately this add on does not work anymore, do you have any other alternative ?

Hi Roman, that's an awesome playlist, thank you! For some reason I get totally different event count in GA4 vs following your query. Not sure what exactly is going on here - I have tried multiple ways to count events, but the disparity to Google Analytics 4 interface in the default unsampled report remains huge :( Is there any advice you can share please? Thank you!

This content is amazing! Tks guy!

I've been trying to create custom queries from the google_ads data that schedule daily and append to a table. Was also wondering if the table could be exported to a google sheet where each appended data/update reflects in the google sheet.

in UA we do have hits.number schema the same i want it for GA4..?

I love these videos, its exactly what I needed!

Роман, Огромное Спасибо за интересную и профессиональную информацию! Такую информацию, действительно, очень сложно найти.

Great, you saved my day, this video is like a summary of 20 websites I had to look through

Hi Marketing Watch House, I am trying to find keyword performance for my campaigns. Since I do not have a Google Ads account, I created an empty one to transfer these tables and then create fake data to recreate the tables. I am not sure what field do I need to use to find out the keyword performance (let's say revenue or clicks) for a specific campaign. Any help would be appreciated.

Awesome Video!!

Thanks for the video! Do you have any recommendations on how to use Python for lead generation? That aren’t as complicated as the Google ads API

I am a bit confused on how you created a new col called ga_session_id that basically duplicated the session ids? Sorry if this question sounds stupid