SALES DASHBOARDS

UK sales dashboards need a July-to-June financial year view, a cost-per-acquisition by channel report, and a pipeline-to-invoiced-revenue reconciliation — three things HubSpot does not configure by default

Most UK businesses running HubSpot or Salesforce accepted the default dashboard their CRM vendor shipped. That default is built for a US calendar year, a US ad ecosystem, and a US accounting stack. It does not know about your April-to-March financial year, your Xero invoicing, or your need to see cost-per-acquisition broken down by Google Ads versus Meta Ads. The result is a dashboard that looks populated but answers the wrong questions. Quota attainment is measured against the wrong year boundary. Marketing efficiency is invisible at the deal level. And every month-end, someone reconciles the CRM figure manually against the accounting system because no one ever built the bridge. We configure, build, and connect sales dashboards for UK businesses that need reporting aligned to how UK businesses actually operate.

Request a Dashboard Build → View the evidence →
This is for you if

This is for Nepali business owners and sales managers who:

Check booking and revenue numbers by asking a team member, then wait for them to count

Run end-of-month reports by having someone copy figures from multiple sources into a spreadsheet

Have no single place that shows enquiries, conversion rates, revenue, and team activity together

Do not know what percentage of enquiries become actual bookings, or where most leads drop off

Cannot tell, without asking, how many calls or follow-up messages their sales team made last week

This applies to education businesses, real estate firms, travel and hospitality operators, healthcare providers, and any Nepal-based service business where enquiry volume and conversion rate directly determine monthly revenue.

What's broken

Problems We Solve

HubSpot reporting set to January-December calendar year

UK businesses running April-to-March financial year with HubSpot defaulting to calendar year face a specific problem: quota attainment, year-to-date performance, and pipeline coverage all measure against the wrong year boundary. A sales director reviewing pipeline coverage in February is looking at 10 months of a financial year that started in April. HubSpot's default "this year" filter shows January to December. The numbers look similar enough that the error goes unnoticed until quarter-end, when the quota attainment figure does not match the finance team's calculation. Financial year configuration requires custom date range setup in every HubSpot report, and it must be maintained each time a new report is cloned or a new dashboard is built. We configure this once, correctly, across your entire reporting environment so every new report inherits the right year boundary automatically.

No cost-per-acquisition report combining CRM and ad spend

UK businesses with Google Ads and Meta Ads spend tracked in separate platforms and closed deal data sitting in HubSpot have no single dashboard showing cost per acquired customer by channel. The marketing team sees cost-per-click and cost-per-lead inside Google Ads and Meta Business Manager. The sales team sees deal count and revenue inside HubSpot. Neither team can see what it actually cost, across the full funnel, to acquire a paying customer from each channel. Marketing efficiency is invisible at the deal level. We build Looker Studio dashboards that pull Google Ads spend, Meta Ads spend, HubSpot deal data, and lead source attribution into a single view, producing a cost-per-acquisition figure by channel that neither platform can show you on its own.

Pipeline not reconciled against Xero or Sage invoiced revenue

UK businesses close deals in HubSpot and invoice in Xero or Sage. The two systems use different revenue recognition timing, different deal identifiers, and often different contact records. At month-end, the CRM says one figure and the accountant says another, and no one has a quick answer for why they differ. This reconciliation gap is not a minor inconvenience. It creates doubt about whether the CRM data is reliable, forces manual cross-referencing every month, and makes it impossible to run a clean pipeline-to-revenue conversion report. We build pipeline-to-invoiced-revenue reconciliation dashboards that connect HubSpot deal records to Xero or Sage invoices, flag the timing differences, and show finance and sales a single reconciled view.

No territory or vertical segmentation in pipeline reporting

UK businesses selling across multiple industry verticals or geographic regions collect deal data at the contact and company level, but the pipeline dashboard shows aggregate figures. There is no way to compare London versus the North, or professional services versus manufacturing, in the standard CRM report view. Territory and vertical segmentation requires that deals be tagged correctly at the point of entry and that those tags are available as filters in every pipeline report. Most HubSpot implementations skip this configuration because it feels like a data hygiene task, not a reporting task. It is both. We audit your deal properties, build the segmentation framework, back-fill where possible, and configure pipeline reports that let your team compare performance by territory, vertical, or any other dimension that matters to how you sell.

