Firebolt
Firebolt’s speed for everyone, not only the people who write SQL.
Dot writes the Firebolt SQL; your engine does the rest.
Ryan Ortiz9:41 AM
@Dot Which search terms returned no results most often on our site today?
1 reply
DotAPP9:42 AM
9 steps · 47s · Access Online
‘Wireless earbuds case’ leads with 3,400 empty searches. Another 41 terms passed 500.
Source: Firebolt’s search_events.
Here is the data.
| Search term | Empty results |
|---|---|
| wireless earbuds case | 3,400 |
| usb c hub 8 port | 1,960 |
| standing desk mat | 1,210 |
Today
Ryan Ortiz9:41 AM
Dot Which search terms returned no results most often on our site today?
Dot9:42 AM
9 steps · 47s · Access online
‘Wireless earbuds case’ leads with 3,400 empty searches. Another 41 terms passed 500.
Source: Firebolt’s search_events.
- wireless earbuds case: 3,400 empty results
- usb c hub 8 port: 1,960 empty results
- standing desk mat: 1,210 empty results
Priya Shah9:41 AM
@Dot How many of our payments failed in the last 24 hours, by card network and reason?
1 reply
DotAPP9:42 AM
5 steps · 26s · Access Online
1.6% failed, most for insufficient funds on Visa debit.
Source: Firebolt’s payments.
Here is the data.
| Network | Reason | Failed |
|---|---|---|
| Visa debit | Insufficient funds | 4,210 |
| Mastercard | Do not honor | 1,880 |
| Visa credit | Expired card | 1,140 |
Today
Priya Shah9:41 AM
Dot How many of our payments failed in the last 24 hours, by card network and reason?
Dot9:42 AM
5 steps · 26s · Access online
1.6% failed, most for insufficient funds on Visa debit.
Source: Firebolt’s payments.
- Visa debit: Insufficient funds, 4,210 failed
- Mastercard: Do not honor, 1,880 failed
- Visa credit: Expired card, 1,140 failed
Daniel Weber9:41 AM
@Dot Who were our top advertisers by spend this week, and how did their cost per click change?
1 reply
DotAPP9:42 AM
9 steps · 47s · Access Online
The top five spent $1.9M. Cost per click rose 8% for three of them.
Source: Firebolt’s ad_events.
Here is the data.
| Advertiser | Spend | Cost per click |
|---|---|---|
| Northline | $520K | +8% |
| Velo | $410K | +8% |
| Arcadia | $380K | −2% |
Today
Daniel Weber9:41 AM
Dot Who were our top advertisers by spend this week, and how did their cost per click change?
Dot9:42 AM
9 steps · 47s · Access online
The top five spent $1.9M. Cost per click rose 8% for three of them.
Source: Firebolt’s ad_events.
- Northline: $520K spend, +8% cost per click
- Velo: $410K spend, +8% cost per click
- Arcadia: $380K spend, −2% cost per click
More in Databases & spreadsheets
Snowflake
BigQuery
Redshift
Postgres
AWS Athena
Databricks SQL
Microsoft SQL
MySQL
Connect your data.
Start for Free