Shops & e-commerce
Orders in Stripe, visitors in Google Analytics, stock in a spreadsheet.
- Stripe
- Google Analytics
- Google Sheets
You ask
- How did sales this week compare with last week?
- What are my best sellers this month?
- Which items are under 10 in stock?
Example answer
Sales this week
$8,420
+12.4% vs last week
96 orders · nothing missing
Where it came from
sourceStripe · charges
SELECT SUM(amount) / 100, COUNT(*)
FROM stripe.charges
WHERE created ≥ Mon AND status = 'succeeded'96 orders · nothing missing