Release Notes

November 2020

We have added the following new report tables to support Reach and Average Frequency:

CAMPAIGN_REACH_DAILY_REPORT
CAMPAIGN_REACH_MONTHLY_REPORT
FUNDING_INSTRUMENT_REACH_DAILY_REPORT
FUNDING_INSTRUMENT_REACH_MONTHLY_REPORT

We have added a new table, PREROLL_CALL_TO_ACTIONS_HISTORY, which stores the preroll call-to-actions for an account. See Twitter's documentation for more information.

We have removed the video_mrc_views field from the analytics tables. The video_total_views field stores the same data.

October 2020

We have released a pre-built dbt package for Twitter Ads. Find the package in Fivetran's dbt hub. Learn more about our dbt integration in our dbt Transformations documentation.

August 2020

We now support syncing data from the reporting tables for the promoted_account entity. See our PROMOTED ACCOUNT tables for more information.

July 2020

We can now sync the records that you have deleted from the funding_instruments, campaigns, line_items, and promoted_tweets entities.

April 2020

In the MEDIA_CREATIVE_HISTORY table, we have deprecated the serving_status field and replaced it with the entity_status field to support Twitter API v7. We will continue to support the deprecated field for the next three months, so be sure to make the required schema changes by July 3, 2020.

February 2020

We have made multiple schema changes to support Twitter API v6 changes. You can read detailed API documentation on Twitter's website. We will continue to support all deprecated items for the next three months, so be sure to make the required schema changes by May 25, 2020.

We have renamed the CITIES segment to METROS. However, the CITIES sub-string will be present in all analytics tables.
We have added the following fields to the tables below:
- media_key to the CARD_HISTORY table
- poster_media_key and poster_media_url to the MEDIA_LIBRARY table
We have added four new fields to the TWEET table because the Twitter API endpoint has changed from scoped_timeline to tweets:
- tweet_type (DRAFT, PUBLISHED, SCHEDULED)
- media_key
- card_uri
- full_text
We have deprecated and replaced the following fields in the tables below:
- text with full_text in the TWEET table
- video_poster_url with poster_media_url in the CARD_HISTORY table
- media_id and video_content_id with media_key in the ACCOUNT_MEDIA_HISTORY table
- image, wide_app_image, and video_url with media_url in the CARD_HISTORY table
We have deprecated the following fields from the tables below:
- media_ids from the SCHEDULED_TWEETS table
- video_hls_url from the CARD_HISTORY table
  
  We will stop syncing data from the VIDEO_APP_DOWNLOAD_CARD, VIDEO_CONVERSATION_CARD, VIDEO_DIRECT_MESSAGE_CARD, and VIDEO_WEBSITE_CARD tables to the CARD_HISTORY table. However, we will continue syncing the data from the VIDEO_POLLS table to the CARD_HISTORY table.

January 2020

We have deprecated the include_sentiment field from the LINE_ITEM_HISTORY table because the Twitter Ads API no longer supports it. To learn more, see Twitter's API documentation.

November 2019

We have improved the sync speed for our Twitter Ads connector.

Previously, we made one API call per entity ID per day of data during syncs. We therefore had to make a large number of API calls when we fetched data for multiple entity IDs and/or for multiple days of data. Making so many API calls slowed down our syncs.

Now Fivetran can fetch multiple days of data for up to 20 entity IDs in a single API call, which makes syncs significantly faster.

August 2019

We released a new version of our Twitter Ads connector, service version 2. You can now select how many months of data you'd like to include in your initial sync. Choose from the following options:
- 3 months
- 6 months
- 12 months
- 24 months
- All time
Twitter Ads connectors running on service version 0 and 1 will sunset on November 21, 2019. If you are using either of these service versions, please upgrade to the newest version by creating a new Twitter Ads connector and syncing into a new schema.

July 2019

You can now configure your Twitter Ads connector through the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.

If we encounter insufficient permissions when we try to sync endpoints for a specific account, then we skip that endpoint for that account and give a warning in the dashboard.

The warning includes endpoints with their respective accounts as follows.

Account ID	Skipped Endpoints
account_1	endpoint_1
	endpoint_2
account_2	endpoint_1

If you receive this warning, give Account Administrator permissions for that account to the user which you used to create your Twitter Ads App.

February 2019

We upgraded Twitter Ads API version to v4. Read more about their new version on Twitter's documentation. This upgrade means the following changes to the schema:

Removed VIDEO_HISTORY and VIDEO_REASON_HISTORY tables as Twitter deprecated the videos endpoint.
Removed column preview_url from table CARD_HISTORY.
From now on the column app_country_code of table CARD_HISTORY will be delivered as country_code.

July 2018

Twitter Ads provides a history of the settings and detailed reports of your Twitter Ad Accounts, Campaigns, Line Items, Tweets, and Media Creatives.

Link to Twitter Ads documentation

Documentation