Facebook Ads Connector

Start moving your Facebook Ads data with fully managed data pipelines. Get clean normalized data ready for analytics, easy to setup and analyze with AI in minutes.

View more about the Facebook Ads connector in the Weld documentation

action_carousel_card

account_id

action_carousel_card_outbound_clicks

347 more facebook-ads tables

Explore available Facebook Ads data

Browse all the data tables available for the Facebook Ads connector, in our interactive ERD data viewer.

View the Facebook Ads Data Schema

Transform and model Facebook Ads data

Get clean data models from your Facebook Ads data. Weld makes it easy to transform and model with the powerful built in SQL editor and AI Assistant.

Facebook Ads

raw.facebook_ads.table1

raw.facebook_ads.table2

Get started with Facebook Ads SQL Templates

Get inspiration on how to model your data, with our collection of foundational SQL templates we have battle-tested at Weld. All the templates work out of the gate with the Weld data integrations for Facebook Ads.

Account Report

Generates an account report for the Facebook Ads integration. It retrieves data from the "ad_insight" and "account" tables and calculates various metrics such as spend, impressions, clicks, CPC, and CTR. The report is grouped by date, account ID, account name, account status, business country code, created time, and currency.

Ad Report

Integrates with Facebook Ads and retrieves data from various tables such as ad_insight, account, campaign, ad_set, and ad. It selects specific columns from these tables and performs calculations to generate aggregated metrics such as spend, reach, impressions, clicks, CPC, CTR, and CPM. The template then joins these tables based on specific conditions and groups the results by certain columns.

Ad-set Report

Generates an ad-set report by integrating with Facebook Ads. It retrieves data from various tables such as ad_set_insight, account, campaign, ad_set, and ad. The template then selects specific columns and performs calculations to provide insights on metrics like spend, reach, impressions, clicks, CPC, CTR, and CPM. The final result is grouped by different dimensions such as date, account, campaign, and ad set.

Campaign Report

Creates a campaign report by integrating with Facebook Ads. It retrieves data from three tables: campaign_insight, account, and campaign. The template calculates various metrics such as clicks, impressions, spend, CPC, and CTR, and groups the results by date, account, and campaign.

URL Report

Generates a URL report for Facebook Ads integration. It retrieves data from various tables such as ad_insight, creative, account, ad, ad_set, and campaign. The template selects specific columns like date, account ID and name, campaign ID and name, ad set ID and name, ad ID and name, creative ID and name, and extracts UTM parameters from the URL. It also calculates the sum of clicks, impressions, and spend, and groups the data accordingly.

View all Facebook Ads templates