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

Facebook Campaigns

Focused version of the campaigns data

Related Integrations: All Integrations / Facebook Ads
-- CREATE VIEW fb_ads_campaigns AS
SELECT
    c.id as "campaign_id",
    c.source_campaign_id,
    c.account_id,
    c.name,
    c.status,
    c.effective_status,
    c.special_ad_category,
    c.lifetime_budget,
    c.budget_remaining,
    c.daily_budget,
    c.last_budget_toggling_time,
    c.spend_cap,
    c.objective,
    c.bid_strategy,
    c.buying_type,
    cpt."value" as "pacing_type",
    c.can_use_spend_cap,
    c.can_create_brand_lift_study,
    c.start_time,
    c.stop_time,
    c.created_time,
    c.updated_time
FROM
    facebook_ads_campaigns c
    LEFT JOIN facebook_ads_campaigns_pacing_type cpt on c.id = cpt.facebook_ads_campaigns_id;

Requirements:

Usage:

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

Modifications:

Properties can be removed or added.