Feature
Reference Supabase data in every analysis.
Join marketing performance with product, CRM, and billing tables in Supabase.
Join synced marketing data with product, CRM, or billing tables in Supabase.
Single source of truth
Marketing and product data live in the same Supabase database.
SQL-first analysis
Create views and joins for LTV, ROAS, and cohort reporting.
AI-ready context
Structured tables make analytics and AI workflows reliable.
Preview
Join marketing data with your tables
Write SQL once and combine ad performance with product, CRM, or billing data.
SQL join
SELECT
customers.plan,
SUM(ads.spend) AS spend,
SUM(orders.amount) AS revenue
FROM marketing_ads_daily ads
JOIN customers ON ads.account_id = customers.ad_account_id
JOIN orders ON orders.customer_id = customers.id
WHERE ads.date >= CURRENT_DATE - INTERVAL '30 days'
GROUP BY customers.plan;Result preview
How it works
Sync marketing data
Bring ad performance into Supabase with clean tables.
Join with your tables
Combine marketing data with product or CRM tables in SQL.
Publish trusted views
Create stable views for dashboards and AI prompts.
Use cases
- Attribute revenue to campaigns and channels.
- Build customer cohorts and retention analysis.
- Answer AI questions from a single SQL source.
FAQ
Does LightningSync change my existing tables?
No. LightningSync writes its own tables and leaves your data intact.
Can I build views on top of the data?
Yes. You can create SQL views and transformations in Supabase.
Ready to start syncing?
Connect your first data source and see your tables populate.