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.

Accessibility

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.

Automation

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.

Visualizations

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.

How to get the most of 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)

ACCOUNT_ATTRIBUTION

Contains account history, index, and custom fields

Link icon

ACCOUNT_HISTORY

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

AD_CONVERSION

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

Link icon

AD_HISTORY

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

AD_LABEL

Contains ad history, ad updated time, label history

AD_RECOMMENDATION

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

Link icon

AD_ROTATION_INTERVAL

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

Link icon

AD_SET_ATTRIBUTION

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

Link icon

AD_SET_CUSTOM_AUDIENCE

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

AD_SET_HISTORY

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

AD_SET_LABEL

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

AD_TRACKING

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

Link icon

APP_LINK

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

Link icon

CAMPAIGN _HISTORY

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

CAMPAIGN_LABEL

Contains campaign history, campaign updated time and label id

CAPABILITY

Contains account history id, index, and capability name

Link icon

CAROUSEL_MEDIA

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

Link icon

CAROUSEL_MEDIA_URL_TAG

Contains carousel ad media index, key and value

Link icon

CREATIVE_HISTORY

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

CREATIVE_HISTORY_ASSET_FEED_SPEC_LINK_URL

Contains index, website url, display url

Link icon

CREATIVE_LABEL

Contains creative history id, label id

CREATIVE_SEQUENCE

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

Link icon

CUSTOM _AUDIENCE_HISTORY

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

FREQUENCY_CONTROL

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

Link icon

LABEL_HISTORY

Contains account d, created and updated time and name

Link icon

LOOKALIKE_ORIGIN

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

Link icon

LOOKALIKE_TARGET_COUNTRY

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

Link icon

PACING_TYPE

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

Link icon

REACH_FREQUENCY

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

Link icon

URL_TAG

Contains key, type, value and creative history id

Link icon

USER_TASK

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

    (eCommerce)
  • B2B Platforms

  • Software as a Service

    (SaaS) companies
  • B2C Marketplaces

What makes Sourcetable special?

A Magic Wand

Interconnectivity

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

A Magic Wand

Collaboration

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

Automation

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.