Here we document changes to our set of data sources. You can find more information about a specific data source column by clicking the link attached to it.
September 20th, 2022
We have decided to finally sunset the paid post detection feature. For more than 2 years we are not promoting this functionality anymore in any of our default metrics in Discover for good reasons. The meaning behind a Facebook post being "potentially paid" is questionable and we haven't seen that function to unfold the customer value we hoped for when releasing it years ago.
With immediate effect past metrics still referencing that data will show posts as "Not yet tagged" and a NULL value will be returned for the related isPotentiallyPaid column in data source facebookOwnPosts.
In about 3 months we are planning to officially deprecate this column, which is the indicator for this column to be fully removed soon after. Further communication will happen at that point. Until then, it will simply return NULL values instead. This is done to softly fade out the remaining usage of this column and not break any existing implementations today.
February 11th, 2022
Data sources instagramTvPosts and instagramInsightsTvPosts will be deprecated on May 11th, 2022, based on Instagram's announcement combining IGTV and feed videos into one format - Instagram Video. Former IGTV videos are now returned by data sources instagramOwnPosts and instagramInsightsOwnPosts instead. This also includes historic IGTV videos. Data sources instagramTvPosts and instagramInsighstTvPosts will return empty results from today onwards. Please make sure to remove all references to the IGTV specific data sources until May 11th, when these data sources will be completely removed.
January 12th, 2022
A new column story has been added to data sources facebookOwnPosts, facebookInsightsOwnPosts and facebookInsightsExpiredPosts holding the accompanying story shown on Facebook, e.g., "BMW posted a video to playlist BMW TODAY".
September 15th, 2020
August 18th, 2020
This data source does now include Retweeted Tweets by default, now returning all Tweets mentioning @handle of a profile - no exceptions. Please note that the whole data source is still based on Twitter's Standard Search API resulting in only a sample set of Tweets being considered.
July 22nd, 2020
June 12th, 2020
June 9th, 2020
June 2nd, 2020
The following data source columns will be deprecated on June 30th, 2020. Please make sure to replace or remove all references to these columns on time.
page_impressions_by_paid_non_paid_total (replacement available)
page_impressions_by_paid_non_paid_paid (replacement available)
page_impressions_by_paid_non_paid_unpaid (replacement available)
page_impressions_by_paid_non_paid_unique_total (replacement available)
page_impressions_by_paid_non_paid_unique_paid (replacement available)
page_impressions_by_paid_non_paid_unique_unpaid (replacement available)
page_posts_impressions_by_paid_non_paid_unique_total (replacement available)
page_posts_impressions_by_paid_non_paid_unique_paid (replacement available)
page_posts_impressions_by_paid_non_paid_unique_unpaid (replacement available)
facebookInsightsByStoryType (whole data source)
Use data source facebookInsights with columns page_content_activity_by_action_type_*, page_content_activity_by_action_type_unique_*, page_impressions_by_story_type_* and page_impressions_by_story_type_unique_* instead.
likes (replacement available)
love (replacement available)
wow (replacement available)
haha (replacement available)
sad (replacement available)
angry (replacement available)
thankful (replacement available)
facebookInsightsVideosRetention (whole data source)
originalName (replacement available)
youtubeAnalyticsTopTenVideos (whole data source)
Use data source youtubeAnalyticsTopVideos serving up to 200 videos instead of just 10 instead.