Hooray! We just launched a direct integration with 🛍   BigCommerce 🛍! Check it out Hooray—Panoply now offers direct integration with BigCommerce!

Facebook Ads

Focused version of the ads data

Related Integrations: All Integrations / 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
	, effective_status
	, last_updated_by_app_id
	, created_time
	, updated_time
FROM facebook_ads_ads;



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


Properties can be removed or added.