Twitter Ads logo

Sync Twitter Ads data to Sourcetable

Twitter Ads

Twitter Ads helps users to visualise reports and data from Twitter ad campaigns, tweets, media creatives and their histories. The platform can be accessed to track important business KPIs in the areas of engagement, growth and ROI.

Sync Twitter Ads data to Sourcetable


Twitter Ads logo
Sourcetable logo

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

Sourcetable Benefits

Query advertising campaign data quickly & easily

Twitter Ads allow business owners to target Twitter users who are interested in their products and services, and show them relevant ads while controlling costs and measuring the success of their campaigns. Syncing Twitter Ads data to Sourcetable, and combining it with inputs from other key platforms and databases, allows businesses to keep track of advertising campaigns on Twitter and elsewhere, and how they interact with other important activities and metrics.

Automation

Sourcetable can be used to compile key data from Twitter Ads and other platforms quickly and intuitively, automate processes in one easy-to-use spreadsheet, and free up time to focus on other important aspects of your business.

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

Accessibility

Query inputs and data from all of your advertising platforms in one place with Souretable. You no longer need to log into multiple platforms or go searching for your ads data across multiple platforms again.

Visualizations

Thanks to our suite of visualization tools, Sourcetable users can set up visually striking live dashboards, bar charts, line graphs, burn charts, mapping and scatter plots, and share with their team to highlight the metrics that matter most.

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

Find out how to get the most from Twitter Ads with Sourcetable

A Magic Wand

Smart Templates

Use out of the box tried and tested templates in order to query Twitter Ads data and enable data collaboration across your entire organisation

A Magic Wand

Quick Analysis

Analyse your advertising campaign data quickly and easily in intuitive cross-channel reports

A Magic Wand

Ease Of use

Compile all your Twitter Ads data into a single spreadsheet, identifying key business insights behind the numbers in order to confidently evaluate and improve your campaigns.

Who uses Twitter Ads data in Sourcetable

📈 Marketing and Advertising professionals

👷🏿 Sales and Sales Ops folk

🚀 Founders

🏢 Ecommerce businesses

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

Show all (30)

ACCOUNT_[SEGMENTATION]

Contains account id, date, segment and metrics

Link icon

ACCOUNT_HISTORY

Contains name, business name, timezone, salt, business id, approval status, industry type, deleted

Link icon

ACCOUNT_MEDIA_HISTORY

Contains account history, video history, media url, creative typem vast url and deleted

Link icon

CAMPAIGN_[AGGREGATION]

Contains account id, campaign history id, date/month, average frequency and total audience reach

Link icon

CAMPAIGN_[SEGMENTATION]

Contains account id,campaign history id, date, segment and metrics

Link icon

CAMPAIGN_HISTORY

Contains account history, funding instrument history, name, start time, servable, daily budget amount local micro, end time, duration in days, standard delivery, entity status, frequecy cap, currency, deleted

Link icon

CAMPAIGN_REASON_HISTORY

Contains campaign history, campaign updated at, index, reason not servable

Link icon

CARD_HISTORY

Contains account history,name, googleplay app id, image display height, preview url, website information, video information, title etc

FUNDING_INSTRUMENT_[AGGREGATION]

Contains funding instrument id, date/month, average frequency, total audience reach

Link icon

FUNDING_INSTRUMENT_[SEGMENTATION]

Contains funding instrument id, date, segment, account id, metrics

Link icon

FUNDING_INSTRUMENT_HISTORY

Contains account history, start time, description, credit limit, local micro, end time, entity status, io header, currency, funded amount local micro, type, able to fund and credit remaining local micro

Link icon

FUNDING_INSTRUMENT_REASON_HISTORY

Contains associations of funding instrument history, funding instrument updated at, index and reason not able to fund

Link icon

LINE_ITEM_[SEGMENTATION]

Contains line item id, date, segment, account id, metrics

Link icon

LINE_ITEM_CATEGORY_HISTORY

Contains associations of line item history, line item updated at, index and category

Link icon

LINE_ITEM_HISTORY

Contains campaign history, bid type, advertiser user id, name, start time, bid amount local micro, target cpa local micro, charge by, product type, end time, bid unit, currency, optimization, include sentiment

Link icon

LINE_ITEM_PLACEMENT_HISTORY

Contains line item history, line item updated at, index and placement

Link icon

LINE_ITEM_TRACKING_TAG_HISTORY

Contains line item history, line item updated at, index, tracking tag and partner

Link icon

MEDIA_CREATIVE_HISTORY

Contains line item history, account media id, account media history, landig url, serving status, approval status, deleted

Link icon

MEDIA_LIBRARY

Contains media key, media id, tweeted, name, file name, media url, category, status, and type, deleted

Link icon

PREROLL_CALL_TO_ACTIONS_HISTORY

Contains line item history, call to action url, call to action, deleted

PROMOTED_TWEET_[SEGMENTATION]

Contains promoted tweet id, date, segment, account id, metrics

Link icon

PROMOTED_TWEET_HISTORY

Contains line item history, tweet, entity status, approval status, deleted

Link icon

SCHEDULED_PROMOTED_TWEET_HISTORY

Contains line item history, scheduled tweet history, tweet, entity status, deleted

Link icon

SCHEDULED_TWEET_HISTORY

Contains account history, tweet, card uri, completed at, text, user id, scheduled status, nullcast, scheduled at

Link icon

TWEET

Contains account history, text, truncated, source, in reply to status id, user id, screen anme, retweet count, favorite count, favorited, retweeted, lang, followers, geo type, coordinates

Link icon

TWEET_HASHTAG

Contains tweet, index, text and indices

Link icon

TWEET_MEDIA

Contains tweet, media id, indices, media url, media url https, url, display url, expanded url, type

Link icon

TWEET_SYMBOLS

Contains tweet, index, text and indices

Link icon

TWEET_URL

Contains tweet, index, url, expanded url, display url and indices

Link icon

TWEET_USER_MENTION

Contains tweet, screen name, name and indices

Link icon

Sample companies

Online businesses integrating Twitter Ads with Sourcetable have access to all relevant data on user clicks, ad spends, and demographic information.

  • Retail online stores

    (eCommerce)
  • Retail offline stores

  • B2B Platforms

  • Software as a Service

    (SaaS) companies
  • B2C Marketplaces

What makes Sourcetable special?

A Magic Wand

Interconnectivity

Connect, sync and analyse your Twitter Ads data together with findings from 30+ other sources, to inform business decisions and improve your ad campaigns

A Magic Wand

Automation

Automate your Twitter Ads data so you can free up time to focus on running your business and selling your product

A Magic Wand

Collaboration

Create intuitive workflow templates based on data from Twitter Ads and other platforms, and share among team members, no knowledge of SQL required

Frequently Asked Questions

How do I sync Twitter Ads 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 Twitter Ads data.
How easy is it to visualize my Twitter Ads data using Sourcetable?
Sourcetable spreadsheets are designed to be intuitive and user-friendly, so anyone can view key data from Twitter Ads - and other advertising platforms such as LinkedIn Ads and Google Ads - at a glance without code.
Which advertising platform works best with Sourcetable – Twitter Ads or Facebook Ads?
Sourcetable enables users to combine data from both platforms, enabling businesses to better understand the relationships among available data, and gain new insights for making better decisions or identifying new opportunities.




Connect your Twitter Ads Data

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