TL;DR A real-time field dashboard gives brand clients live visibility into campaign performance — no more waiting for weekly reports or chasing your team for updates. Book a 20-min call to build yours.
The spreadsheet problem
You know the drill. Brand client emails at 3pm asking for an update. You scramble to pull numbers from three different sources. Copy-paste into Excel. Format it. Realise the numbers don’t match yesterday’s version. Fix it. Send it with a caveat about “data being updated tomorrow.”
The client receives a static snapshot that was already stale when you sent it.
Now imagine the alternative. The client opens a link. They see live engagement numbers, conversion rates, store-level performance, and ambassador activity — all updated automatically. No email needed. No scramble. No stale data.
That’s a real-time field dashboard. And it changes everything about how you work with brand clients.
What a real-time field dashboard looks like
A real-time dashboard isn’t just a prettier spreadsheet. It’s a fundamentally different way of presenting field marketing data.
The live feed
At the top: today’s numbers. Engagements so far. Conversions. Active ambassadors. Stores visited. These update as reps submit data throughout the day.
This live feed creates a sense of momentum. The brand client can watch the numbers climb during an activation. It builds confidence in a way that a retrospective report never can.
The campaign view
Below the live feed: campaign-level metrics. Progress against targets. Running conversion rate. Cost per engagement. Presented with clear visual indicators — progress bars, RAG statuses, trend arrows.
| Metric | Target | Current | % Complete | Status |
|---|---|---|---|---|
| Total engagements | 10,000 | 7,340 | 73% | On track |
| Conversion rate | 20% | 23.4% | 117% | Ahead |
| Stores activated | 50 | 41 | 82% | On track |
| Cost per engagement | £5.00 | £4.60 | 109% | Ahead |
| Data captures | 2,000 | 1,180 | 59% | At risk |
At a glance, the client knows where things stand. No 30-minute call needed. No email chain.
The store map
A geographic view showing every activation location. Colour-coded by performance. Click a pin for store-level detail — who’s there today, what’s happening, how it compares to plan.
The ambassador leaderboard
Top-performing ambassadors ranked by conversion rate or engagements. Updated in real-time. This creates healthy competition among the team and gives the brand client visibility into team quality.
The architecture
Building a real-time field dashboard requires four components connected in sequence.
1. Field app (data capture)
This is where reps input data. The app needs to capture data in real-time — not in a batch upload at the end of the day.
Requirements:
- Mobile-friendly (reps are on their feet)
- Offline capability (not all stores have great signal)
- Structured data capture (dropdowns, not free text)
- API or webhook for data export
Tools: Repsly, Skout, Reapp, GoSpotCheck, or custom-built.
2. Fivetran (data pipeline)
Fivetran connects to your field app’s API and syncs data to your warehouse on a schedule. For near-real-time, you can configure syncs every 15-60 minutes.
It handles the messy parts: schema changes, incremental loads, error recovery. You configure it once and it runs.
3. BigQuery (data warehouse)
All your field data lands in BigQuery. This is where transformation happens — calculating conversion rates, aggregating by store, comparing against targets. SQL views and dbt models keep the logic clean and maintainable.
BigQuery also joins field data with other sources: retailer sales data, staffing schedules, campaign targets. One warehouse, one source of truth.
4. Looker Studio (dashboard)
Looker Studio connects directly to BigQuery and renders the dashboard. It’s free (with a Pro option for advanced features), supports branded templates, and handles real-time data refresh.
The dashboard is a URL. Share it with the brand client. They bookmark it. They check it whenever they want. Done.
The full flow: Field app → Fivetran (every 15-60 min) → BigQuery → Looker Studio → Brand client
💡 This is what we do. We build real-time field dashboards using exactly this architecture — field app to Fivetran to BigQuery to Looker Studio. Live data, branded dashboards, zero maintenance for your team. Book a 20-minute discovery call — no pitch, just scoping.
What “real-time” actually means
Let’s set expectations. “Real-time” in field marketing doesn’t mean millisecond latency. It means:
- Data from reps is captured as they work (not at end of day)
- Pipeline syncs every 15-60 minutes
- Dashboard refreshes when the viewer opens it
In practice, the data is 15 minutes to 1 hour behind reality. For field marketing, that’s more than enough. You’re not trading stocks. You’re tracking whether the Manchester activation hit its engagement target by lunchtime.
The improvement over the status quo — data arriving 2-5 days after the activation — is transformational.
The client experience
When you give a brand client a live dashboard, the dynamic of the relationship changes.
Before: Client emails asking for updates. You spend hours compiling. Client questions the numbers. Back and forth. Trust erodes through friction.
After: Client opens the dashboard. Data is there. Questions are answered before they’re asked. Calls focus on strategy and optimisation instead of “can you send the numbers?”
The agencies we work with report a measurable improvement in client satisfaction after implementing live dashboards. Some clients have told us it was the primary reason they renewed.
Designing for the right audience
A common mistake: building one dashboard and sharing it with everyone.
Brand clients need a clean, summary-level view. Campaign managers need operational detail. Ambassadors need individual performance. Finance needs cost metrics.
Brand client dashboard: High-level KPIs, campaign progress, store performance map. Clean, branded, minimal clutter.
Operations dashboard: Ambassador schedules, attendance tracking, stock issues, logistics alerts. Detailed, actionable, filterable.
Finance dashboard: Cost per engagement, budget burn rate, ROI calculations, monthly reconciliation.
Same data. Different views. Different audiences.
Common mistakes
Showing too much data. A dashboard with 50 metrics is a spreadsheet with a logo. Focus on 5-8 key metrics per view. Let users drill down if they want more.
Not setting thresholds. Numbers without context are meaningless. Show targets. Show RAG status. Make it obvious what’s good, what’s fine, and what needs attention.
Forgetting mobile. Brand clients check dashboards on their phones. Looker Studio supports responsive layouts — use them.
Not testing the pipeline. Before launch, test every stage. Submit test data from the field app. Verify it flows through Fivetran to BigQuery to the dashboard. Break things before the client sees them.
Getting started
At Chartica, we’ve built real-time field dashboards for over 20 teams. We’re based in London and specialise in Analytics as a Service for field marketing agencies.
Our standard delivery is about three weeks from kick-off to live dashboard. We manage everything in our cloud — Fivetran, BigQuery, Looker Studio — on a monthly retainer. Your team doesn’t need to learn any tools or write any code.
The era of emailing spreadsheets is over. Your clients expect live data. Give it to them.
Know someone drowning in spreadsheets? Share this guide with them.
→ See all our field marketing analytics resources: Field Marketing Reporting & Dashboards
If this sounds like more work than you want to take on, that’s what we do at Chartica. Book a 20-minute discovery call — we’ll scope it out, no pitch.