LightningSync
LightningSync
IntegrationsMeta Ads
Meta logoMeta Ads → Supabase

Meta Ads data in Supabase.
Updated automatically.

Sync Facebook + Instagram Ads performance into clean Postgres tables in Supabase. Query spend, impressions, clicks, and results without manual exports.

Start Syncing Free View demo
Official Meta OAuthQuery-ready tablesStart syncing in minutes
LightningSync
How it works
Step 1 of 4Auto
LightningSync
Dashboard
Setup
Sync
Data

Select a source

Step 1 of 4
Square OrdersSquare Orders
Connect
Meta AdsMeta Ads
Connect →
Google AdsGoogle Ads
Connect
TikTok AdsTikTok Ads
Connect
LinkedIn AdsLinkedIn Ads
Connect
GA4GA4
Connect
Features

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.

Facebook Ads
Connected
Square Seller Data
Connected
Instagram Ads
Connected
LinkedIn Ads
Available
Google Ads
Connected
YouTube Ads
Available

Official Integration Logins

Connect ad + analytics platforms using official sign-in. We refresh tokens automatically so syncs don’t break.

Backfill
Daily
Hourly
Incremental

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.

marketing_ads_daily
datedate
platformtext
campaign_idtext
spendnumeric
impressionsint
clicksint

Unified Marketing Schema

Normalize metrics into clean tables so you can query cross-channel performance with standard SQL.

Meta Ads → Supabasesuccess
Square Seller Data → Supabaserunning
Google Ads → Supabaseretrying

Sync Monitoring

See run history, rows synced, and errors so you can trust what landed before you report on it.

POST /webhook
{
event: "sync.failed",
source: "facebook_ads",
run_id: "run_84a…"
}

Alerts + Webhooks

Get notified when a sync fails or when data is late. Pipe events into Slack, email, or your own systems.

Platform
Spend
Clicks
Conv.
ROAS
meta
$3.2k
8.1k
214
2.8
google
$2.1k
5.4k
176
3.1
tiktok
$0.9k
2.8k
71
2.2

Reporting-Ready Tables

Build dashboards in Retool, Metabase, or SQL. Tables are consistent across platforms and ready to join with your own data.

Use cases

What you can do with Meta Ads data

Use SQL to answer performance questions fast, then join Meta Ads with the rest of your business data in Supabase.

Cross-channel reporting

Join Meta Ads with Google Ads, GA4, and Search Console to see blended spend and conversions in one place.

  • Unified spend + conversion views
  • Channel mix and budget pacing
  • One schema across platforms

Creative performance & fatigue

Track results by campaign/ad set/ad to spot winners early and catch performance decay before it hits CAC.

  • Creative and placement breakdowns
  • Trend spend, CTR, and CPA
  • Faster iteration loops

CAC and LTV by campaign

Blend ad spend with your product or CRM tables to measure CAC, payback, and LTV cohorts by campaign.

  • Join to signups and revenue
  • Cohort analysis in SQL
  • Own your attribution logic
How it works

From official integration logins to query-ready tables

Connect platforms, sync into Supabase, and monitor every run so your reporting stays reliable.

01

Connect platforms

Log in with Square, Facebook, Google, Instagram, LinkedIn, and more using official integration logins.

02

Connect Supabase

Official Supabase Login, select your project, and schedule automated syncs.

03

Schedule and monitor

Run real-time/hourly/daily syncs, retries, and alerts. Track every run with row counts and timestamps.

supabase-sql-editor
step_01.sql
-- Official login connected successfully
select name, status
from integrations
where user_id = current_user;
_
Pricing

Plans for production reporting

Start free. Upgrade when you need scheduled syncs, higher limits, and alerts for production reporting.

Free

Start in minutes

Get started and validate your pipeline before you automate everything.

$0
Free forever
Start Syncing Free
  • 100 syncs/month
  • 10K records per sync
  • 1 ad account
  • 30 days history
  • Manual syncs
  • All integrations
Most popular

Starter

Secure Stripe billing

Automated syncs, higher limits, and alerts so you can trust the data landed.

$15/month
Billed monthly
  • 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 human

For teams with strict compliance, custom limits, and dedicated support.

Custom
Custom contract & SLA
Contact Sales
  • Custom sync + volume limits
  • Dedicated onboarding
  • SLA & priority support
  • Security review support
  • Roadmap alignment
Cancel anytime. No questions asked.Free tier includes all integrations.Your data stays in your Supabase.
Customer story

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.

In use at
Ascentium Digital
“

LightningSync helps us keep cross-channel marketing data in Supabase without manual exports, so reporting stays fast and consistent.

Andy
CEO, Ascentium Digital
Get early access
Want to be next?

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 survey
FAQ

Meta Ads FAQ

Common questions about syncing Meta Ads into Supabase.

What data does the Meta Ads integration sync?▼
It syncs reporting-ready performance data (spend, impressions, clicks, and results where available) with identifiers for accounts, campaigns, ad sets, and ads so you can group and filter in SQL.
What permissions do you request from Meta?▼
LightningSync connects via Meta OAuth and requests read access needed for reporting. We never create, edit, or pause campaigns from your account.
How do you handle backfills and delayed conversions?▼
On first connect, LightningSync backfills available history. After that, it re-syncs recent dates to capture late-attributed conversions and edits, so your dashboards stay accurate.
Get started

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.

Start Syncing Free View demoView integrations

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

How do you currently get Meta Ads data into your database?