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 6 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 June 22 issue of Seotistics is here for you! LLM/AI measurement is on the mouth of everyone... but is it actually possible? I don't want to give you the secret to all problems because it doesn't exist. In fact I will show you why most of this is not as easy as you imagine. This is just an intro for the next content. P.S. I will also write a longform article on the topic, this is just the starter. Please move this email to your Primary inbox or reply to it....
Use Data Or Be Used By Data! The June 16 issue of Seotistics is here for you! The more I work in Web, the more I realize the shift that is happening is more real. SEO, PPC, Social media, you name it, it's just a different game now. Yet, people wage their marketing campaigns with outdated tools and tactics. It's always fun to come back to old problems with new perspectives and tools! Please move this email to your Primary inbox or reply to it. This is to prevent Seotistics goes into spam by...
Use Data Or Be Used By Data! The June 8 issue of Seotistics is here for you! After one of my best weeks in terms of Web Analytics events, I am here to share what we learned. From Wednesday to Saturday I attended 4 different events in Copenhagen organited by the Brand Leadership Community. Naturally I must inform my readers about what I learned and what's going on in Web Analytics! Please move this email to your Primary inbox or reply to it. This is to prevent Seotistics goes into spam by...
