Release Noteslink

June 2023link

We have added the following new tables:

• ACCOUNT_METROS_REPORT
• CAMPAIGN_METROS_REPORT
• FUNDING_INSTRUMENT_METROS_REPORT
• LINE_ITEM_METROS_REPORT
• PROMOTED_TWEET_METROS_REPORT
• PROMOTED_ACCOUNT_METROS_REPORT

We have updated the following tables:

NOTE: This change is enabled by default for connectors created after June 12, 2023. We are gradually rolling this out to all existing connectors and will notify all customers beforehand.

March 2023link

You can now select or deselect the following tables to sync from the Schema tab on your connector details page:

• CAMPAIGN_HISTORY
• CARD_HISTORY
• FUNDING_INSTRUMENT_HISTORY
• LINE_ITEM_HISTORY
• TWEET

August 2022link

We have added a new column, budget_optimization, to the CAMPAIGN_HISTORY table to support Twitter API version 11.

We have upgraded our Twitter Ads connector from version 10 to version 11 of the Twitter API.

May 2022link

We have changed the segmentation of the line_item_cities_report report.

We have renamed the country_name column to location_name.

We have added a new column, location_type.

December 2021link

We have added a new column, duration, to the MEDIA_LIBRARY table for storing video length values.

February 2021link

We now support syncing data for the media_creative entity. See our MEDIA CREATIVE table documentation for more information.

November 2020link

We now support Twitter Ads API v8.

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 2020link

We have released pre-built, dbt Core-compatible data models for Twitter Ads. Find the models in Fivetran's dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

August 2020link

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

July 2020link

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

April 2020link

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 2020link

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 2020link

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 2019link

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' worth of data. Making so many API calls slowed down our syncs.

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

August 2019link

• We released a new version of our Twitter Ads connector, service version 2. You can now select how many months' worth 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 2019link

• 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.

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 2019link

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 2018link

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