Pull all your data — from Google to Bing to your social media — into one place that stays in sync. Ask questions in plain English, or plug it into ChatGPT, Claude, and your AI agents so they answer with your real numbers.
how did paid acquisition compare to organic in q2, by repeat revenue?
Organic search drove 2.2× higher 90d LTV than paid channels. Display fell out of profitability; reallocate to organic + email.
| channel | new | repeat £ | 90d LTV | ret. |
|---|---|---|---|---|
| organic | 4,812 | £284k | £2,140 | |
| 2,988 | £167k | £1,590 | ||
| paid social | 3,201 | £198k | £1,720 | |
| display | 887 | £41k | £980 |
WITH channel_revenue AS (
SELECT ga.source AS channel,
COUNT(DISTINCT o.customer_id) AS new_customers,
SUM(o.revenue) AS repeat_rev,
AVG(l.ltv_90d) AS ltv_90d
FROM ga4.sessions ga
JOIN shopify.orders o USING (customer_id)
JOIN klaviyo.ltv l USING (email)
WHERE o.created_at BETWEEN '2024-04-01' AND '2024-06-30'
GROUP BY ga.source
)Wire in your ads, analytics, commerce, search, SEO, email and video stack with OAuth. Everything stays fresh; everything stays queryable.
The chat sits on top of every connector you've wired in. Plain English in, markdown + tables + the SQL it ran out — every time.
Type the question. We plan across sources, write the joins, surface the SQL.
Every answer formatted for humans and agents. Read it, edit the query, hand it off.
Live usage indicators — green, amber, red. One-click top-ups, no hidden bills.
Generate a token, plug your agent in. They call 1stli like a function.
show me Q2 acquisition channels ranked by 90-day LTV, with retention curves and total repeat revenue.
Organic search and email lead on retention. Display has fallen below your blended payback target — 2.2× LTV gap vs. display.
| channel | new | repeat £ | 90d LTV | retention |
|---|---|---|---|---|
| organic | 4,812 | £284k | £2,140 | |
| 2,988 | £167k | £1,590 | ||
| paid social | 3,201 | £198k | £1,720 | |
| display | 887 | £41k | £980 |
SELECT ga.source, SUM(o.revenue) AS repeat_rev
FROM ga4.sessions ga
JOIN shopify.orders o USING (customer_id)
WHERE o.created_at BETWEEN '2024-04-01' AND '2024-06-30'
GROUP BY ga.source ORDER BY repeat_rev DESCOAuth into your stack. Ads, analytics, commerce, search, SEO, email, video — wired in and queryable.
~ 90 seconds per sourceType your question. 1stli writes the SQL, joins the sources, returns markdown + tables.
no sql required, sql includedMCP-ready by default. Your agents call your workspace like a function. Audit every join.
mcp · bring your own agent"We deleted four reporting tools the week we onboarded. Our LTV question, answered in 18 seconds, used to take a sprint."
"As an agency we run 22 clients in 1stli. Same prompt, twenty-two workspaces, twenty-two answers. The economics broke our spreadsheet."
"The SQL transparency is what sold engineering. Our agents call it like a function and we can audit every join. Blended CAC fell 28%."
Generous free credits across three live sources. No card, no sales call, no warehouse to provision. Bring your stack — and your agents.