What we engineer

What we build for Nepali businesses

Looker Studio dashboard builds

pulling data from Google Sheets, Google Analytics, Facebook Ads, Google Ads, and CRM connectors available at no cost

Conversion funnel reporting

showing the drop-off rate at each stage from first enquiry to closed booking

Revenue tracking

by week and month, with comparison to the previous period

Lead source attribution

showing which channel — organic search, Facebook, Google, referral, direct — is producing the highest volume and best conversion rate

Team activity reporting

showing calls made, messages sent, and follow-up completions per team member

GoHighLevel and HubSpot Free reporting configuration

for businesses that have a basic CRM but have not set up reporting inside it

Shareable dashboard links

that the business owner can open from any device without logging into four separate tools

Request a Dashboard Build →
What changes

What a Nepali business looks like after a dashboard is built

Before
After
Before Revenue data sits in the accounting system. Enquiry data sits in WhatsApp. Booking data sits in a Google Sheet. Ad performance data sits in Facebook Ads Manager and Google Ads. These four sources are never combined into a single view. When the business owner wants to understand performance, they get a fragmented picture from four separate systems, none of which talk to each other. Pulling a meaningful weekly or monthly picture requires manual effort every time, and the picture is never complete because one person controls each source.
After Reporting time drops to zero — no more manual monthly compilation; the dashboard is always current
Before Someone on the team spends two to four hours each month copying numbers from multiple sources into a reporting spreadsheet. By the time the report is shared with the business owner or management team, the numbers are already a week or more out of date. Decisions made from that report are based on a lagging snapshot, not current reality. A Looker Studio dashboard connected directly to Google Sheets, Google Analytics, and basic CRM sources produces the same report in real time, with zero manual compilation effort.
After Conversion rate becomes visible — for the first time, the business knows the actual enquiry-to-booking rate and can set a realistic improvement target
Before The business does not know what percentage of enquiries become quotes. It does not know what percentage of quotes become bookings. It does not know where in the process most leads stop progressing. Without funnel visibility, there is no data-supported answer to the most important question in sales: which step in the process, if improved, would have the largest impact on revenue? Investing in more lead generation when the conversion rate between quote and booking is 20 percent is a much lower-leverage decision than fixing the conversion rate first.
After Lead source data informs ad spend decisions — when the dashboard shows that Facebook Ads produce twice the volume but half the conversion rate of Google Ads, the budget allocation decision becomes straightforward
Before The business owner has no visibility into how many calls or follow-up messages each team member made in the past week. Performance management relies on subjective impressions and the volume of visible WhatsApp activity. There is no report showing which salesperson is most active, which has the highest conversion rate, or which is sitting on a high number of stale leads. Activity data is the leading indicator of revenue. Without it, the only performance signal available is the lagging result: revenue at the end of the month.
After Team activity becomes a manageable metric — activity data turns a subjective performance conversation into a specific one
How it works

How we build a Nepali business dashboard

  1. 01

    Data source audit

    Week 1

    We map every data source the business currently uses: the Google Sheet tracking bookings, the CRM or GoHighLevel account, the Google Analytics setup, the Facebook Ads account, and the Google Ads account. We identify which sources have reliable, consistent data and which need cleaning or restructuring before they can be used in a dashboard.

  2. 02

    KPI definition

    Week 1

    We work with the business owner to define the four to eight numbers that matter most for their specific business. For most Nepali businesses this is: total enquiries by source, enquiry-to-booking conversion rate, monthly revenue vs target, and team activity by member. We confirm the definitions before building.

  3. 03

    Data connection and structure

    Week 2

    We connect each data source to Looker Studio using available free connectors. Where a direct connector does not exist, we set up a Google Sheets structure that the team updates and that feeds the dashboard automatically. We clean any data quality issues at this stage.

  4. 04

    Dashboard build

    Week 2-3

    We build the dashboard in Looker Studio with the agreed KPIs, conversion funnel view, lead source breakdown, and team activity report. We configure date range controls so the business owner can view any period without changing the underlying data.

  5. 05

    Handover and training

    Week 3

    We share the dashboard link, walk the business owner and relevant team members through each section, and document the data sources connected. We confirm the team can update data sources without our involvement.

