🥳 Introducing our new Flex Connector! 👉 Learn more Introducing our new Flex Connector!

Facebook Ads

Focused version of the ads data

Related Connectors: Our connectors / Facebook Ads 
-- CREATE VIEW fb_ads_ads AS
SELECT id AS "ad_id"
	, source_ad_id
	, account_id
	, campaign_id
	, adset_id
	, "name"
	, preview_shareable_link
	, "STATUS"
	, effective_status
	, last_updated_by_app_id
	, created_time
	, updated_time
FROM facebook_ads_ads;

Requirements:

Usage:

This is the “ready for analysis” view of Facebook Ads’ ads information

Modifications:

Properties can be removed or added.

View Facebook Ads docs
Edit on Github

Other Facebook Ads queries.

Action Insights by Ad Format and Optimization Type Facebook Ad Accounts Facebook Ads Ad Creatives Facebook Adsests Facebook Adsets Ad Creatives

Other queries.

Account to Email Mapping Average Days to Close by Close Month Average Engagements to Close by Deal Type Companies Report Companies consolidated
Panoply award from G2 Crowd
Panoply award from G2 Crowd
Panoply Google Cloud Partner badge
Panoply AWS Partner badge