The GA4 BQ export. Though a great source of unsampled, event-level data, can be complex and confusing. Traffic source data appears in 4 different places. - traffic_source - session_traffic_source_last_click - collected_traffic_source - event_params adswerve.com/technical-insi…

Do you remember when you joined X? I do! #MyXAnniversary

Success at work is measured in impact, not activity, not survival. If you work for a manager (or in a culture) that doesn’t realize this and is forcing you to focus on activity or survival, that’s the clearest sign you need to get out.

Coming back home with 6 points. #LGI | Dime Community Bank

In the present, it is very understandable why we would want to save energy, move quickly, and not think too much. In the future, is is very hard to understand why we didn't spend more energy, why we didn't move a little slower, and why we didn't think a little more.

Experience is not the best teacher. It is the latest teacher instead of the earliest, and the narrowest teacher instead of the broadest. You can learn earlier and more broadly by seeking comprehension. Then, you will actually understand the experiences you have.

Congratulations!

🤖 Here is how you can track AI traffic in GA4 BigQuery. 👇 Calculate the values of the 'Traffic Source' column by extracting the values from the 'traffic_source. source' field where 'traffic_source.source' matches the following JavaScript regex that uses the RE2 syntax:

🚀 🤓 If you don't wish to struggle with calculating any metric based on engagement like 'engaged users' in GA4 BigQuery, you need a good understanding of  'engagement_time_msec'. 👇 User engagement refers to the time a user actively spends interacting with your website or app.

🚀 🤖 5 Simple Steps to Track UTM Parameters in GA4 BigQuery. 👇 Step-1: Calculate the values of the 'Campaign Name' column by extracting the values from the 'collected_traffic_source. manual_campaign_name' top level field. Exclude the values where 'Campaign Name' is 'null',

🤯 🧨 💥 Learn traffic attribution in GA4 BigQuery within 2 minutes. 👇 ‘event_params.source’, ‘event_params.medium’ and ‘event_params.campaign’ fields (let's call them 'traffic fields') represent last-touch attribution at the event level. These traffic fields do not

📢 GA4 News: Google is removing the 'Key events' report (under 'Data Display') in the GA4 property and is updating the 'Events' report so that it also reports on key events. The 'Key events' report is retiring. There is also a new report rolling out called 'Network settings'. If

☠️ 💀 Direct traffic in GA4 reports is not a reliable indicator of branded traffic. Whenever GA4 is not able to determine the origin of the traffic source, it reports that traffic as direct traffic. 👇 Whenever a referrer is not passed or is dropped because of technical

The 2-step secret to career success and happiness: 1. Get good at selling...don't be bad. 2. Work somewhere that selling is easy...don't work somewhere selling is hard. 90% of the people I meet are both bad at selling and they're working somewhere selling is hard.

Don't ever call a meeting "expensive," and don't let anyone else call it that, either. Meetings are investments, not expenses. A great investment should never be saddled with the label of "expensive," and nobody should be trying to cost-optimize meetings and dialogue. It's fair

📢 Cross-channel budgeting (still in alpha) in GA4 is a limited release feature. It is only available to selected users for testing and feedback and is not yet part of the standard GA4 offering. 👇 In other words, it is not rolling out, but if the testing goes well and Google

This turned into a short thread about how the leader’s brain works differently than other brains. I think you might find it helpful to give this a quick read. Would love to hear your thoughts.

There’s a great way of saying almost anything. The great way gets you better results than the blunt way. Better results than the accommodating way. Better results than the accusatory way. Better results than the deferential way. And definitely better results than not saying it.

Every single thing I share is designed to help every single person who reads it. You are guaranteed to get better results if you consider and implement these ideas. I hope this is self evident, and I hope you have found this to be the case.

You may be too late to create and sell workflow automations. But that's the good news because you are just in time to create a knowledge base (KB). The chart below was developed by chatgpt based on its own research data. Anyone with minimal tech skills (or even none) can now