Impact & Analytics · BI Hub

Your data lake is live.
Your marketing data isn't.

BI Hub answers the questions your CFO and CMO ask every month, from budget to sales, in one live view by brand, medium and state.

Campaign analytics overview
Where is every dollar between plan and paid? FY 2025-26
Planned
$5.45M
Executed
$4.2M
77% of plan
Verified
$3.9M
backed by proof
Paid
$3.3M
61% of plan
Plan → committed → executed → verified → billed → paid
Planned48.0
Committed42.6
Executed36.9
Verified34.2
Billed33.1
Paid29.4
Watch6 campaigns have spend with no proof yet.
The problem

Your marketing data lake has
a blind spot

And other tools don't fix it either.

USING POWER BI OR A DATA LAKE?

Your dashboards show what reached the lake. Approvals, proof of execution and vendor bills never did, so the numbers stop at spend.

USING OTHER TOOLS?

Most tools see one part of the spend. BI Hub reads the whole chain, from budget to payment to sales.

Compare Brandintellé →
What it costs you

The cost of
poor marketing visibility

1

Monthly review

Spend is in one report, approvals in email and sales in another file, so the meeting argues about numbers instead of acting on them.

Decisions on gut feel
2

CFO and CMO bring different numbers

Finance counts what was billed, marketing counts what was planned, and nobody can show how one turns into the other.

Two versions of the truth
!

Next year's plan built on last year's Excel

With no clean record of what worked, the new budget copies last year's split and adds a percentage.

Budgets repeated, not improved

See BI Hub
in action.

Campaign analytics

Every campaign,
from plan to paid.

Planned, committed, executed, verified, billed and paid for every campaign, with spend that has no proof or no bill yet flagged.

Campaign analytics
Which campaigns have spend with no proof or no bill?
Executed
$4.19M
Billed
$3.76M
Executed, not billed
$430K
No proof yet
$160K
Executed vs billed by campaign ($M)
Seasonal · Aurex 1251.36 / 1.11
Launch · Volt EV1.15 / 0.88
Summer · Strada 1500.97 / 0.90
Dealer meets · West0.59 / 0.52
ExecutedBilled
Act now$430K executed but not billed. Accrue it before close.
Budget analytics

Know what's left
before you commit it.

Outlook, approvals, commitments, provisions and payments by business unit and budget head.

Budget analytics
How much budget is left before we commit more?
Outlook
$5.9M
Committed
$5.1M
86% of outlook
Provisioned
$690K
Paid
$3.3M
Committed against outlook, by business unit
Two-wheelers$3M
Electric$1.4M
Corporate brand$740K
CommittedOutlook
Act now10 budget heads committed past outlook.
Media investment

Right rates.
Proof it ran.

Spend by medium and vehicle against benchmark rates, and how much is backed by independent proof.

Media investment
Did we pay the right rates, and did it run?
TV
$1.6M
General entertainment · Prime
Digital
$1.3M
Radio
$350K
Rates vs market median
+4%
Share of spend backed by independent proof
Digital97%
TV92%
Print88%
Outdoor81%
Radio55%
WatchRadio: only 55% of spend has proof.
Regional & retail performance

Every zone on pace,
every dollar tied to sales.

Budget from head office to zones, area offices and dealers; pace against seasonal phasing; dealer co-funding; cost per sale.

Regional & retail performance
Is every zone on pace, and what does a sale cost?
Zones on pace
4 of 5
Dealer co-funding
$270K
Cost per sale
$21
Area 7 spend pace
128%
of seasonal phasing
Spend pace against seasonal phasing
North96%
South103%
East91%
Central99%
West · Area 7128%
Act nowArea 7 will run out of budget by January.
Brand investment

Spend in line
with the business.

Each brand's share of spend against its share of sales, with over- and under-invested brands flagged.

Brand investment
Is each brand's spend in line with its sales?
Aurex 125 · spend share
66%
Aurex 125 · sales share
51%
Strada 150 · spend share
22%
Volt EV · spend share
12%
21% of sales
Share of spend vs share of sales
Aurex 12566 / 51
Strada 15022 / 28
Volt EV12 / 21
Spend %Sales %
WatchAurex 125 takes 66% of spend for 51% of sales.
Sales outcomes

Which dollars
moved sales.

Spend vs sales by state, the inquiry-to-retail funnel, and ROI by medium.

Sales outcomes
Which dollars moved sales?
Inquiries
124,000
Test rides
31,500
Retail sales
18,200
Return per $1 · Digital (est.)
$2.6
Inquiry-to-retail funnel
Inquiries124,000
Test rides31,500
Bookings23,400
Retail18,200
OpportunityThe next dollar works harder in Digital than Radio.

ROI comes from a response model and is shown as an estimate, not a fact.

E-commerce

Findable, in stock,
priced right.

