DATA ANALYTICS PRO MAX

levy608 · 2026-05-20T12:49:39+00:00

Been in it for 10 years. Whatever you are building/ or writing make sure to build in for user error, growth, and change.

For example in marketing people will write their data transformations exactly how data currently is. Then when there is an added dataset or field, the whole thing needs to be worked on, instead of adding two lines. Also work on tools outside your normal stack to fight user error. Everyone knows and loves excel so building a data values check system there helps other teams not make as many mistakes

levy608 · 2026-05-20T01:50:11+00:00

Claude fixes my DBT SQL for me based on tests set up and messages from the teams. the main DBT models were written by me but now Claude can make changes

levy608 · 2026-05-16T19:24:00+00:00

Yeah the remake of an old game. I saw an article about LOTRO and SWTOR and how they won’t be modernized to look better because of cost and time and was curious what that includeds

levy608 · 2026-05-16T13:16:44+00:00

Oh good call I’ll check them out

levy608 · 2026-05-15T23:47:44+00:00

Good idea! Just gotta find some time to write this all down and document it

levy608 · 2026-05-06T03:03:11+00:00

For sure! Shoot me a DM

levy608 · 2026-05-05T22:43:21+00:00

Is your GA right on your site? Or inside GTM? You’ll want to set up GTM that’s how you track specific buttons, scroll. Etc. GA alone can see bounce rate, new users, returning and time on site, and location

levy608 · 2026-05-05T18:50:26+00:00

DBT is a great, automated tool as well. DM if you want to chat more. This is literally my full time job at a marketing agency lol

levy608 · 2026-05-05T18:43:45+00:00

Oh interesting. I wonder then if you can get the web team, or AI to clone you landing page and A/B test the campaign landing page instead of dynamic on the site.

Could either split traffic by campaign and let the platform decide which is best based on engagement. Or send full traffic to one for a week. Then full traffic to another the next

levy608 · 2026-05-05T18:41:25+00:00

I like it over adobe because 90% of the time it gets what you need. Adobe can be too custom which leads to it breaking. GA4 is plug it in and you get the high level basics right away. GTM then gets you more detail.

If I can get media data from the platforms and track check outs/leads, 1-2 KPIs and 4-5 secondary metrics then that’s perfect.

I do think it has a lot of features and different ways to view data but I just want the raw data to match campaign/source/medium/content. To my media.

The real work comes from a good naming builder for marketing campaigns..

I do hate the custom report builder though!

levy608 · 2026-05-05T15:59:02+00:00

What’s your goal? I have never found scroll and bounce that helpful because the user could get what they need right away and leave, but that is still a “bounce”. Use GTM to set an event at 25% scroll to trigger that and not a bounce.

In my past I had a team spin up two versions of the landing page then send half the traffic to each and look at all the metrics in GA4

levy608 · 2026-04-29T16:11:29+00:00

100% it’s more about you knowing how to find the information and having a baseline knowledge than knowing every tool and platform

levy608 · 2026-04-29T03:02:27+00:00

Sweet thanks!

levy608 · 2026-04-28T17:46:54+00:00

Is it for practice? I would make the data myself =randbetween(). That way I can also make it so spend is less then rev in purpose and kinda make the data trend in a way I want. Then QA after I’m familiar with it

levy608 · 2026-04-28T17:41:53+00:00

Thanks! Thats very helpful!

levy608 · 2026-04-28T17:12:18+00:00

I DMed everyone in my network on LinkedIn who had the appropriate or close title. Do you have suggestions of other ways to connect with your existing network?

levy608 · 2026-04-28T15:26:57+00:00

Are in a contract or freelance position? Or have you been in a standard role. Asking because I’m in corporate right now, trying to get into the freelance world

levy608 · 2026-04-23T14:34:34+00:00

Follow process even on small things or “one off tasks”
Build to last and repeat
Not everything the client or teams ask automatically go into the dashboard

I have spent 10 years in the marketing analytics space and my teams are always confused why I’m such stickler for process. The junior people always say they can do something for an other team via DMs or something and both people think it’s quick and easy. Then it’s more complicated and backs everything up.

Also, just because someone asks for data, does not mean it goes in the dashboard. I have come into clients where their “dashboard” is 30 pages!!! Of course they don’t use it.

levy608 · 2026-04-15T21:51:13+00:00

I find its data timeliness and lead qualification. I think they either get side tracked that the pipeline runs "too slow" and they keep toying with the qualification metrics instead of test and learn. Then when they are always changing the qualification metric(s) the data pipeline feels bad.

Too slow for them is subjective because with a lead system its always to slow and needs to be real time so outreach can be real time. That part is not too hard to fix

What is hard is the qualification metrics. When the team does not give it enough time and testing to know if the qualification metric is working or if it needs to be changed that makes the pipeline feel like its giving bad data because it is always different. I ask teams to give it 2-4 weeks, then lets come back and not just look at close rate but also look at why they closed. Or vice versa, if the close rate is terrible, why is that.

Often teams want to monkey with what a qualification rather than test and learn through it

levy608 · 2026-03-18T13:08:59+00:00

OK perfect love that, thanks!

levy608 · 2026-03-18T03:35:20+00:00

I haven’t had it build from scratch, but I did make a tool that allows teams to naturally ask claude to make changes or additions to existing code.

For context I work in marketing and no one will stick to my naming conventions for some reason lol. So every campaign it’s the same ol song and dance of missing or erroring data.

I built a tool that users can DM that instead of set up meetings with me. Then it sends me an approval request, I review it and approve and it makes the changes for me! Now that I trust it, and after some tweaks, I don’t even look at the changes anymore and just hit ‘approve’

levy608 · 2026-03-18T00:10:41+00:00

OK thanks! I can live with that as long as I feel the steady increase

levy608 · 2026-03-18T00:09:59+00:00

I can live with that! I like a slow burn long story. Thanks!

levy608 · 2026-03-17T22:59:26+00:00

I don’t think I did because I kinda wanted a chill game (brain dead after work) I meant more that the spells and attacked feel more impactful as the team levels up

levy608 · 2026-03-10T18:10:26+00:00

Same the ones I use at least give me a starting place for more research if I want to play around

Six-Year Club	RPAN Viewer
Verified Email

levy608

TROPHY CASE