Looker
Answers that run through your LookML, so numbers match Looker.
Dot also reads your dashboards and saved Looks.
David Mensah9:41 AM
@Dot What’s our repeat purchase rate by acquisition channel this year?
1 reply
DotAPP9:42 AM
9 steps · 50s · Access Online
28%, by your explore’s repeat-buyer measure. Referral customers return most, at 39%.
Source: Looker’s ecommerce.orders.
Chart
Today
David Mensah9:41 AM
Dot What’s our repeat purchase rate by acquisition channel this year?
Dot9:42 AM
9 steps · 50s · Access online
28%, by your explore’s repeat-buyer measure. Referral customers return most, at 39%.
Source: Looker’s ecommerce.orders.
Sarah Chen9:41 AM
@Dot Why does the Active Customers tile on the Exec dashboard differ from my number?
1 reply
DotAPP9:42 AM
5 steps · 37s · Access Online
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
Sarah Chen9:41 AM
Dot Why does the Active Customers tile on the Exec dashboard differ from my number?
Dot9:42 AM
5 steps · 37s · Access online
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
Ryan Ortiz9:41 AM
@Dot Run our At-Risk Accounts Look and add each account’s usage trend.
1 reply
DotAPP9:42 AM
9 steps · 53s · Access Online
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
Ryan Ortiz9:41 AM
Dot Run our At-Risk Accounts Look and add each account’s usage trend.
Dot9:42 AM
9 steps · 53s · Access online
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
More in Semantic layers
Power BI
dbt
Cube
Steep
Malloy
Azure Analysis Services
Connect your data.
Start for Free