Sales by platform, retail media return, share of search, out-of-stock by city, and discount depth.

E-commerce
Are we findable, in stock and priced right?
Online sales
$950K
Retail media return
$4.2 per $1
Share of search
18%
Out-of-stock cities
3
Online sales by platform ($M)
Brand website0.36
Amazon0.27
Flipkart0.22
Classifieds0.10
WatchVolt EV out of stock in 3 cities on Flipkart this week.

Marketplace data comes in by upload until the Amazon and Flipkart connections go live.

Intent triggers

What buyers say
before they buy.

Four layers from your social listening data: decision triggers, objections, unmet needs, and the phrases that signal intent to buy.

Intent triggers
What do buyers say before they buy?
Mentions read
48,200
Intent phrases
3,150
Objections
1,240
Unmet needs
410
Top phrase in each layer (mentions)
Trigger · "holiday offer"2,860
Objection · "no callback from service"1,780
Need · "home test ride"850
Intent · "booking this week"1,190
Opportunity"no callback from service" is the top objection this month. Answer it in the next campaign.
Vendor analytics

Pay market rates,
to vendors who deliver.

Vendor concentration, rates against market median rates, on-time delivery vs proof, billing disputes, and payment ageing.

Vendor analytics
Are we paying market rates, to vendors who deliver?
Top 3 vendors · share
61%
Rates vs market median
+6%
On time, with proof
87%
Small vendors past terms
$145K
Share of spend by vendor
Northstar Media28%
Pixelwave Digital19%
Inkline Print14%
Skyline Outdoor11%
Fieldworks Events9%
Act now$145K owed to small vendors past their payment terms.
Ops audit & turnaround

See where approvals stall
and controls break.

Time at each stage against its deadline, who holds the item, control exceptions (PO after execution, split under approval limit, duplicate invoice), and the audit sampling queue.

Ops audit & turnaround
Where do approvals stall, and where do controls break?
Estimates approved on time
65%
Waiting with Anita Desai (CFO)
9 items
Control exceptions
14
PO after execution · split · duplicate
Audit sample queue
22
Average days at each stage against its deadline
Estimate · Neha Kapoor5.1 / 4 d
Plan · Rahul Mehta2.4 / 3 d
Proof review4.2 / 5 d
Invoice · Anita Desai6.0 / 7 d
Average daysDeadline
Watch35% of estimate approvals miss the 4-day deadline.
Why a data lake can't see this

Five data streams.
One governed view.

  1. 1Budget & approvals
  2. 2Sourcing & POs
  3. 3Execution & proof
  4. 4Invoices & payments
  5. 5Sales & market data
BI Hub

Four of these streams are created inside Brandintellé, so they never reach your data lake on their own.

Data sources

Sits above your data lake.
Not replacing it.

In, live via API
In, by upload
  • TV monitoring data uploaded by your agency (e.g. BARC in India)
  • Sales and dealer data
  • Social listening exports
  • Marketplace data

Brandintellé does not provide monitoring data.

Out
Your data lake and BI tools.

In your next review,
no one says ‘let me get back to you’

One
Source of truth
CMO and CFO walk in with the same numbers.
Every dollar
Traced from plan to paid
Budget, approval, proof, bill and payment in one record, not rebuilt from agency Excel.
Ten
Questions answered
Budget, campaigns, media, regions, brands, sales, e-commerce, buyer intent, vendors and controls.

Enterprise-grade security. Built in

SOC 1 Type 2 and SOC 2 Type 2 audited
Infrastructure
Encrypted hosting, secure transmission.
Access Controls
Role-based permissions, secure APIs.
Compliance
SOC 1 and SOC 2 Type 2 audited. GDPR compliant, with EU data hosting.
You Are Here

Impact & Analytics is where the chain completes.

Every dollar tracked from the moment it’s budgeted to the moment it moves a market.

BudgetPlanSourceExecuteProofProvisioningInvoicePaymentImpact
FAQ

Frequently asked
questions

Can I use BI Hub without the other modules?

Yes. Data from outside Brandintellé comes in by upload, so BI Hub works on its own.

Does BI Hub prove ROI?

It estimates it with a response model. Estimates are labelled as estimates, not stated as fact.

Which data does it read?

Google Ads, Meta, DV360 and SAP through live connections. TV monitoring data uploaded by your agency (e.g. BARC in India), sales and dealer data, social listening exports and marketplace data come in by upload. Brandintellé does not provide monitoring data.

Does it replace Power BI or our data lake?

No. It feeds them governed marketing data.

Does it cover social listening?

Yes, from your listening tool's exports. It is not an online reputation management tool.

How is national spend mapped to states?

Through a market master that spreads national buys across states by agreed weights.

How long is setup?

Typically 2–3 months, depending on your data sources.

← Invoice ReconciliationImpact & Analytics — Module 6 of 8Regional Marketing →