Skip to main content

Work

Recent projects and the systems behind them.

Automated Performance Reports

For businesses that spend on marketing.
Live

By Monday morning, the report is already in your inbox. Traffic, rankings, top pages, what went up, what dropped, versus last week, in plain language. No dashboards to log into. No reports to build. No analyst to chase.

  • Two formats, every time. A plain-language summary in your inbox, plus a full Excel workbook with all the data behind it.
  • Weekly, monthly, quarterly. Each one deeper than the last, fully automatic.
  • Every report scored 0 to 100 with a clear verdict: growing, flat, or declining.
  • Actions to take this week, not just numbers to stare at.
3Report cadences
ZeroManual work
0–100Performance score
GA4 + Search Console Email summary + Excel workbook Weekly, Monthly, Quarterly
  1. Connect once: GA4 and Search Console link through a single connector, so traffic, rankings, and behaviour flow into one place automatically
  2. We do the thinking: Not just totals, but week-over-week comparisons, trend detection, and a scored verdict, run on schedule
  3. You get the report, two ways: A summary with sections, tables, and action items lands in your inbox, and a detailed Excel workbook lands alongside it, every query, page, channel, and trend, ready to filter, share, or archive. No manual step in between
  4. Weekly: Traffic, search performance, top pages, and what to do this week
  5. Monthly: Which pages converted, which didn't, and next month's priorities
  6. Quarterly: 90-day trends, keyword opportunities, and a roadmap for the next quarter

Content Intelligence Engine

For agencies and freelancers running content for multiple clients
Live

The hardest part of content isn't writing. It's knowing what to write next. I built a tool that reads everything a client's competitors have recently published, studies it, and hands back a content roadmap: what to write, in what order, for the next 1, 3, or 6 months. Not tested on a demo. Running on a real client, producing a roadmap they execute.

  • Kills the blank page. Research that took 2–3 hours per client now runs in minutes.
  • Every client saved as a profile, rules and all: "never mention price" stored once, respected in every output.
  • Roadmaps sized to the engagement: 1, 3, or 6 months.
  • Shows its homework. Every idea is grounded in real articles competitors actually published, plus the gaps nobody's writing yet.
Hours → MinsResearch per client
1, 3, 6Month roadmaps
3–8Competitors tracked
Content Strategy Competitive Research Claude API Python + Streamlit
  1. Enter the client and competitors: Client profile, hard rules, and 3–8 competitor URLs saved once, reused on every run
  2. Collect what competitors published: The tool fetches recent articles from every competitor site, trying different methods until one works: clean feeds, scraped pages, or a fallback route when a site doesn't cooperate
  3. Analyse for themes and gaps: Every article gets studied for what's being said, and just as important, what nobody's saying yet
  4. Generate the roadmap: A sequenced content plan for the next 1, 3, or 6 months, every idea traceable back to a real published article
  5. Remembers the brand: Rules like "never mention price" are stored once on the client profile and respected in every future output
  6. Switch clients in one click: Each client is a saved profile, no re-entering context, no starting from scratch

Premium Studio of Surfaces Brand Growth

For local businesses that live or die on being found, being trusted, and being fast to reply
Details anonymized. Client name and identifying specifics withheld by agreement.

A premium design and surfaces studio in Hyderabad already had steady inbound interest through Google, people were finding them and calling. What was missing was quality: nothing online proved they were the specification-grade expert serious architects and designers actually trust, not just another tile shop. Instagram told the same story, decent work, but reels pulling a fraction of the views comparable local studios were getting with similar content.

I built the system to fix that: WhatsApp set up so every enquiry gets a fast, verified reply, a founder LinkedIn presence giving his decade of expertise an actual public voice, a Reels-first creative system built around why the old posts weren't landing, and a six-month plan to earn trust with the buyers who matter most, on Google, Google Maps, and AI tools like ChatGPT.

Two months in: WhatsApp and founder content are live and running. The content and creative systems are now rolling out.

  • Every enquiry now gets a fast reply from a verified, blue-tick WhatsApp number, so it reads as a professional studio, not a random shop
  • The founder's decade of hands-on material expertise now has a public voice on LinkedIn, nearly 30 posts in two months, the kind of authority a serious buyer checks for before trusting a supplier
  • Audited Instagram against comparable local studios, found reels getting a fraction of the views similar accounts pulled with similar content, and built a Reels-first creative system, shot list, content pillars, and KPIs, to close that gap
  • Content built for the buyers who matter most, architects specifying a real project, not just browsers comparing prices, six months of it, already written and going out
6-MonthContent roadmap
30+Posts written
4Systems connected
WhatsApp Business API LinkedIn Ghostwriting Local SEO AEO / GEO Reels Strategy Google Business Profile
  1. WhatsApp first: WATI integration, blue-tick verification, and an AI response bot, built and demoed so it's ready the moment the client wants it live
  2. Started with the founder, not the brand: LinkedIn posts in his own voice, because people trust a person before a company page
  3. Audited Instagram against comparable local studios: found reels underperforming similar accounts by a wide margin, then built a Reels-first creative brief, shot list, content pillars, and monthly targets to close the gap
  4. Mapped a six-month content system before writing a single post: every platform assigned a specific role, so nothing gets duplicated for no reason
  5. Wrote the actual content in advance, not just a calendar of topics, so execution never stalls waiting on ideas
  6. Tagged every piece for its actual job: local search, national search, or getting cited by AI tools like ChatGPT and Perplexity
  7. Now executing month by month, with a content team producing against the plan, so visibility keeps compounding instead of resetting every time a campaign ends