Organic Growth Marketing

Growth Advisor

Sketch Artist/Drafter

Ten Speed

- 3x'd brand growth in <12 months using an integrated content strategy
- Produced and grew a podcast from ~ 70 downloads/month to 800/month in 12 months (11X)
- Responsible for Leads (Nurture potential) and MQLs (Conversion potential)
- Responsible for marketing strategy, services marketing and website messaging, paid social, organic social, SEO and blog creation/distribution, case study creation, newsletter creation, co-marketing, podcast production and co-hosting, guest outreach/appearances

Marketing Manager

- In charge of 8 - 10 accounts at any given time
- Average account growth across all owned accounts of 166% (range of pre-seed to series D clients)
- Owning SaaS content strategy creation and pitching, creating an integrated plan to ensure SEO worked across all marketing channels for enhanced distribution, repurposing, and increased influenced conversions from content, identified technical website health, created briefs for writers, and handled administrative communication + retention efforts by acting as the main POC for accounts

SEO Content Strategist

phenomenon

Sr. SEO Manager

Marketing Supply Company

SEO Content Manager (acquired by phenomenon)

Green Gardens Community Farm

-Developed content based on SEO strategies to increase engagement and amplification via comments, shares, saves and reach for social media (Facebook/Instagram). Since beginning in October, amplification and comments have increased by 200% per post.
-Creation and management of marketing calendar to keep sales and management teams aligned and accountable to campaign dates.
-Strategic goal setting to ensure content has a channel and purpose.
-On-page SEO for greengardensfarm.com
   -Google Search Console, Ubersuggest, Google Analytics to evaluate strength of links, SEO keyword research. After one month of technical fixes and backlink reconnects, traffic to the site has risen from 1,000/mo to 4,000/mo.


As a Freelancer for the past 6 months I have taken part in several content creation projects:

-Website Design/SEO - Squarespace and Unbounce
-Videography - EXP Reality/Food Bank of Southwest Michigan and Join The Fight/Custer's Last Stand
-Photography/Social Copy - Green Gardens Community Farm - Instagram/Facebook
-Ebook - 5 Questions to Determine if the Green Box is Right For You - Green Box Program
-Podcast - Green Gardens Community Farm - On the Farm

Social Media and Content Marketing Manager

-Manage small teams of 4-6 crew members (includes assignments, weekly goal setting, logistics, and quality standards)
-Developed yearly succession plans including calendar/excel sheets for 45 vegetable crops
-Identify and treat pest and disease pressures using university researched Integrated Pest Management recommendations for organic farming practices.
-Implement content marketing strategies for all social media channels (Instagram/Facebook)
-Design and Edit using SEO on company website (Squarespace) and landing pages (Unbounce) to perform A/B testing and drive new leads through the customer acquisition funnel for our Green Box program

Field Operations Manager

Newaygo County RESA

-Mentored and coached students 15 to 19 years of age to increase critical reflection and patterned critical thinking skills (Soft-skills development)
-Lead E-mail communications with families, students, and faculty.
-Developed curriculum for career exploration, community service, and soft-skllls training
-Managed and reported data of student progress and community service hours to stakeholders
-Developed marketing materials using Canva, Microsoft Office, and Adobe tools (Graduation Event Invitation/College and Career Night Out Postcards)

Training: 

-Cognitive Coaching Part I: Days 1-4
-Growth Mindset training and practice
-Youth Mental Health training

Early College Services Specialist

Newaygo County College Access Network

-Wrote and managed grant materials (Drafts, layout, budget documents, images, dataset presentation, calendar) for 3 grants worth more than $250,000
-Functioned as the face of WE CAN! Newaygo County at countywide and statewide college access conferences (MCAN Conference, Fremont Career and College Night Out, 5 school district specific events)
-Collected, organized, and presented data on college access for Newaygo County from the Michigan State University College Advising Corps., Michigan College Access Network, and the American Community Survey
-Created, refined and documented processes and systems for improved sustainability of institutional knowledge
-Organized/Coordinated College and Career Night Out event (20 volunteers, 48 college and university representatives, 5 college access speaking professionals, and 400+ families)

Network Assistant

Michigan State University

