Social Media Reporting: Rollup Report

Description

• Each record represents a post from a social media account

Supported Data Sources

• Facebook Pages

• LinkedIn Company Pages

• Instagram Business

• Twitter Organic

Columns

Type	Name	Description
STRING	_dbt_source_relation
DATETIME	created_timestamp	The timestamp the post was created
STRING	post_id	The ID of the post, from the source platform
STRING	post_message	The message of the post
STRING	page_id	The ID of the page, from the source platform
STRING	page_name	The name of the page, from the source platform
STRING	post_url	The URL of the post
STRING	source_relation	The source of the record, if the unioning functionality is being used.
STRING	platform	The platform the post comes from
INTEGER	clicks	The number of clicks on the post
INTEGER	impressions	The number of impressions on the post
INTEGER	likes	The number of likes on the post
INTEGER	shares	The number of shares on the post
INTEGER	comments	The number of comments on the post