Case Study
How a Kuala Lumpur agency reclaimed 10 hours every week
Bright Social Studio was drowning in spreadsheets. Now they're not.
Every Monday morning started the same way for Nadia.
She'd open her laptop, pull up Meta Ads Manager, then TikTok Ads, then three different Google Sheets. Copy numbers. Paste them into templates. Format cells. Export PDFs. Send emails to 15 different clients.
Two to three hours. Every single day.
Her team at Bright Social Studio was doing what they were hired to do — manage social campaigns for SMEs across Kuala Lumpur. But instead of creating content or optimizing ads, they were trapped in reporting hell.
"We knew there had to be a better way. But we're not developers. We didn't know where to start, and we couldn't afford to hire someone full-time just to fix this."
That's where Axelyn came in.
The approach: No new software. No coding. Just smart connections.
Nadia didn't need another tool to learn. She needed her existing tools to talk to each other.
What we built:
- →Connected Meta Ads and TikTok directly to Google Sheets using Make (Integromat)
- →Set up automatic daily syncs at 6 AM — no manual refreshing
- →Built a live Looker Studio dashboard with 4 specialized pages: Performance Overview, Client Breakdown, Optimization Insights, and Automated Alerts
- →Automated weekly email delivery — each client gets their report, on schedule, every Monday at 9 AM
The entire system was live in seven days. No code written. No new platforms to learn. Just invisible infrastructure doing the heavy lifting.
Inside the dashboard: Four pages that tell the complete story
Instead of one overwhelming spreadsheet, we built a system that guides you from overview to action. Each page answers a specific question that agency teams ask every day.
Performance Overview
"How are we doing overall?"
The first thing Nadia sees every morning. Six key metrics at the top — total impressions, clicks, CTR, spend, conversions, and ROAS — give her the agency's health in 3 seconds. Below that, line charts show how spend and revenue move together over time, and a side-by-side comparison reveals whether Meta or TikTok is delivering better returns.
"Before, I'd spend 20 minutes just adding up numbers. Now I see everything in one glance."
Client Breakdown
"Which clients are hitting their targets?"
Each client gets their own view. Select "Café Botanica" from the dropdown and instantly see only their campaigns — spend, revenue, ROAS, and conversions isolated. A detailed table breaks down every campaign by platform, and trend lines show whether performance is climbing or declining. When a client asks for their numbers, Nadia just filters to their name and shares the link.
"Clients love that they can explore their own data. They feel more in control, and I get fewer 'quick question' emails."
Optimization Insights
"Where should we focus our attention?"
This is where strategy happens. Scatter plots reveal which campaigns are getting cheap conversions versus expensive ones. Heatmaps show which days and platforms are firing on all cylinders. CTR trends expose creative fatigue before it tanks performance. It's not just data — it's a map showing exactly where to optimize next.
"We used to make decisions based on gut feeling. Now we see exactly which campaigns need new creative or better targeting."
Alerts & Recommendations
"What needs fixing right now?"
The proactive layer. A scorecard at the top shows how many campaigns are below target ROAS or struggling with low CTR. Below that, a prioritized list of action items — "Weekend Brunch Promo needs creative refresh" or "Fitness Challenge: reduce CPC by tightening audience targeting." No more hunting for problems. The system surfaces them automatically.
"This page alone saves us hours. Instead of digging through data looking for issues, the dashboard tells us exactly what to fix."
The result?
Four pages that work together like chapters in a book. Page 1 tells you where you stand. Page 2 zooms into each client. Page 3 shows where to optimize. Page 4 flags what needs immediate attention. Every morning, Nadia walks through this exact flow — and it takes her less time than making coffee.
What changed
Nadia's Monday mornings look different now.
She opens her inbox. Fifteen reports are already sitting there — generated overnight, formatted perfectly, sent to clients automatically. What used to take 2–3 hours now takes less than 30 minutes to review and customize if needed.
80%
less time on reporting
Zero
manual copy-paste errors
15
clients automated
Her team isn't stuck in spreadsheets anymore. They're doing the work they were hired to do — creating campaigns, testing creatives, growing their clients' brands.
"I didn't think automation was for small agencies like us. I thought it was expensive, complicated, or required a tech team. Turns out, we just needed someone who understood our workflow and knew how to connect the dots."
Project snapshot
RM 1,200
Total investment
7 Days
From kickoff to live
10+ hrs
Saved every week
Your team shouldn't waste time on work a system could do.
If you're losing hours to manual processes, disconnected tools, or repetitive admin work — let's talk about what automation could look like for you.
Book a free intro call