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 10 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 October 19 issue of Seotistics is here for you! I am just back from Rome and AI didn't sleep, we are full of news and updates. As you know if you are working with automation, you need to know this stuff! As I try to recover from multiple conferences in a row, here is the latest summary of what's going on. Most of these topics will be expanded in the next issues as they are too new π Please move this email to your Primary inbox or reply to it. This is to...
Use Data Or Be Used By Data! The October 12 issue of Seotistics is here for you! Measurement did change in the last year and I am here to remind you some basic facts. AI is for sure one of the main culprits but not the only one. I am also writing a huge article on LLM measurement, stay tuned π Hectic week, too much to do, including course updates. 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 October 5 issue of Seotistics is here for you! The last time we saw some nice workflows you can use in real time for your small website. Well, I show you what else you can do and the latest news in the Web Analytics world :3 Nowadays you can have a better Analytics stack than your competitors just with common sense. There are big changes coming ahead and 2027 will be THE year. P.S. Go check my previous issues if needed, this is a sequel. Please move this email...
