Instagram Business: Posts

Description

• Each record represents the daily performance of a post or story.

Supported Data Sources

• Instagram Business

Columns

Type	Name	Description
STRING	account_name	The name of this user.
INTEGER	user_id	The ID of this user.
INTEGER	post_caption	The caption of the post or story
DATETIME	created_timestamp	The timestamp this post or story was created
INTEGER	post_id	The media ID of this post or story
BOOLEAN	is_comment_enabled	Whether comments are enabled for this post or story
BOOLEAN	is_story	Whether this is a story
STRING	media_type	Media type. Can be CAROUSEL_ALBUM, IMAGE, or VIDEO.
STRING	media_url	Media URL. Will be omitted from responses if the media contains copyrighted material, or has been flagged for a copyright violation.
STRING	post_url	Permanent URL to the media.
STRING	shortcode	Shortcode to the media.
INTEGER	thumbnail_url	Media thumbnail URL. Only available on VIDEO media.
STRING	username	Username of user who created the media.
INTEGER	carousel_album_engagement	Total number of likes and IG Comments on the album IG Media object.
INTEGER	carousel_album_impressions	Total number of times the album IG Media object has been seen
INTEGER	carousel_album_reach	Total number of unique Instagram accounts that have seen the album IG Media object.
INTEGER	carousel_album_saved	Total number of unique Instagram accounts that have saved the album IG Media object.
INTEGER	carousel_album_video_views	Total number of unique Instagram accounts that have viewed video IG Media within the album.
INTEGER	comment_count	Total number of comments on the IG Media object.
INTEGER	like_count	Total number of likes on the IG Media object.
INTEGER	story_exits	Number of times someone exited the story IG Media object.
INTEGER	story_impressions	Total number of times the story IG Media object has been seen.
INTEGER	story_reach	Total number of unique Instagram accounts that have seen the story IG Media object.
INTEGER	story_replies	Total number of replies to the story IG Media object.
INTEGER	story_taps_back	Total number of taps to see this story IG Media object's next photo or video.
INTEGER	story_taps_forward	Total number of taps to see this story IG Media object's previous photo or video.
INTEGER	video_photo_engagement	Total number of likes and IG Comments on the video IG Media object.
INTEGER	video_photo_impressions	Total number of times the video IG Media object has been seen.
INTEGER	video_photo_reach	Total number of unique Instagram accounts that have seen the video IG Media object.
INTEGER	video_photo_saved	Total number of unique Instagram accounts that have saved the video IG Media object.
INTEGER	video_views	Total number of times the video IG Media object has been viewed.
INTEGER	reel_comments	Total number of comments on the reel IG Media object.
INTEGER	reel_likes	Total number of likes on the reel IG Media object.
INTEGER	reel_plays	Total number of times the reel IG Media object has been played.
INTEGER	reel_reach	Total number of unique Instagram accounts that have seen the reel IG Media object.
INTEGER	reel_shares	Total number of times the reel IG Media object has been shared.
INTEGER	reel_total_interactions	Total number of interactions the reel IG Media object had.
STRING	source_relation	The source of the record, if the unioning functionality is being used.