Skip to content
Maaz Ahmed

A marketing dashboard that builds itself

Days of monthly exports into Power BI, replaced by a dashboard that pulls GA4, Search Console, Meta, LinkedIn and YouTube data on its own.

Client
Jaffer Business Systems
Scope
Marketing automation, analytics and diagnostics
Period
2026 to present
Result
Days of monthly reporting work, now automatic
Jaffer Business Systems, A marketing dashboard that builds itself

The problem

Jaffer Business Systems runs six business units, from fintech to energy and automation, each with its own website and social channels. When I joined the marketing team, a lot of its work was manual.

The monthly dashboard was the biggest example. Someone exported the numbers from LinkedIn, GA4, Search Console, Meta and YouTube, compiled them into an Excel sheet and uploaded that into Power BI. It took days, every month, and the dashboard was out of date the day it was finished.

What I built

I saw a job that should not need a person, and built it with Claude Code.

  • Connected the GA4, Search Console, Meta, LinkedIn and YouTube APIs to a Google Sheet. Apps Script keeps pulling the data in on its own.
  • Put it on GitHub and Cloudflare, so it runs and updates without anyone at a computer, and the API keys stay private.
  • Designed the dashboard on top: which KPIs, trends and charts matter, for all six units on one screen, filtered by unit, year and month. Open the dashboard.
  • Built a diagnostic for leadership from the same data: where the portfolio leaks attention, where it is ready to scale, and an action plan in priority order. Read the diagnostic.
  • Connected Claude to the team’s GoHighLevel CRM, so new leads are qualified, follow-ups are drafted and CRM data feeds the same reporting.
  • Rebuilt GA4 and Tag Manager conversion tracking underneath, so the numbers could be trusted.

What changed

The monthly dashboard stopped being a job. It no longer waits for the end of the month either. It keeps itself up to date as the data comes in, and the days the team spent compiling it went back into the actual marketing.

This is also how I learned marketing automation: APIs, GitHub, Cloudflare and Apps Script, on a real problem with a real team waiting for the result.

Why it is here

A clothing brand selling into Europe, the UK and the Gulf has the same problem at a smaller size. Search, ads and social live in different tools, someone spends days stitching them together, and nobody can say which market deserves the next budget. I build the same automated reporting for clients.

The diagnostic

A long-form report for leadership. It starts with three findings that change the next budget and ends with ten moves ranked by impact, confidence and ease.

Diagnostic report cover headed Where the portfolio leaks attention and where it's ready to scale, beside the six business unit logos
Opening page.
Three findings that change the next budget, each with a headline figure and a short explanation
Three findings that change the next budget.
Bar and line charts comparing Facebook and Instagram reach across the year
Channel performance across the year.
A ranked list of moves, each scored for impact, confidence and ease
Ten moves, ranked.

Want the same result? See how I work on Marketing automation, or tell me about your business.

Next project

Tell me what you are selling and where.

Send the store URL and the markets you want to grow in. I will reply with what I would look at first.

Book a consultation

Or message me on WhatsApp or LinkedIn.