Snowflake
Answers from Snowflake for sales, finance and operations alike.
Dot picks the right tables, writes the SQL and shows it beside every answer.
Sarah Chen9:41 AM
@Dot What was our net revenue retention by segment last quarter, and which accounts drove the change?
1 reply
DotAPP9:42 AM
4 steps · 20s · Access Online
NRR was 112%. Enterprise led at 121%, with three accounts adding $1.4M in expansion.
Sources: Snowflake’s fct_revenue and dim_accounts.
Chart
Today
Sarah Chen9:41 AM
Dot What was our net revenue retention by segment last quarter, and which accounts drove the change?
Dot9:42 AM
4 steps · 20s · Access online
NRR was 112%. Enterprise led at 121%, with three accounts adding $1.4M in expansion.
Sources: Snowflake’s fct_revenue and dim_accounts.
Ryan Ortiz9:41 AM
@Dot Which industries have our shortest sales cycle this year, and how big are their deals?
1 reply
DotAPP9:42 AM
10 steps · 53s · Access Online
Healthcare: 41 days, and the largest deals too.
Source: Snowflake’s fct_opportunities.
Here is the data.
| Industry | Sales cycle | Average deal |
|---|---|---|
| Healthcare | 41 days | $86K |
| Software | 58 days | $74K |
| Retail | 90 days | $52K |
Today
Ryan Ortiz9:41 AM
Dot Which industries have our shortest sales cycle this year, and how big are their deals?
Dot9:42 AM
10 steps · 53s · Access online
Healthcare: 41 days, and the largest deals too.
Source: Snowflake’s fct_opportunities.
- Healthcare: 41 days sales cycle, $86K average deal
- Software: 58 days sales cycle, $74K average deal
- Retail: 90 days sales cycle, $52K average deal
Priya Shah9:41 AM
@Dot Did rainy weekends hurt our store sales this summer? Use the weather data we get from Snowflake Marketplace.
1 reply
DotAPP9:42 AM
6 steps · 35s · Access Online
Yes. Rainy weekend days sold 14% less, mostly in garden and outdoor.
Sources: Snowflake’s store_sales and weather.daily.
Chart
Today
Priya Shah9:41 AM
Dot Did rainy weekends hurt our store sales this summer? Use the weather data we get from Snowflake Marketplace.
Dot9:42 AM
6 steps · 35s · Access online
Yes. Rainy weekend days sold 14% less, mostly in garden and outdoor.
Sources: Snowflake’s store_sales and weather.daily.
More in Databases & spreadsheets
BigQuery
Redshift
Postgres
AWS Athena
Databricks SQL
Microsoft SQL
MySQL
MotherDuck
Connect your data.
Start for Free