Integrate Meta Ads using Fiber

Sync your customers' dataFiber pulls data from your customers' Meta Ads accounts into your database or cloud storage. Skip months of integration work and begin syncing in minutes.

→

Fiber

→

postgres-prod

meta_ads_campaigns

meta_ads_accounts

meta_ads_business_users

Your customers' Meta Ads accounts

Your production database

Meet your new integration toolkit: SQLReplace calls to the Meta Ads API with an interface you already use. Access the data you need straight from your database.

-- Fetch all the Campaigns belonging to the Meta Ads 
-- account of a particular user. 

SELECT *
FROM fiber.meta_ads_campaign
WHERE account_id = '{user.meta_ads_id}'

-- Fetch all the Campaigns belonging to the Meta Ads 
-- account of a particular user. 

SELECT *
FROM fiber.meta_ads_campaign
WHERE account_id = '{user.meta_ads_id}'

Code

CREATE TABLE fiber.meta_ads_campaign (
  id TEXT NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE,
  updated_at TIMESTAMP WITH TIME ZONE,
  account_id TEXT,
  account_id TEXT,
  buying_type TEXT,
  can_use_spend_cap BOOLEAN,
  configured_status TEXT,
  created_time TEXT,
  effective_status TEXT,
  is_skadnetwork_attribution BOOLEAN,
  name TEXT,
  objective TEXT,
  start_time TEXT,
  stop_time TEXT,
  updated_time TEXT,
  primary_attribution TEXT,
  lifetime_budget TEXT,
  source_campaign JSONB,
  spend_cap TEXT,
  topline_id TEXT
)

CREATE TABLE fiber.meta_ads_campaign (
  id TEXT NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE,
  updated_at TIMESTAMP WITH TIME ZONE,
  account_id TEXT,
  account_id TEXT,
  buying_type TEXT,
  can_use_spend_cap BOOLEAN,
  configured_status TEXT,
  created_time TEXT,
  effective_status TEXT,
  is_skadnetwork_attribution BOOLEAN,
  name TEXT,
  objective TEXT,
  start_time TEXT,
  stop_time TEXT,
  updated_time TEXT,
  primary_attribution TEXT,
  lifetime_budget TEXT,
  source_campaign JSONB,
  spend_cap TEXT,
  topline_id TEXT
)