YouTube Ads → SupabaseYouTube Ads data in Supabase.
Updated automatically.
Sync video campaign performance into Supabase and query view rates, completion metrics, CPV, spend, and conversions without exports.
select date,
campaign_name,
sum(video_views) as video_views,
round(sum(cost_micros)::numeric / 1000000, 2) as spend_usd,
round(avg(video_quartile_p100_rate) * 100, 1) as avg_completion_rate_pct
from ytads_campaigns_daily
where date >= current_date - interval '30 days'
group by 1, 2
order by date desc
limit 25;spend_usd is derived from cost_micros (divide by 1,000,000).
Automated and safe extracting of marketing data
LightningSync replaces manual CSVs exports and broken Python scripts with automated connectors, set up through official logins, that bring your sales and marketing data into one place, so your analytics and reporting stays updated, reliable, and unified.
Official Integration Logins
Connect ad + analytics platforms using official sign-in. We refresh tokens automatically so syncs don’t break.
Real-time, Daily, Hourly, or Custom Syncs
Set up schedules once, keep your data in sync automatically forever. No more switching between platforms to manually export CSVs or run scripts that break easily.
Unified Marketing Schema
Normalize metrics into clean tables so you can query cross-channel performance with standard SQL.
Sync Monitoring
See run history, rows synced, and errors so you can trust what landed before you report on it.
Alerts + Webhooks
Get notified when a sync fails or when data is late. Pipe events into Slack, email, or your own systems.
Reporting-Ready Tables
Build dashboards in Retool, Metabase, or SQL. Tables are consistent across platforms and ready to join with your own data.
What you can do with YouTube Ads data
Analyze video campaign performance in SQL, then join it to signups, purchases, or revenue tables in Supabase.
View rate and completion analysis
Track how far people watch and compare completion metrics across campaigns and time windows.
- Quartile completion rates
- View rate vs. impressions
- CPV and efficiency trends
Creative and audience iteration
Find what’s working, then iterate quickly with a stable schema you can reuse across accounts.
- Compare campaigns by theme
- Spot fatigue early
- Build reusable dashboards
CAC and payback for video
Join spend to downstream outcomes so you can measure CAC, payback, and ROI by campaign.
- Join to conversions and revenue
- Cohorts by campaign
- Own your attribution logic
From official integration logins to query-ready tables
Connect platforms, sync into Supabase, and monitor every run so your reporting stays reliable.
Connect platforms
Log in with Square, Facebook, Google, Instagram, LinkedIn, and more using official integration logins.
Connect Supabase
Official Supabase Login, select your project, and schedule automated syncs.
Schedule and monitor
Run real-time/hourly/daily syncs, retries, and alerts. Track every run with row counts and timestamps.
Plans for production reporting
Start free. Upgrade when you need scheduled syncs, higher limits, and alerts for production reporting.
Free
Start in minutesGet started and validate your pipeline before you automate everything.
- 100 syncs/month
- 10K records per sync
- 1 ad account
- 30 days history
- Manual syncs
- All integrations
Starter
Secure Stripe billingAutomated syncs, higher limits, and alerts so you can trust the data landed.
- 3K syncs/month
- 300K records per sync
- Unlimited ad accounts
- 365 days history
- Scheduled sync (every 30 mins)
- Webhooks + alerts
- Priority support
- All integrations
Enterprise
Talk to a humanFor teams with strict compliance, custom limits, and dedicated support.
- Custom sync + volume limits
- Dedicated onboarding
- SLA & priority support
- Security review support
- Roadmap alignment
What our first customer says
LightningSync is in early access. Here’s feedback from a team using it to keep marketing reporting reliable in Supabase.
LightningSync helps us keep cross-channel marketing data in Supabase without manual exports, so reporting stays fast and consistent.
Become a design partner
Tell us what you need for your reporting stack. We’ll prioritize the integrations and tables that matter for your workflows.
Take the 30s surveyYouTube Ads FAQ
Common questions about syncing YouTube Ads performance into Supabase.
Does this sync through YouTube or Google Ads?▼
What metrics are included?▼
How are cost and CPV represented?▼
Get your marketing data into Supabase, without the busywork.
Start free with 100 syncs/month. Upgrade when you need scheduled syncs, higher limits, and alerts.
Shape our roadmap & get early access
Tell us what you need for reporting. We’ll prioritize the integrations, tables, and workflows that matter.
Step 1 of 4