SALES DASHBOARDS

Canadian sales dashboards need a July-to-June or April-to-March fiscal year view depending on entity type, bilingual French-English KPI labels for Quebec teams, and a provincial revenue breakdown that no default CRM configures automatically

Canadian businesses face a reporting configuration problem that is easy to miss until it matters. The financial year end is not standardised across entity types. Provincial revenue reporting is not something any default CRM supports. And for businesses with a Quebec sales team, an English-only dashboard is a dashboard that gets used reluctantly. Most HubSpot and Zoho implementations deployed in Canada are configured by partners working with US or international default settings. The fiscal year stays at December 31. Provincial segmentation is never built. The Quebec team gets the same English-language dashboard as the Ontario team, and adoption stays lower than it should be. We build sales dashboards for Canadian businesses that reflect the correct fiscal year end, include provincial revenue segmentation, and support bilingual French-English display where required.

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

Financial year not matching the Canadian business entity's fiscal year

Canadian businesses do not have a single standard fiscal year end. Most small businesses and sole proprietors use December 31. Many federal contractors, Crown corporations, and government-adjacent businesses use March 31. Some professional services firms and academic institutions use June 30 or August 31. HubSpot defaults to December 31. A business with a March 31 fiscal year end running HubSpot with a December 31 default will produce inaccurate YTD quota attainment from January through March, because the system treats those months as the end of one year while the business's finance function treats them as the final quarter of the current year. The discrepancy compounds when comparing current year to prior year performance. We configure HubSpot, Zoho CRM, and Salesforce with the correct fiscal year end date for your entity, rebuild the affected standard date filters, and verify that all pipeline reports and quota attainment calculations are using the right boundaries.

No provincial revenue breakdown

Canadian businesses generating revenue across Ontario, Quebec, British Columbia, Alberta, and other provinces have no native provincial segmentation in their CRM pipeline reports. The default dashboard shows national aggregate figures. This gap has two consequences. First, sales leadership cannot compare provincial pipeline performance or identify which province has the fastest close cycle or the highest average deal value. Second, provincial sales tax compliance (GST, HST, and PST rates vary by province) requires province-level revenue data that the CRM cannot produce if provincial segmentation was never configured. We build provincial revenue segmentation into deal records, configure provincial pipeline filters, and build Looker Studio or Power BI dashboards that show pipeline and closed revenue broken down by province, along with the applicable tax rate for each province's deals.

French-language dashboard labels absent for Quebec teams

Quebec sales teams reviewing dashboards with English-only KPI labels are not getting a full benefit from the CRM investment. This is not simply a preference: French is the working language of many Quebec-based sales teams, and a dashboard in English requires an extra cognitive step for every metric reviewed. Power BI and Looker Studio both support bilingual label configuration. In Power BI, French and English label sets can be configured at the dataset level and switched by the viewer's language preference. In Looker Studio, bilingual dashboards require a separate page or a duplicated report with translated labels. Most implementations do not include this configuration because it is specified by the IT or operations team, not by the Quebec sales team who will use it. We configure bilingual French-English dashboard label sets for Power BI and Looker Studio, review translations with French-speaking team members, and deliver dashboards that display in the viewer's preferred language.

No CASL consent status visible in lead reporting

Canadian CRM lead reports do not show CASL consent status by default. The marketing team is reviewing lead counts, lead source breakdowns, and lead-to-opportunity conversion rates without any visibility into which leads have valid CASL consent for commercial email communication. The practical risk is that leads are included in campaign performance reports and lead nurture workflows without the marketing team knowing whether those leads have valid express or implied consent. CASL implied consent has a two-year maximum duration; leads last contacted more than two years ago may no longer have valid consent. We add CASL consent status and consent date as visible fields in HubSpot or Zoho lead reports, configure filters that allow the marketing team to segment consented versus non-consented leads, and build a consent expiry flag that identifies implied consent records approaching the two-year limit.

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 the correct fiscal year end date for a Canadian business in HubSpot or Zoho CRM reporting?

In HubSpot, fiscal year start is configured in Settings under Account Defaults, then Fiscal Year. You set the month in which your fiscal year begins, and HubSpot applies this to all date range filters that use fiscal year references. This setting is available in Sales Hub Professional and above. In Zoho CRM, fiscal year configuration is in Setup under Company Details, where you set the fiscal year start month. After changing this setting in either platform, review all saved reports that use relative date filters such as "this year" or "last year", as these will shift to the new fiscal year boundary. Quota attainment reports are the most commonly affected and should be verified against your finance team's figures after the change.

How do I add provincial revenue breakdown to Canadian CRM pipeline reporting?

Provincial revenue breakdown requires a province field on either the deal record (for new deals) or the contact or company record (for segment-level analysis). In HubSpot, create a custom deal property called Province with a dropdown list of Canadian provinces. In Zoho CRM, add a custom field to the Deals module. Once the field exists, populate it for existing records via CSV import or a bulk update workflow, and set up a required field rule or workflow to ensure new deals always have a province assigned. Pipeline reports can then be filtered and grouped by province in HubSpot's report builder, Zoho Analytics, or a connected Looker Studio dashboard. For provincial tax reporting, add a second field for applicable tax type (GST, HST, PST, QST) populated automatically by a workflow based on province selection.

How do I build a bilingual French-English sales dashboard for a Canadian business in Looker Studio or Power BI?

In Power BI, bilingual dashboards are built using the Translations feature in the dataset model. You add a French culture (fr-CA) to the dataset and translate measure names, column names, and hierarchy labels. Report consumers with their browser or Power BI language set to French will see French labels automatically. In Looker Studio, native multilingual label switching is not available, so the most practical approach is to build separate French and English report pages with the same charts but translated titles, labels, and calculated field names, and share the appropriate page URL with each team. Both approaches require a translated label set reviewed by a French-speaking Canadian team member to ensure the terminology matches how the Quebec sales team refers to their KPIs in practice.

How do I include CASL consent status as a filter in Canadian CRM lead reporting dashboards?

CASL consent status needs to exist as a contact or lead property in your CRM before it can be used as a filter in dashboards. In HubSpot, the standard legal basis for communication and subscription status fields can be used, but a more explicit CASL-specific approach is to create a custom contact property for consent type (express, implied, or none), consent date, and consent source (for example, form submission, purchase, business card). Once these properties are populated, they can be added as filter criteria in HubSpot reports to segment leads by consent status, and a calculated field can flag records where implied consent date is more than 24 months ago. In Looker Studio connected to HubSpot, these properties appear as available dimensions and can be used as dashboard-level filters.

What are the most important sales dashboard KPIs for a Canadian B2B SMB?

For a Canadian B2B SMB, the most important pipeline KPIs are total pipeline value versus quota (pipeline coverage ratio), number of active deals by stage, average deal size, win rate, average days to close, and lead-to-opportunity conversion rate by lead source. For businesses with multiple provinces, provincial pipeline breakdown and provincial win rate are important additions. For businesses subject to CASL, an active consent ratio (percentage of leads with valid consent) is a compliance KPI that belongs on the marketing dashboard. Fiscal year alignment is the foundation of all these metrics: YTD quota attainment and pipeline coverage ratios are not meaningful if the year boundary does not match the one your finance team is using.

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 →