The Seotistics newsletter is written by Marco Giordano, a Data/Web Analyst with the goal of combining business and web data. Tired of the usual boring Analytics content without any business impact? Seotistics teaches you how to use Analytics, web data and even content in your workflow while helping you with Strategy.
Share
Portfolio Projects for Web Analytics
Published 4 months agoΒ β’Β 6 min read
β
Use Data Or Be Used By Data!
The December 22 issue of Seotistics is here for you!
Cool, you have learned GA4, GSC and GTM but still got nothing to show, it's normal.
I will show you some cool projects or ideas to differentiate yourself.
If you think taking a course on GA4 is enough to get you money... try again, the market is saturated.
P.S. Holidays time, I will expand on this issue in January!
Please move this email to your Primary inbox or reply to it. This is to prevent Seotistics goes into spam by accident. Gmail users can read this tutorial to do it.
Tools like Screaming Frog or Sitebulb help you with technical details like status codes, although you could also do it yourself with Python or Javascript.
Log files are NOT beginner friendly and it's hard to get your hand on them but if you already work somewhere, use them!
You can do some nice analyses and the topic isn't that popular as you think.
Data Warehouses & Modeling
This is the current meta and how to run any successful project.
You can't use outdated tools and expect to strive for optimal data work.
BigQuery is our preferred choice because you have the direct exports from GA4 and GSC (and it's much easier than the alternatives).
Understanding the BigQuery interface and basic Google Cloud stuff like authentication is OK.
Once you are familiar with them, you may need to learn some data modeling (article coming out in January).
βGA4Dataform is my go-to because it's free and super simple but we are here to learn so you need to do it manually!
Some clicks and you have some ready to go tables!
An analysts is NOT tasked with engineering tasks unless you want to go into a super technical path.
In practice being an engineer or having enough skills to temporarily survive without them.
For small projects, you don't even need engineers, if you ask me.
DataViz
The most important part of Analytics is communicating with others and most often, you will craft nice visuals.
If you need a shortcut for your portfolio, this is it!
This similarity matrix is one example and it can elicit action π More here.
In reality, most of the visuals that are useful are simple and not complex at all.
If you need something interactive and with multiple filters, it's time to consider Looker Studio or a custom web app.
LS is super easy to learn and you can just toy with it, really. Google did a great job in the last year to add new features.
I don't recommend tools like PowerBI and Tableau because:
not the #1 choice for Web Data
Hard to build something with them as a beginner
no one really cares in Marketing
PowerBI still gives me nightmares, avoid it.
Web apps were quite complex for me in the past but now with AI you can build local samples quickly.
Mind you, if you need to deploy it, then it's not that simple.
Javascript (d3.js) is the real GOAT of visualization. β Again, you can start simple with Python and a library like Plotly.
Oh Wait, LLMs Exist?
As discussed in my past issue, LLMs are a huge help and you shouldn't sleep on them.
It's true that you need some foundations but most of my marketing friends have been using them with 0 background.
Yes, I say that again, people with ZERO background in data. None.
If you have the expertise in your field but lack technical skills, you live in the best era.
Yes but you still need to develop the capacity to think like an analyst, uh:
The Seotistics newsletter is written by Marco Giordano, a Data/Web Analyst with the goal of combining business and web data. Tired of the usual boring Analytics content without any business impact? Seotistics teaches you how to use Analytics, web data and even content in your workflow while helping you with Strategy.
Read more from Seotistics - Web Analytics + Business + Strategy
Use Data Or Be Used By Data! The April 13 issue of Seotistics is here for you! Data modeling is a big deal and yet, you often see it discussed as a marginal topic. Do you know how many companies are using outdated practices and paying the consequences? This issue is a short introduction to a topic that I will dissect in my new course and future content (also check my past article in the resources). P.S. The Seotistics Sales end up tomorrow night, be quick π Please move this email to your...
Use Data Or Be Used By Data! The April 7 issue of Seotistics is here for you! The other time we talked about Claude Code... and now it's time for part 2! We will cover business context and those juicy leaks from last week. I still need some time to figure it out but hey, get this preview! P.S. Won't link the actual leaks for clear legal reasons π Please move this email to your Primary inbox or reply to it. This is to prevent Seotistics goes into spam by accident. Gmail users can read this...
Use Data Or Be Used By Data! The March 30 issue of Seotistics is here for you! Claude Code is the absolute GOAT and today I will show you how to actually use it. Or well, what you need to start and avoid writing random prompts. If you are half-serious about Web Analytics, you can NOT skip Claude Code. AI is the divider: forget about learning GA4/GTM and call it a day. This issue will introduce you to the key concepts that we will cover deeply in the upcoming weeks. Please move this email to...
