Connector

Send Facebook Ads data to AWS Redshift

Facebook and Instagram ad performance as Redshift tables you own: ads, creatives and insights, each its own table, refreshed on a schedule. Join them to web analytics and CRM to see which ads bring customers and revenue.

Facebook AdsConnectedAdAd AccountAd Account UserAd Creatives
Data MartPublishedone definition
AWS RedshiftDateCostClicksDaily 09:00
Refreshed on a schedule. No exports, no copy-paste.

Get Started Free

Hand this to your AI

Facebook says what its ads delivered, and your AWS Redshift tables can't confirm it because the spend isn't there.

Paste this into your AI assistant. It creates a Facebook Ads Data Mart on your AWS Redshift storage and loads ads, creatives and insights as tables you own, refreshed on a schedule.

The prompt

load Facebook Ads insights into AWS Redshift daily and build a Data Mart that joins spend by ad to website sessions and CRM revenue, so I can rank ads by revenue, not by purchase ROAS

Endpoints

Facebook Ads Endpoints

Documentation

15 Facebook Ads endpoints you can import. Each lands in its own table in your data warehouse.

S00 · Why

Why join Facebook Ads with web analytics and CRM in AWS Redshift

Ads Manager reports delivery using Meta's own attribution. Which ads produced customers and revenue is a question for your data: spend has to sit beside website touch points and CRM deals in one data warehouse.

  • Place Facebook spend beside Google, TikTok and Microsoft in one Redshift database
  • Link clicks and sign-ups to the orders and deals they became
  • Store spend, reach and ROAS in your AWS account, outside any ad account
Facebook AdsAd spend, reach
Web analyticsVisits, sign-ups
CRMDeals
Your data warehouseAWS RedshiftAdTouch pointDealJoined by idAd seen or clickedDeal months onOne query joins ad to deal.

S01 · Step 1

Step 1: Pick Facebook Ads and the fields to load

Create a Data Mart on your Redshift data storage, choose Facebook Ads as the data source, sign in with Facebook or paste an access token, add your ad account ids and select the fields.

  • 15 endpoints and 1172 fields to choose from
  • Ad Insights has 100 fields: spend, reach, clicks, conversions, ROAS
  • Each breakdown gets its own Data Mart and table
New Data MartChoose a sourceGoogle AdsFacebook AdsTikTok AdsAuthorizeConnectedEndpointAd InsightsAdAd AccountAd Account User
Ad Insights100 fieldsdate_startspendimpressionsclicksreachpurchase_roas

S02 · Step 2

Step 2: Load Facebook Ads into a Redshift schema and table

Schema and table in your Redshift database are filled in for you and can be edited. The first load covers the start of the previous month through today.

  • Insights land in their own table, apart from ads and creatives
  • Run History shows every load
DestinationAWS RedshiftSchemafacebook_adsTablead_account_insightsRun
Run HistoryPendingRunningSuccessIncremental load
Tablefacebook_ads.ad_account_insig…

S03 · Step 3

Step 3: Read the output schema without an API guide

After the first run the output schema gives each field a description. Fields like actions and action_values are columns of their own. Feed it to your data quality checks.

  • No Marketing API reference needed to read a column
  • Analysts and marketers read the same names
facebook_ads.ad_account_insightsOutput schemaFieldDescriptiondate_startThe start date for your data…spendThe estimated total amount of…impressionsThe number of times your ads…clicksThe number of clicks on your ads.reachThe number of people who saw…purchase_roasThe total return on ad spend…

S05 · Step 5

Step 5: Schedule the refresh and backfill the past

Schedule once with a scheduled refresh: daily, weekly, monthly or on an interval. Backfill any earlier period when you need it.

  • Backfills past a month are cut into segments of up to 31 days automatically
  • No orchestration to run in AWS
ScheduleRun on a scheduleDaily 09:00
BackfillRun backfill
Run HistoryDaily scheduleManual backfillDaily schedule

S06 · Step 6

Step 6: Point every report at the same Redshift tables

One set of Redshift tables feeds your data model, spreadsheets, dashboards, AI assistants such as Claude and ChatGPT, and scheduled AI insights.

  • Combine Facebook with Google and TikTok spend once
  • Dashboards and sheets cannot drift apart
Facebook AdsData MartPublished
Blended ad spend
Google Sheets
Data Studio dashboards
Claude, ChatGPT
Slack, email

Recent updates

Why OWOX

Why OWOX for Facebook Ads in AWS Redshift

API scripts, generic ETL and CSV exports all move Facebook numbers. OWOX puts them in Redshift tables that are readable and ready to join.

  • Your Redshift, your tables. Data sits in your own database behind your AWS credentials, outside the ad account.
  • One table per breakdown. Country, region, age and gender, device, placement and product breakdowns load separately, so you keep only the cuts you use.
  • Joins built in. Ad, ad set and campaign ids link the tables to each other and to CRM.
  • No upkeep on the API. Changes to the Marketing API are handled for you.
  • Free to self-host. The open-source OWOX Data Marts runs in your own infrastructure.

Book a callGet Started Free

Trust

The Data Partner You Can Trust

users

175K Source: Internal OWOX data as of 2026-11-11

Executives and data analysts across 20+ industries

G2 rating

4.9★2

“A trusted data analytics partner” — verified review

npm installs

171K3

In Open Source We Trust

Customers