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.
November 24th, 2022
Additions
instagramInsightsStories
November 21st, 2022
Additions
linkedInAnalyticsOwnPosts
September 20th, 2022
Deprecations
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
Deprecations
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
Additions
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
Additions
facebookInsights
facebookInsightsOwnPosts
August 18th, 2020
Modifications
twitterMentions
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.
Additions
twitterMentions
July 22nd, 2020
Additions
twitterAnalyticsOwnTweets
twitterAnalyticsOwnReplies
June 12th, 2020
Additions
linkedInAnalyticsOwnPosts
June 9th, 2020
Additions
facebookInsightsOwnPosts
facebookInsightsExpiredPosts
June 2nd, 2020
Additions
facebookInsights
facebookInsightsOwnVideos
Deprecations
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.
facebookAdsPostAds
facebookInsights
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.
facebookInsightsOwnVideos
facebookInsightsVideosRetention (whole data source)
Use data source facebookInsightsOwnVideos with column total_video_retention_graph instead.
facebookOwnPosts
facebookUserPosts
instagramOwnPosts
profiles
originalName (replacement available)
youtubeAnalyticsTopTenVideos (whole data source)
Use data source youtubeAnalyticsTopVideos serving up to 200 videos instead of just 10 instead.
youtubeVideos