Send data from Facebook Ads to Redshift
Get started for free
No credit card required | 14 days | 10 million records | 30 pipelines
or sign up with your email
By signing up, you agree to Kondado’s Terms of service and Privacy policy
Replicate Facebook Ads Data to Redshift
Kondado provides a direct connection that moves your advertising metrics from Facebook Ads to Amazon Redshift without requiring engineering resources or complex ETL scripts. You simply authenticate your Meta advertising account through the standard OAuth flow, configure which data pipelines to activate from the 14 available options covering campaigns, ads, and lead forms, and set your preferred update frequency from every five minutes to daily intervals. This no-code approach allows marketing analysts and data teams to centralize campaign performance data for advanced analytics, custom attribution modeling, and cross-channel reporting alongside other business data sources.
Once configured, your Redshift warehouse receives fresh advertising data automatically, ready for SQL queries and visualization in your preferred business intelligence tools.
Kondado replicates Facebook Ads data to Redshift on a configurable schedule, offering 14 distinct pipelines including Campaign Performance, Ad Performance, and Lead Forms that deliver 1,569 fields directly to your data warehouse. The platform updates data automatically based on your configured timing, enabling automated reporting workflows without manual CSV exports or ongoing API maintenance.
Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required
Available Facebook Ads Pipelines
The Campaign Performance and Ad Performance pipelines deliver granular advertising metrics directly into your Redshift warehouse, allowing analysts to calculate true ROAS by joining Facebook spend with internal sales data from other sources. You can evaluate creative effectiveness through detailed impressions, clicks, and cost-per-click analysis, while monitoring account-level health and budget allocation with the Ad Account Performance pipeline.
For lead generation teams, the Lead Forms pipeline captures submission data and form field responses, enabling automated nurture workflows and lead quality scoring models built entirely in SQL. Combined with Page Metrics and Post Metrics, marketing teams can analyze organic versus paid performance holistically, creating unified dashboards that track the complete customer journey from social engagement to final conversion.
Try out all the features for free for 14 days
Facebook Ads data available for Redshift
Available integrations
| Integration | Description |
|---|---|
| Ad account performance | Analyze account performance with metrics such as total spend, account status, and age of the account. |
| Ad accounts | View information on ad accounts, including name, account ID, and account status. |
| Ad metadata | Explore ad details such as ad ID, account ID, and ad set name. |
| Ad performance | Evaluate ad performance with metrics such as impressions, clicks, and cost per click. |
| Ad preview | Preview ads including creative content and targeting settings. |
| Ad set performance | Analyze ad set performance with metrics such as impressions, clicks, and total cost. |
| Adset metadata | Examine ad set metadata including ID, name, and status. |
| Campaign metadata | View campaign metadata such as campaign ID, name, and status. |
| Campaign performance | Analyze campaign performance with metrics such as impressions, clicks, and cost per acquisition. |
| Lead forms | Examine lead forms including fields, status, and captured data. |
| Page Metrics | Analyze impressions, clicks, and engagement of the page, including fields like page name, business city, and account status. |
| Page: Posts | Examine post performance with metrics such as impressions, clicks, post ID, and ad set name. |
| Pages | Provides information about pages, including business name, address, and account status, allowing an overview of operations. |
| Post Metrics | Evaluate post performance with metrics such as clicks, impressions, and cost, along with ad ID and ad set ID. |
Try out all the features for free for 14 days
How to send Facebook Ads data to Redshift
Sync data automatically — no code, no manual exports.
Connect Facebook Ads Data Source
Authenticate your Facebook Ads account through Kondado's guided OAuth setup to establish the data source connection. Select your ad accounts and grant permissions for the platform to access campaign metadata and performance metrics.
Configure Redshift Destination
Enter your Amazon Redshift cluster credentials including host, port, database name, and user authentication details. Kondado automatically tests the connection and prepares the destination schema for incoming advertising data.
Select Pipelines and Schedule
Choose from the 14 available pipelines such as Campaign Performance and Lead Forms, then configure your update schedule from five minutes to daily intervals. Activate the replication to begin automated data transfers that keep your Redshift warehouse synchronized with your current advertising data.
Try out all the features for free for 14 days
Hundreds of data-driven companies trust Kondado
'%3E%3Cpath d='M51,41a9.978,9.978,0,0,0-7.857,3.835L22.648,34.588a9.69,9.69,0,0,0,0-5.176l20.5-10.247a10.1,10.1,0,1,0-1.791-3.577L20.857,25.835a10,10,0,1,0,0,12.33L41.352,48.412A9.994,9.994,0,1,0,51,41Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M33,47.645V60.71c.024-.014.05-.018.073-.033l11-7A2,2,0,0,0,45,51.992V40.012Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M31,47.645,19,40.011V51.992a2,2,0,0,0,.927,1.688l11,7c.023.015.049.019.073.033Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M32,21.693l12-7.634L33.076,7.086a2,2,0,0,0-2.152,0L20,14.059Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M12,35.556,0,27.922V39.9A2,2,0,0,0,.927,41.59l11,7c.023.014.049.019.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M52,35.556l12-7.634V39.9a2,2,0,0,1-.927,1.687l-11,7c-.023.014-.049.019-.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M47,38.914a2,2,0,0,0-.924-1.686L38,32.074V27.922l12,7.634V48.621c-.024-.014-.05-.019-.073-.033L47,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M13,33.821l12-7.634L14.076,19.214a2,2,0,0,0-2.152,0L1,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M17,38.914a2,2,0,0,1,.924-1.686L26,32.074V27.922L14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M32,45.91l12-7.634L33.076,31.3a2,2,0,0,0-2.152,0L20,38.276Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M14.076,19.214a2,2,0,0,0-2.152,0L1,26.187l12,7.634,12-7.634Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M49.924,19.214a2,2,0,0,1,2.152,0L63,26.187,51,33.821,39,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M26,27.922,14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726V38.914a2,2,0,0,1,.924-1.686L26,32.074Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M27.076,25.138A2,2,0,0,1,28,26.824V30.8l1.848-1.179A4,4,0,0,1,31,29.123V23.428L19,15.794v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M36.924,25.138A2,2,0,0,0,36,26.824V30.8l-1.848-1.179A4,4,0,0,0,33,29.123V23.428l12-7.634v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M33.076,31.3a2,2,0,0,0-2.152,0L20,38.276,32,45.91l12-7.634Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M50.348,42.573c0-9.411-8.691-12.336-16.348-14.416v-16.1a32.837,32.837,0,0,1,9.363,1.656l2.778,1.11,2.228-5.57L45.584,8.134A38.043,38.043,0,0,0,34,6.046V1H30V6.081c-8.213.594-16.348,4.86-16.348,13.471,0,9.036,8.841,11.732,16.348,13.744V50.074a33.591,33.591,0,0,1-12.006-2.511l-2.683-1.341-2.684,5.367,2.684,1.342c.243.121,5.7,2.792,14.689,3.152V63h4V56.065C44,55.462,50.348,50.3,50.348,42.573Zm-30.7-23.021c0-5.133,5.96-7.016,10.348-7.446V27.071C23.512,25.243,19.652,23.535,19.652,19.552ZM34,50.043V34.393c6.5,1.882,10.348,3.761,10.348,8.18C44.348,48.377,37.873,49.744,34,50.043Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