-Conducted research using organic compounds and their effectiveness for use as herbicides in certified organic farming
-Designed and systematized research experiments
-Recorded and maintaining data
-Analyzed other university research to aid in future experimentation design and effectiveness.
-Maintained horticultural demands of crops (seeding, transplanting, watering, fertilizing, pruning)

Training:
-Radioactive Materials Management and Handling training course from Michigan State University

Lab and Greenhouse Research Assistant

-Consulted one-on-one with students/families about post-secondary planning and options with more than 1,100 students advised in two years
-Created a college-access curriculum and calendar for freshmen, sophomore, junior, and senior students
-Served as a member of the Affordability Action Team designed to create and implement strategies to reduce the financial barriers associated with attending college and receiving career training
-Served as a member of the Hesperia High School Scholarship Committee
-Coordinated statewide event and initiatives (College Application Week, FAFSA Completion weekly meetings, and Decision Day Celebration)

College Adviser (AmeriCorps)

-Attained chauffeur's license to Drive the catering delivery truck
-Served as an individual server in various environments including suite service at hockey, basketball, and football events (MSU athletics), wedding receptions, and wine and cheese expositions

Banquet Server

Clean Water Action

-Managed college-aged staff in groups of 5-7 (fundraising communication techniques, on-site training, route placement, and daily performance reviews)
-Collected community data from door to door interviews and letter writing campaigns
-Counted and Confirmed monetary donations
-Practiced Door-to-door canvasing and fundraising techniques (average 100 doors/day)
-Disseminated communication between the Director and canvassers

Field Manager

Hands-on Marketing and Content Leader - A content optimization specialist turned generalist, there isn't a type of content I haven't experimented with

A creative trained in the technical world, I began my marketing career as an SEO Specialist studying algorithms and driving up organic traffic. In short order, I worked my way up through several agency promotions to be an SEO content strategist.

As the main point of contact, serving 10 to 15 SaaS companies at any given time, my interests expanded from algorithms and content to integrated content strategies, newsletters, CRO, and social (which is probably how you found my profile). This evolution of my career trajectory was a natural process as a result of 2 questions.

1. How do I offer consultative advice for marketing strategies and tactics that support the companies I work for beyond offering SEO services?

2. How do I become a Director of Content, a Growth Marketing Director, or a CMO one day?

My solution: I moved horizontally into a Marketing Manager role where I can play an active part in paid, social, email, optimized content, case studies, partnership discussions, podcasting, branding and design decisions, and work cross-functionally with a sales teams.

Cheers to continued success and a never-ending journey of learning. And let me know if I can ever be of help to you and your team!

Derek Flint

Sika

- Producing business use cases for customer/marketing data
- Data Governance
- Data Modeling 
- Documenting processes

Data Analyst

- Web/SEO reporting and data analysis for the entire company
- Monitoring International SEO
- Creating a data system to store and report on Web/SEO data
- Data Governance 
- Keyword Research 
- Creation of SEO trainings

SEO Specialist & Web Analyst

Seotistics

- Turning web data into business value
- Creating robust processes and operations for your website
- Auditing and managing Content
- Using BigQuery, GA4 & GSC to craft actual use cases

Web Analyst Consultant

- SEO Content Strategy to drive Traffic for Displays Ads or Lead Generation
- Content Distribution and Repurposing to get the most out of your budget
- Helped an emerging entrepreneur to monetize their website via Lead Generation
- Data Analysis in Python/R to get insights on traffic and ads performance
- Increased clicks by ~15 times and CTR more than doubled (6 months) for 2 publishers

Freelance SEO Specialist & Analyst

Cesmed - Centro Studi del Mediterraneo 

I practiced with Joomla CMS and Excel and started to improve my knowledge in the sector

Search Engine Optimization Specialist

I am a Data/Web Analyst and turn data into actions, optimize processes and document best practices. 

My professional background in SEO, Marketing and Content helps a lot when using data and building processes. 

If you feel lost with your web data and want a solid action plan, contact me now!

Marco Giordano

My advice for those who want to learn GA4... is don't learn it! 

Or well, learn GA4 from its BigQuery schema like I did, because the UI is unusable for serious projects.

If you want to actually help your clients, you need to provide the best solution for the long term.

The UI (but also the API) is absolutely unable to scale: 

❌ Sampling, limits (quota limits, retention, cardinality, this and that)
❌ Actually having to use the tool lol
❌ Educating people to use the tool (good luck)
❌ Excessive discrepancies and too many details 

