Guides
Web analytics and CRM dashboard: what to combine and how
Published November 10, 2026 · 8 min read
Most small businesses have two dashboards that never talk to each other: web analytics, which counts visits and sources, and the CRM, which counts contacts, deals and sales. The figure that really matters sits between them: which channel brings customers who buy, which landing page produces deals and how quickly the team replies to people who write in.
This guide covers what to combine in a single dashboard, with sample widgets, the templates you can start from and the permissions needed to see data that links visits to people.
Key takeaways
- A useful dashboard answers business questions; it doesn't show every possible metric. Start with three or four questions.
- Combining web and CRM data needs a link: an identified visitor becomes a contact, and their first touch carries over to their deals.
- Flowgration provides web sources (sessions, pages, events, forms, landing pages, funnels) and sources that join web and CRM data (contacts with their first visit, and deals by first-touch channel).
- Ready-made templates exist: web traffic, landing performance, lead capture funnel, sales by channel, forms and leads, attribution by channel and inbox response times.
- Data that shows people needs permission on visitors plus read access to the CRM.
Why join web analytics with the CRM?
An analytics tool knows a campaign brought 400 visits. The CRM knows six deals were won this month. Neither one alone tells you how many of those six came from that campaign.
To answer that you need to link visits and people. In Flowgration that link exists when a visitor who accepted analytics identifies themselves, for example by submitting a form. From then on their first touch (source, medium, campaign and landing page) is attached to the contact and, through the contact, to their deals.
What questions should your dashboard answer?
Before adding widgets, write down the questions. Some that work well for a small business:
- Where does traffic come from, and is it growing?
- Which landing pages turn visits into leads?
- Which first-touch channel brings the most won revenue, and at what win rate?
- Which forms and popups collect the most contacts?
- Do we reply quickly to people who write in?
Each question becomes a row of the dashboard. If a widget doesn't answer any of them, drop it.
What data can you combine?
| Source | What it holds | Example question |
|---|---|---|
| Web sessions | One row per session: domain, landing page, UTMs, referrer, device, duration, bounce | Which campaigns bring longer sessions? |
| Page views | Views per day, domain and page, with the page title | Which pages are growing this month? |
| Web events | Events per day and name (CTA clicks, leads, scroll...) | How often is the demo button clicked? |
| Detected forms | Submissions per form and views of the page | Which form converts best? |
| Landing pages | Visits, CTA clicks, leads and conversion per landing page | Which landing page brings the most leads per visit? |
| Funnels | Your saved funnels, one row per step | Where do people drop off? |
| Contacts with first visit | Contacts with their first source, medium, campaign and landing page | Which channel do new contacts come from? |
| Deals by channel | Deals with their contact's first touch: won value, win rate | Which channel brings the most revenue? |
| Attribution credits | Contacts, deals and revenue credited by source, medium, campaign, landing page or journey | How is credit split across channels? |
| Flowgration forms | Views, submissions, rejected and conversion of your native forms and popups | Which popup works? |
| Inbox statistics | Conversations, answered, first response time per mailbox and assignee | Who replies fastest? |
Session metrics (bounce, duration, unique visitors) only exist in consent mode. If your site runs in cookieless mode, session-based sources stay empty and you get aggregate views and events.
Example dashboard: from visit to sale
A simple layout, top to bottom:
| Row | Widget | Source | Type |
|---|---|---|---|
| 1 | Sessions in the period | Web sessions | KPI with comparison |
| 1 | Leads in the period | Landing pages | KPI |
| 1 | Won revenue | Deals by channel | KPI in euros |
| 1 | Win rate | Deals by channel | KPI in % |
| 2 | Sessions over time | Web sessions | Time series |
| 2 | Leads by landing page | Landing pages | Bar, top 8 |
| 3 | Revenue by first-touch channel | Deals by channel | Sorted bar |
| 3 | Contacts by source | Contacts with first visit | Donut with "Others" |
| 4 | Landing page table | Landing pages | Table sorted by visits |
With that structure you can see at a glance whether traffic arrives, whether it turns into leads and whether those leads become sales. For the purely commercial side, the sales dashboard template completes the picture.
Which templates can you start from?
In the visualizer you can start from a template and adjust it:
- Web traffic: sessions, bounce, average duration, share identified, devices, sources and campaigns.
- Landing performance: visits, CTA clicks, leads and conversion per landing page.
- Lead capture funnel: funnel steps, form conversion and where contacts come from.
- Sales by channel: revenue and win rate by first-touch channel.
- Forms and leads: views, submissions, conversion and rejected submissions of your forms and popups.
- Attribution by channel: contacts, deals and revenue credited with the linear model; the full set of models is in the revenue attribution report.
- Inbox: response times: conversations, answered rate and first response per mailbox and assignee, useful if you run a shared inbox with Gmail.
Each widget has its own style panel (number, currency, percentage or duration format, comparison with the previous period, top N with "Others", targets and colour rules), and you can undo, redo and duplicate widgets.
Who can see data that joins web and CRM?
Purely web sources (traffic, pages, events, landing pages) only show aggregate figures. Sources that join visitors with contacts and deals expose personal data, so they need two permissions: access to the visitors section of web analytics and read access to the CRM. If someone lacks either, those sources don't appear for them. And if your organization limits members to their own records, attribution data respects that limit too.
That's a good reason to review roles before sharing a dashboard with the whole team.
Common mistakes when building the dashboard
- Too many widgets. More than ten or twelve on one screen and nobody reads it.
- Mixing periods. All widgets in a row should use the same date range.
- Comparing channels without UTMs. If your links aren't tagged, almost everything shows as direct.
- Reading conversion on low volume. Ten visits and two leads is not a reliable 20%.
- Expecting it to match another tool. Each tool counts differently; see why GA4 and CRM numbers differ.
Frequently asked questions
Do I need SQL to build these dashboards?
No. You pick a source, a metric, a grouping and a chart type. Templates give you a complete dashboard to edit.
Can I ask the AI assistant to build the dashboard?
Yes. Flowgration includes an AI assistant that can design dashboards and query web data, always with the permissions of the person asking.
Why does the sales by channel dashboard show so much "unattributed"?
Because those contacts have no linked first visit: they arrived without consent, through a channel with no website visit, or before the tracker was installed. Hidden UTM fields on forms narrow that gap.
How often is web data updated?
Events are processed every 5 minutes. Attribution credits are recalculated every night.
How Flowgration does it
In Flowgration web analytics and the CRM share one database, so the visualizer can put sessions, landing pages, funnels, contacts by first visit, deals by channel, attribution and inbox response times on the same dashboard, with templates to get started. More on the web analytics page.
Limits: the link between visits and contacts only exists for visitors who accepted analytics and were identified; session-based sources need consent mode; each query has a row cap to keep dashboards fast; and there are no session recordings. Web analytics starts on the Essential plan and visitor identification on Growth (plans).
Build your WooCommerce CRM in 60 seconds
Flowgration turns your store's orders into a living CRM and runs email, SMS and WhatsApp on autopilot. Free up to 500 contacts.
Start free