Facebook Ads Account logo

Sync Facebook Ads Account data to Sourcetable

Facebook Ads Account

Facebook Ads Account gives you complete control over your Facebook Ads account, helping users to manage their campaigns, ad sets and creatives. It includes the entire history of settings for your Facebook Ads, and can be used to track important KPIs like CTR (Click-Through-Rate), CPC (Cost Per Click) and Return On Ad Spend (ROAS).

Sync Facebook Ads Account data to Sourcetable

Facebook Ads Account logo
Sourcetable logo

Find out how to make the most of your Facebook Ads Account data with Sourcetable

Sourcetable Benefits

Query advertising campaign data quickly & easily

Facebook Ads Account allows business owners to get the key findings behind their Facebook ad campaigns, control costs and make informed decisions on how to target Facebook users who are interested in their products and services. Syncing Facebook Ads Account data to Sourcetable, and combining it with inputs from other key platforms and databases, allows businesses to keep track of advertising campaigns on Facebook and elsewhere, and how they interact with other important activities and metrics, easily and at a glance.


Syncing your Facebook Ads Account data to Sourcetable allows users to query inputs from multiple databases and platforms without having to learn SQL – making your advertising campaign data accessible to all members of your team, regardless of their level of tech skills.


Sourcetable brings together key data from Facebook Ads Account and other platforms quickly and intuitively, allowing users to automate processes and free up time to focus on other important aspects of their business.

An example interface to create an automation when sales surpass certain number


Sourcetable offers a full range of visualization tools for all your reporting needs, from bar charts to line graphs, burn charts, mapping, scatter plots and more. Create visually striking dashboards, share among your team and highlight the insights that really matter.

A simple flow showing how a table converts to a chart easily

Find out how to get the most from Facebook Ads Account with Sourcetable

A Magic Wand

Smart Templates

Use out of the box tried and tested templates in order to cross-reference Facebook Ads Account data and enable data collaboration across your entire organisation

A Magic Wand

Quick Analysis

Analyse your social media advertising campaign data instantly in cross-channel reports

A Magic Wand

Ease Of use

Compile all your Facebook Ads Account data into a spreadsheet, query it and find the key business insights behind the numbers, allowing you to confidently update and improve your social media campaigns.

Who uses Facebook Ads Account data in Sourcetable

📈 Marketing and Advertising professionals

💸 CFOs & Accountants

👷🏿 Sales and Sales Ops folk

🚀 Founders

📱 Social Media Managers

🏢 Ecommerce businesses

Here's a sample of Facebook Ads Account data that will be available in your Sourcetable spreadsheets:

Show all (31)


Contains account history, index, and custom fields

Link icon


Contains complete account information and has fields of account status, age, amount spent, balance, currency, name, tax information, next bill date, funding source

Link icon


Contains ad history, action type, appliation, conversion id, creative, dataset, event information, pist and page information

Link icon


Contains account history, Ad set history, campaign history, creative history ad history, bid info and type, configured status, effective status, name and ad review feedback global and placement specific

Link icon


Contains ad history, ad updated time, label history


Contains ad history id, ad updated time, blame field, code, confidence, importance, message and tile

Link icon


Contains ad set history id, ad set updated time, date range start time

Link icon


Contains ad set history id, ad set updated time, and custom fields

Link icon


Contains ad set history id, ad set history updated time, custom audience history, and is excluded


Contains account history, campaign history, ad set history, bid amount, info and strategy, billing event, daily budget, destination type, name, status, instagram actor id, effective id

Link icon


Contains ad set history id, ad set updated time and label id


Contains ad history id, action type, application, conversion id, creative, dataset, event information, fb pixel and event, post information, response, subtype

Link icon


Contains creative history, app type, undex, template page, creative history, app name, app store id, url, class name and package name

Link icon


Contains account history, campaign history, boosted object id, budget rebalance flag, buying type, can create brand lift study, configured status, name, objective, spend cap, start time, status, stop time

Link icon


Contains campaign history, campaign updated time and label id


Contains account history id, index, and capability name

Link icon


Contains index, caption, message, description, link, creative id

Link icon


Contains carousel ad media index, key and value

Link icon


Contains account history, actor id, applink tratment, body, branded content sponser page id, instagram information, template information, name, link information, page message, status, title, video id, thumbnail url

Link icon


Contains index, website url, display url

Link icon


Contains creative history id, label id


Contains ad set id, ad id and ad set updated time

Link icon


Contains updated time, account history, approximate count, content updated time, created time, data source creation params, data source sub type, permission information fields, name, lookalike country, ratio, type, delivery status code, description and rule

Link icon


Contains ad set id, ad set updated time, event, interval days and ma frequency

Link icon


Contains account d, created and updated time and name

Link icon


Contains custom audience id, custom audience updated time, origin custom audience id, name and type

Link icon


Contains the associations of custom audience history and custom audience history updated time and country

Link icon


Contains ad set history id, ad set updated time, name and index

Link icon


Contains country code, account id, min reach limits, max campaign duration, min campaign duration, max days to finish

Link icon


Contains key, type, value and creative history id

Link icon


Contains index, account id and task

Link icon

Sample companies

Online businesses integrating Facebook Ads Account with Sourcetable have access to all relevant data on audiences, users, leads, revenues and email marketing.

  • Retail online stores

  • B2B Platforms

  • Software as a Service

    (SaaS) companies
  • B2C Marketplaces

What makes Sourcetable special?

A Magic Wand


Connect, sync and query Facebook Ads Account data with inputs from 30+ other sources, no knowledge of SQL required

A Magic Wand


Easily create and share workflow templates to drive decisions and improve campaigns based on findings from Facebook Ads Account and other platforms

A Magic Wand


Automate data and processes from Facebook Ads Account so you can focus on what matters most: selling your product

Frequently Asked Questions

How do I sync Facebook Ads Account data to Sourcetable?
Sourcetable is currently in Closed Beta. Sign up to the Beta here to tell us a little about yourself and request information on how to sync your Facebook Ads Account data.
How easy is it to visualize my Facebook Ads Account data using Sourcetable?
Sourcetable spreadsheets are designed to be intuitive and user-friendly, so anyone can view key data from Facebook Ads Account - and from campaigns on other advertising platforms via LinkedIn Ads and Twitter Ads - at a glance without code.
Which advertising platform syncs best with Sourcetable – Facebook Ads or Twitter Ads?
Sourcetable enables users to combine data from both platforms quickly and easily, enabling businesses to better understand the relationships among available data, and gain new insights for making better decisions or identifying new opportunities.

Connect your Facebook Ads Account Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.