If you are an engineer, you don't even need to read this... you already know an interface isn't solid and scalable. 

The BigQuery export gives you the rawest data, aka you have full control over what you do with it.

(It also gives you mastery over the data, how metrics are calculated and what is what). 

But many marketers fixate with shortcuts and nice interfaces and lose in the long term.

So my advice is not to be discouraged by the bad talk online and just do it. 💪

There are many tools that can help you:

✅ A load of free resources online (including mine)
✅ LLMs like Claude doing the work for you. Even GA4SQL, nice website! 
✅ GA4Dataform making that mess of a schema usable with 3 clicks

Then, you can create whatever you want as always with Looker Studio or even Sheets. 

So, I ask you again, is it necessary to waste time on GA4 reports? (Spoiler: no.)

Just learn how to configure it properly and understand the key settings.  

📥 If you want to learn more about Web Analytics, subscribe to my newsletter in bio!

Data/Web Analyst | GA4, GSC, SEO, Content | BigQuery, Python, R, SQL

Competitive analysis is much more than opening a tool and exporting CSVs.  
  
Here I compare different domains to see how many keywords they share.  
  
I've taken my keywords in BigQuery (GSC) as a starting point to check the SERPs with DataForSEO.  
  
You can use this matrix to:  
  
↳ Actually understand who is a competitor of yours  
↳ Which competitors are similar to each other  
↳ Understand where to focus  
  
Once we have some more data (and less influencer hype), we could even assess similarity for AI Mode.  
  
❗️For the "top" keywords I don't rank since most of my traffic is branded/Direct/Social/Email but this helps me a lot to identify gaps for all the channels.  
  
P.S. Guess which domain is the outlier and explain why it's featured in the table 😂  
  
I will publish an article about SERP Clustering too this week (and much more), stay tuned.  
  
📥 If you want to learn more about Web Analytics, subscribe to my newsletter in bio!

Always check the clicks distribution of your website!  
  
🤔 How many pages are getting clicks and which ones?  
  
The normal SEO advice is to focus all of your attention on the best pages…  
  
or to find opportunity pages.  
  
This advice is good actually but it needs context.  
  
💡If you have a lot of templated pages, you can go the other way and apply changes at scale.  
  
The weight of Tech SEO may not be much for small websites but it stacks for bigger websites!  
  
Tiny changes aren’t tiny anymore if applied in bulk.  
  
The example below is a medium-sized website and it gets 12% of the total clicks from the top 1% pages by clicks (all non-branded).  
  
It’s quite diversified in terms of organic traffic if you think about it… the other 88% is given by the 99% “worst” pages.  
  
I know, talking about percentages may make your head spin but think about it…  
  
Is everything 80/20 as they say?  
  
Nope, you have to analyze case by case, although you will often deal with skewed data, that is true.  
  
P.S. The plot below takes the clicks by page (grouped data) and shows a rank on the x-axis, where 0 is the best rank (more clicks).  
  
🤔 Did you know of this method?  
  
📩 Want to learn more about Web Analytics? Subscribe to my newsletter in bio!

Single Page View, having all the data you need for a single page.  
  
Gather all of your useful data and merge it to create a single record for each page.  
  
This is essential for content auditing...  
  
and for advanced web analysis.  
  
You don’t want to look only at GSC data alone when deciding to do some pruning.  
  
GA4 data informs you about all the other channels to prevent you from making bad decisions.  
  
💡 As you may know, most of what you get in GSC by default isn’t super informative, you need to create your custom metrics.  
  
Once you figure them out, you can go wild and report more than clicks and impressions.  
  
Once again, content plans and CRMs add even more power to your analysis because you can add:  
  
👉 author  
👉 published date  
👉 last update  
👉 clusters/tags/categories/notes  
  
All of this is another way to label your pages easily… instead of measuring standard metrics.  
  
Any other data source is well appreciated if you can use it!  
  
The same goes for including dates or drilling down.  
  
In some cases, you may want to go deeper and see what happens by month.  
  
In the majority of cases, you'd only aggregate by page and set some conditions for pruning/optimizing:  
  
👉 below a certain performance threshold  
👉 by inlinks  
👉 by engagement  
👉 by $  
  
The possibilities are endless but what matters is the result!  
  
Fit this information into a process and you'll be much more efficient.  
  
