Looker
Answers that run through your LookML, so numbers match Looker.
Dot also reads your dashboards and saved Looks.
Ryan Ortiz9:41 AM
@Dot What’s our repeat purchase rate by acquisition channel this year?
1 reply
Dot9:42 AM
28%, by your explore’s repeat-buyer measure. Referral customers return most, at 39%.
Source: Looker’s ecommerce.orders.
Today
Ryan Ortiz9:41 AM
Dot What’s our repeat purchase rate by acquisition channel this year?
Dot9:42 AM
28%, by your explore’s repeat-buyer measure. Referral customers return most, at 39%.
Source: Looker’s ecommerce.orders.
Priya Shah9:41 AM
@Dot Why does the Active Customers tile on the Exec dashboard differ from my number?
1 reply
Dot9:42 AM
The tile counts the last 28 days and leaves out trials. You used the calendar month.
Source: Looker’s Exec dashboard.
Here is the data.
| Active customers | Count |
|---|---|
| Exec dashboard tile | 8,412 |
| Your number | 9,050 |
| Trials and extra days | 638 |
Today
Priya Shah9:41 AM
Dot Why does the Active Customers tile on the Exec dashboard differ from my number?
Dot9:42 AM
The tile counts the last 28 days and leaves out trials. You used the calendar month.
Source: Looker’s Exec dashboard.
- Exec dashboard tile: 8,412 count
- Your number: 9,050 count
- Trials and extra days: 638 count
Daniel Weber9:41 AM
@Dot Run our At-Risk Accounts Look and add each account’s usage trend.
1 reply
Dot9:42 AM
14 accounts are at risk. Nine have used the product less every month since June.
Sources: Looker’s At-Risk Accounts and usage.
Here is the data.
| Account | Usage since June |
|---|---|
| Kestrel | −34% |
| Orbit | −21% |
| Lumen | +4% |
Today
Daniel Weber9:41 AM
Dot Run our At-Risk Accounts Look and add each account’s usage trend.
Dot9:42 AM
14 accounts are at risk. Nine have used the product less every month since June.
Sources: Looker’s At-Risk Accounts and usage.
- Kestrel: −34% usage since June
- Orbit: −21% usage since June
- Lumen: +4% usage since June
How GetDot works with Looker
How Dot queries Looker
Dot syncs your LookML models and explores: dimensions, measures, filter-only fields and parameters, with their descriptions.
To answer, Dot writes an explore query and Looker compiles it to SQL from your LookML, joins and measures included, then runs it on Looker’s own database connection, so Dot needs no warehouse credentials for it. Explore default filters and parameter defaults stay in force, and the Query tab links to the same query in Looker.
Permissions and row-level security
Reading dashboards, Looks, explores and folders is on by default. Creating, editing or deleting content, and managing users or schedules, stays off until an admin turns it on.
LookML access_filters carry over. Dot mirrors each explore’s access filters into its own row-level rules (Team plan), with each person’s user attribute values, like region, synced from Looker. A person with no value is denied rather than shown everything.
Only the explores and fields turned on in Dot can be queried, by anyone, admins included.
Dot and Conversational Analytics in Looker
As of October 2026, Google’s Conversational Analytics in Looker, part of Gemini in Looker, is generally available on Looker-hosted instances. It answers from your explores, combines up to five in one question, explains each calculation and lets you share agents; Looker’s release notes list data agents for LookML dashboards as generally available in October 2026.
Choose it when your people live inside Looker and their questions fit your explores. Choose Dot when they ask in Slack, Teams or email, want the report written for them on a schedule, or ask about data nobody got around to modeling in LookML.
Questions
More in Semantic layers
Malloy
Power BI
dbt
Cube
Steep
Azure Analysis Services
Connect your data.
Start for Free