Lens Explorer
Lens Explorer is the interactive data-exploration tool inside Salesforce CRM Analytics (formerly Tableau CRM, originally Einstein Analytics, originally Wave Analytics).
Definition
Lens Explorer is the interactive data-exploration tool inside Salesforce CRM Analytics (formerly Tableau CRM, originally Einstein Analytics, originally Wave Analytics). A Lens is an ad-hoc visualization of a dataset; the Lens Explorer is the no-code interface that lets analysts build the lens by dragging fields onto chart shelves, filtering data, drilling into subsets, and pivoting groupings. Lenses can be saved, embedded in dashboards, exported, or kept as throwaway exploration sessions.
The Lens Explorer is the workhorse tool for self-service analytics in CRM Analytics. Power users open a dataset, build a lens to answer one question (revenue by region, conversion rate by source, churn by tenure), save it for repeat use, and move on. Lenses are the building blocks of dashboards; an analyst designs a dashboard by composing multiple saved lenses on a single canvas. Salesforce''s strategic direction has moved the broader analytics conversation toward Tableau and Tableau Pulse, but the Lens Explorer remains the native exploration tool inside CRM Analytics for orgs invested in the platform.
How Lens Explorer powers ad-hoc analytics in CRM Analytics
Lens as visualization unit
A Lens is a saved query plus a visualization configuration against a single dataset. The lens stores the SAQL or JSON query, the chart type (bar, line, donut, table, heat map, scatter), and the field-shelf bindings. Opening the lens re-runs the query and renders the chart with current data. Lenses are the unit of analytics composition in CRM Analytics.
The Explorer interface
The Explorer is the no-code authoring environment. Analysts pick a dataset, see all available fields, drag fields onto the chart shelves (Bars, Stacks, Color, Size, Pages), and the platform builds the visualization. Filters apply to all subsequent operations; grouping pivots the data. Every interaction updates the underlying SAQL query.
SAQL and the underlying query
The Lens Explorer compiles every user interaction into SAQL (Salesforce Analytics Query Language), the platform''s analytics query language. Advanced users can switch to SAQL mode and write the query directly, accessing features the Explorer UI does not expose. Most lenses live entirely in Explorer mode; SAQL is the escape hatch for complex needs.
Datasets, dataflows, and the data layer
Lenses query datasets, which are the snapshotted-and-shaped data tables that CRM Analytics builds from Salesforce data, external sources, or both. Dataflows refresh datasets on a schedule. The dataset structure determines what fields the lens can use and how performant the queries are; bad dataset design produces slow lenses.
From Lens to Dashboard
Lenses are the building blocks of CRM Analytics dashboards. Designers compose multiple saved lenses on a single canvas, configure interactions (one lens filters the others), and publish the dashboard. The lens is the data view; the dashboard is the composed experience.
Sharing and collaboration
Lenses can be shared with other CRM Analytics users via the standard Salesforce sharing model. The lens definition is shareable; users with access see the chart and the underlying query but inherit only the datasets they have permission to. Sharing scales well within a CRM Analytics tenant.
Tableau and the strategic direction
Salesforce acquired Tableau in 2019 and has been investing heavily in Tableau as the long-term analytics platform. CRM Analytics still ships as a Salesforce-native option, but Tableau is the broader-market strategic direction. Customers planning new analytics deployments should evaluate Tableau alongside CRM Analytics; existing CRM Analytics customers continue to use Lens Explorer with no near-term replacement.
Build a Lens in CRM Analytics
Lens authoring is the fastest path from raw data to a question answered. Most lenses come together in five minutes.
- Open the dataset
Analytics Studio, find the target dataset, click Explore. The Lens Explorer opens with the dataset selected.
- Pick the measure
The measure is the value to display (Sum of Amount, Count of Records, Average of Age). Drag from the field panel onto the Bars shelf.
- Add groupings
Drag categorical fields (Region, Industry, Stage) onto the Bars shelf to group the measure. The chart updates immediately.
- Add filters
Drag a field onto the Filter shelf or use the Filter button. Common filters: this quarter, this year, specific values.
- Pick the right chart type
Bar for category comparison, line for trends, donut for share-of-whole. The Explorer suggests defaults based on the field types.
- Save the Lens
Click Save. Name the lens descriptively. The lens is now reusable in dashboards and shareable with the team.
The underlying data the lens queries.
The numeric value to display.
Categorical fields that pivot the measure.
Scope the lens to the relevant subset.
Visualization shape that matches the data structure.
- Lens performance depends on dataset design. Slow datasets produce slow lenses regardless of the lens-level configuration.
- SAQL mode unlocks features Explorer UI does not expose. Saving a SAQL-mode lens prevents future edits in Explorer mode; switching back can lose unsaved changes.
- Sharing lenses requires sharing the underlying dataset. A shared lens against a dataset the recipient cannot access shows an error, not the chart.
- Tableau is the long-term strategic direction. New analytics investments should consider Tableau alongside CRM Analytics.
Trust & references
Cross-checked against the following references.
- Explore Data with LensesSalesforce Help
- CRM Analytics OverviewSalesforce Help
Straight from the source - Salesforce's reference material on Lens Explorer.
- SAQL ReferenceSalesforce Developers
About the Author
Dipojjal Chakrabarti is a B2C Solution Architect with 29 Salesforce certifications and over 13 years in the Salesforce ecosystem. He runs salesforcedictionary.com to help admins, developers, architects, and cert/interview candidates sharpen their fundamentals. More about Dipojjal.
Test your knowledge
Q1. What is Lens Explorer?
Q2. What's the workflow that Lens Explorer fits into?
Q3. When should you build a dashboard versus stay in Lens Explorer?
Discussion
Loading discussion…