2 years ago, I was thrown into Commanders Act and Javascript tracking. I remember staring at the screen, wondering if I’d ever get the tags to fire correctly. 🫣 Now, I set up tags like muscle memory. It’s wild how much you can learn when you’re dropped in the deep end.

To those in mobile analytics :

Have you ever run 2 mobile analytics SDKs in parallel (e.g., GA4 + another analytics tool)? Curious if it helped or caused more trouble: performance hits, data overlap, or maintenance headaches? Worth it, or a lesson learned? Would love to hear your experiences!

I remember when you could just buy a computer program like Microsoft Word or Photoshop and just have it on your computer forever without having to pay monthly or yearly. What a time that was

Trying to connect lines to shapes in Looker Studio feels impossible lately. The lines keep moving around, and it’s so frustrating to get them to stay where they’re supposed to. 😖

First time working on dynamic data visualizations in Python with Visual Studio. It’s fun, but managing interactivity without slowing down performance is a tricky challenge! 🫥

Team asked for a quick data pull. I said, “Sure, just 5 minutes.”

3 hours later, I’m knee-deep in SQL joins, questioning the meaning of life, only to realize… they gave me the wrong dataset to start with.

Data analysis: where “quick” is always a lie.

Working with IT teams as a Data Analyst in an agile setup feels like running a relay race where we forgot to agree on the handoff. They work in sprints, we deal with constant changes. The trick? Meeting halfway; planning ahead while staying flexible for when the data world surprises us.

Data taught me one thing: silence speaks volumes. It’s not always about what’s in the numbers>it’s about what’s missing. The question no one asked, the metric no one tracked. The best insights come when you lean into the gaps and ask, ‘What aren’t we seeing?’

Once converted, you can also break event_timestamp into HH:MM:SS manually for precise control. This splits event_timestamp (in sec) into HH, MM, and SS using simple math:
1. Divide by 3600 for total hours.

Here’s a something you need to know: In GA4 BigQuery exports, event_timestamp is in microseconds, but many tools expect milliseconds. Always divide by 1000 or use TIMESTAMP_MICROS(event_timestamp) to avoid time discrepancies in your analysis.

Looker Studio’s been having a rough time lately: bugs, slow loading, and fixes that take ages. Support responds, but their process feels like going in circles, not as smooth as other tools. They really need to step up and make things work better.

Essential BigQuery SQL Tips for GA4 Analysis medium.com/@maissa-boun...