P.S. You can also list all the queries a page ranks for in a single cell but that's a bad practice.  
  
📩 Want to learn more about Web Analytics? Subscribe to my newsletter in bio!

GA4 event data in BigQuery is hard to understand at first.  
  
Because it's actually a lot of tables and not just one, every day gets its own.  
  
Every row represents an event in the infamous events table.  
  
A parameter is additional info on an event.  
  
❗ The event_params column contains a lot of values inside it.  
  
It's an example of a nested and repeated schema.  
  
5 columns and just 1 row for all those parameters.  
  
It's like a small table within our bigger event table.  
  
The vast majority of website audits involve user interactions, so the events table is the MVP.  
  
🤔 The first_visit event has a parameter called page_location, namely where the event takes place.  
  
The URL is a string, so the value is under string_value and absent from the other 3 columns.  
  
ga_session number is an integer because it's a whole number. The other columns stay empty.  
  
You can do a lot with the events table:  
  
✅ Combine it with GSC to get additional page metrics  
  
✅ Sending your custom dimensions and properly classifying your pages  
  
✅ Explore how users navigate your pages  
  
✅ The good ol' analyses with Ecommerce data  
  
💡 The most effective exercise is grouping pages by performance or specific dimensions to give better advice.  
  
"Is this page among the top performers for revenue or is it only bringing traffic?"  
  
"What's the cluster it belongs to?"  
  
❗ Having custom dimensions to classify your pages is the best thing you can do so you'll get this data in BigQuery.  
  
This table has some perks:  
  
👉 it's as granular as it gets (good for accuracy)  
👉 you can define your attrib. models, metrics, you name it  
👉 you bypass GA4 quota limits, sampling and other limits  
  
GA4 data is shown in this pesky format for storage purposes but...  
  
good organizations will change the structure given by GA4 and create more tables out of it.  
  
It's honestly hard to write queries so engineers like to make it easier for us (hopefully).  
  
I don't want to get too technical, check my future posts!  
  
---  
  
So yeah, querying this event table requires you to:  
  
- stitch more tables together  
- unnest the event parameters  
- calculate pretty much a lot of metrics manually  
  
But there are "alternative" methods to make your life easier!  
  
📥 If you want to learn more about Web Analytics, subscribe to my newsletter in bio!

Seotistics Black Friday Sales are coming next week! 

Yes, this is the time of the year with the biggest discounts.

✅ Learn GA4, GSC and BigQuery
✅ Use battle-tested frameworks for Web and SEO data/analysis
✅ Get access to Python notebooks and SQL code 
✅ Dedicated 1:1 support and community access
✅ Integrate LLMs into your workflow to make your life easier 

Product updates coming soon too, stay tuned via my newsletter in bio 👀

You can prepare your wallets and check the link in the comments 🔗

It's the last day for the 40% discount on all my products. 

Use coupon code: BF2025. 

This is the best deal of 2025, take your chance now 👀

🔗 The link to buy is in the comments ⬇️

Analytics isn't (only) about data.  
  
It's also about:  
  
↳ decisions  
↳ business  
↳ speed  
  
The more you obsess over technical tools, the more you'll get punished.  
  
💡 LLMs are teaching us that and this is a great time to go beyond "tactics".  
  
Do whatever it takes to help decision makers make better choices.  
  
If you have a solid understanding of your industry, you'll have no problems to adapt.  
  
❗️Finally, you must be quick.  
  
Some decisions and projects can't wait forever.  
  
It's better to be wrong and pivot quickly rather than waiting for Godot (aka 100% accuracy).  
  
📥 If you want to learn more about Web Analytics, subscribe to my newsletter linked in my bio!

Classifying SEO Automation & Solutions With This Matrix.  
  
What should a business do?  
  
You can think in terms of complexity and business value.  
  
🙅‍♂️ A complex solution is hard to adopt and use in reality.  
  
Low business value is something you want to avoid even more.  
  
This means:  
  
👉 SEO Analysis because just analyzing GSC data adds a lot of value.  
  
You can find potential ideas, and what to optimize and it’s not even that expensive.  
  
Even if you have a lot of data, you can use BigQuery and do something.  
  
👉 SERP Clustering is one of the quickest ways to spot opportunities.  
  
I was able to find ideas and financial opportunities in just 10 minutes.  
  
