SALES DASHBOARDS

Nepali business owners asking "how many bookings do we have this month?" should be able to see the answer on a dashboard — not by asking a team member who checks a WhatsApp group

When your revenue picture is split across a Google Sheet, a WhatsApp group, a Facebook Ads account, and an accounting file, you do not have reporting — you have four separate data sources that nobody has combined. We build Looker Studio dashboards for Nepali businesses that pull all four into a single shared view, updated in real time, accessible from any device.

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

Four reporting problems that keep Nepali business owners guessing about their own revenue

No centralised view of the business

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.

Monthly reports compiled manually

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.

No conversion funnel visibility

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.

No team activity tracking

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.

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

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.

Common questions

Sales dashboard questions from Nepali businesses

What is Looker Studio and how can a Nepali business use it to build a free sales dashboard?

Looker Studio is Google's free data visualisation tool that connects to Google Sheets, Google Analytics, Google Ads, and third-party CRM connectors to produce shareable, real-time reporting dashboards. A Nepali business can use it without paying for any software licence — the tool is free, and most Nepali businesses already use Google Sheets and Google Analytics, which connect to Looker Studio directly. The work involved in building a useful dashboard is not the tool itself but the data structure setup, connector configuration, and KPI design. A well-built Looker Studio dashboard for a small Nepali business typically takes two to three weeks to complete and requires no technical knowledge from the business owner to use once it is live.

What CRM platforms connect to Looker Studio for a Nepal-based business?

GoHighLevel connects to Looker Studio through a Google Sheets export workflow: the CRM data is pushed to a connected Google Sheet, which Looker Studio reads directly. HubSpot Free connects to Looker Studio through a third-party connector, several of which are available at no cost for basic pipeline data. Google Analytics connects natively with no additional setup. Facebook Ads and Google Ads both have official Looker Studio connectors that pull spend, impressions, and conversion data. For most Nepal-based businesses using these tools, the full data connection can be completed without purchasing any paid connector service.

What are the most important sales KPIs a small Nepali business should track on a dashboard?

The four most important KPIs for a small Nepali business are: total enquiries by source (showing which channel is driving the most leads), enquiry-to-booking conversion rate (showing what percentage of leads become paying customers), monthly revenue versus target (the primary financial outcome metric), and team activity by member (showing calls made, messages sent, and follow-ups completed per person). Secondary metrics that add significant value once the primary four are visible include: average deal value, lead response time, and pipeline age by stage. Starting with the four primary KPIs and building from there is more useful than attempting to track twenty metrics before the data infrastructure is reliable.

How do I build a conversion funnel report showing enquiry-to-booking rates for a Nepali business?

A conversion funnel report in Looker Studio requires a data source that records the stage of each enquiry at each point in the process — typically a Google Sheet or CRM that has a status column updated as each lead progresses from enquiry to quote to booking to closed. The Looker Studio funnel chart then reads the count of records at each stage and calculates the drop-off percentage between stages. For a Nepali business that currently tracks leads in a Google Sheet, this requires adding a standardised status column and ensuring the team updates it consistently. Once the data structure is in place, the funnel chart in Looker Studio is a straightforward build. The more important work is the data discipline: the funnel is only accurate if lead status is updated at each stage.

How long does it take to build a Looker Studio sales dashboard for a small Nepal-based team?

A Looker Studio sales dashboard for a small Nepal-based team typically takes two to three weeks from first data source audit to final handover. Week one covers data source audit, KPI definition, and data cleaning. Week two covers connector setup and dashboard build. Week three covers review, adjustments, and team training. The timeline extends if the business has significant data quality issues — for example, a Google Sheet where booking status has not been updated consistently, or an ad account that has not been linked to Google Analytics. Businesses with clean, consistent data in their existing Google Sheets can sometimes complete the build in ten to fourteen days.

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
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.