Redshift
Every team gets answers from Redshift, without waiting on an analyst.
Dot turns each question into Redshift SQL and shows its work.
Priya Shah9:41 AM
@Dot Which products get returned most this quarter, and why?
1 reply
DotAPP9:42 AM
7 steps · 36s · Access Online
Slim-fit jeans: 24% come back, against 9% on average.
Sources: Redshift’s returns and order_items.
Here is the data.
| Product | Returned | Top reason |
|---|---|---|
| Slim-fit jeans | 24% | Sizing |
| Linen shirt | 17% | Color |
| Rain jacket | 14% | Sizing |
Today
Priya Shah9:41 AM
Dot Which products get returned most this quarter, and why?
Dot9:42 AM
7 steps · 36s · Access online
Slim-fit jeans: 24% come back, against 9% on average.
Sources: Redshift’s returns and order_items.
- Slim-fit jeans: 24% returned, Sizing
- Linen shirt: 17% returned, Color
- Rain jacket: 14% returned, Sizing
Daniel Weber9:41 AM
@Dot Which customers bought in last year’s holiday season but haven’t ordered since?
1 reply
DotAPP9:42 AM
8 steps · 45s · Access Online
4,860 customers, who spent $1.1M last holiday season.
Sources: Redshift’s orders and customers.
Today
Daniel Weber9:41 AM
Dot Which customers bought in last year’s holiday season but haven’t ordered since?
Dot9:42 AM
8 steps · 45s · Access online
4,860 customers, who spent $1.1M last holiday season.
Sources: Redshift’s orders and customers.
Lisa Park9:41 AM
@Dot Which email campaign earns the most per send?
1 reply
DotAPP9:42 AM
4 steps · 21s · Access Online
‘Back in stock’: $0.42 per send, four times the newsletter.
Sources: Redshift’s email_sends and orders.
Chart
Today
Lisa Park9:41 AM
Dot Which email campaign earns the most per send?
Dot9:42 AM
4 steps · 21s · Access online
‘Back in stock’: $0.42 per send, four times the newsletter.
Sources: Redshift’s email_sends and orders.
More in Databases & spreadsheets
Snowflake
BigQuery
Postgres
AWS Athena
Databricks SQL
Microsoft SQL
MySQL
MotherDuck
Connect your data.
Start for Free