Your keyword list should be good and you should perform some cleaning first but it’s super simple to implement.  
  
You don't even need to create your script, just pay for a tool!  
  
If you are big, you can consider working on your own tool.  
  
👉 Most of the stuff you see on social media falls under low complexity and low business value.  
  
A Python script alone doesn’t change your business or make you rich.  
  
The same goes for the AI Automation you see everywhere.  
  
A custom GPT alone isn’t that hard to reproduce and won’t make you stand out.  
  
👉 Overengineering is the other side of the spectrum.  
  
This is the worst you can buy!  
  
Super complex tools or solutions won’t benefit you if you can’t make them actionable.  
  
Always go for the simplest solution first.  
  
In reality, most of what is done in SEO can be solved easily.  
  
Actually, almost every industry suffers from the same issue...  
  
👉 Custom tools and good SEO Automation are what you need in the long term.  
  
You can’t base your entire strategy on quick wins because it’s not sustainable.  
  
💡 This is why you create tools to scale and automate processes.  
  
Do you really need to spend a week to build a report?  
  
Of course not, you’d be smart and use Google Cloud.  
  
In other cases you can simply have a Python script to help you save hours or even days.  
  
Automation can get complex quite easily at advanced levels but it’s where you also get more business value.  
  
If you consider all the time and cost savings, the numbers are astonishing.  
  
💡Go for the quick wins first and see if they can be replicated in different sections of a website.  
  
On an enterprise level, you can also think about regions and countries.  
  
Once you are mature enough, consider building custom tools or automation that benefits your business.  
  
Automating reporting via Google Cloud is one such example.  
  
All of this can be estimated in terms of ROI to assess their feasibility.  
  
P.S. The example here is inspired by the book written in the picture.  
  
📥 If you want to learn Web Analytics, subscribe to my newsletter in bio!

Cool, you now have your GA4 data in BigQuery but what about conversions (aka key events)?

😩 The GA4 export does NOT tell you which events are conversions.

So... how do we do?

Simple, we use the GA4 Admin API to pass this information 👀

✅ Then, you can flag which events are conversions or not, with a boolean column: true or false.

This is my favorite trick especially if you have multiple subdomains with their properties and with specific conversions.

In all the other cases, you can simply flag them manually once you report on them, no need for this.

That is, if you actually have a few conversions, as it should be! 

P.S. Ofc you'd need to do this in Dataform/DBT and make it a little bit more "elegant".

📥 If you want to learn Web Analytics, subscribe to my newsletter in bio!

LLMs like Claude help TREMENDOUSLY with coding, especially SQL and Python.

Don't limit yourself to "I am not a technical person", it's no longer an excuse.

It's not like you need to memorize code or lines.. forget about it.

✅ Use your brain for actually giving context into data.

As long as you don't do fatal mistakes, it's 100% fine to rely on LLMs. 

You are paid to provide value and give a meaning to data, LLMs don't do that.

💀 Or well, they do it but it's mid, LLMs are simply your tools. 

Let's be real, most of the requests we do are always the same.

Document the code and automate what's possible! 

💪 Prompting per is quite simple for 99% of the use cases we have...

but I still see common mistakes like being generic.

A few days ago I also showed you to use a simple method to have more accurate answers: using sample .md files. 

Yeah, it looks simple and easy but it works.

Don't be lazy and give it a try 👀

🧪 I tested a LOT and I proudly say Claude + Cursor are my daily bread. 

I never learned Javascript but it's so easy to create some quick web app now.

And don't even think I write 80 lines of SQL manually 😂 I use templates though! 

📥 If you want to learn Web Analytics, subscribe to my newsletter in bio!

taplio

The Battle

Derek Flint

Marco Giordano

Followers

Posts

Engagements

Likes

Performance ScoreMarco Giordano's LinkedIn Performance

Ready to grow your LinkedIn presence?

taplio

The Battle

Derek Flint

Marco Giordano

Followers

Posts

Engagements

Likes

Performance Score.css-goub6s{font-size:var(--chakra-fontSizes-md);font-weight:500;color:var(--chakra-colors-gray-600);display:block;margin-top:var(--chakra-space-1);}Marco Giordano's LinkedIn Performance

Ready to grow your LinkedIn presence?

Performance ScoreMarco Giordano's LinkedIn Performance