Request a Dashboard Build →
Common questions

FAQs

How do I configure HubSpot to report against UK financial year dates (April to March)?

HubSpot does not have a native financial year setting that automatically applies April-to-March across all reports. The correct approach is to use custom date range filters with saved date properties, configure your fiscal year start in HubSpot's account settings (available in Sales Hub Professional and above), and apply consistent date filters across every report in your dashboards. For reports that need to compare current financial year against prior financial year, you need to build those comparisons manually using calculated date ranges rather than HubSpot's built-in "this year versus last year" toggle, which will always use January-December unless the fiscal year setting is configured. We configure this across your full reporting environment so new reports inherit the correct boundary.

How do I build a Looker Studio dashboard combining HubSpot pipeline data with Google Ads and Meta spend for a UK business?

Looker Studio connects to HubSpot via the official HubSpot connector, which exposes deal, contact, and company data. Google Ads connects natively. Meta Ads requires either a third-party connector (Supermetrics, Windsor.ai, or similar) or a manual data export into Google Sheets used as a Looker Studio data source. The build involves configuring the connections, creating calculated fields for cost-per-acquisition (total ad spend divided by closed-won deal count, filtered by lead source), and building a blended data view that aligns the date dimensions across all three sources. The main technical challenge is matching HubSpot lead source attribution to the correct ad platform campaign, which requires consistent UTM parameter setup on your UK ad campaigns before the dashboard build begins.

How do I reconcile HubSpot CRM deal revenue with Xero or Sage invoiced revenue in a UK reporting dashboard?

The reconciliation requires a common identifier between HubSpot deals and Xero or Sage invoices. The most reliable approach is to write a unique deal reference from HubSpot into the invoice reference field in Xero or Sage at the point of invoicing, either manually or via a Zapier or Make automation. Once the common identifier exists, you can export both datasets into a Google Sheet or a Looker Studio blended data source, match on the identifier, and calculate the difference. The timing gap between deal close date in HubSpot and invoice date in Xero is the most common source of discrepancy and should be displayed as a separate column rather than treated as an error.

How do I add territory segmentation to HubSpot pipeline reports for a UK sales team?

Territory segmentation in HubSpot pipeline reports requires a deal or contact property that captures territory (for example, London, North West, Scotland, or a postcode region). If this property does not exist, you need to create it, define the territory values, and either back-fill existing records via a CSV import or set up a workflow that assigns territory based on company postcode or owner. Once the property is populated, you can add it as a filter and group-by dimension in HubSpot's deal pipeline reports and in any Looker Studio dashboard connected to HubSpot. The back-fill is the most time-consuming part; ongoing assignment via workflow is straightforward once the property is configured.

What sales dashboard KPIs matter most for a UK B2B professional services or SaaS business?

For UK B2B professional services, the most important pipeline KPIs are pipeline coverage ratio (pipeline value as a multiple of quota), weighted pipeline by stage, average deal size by service line, win rate by lead source, and days-to-close by deal size band. For SaaS, the additional KPIs are monthly recurring revenue by cohort, pipeline velocity (deals times win rate times average deal value divided by average sales cycle length), lead-to-opportunity conversion rate by channel, and churn rate alongside new business pipeline. The financial year alignment matters for both: YTD quota attainment and pipeline coverage are meaningless if the year boundary is wrong.

Our team

The people behind the work

Not a black box. Real specialists you can call, with their names on the work.

Niraj Raut

Niraj Raut

Founder — Ecommerce SEO
Keshab Joshi

Keshab Joshi

PPC Expert
Hawrry Bhattarai

Hawrry Bhattarai

Google Ads Expert
Arogya Rijal

Arogya Rijal

SaaS SEO Expert
About Us →
Start here

Ready to see your business numbers in one place?

Most Nepali businesses already have the data — it is just in four separate places and nobody has combined it. A Looker Studio dashboard does not require new software, does not require changing how your team works, and does not require technical knowledge to use once it is built. If you want to stop asking team members what the numbers are and start seeing them directly, we can map your current data sources and tell you exactly what a dashboard would show.

Request a Dashboard Build →