Learning Outcomes
You will learn how to export data from CORE to an XLS spreadsheet
You will understand the meaning of each column in the exported spreadsheet
Data from the All Posts sections in CORE can be exported to an XLS file, making it easy to share data across teams!
You can find an All Post section on both the Brand level
and for each individual Profile
Clicking the export button from the Brand level, will give you the option to export just the Current brand profiles' results or The whole brandset's results.
Doing so from the Profile level will bring up the options to export the Current profile results, All brand profiles results, or The whole brandset's results.
The type of data you'll be able to export will vary for Private and Public data, so we'll discuss each separately.
Public Data
Public data is collected for any profile added to CORE
Brand - All Posts section
ID - URL ID
Name - Account name (i.e Twitter/Facebook)
Type - Data source
Link - Social channel URL
Followers - The account’s followers
Engagements - i.e Twitter retweets
Engagements/post - The total sum of all posts’ replies + likes + retweets OR Comments + likes + shares + video views
DIVIDED by total number of posts in an intervalImpressions - The number of times a post has been displayed in a timeline, whether the post is clicked or not.
Impressions/post - The total sum of all posts’ replies + likes + retweets OR comments + likes + shares + video views DIVIDED by total number of posts in an interval.
Average ER - Engagement Rate
Profile - All Posts
Post ID - The Post ID
Published - The date the content was posted
Link - The Post URL
Media Type - The type of post i.e status, video & photo
Post Type (Instagram Only) - Reel, Image, Video, Carousel
Tags - The tags created and used to group the results
Likes - Type of engagement
Comments - Type of engagement
Video Views - Type of engagement
Retweets -Type of engagement
ER - Engagement Rate
Visibility -The visibility is a score we assign to each post, across all channels, designed to measure the impact of a piece of content
Potential Impressions - PEI is the potential amount of times your post has appeared in a timeline.
Actual Impressions - AEI predicts the actual number of times that a piece of content has been delivered to a timeline
Message - The main body of the post
Private Data
Private data is only collected for Profiles that have been plugged in.
Brand - All Posts section
Brand - Title of Brand or Profile when adding a new brand
ID - The unique URL of an individual post as found on the native source's site i.e. Twitter.com/______
Name - Account name (i.e Twitter/Facebook)
Type - Data source
Link - Social channel URL
Followers - The profile/user account’s number of follower/audience
Engagements - i.e Twitter retweets
Engagements/post - the total sum of all posts’ replies + likes + retweets OR comments + likes + shares + video views DIVIDED by total number of posts in an interval.
Impressions - The number of times a post has been displayed in a timeline, whether the post is clicked or not.
Impressions/post - The total sum of all posts’ replies + likes + retweets OR comments + likes + shares + video views DIVIDED by total number of posts in an interval.
Average Daily ER - Engagement Rate
Profile - All Posts
Post ID - The Post Identification number
Published - The date the content was posted
Link - The unique URL of an individual post as found on the native sources site i.e. Twitter.com/______
Type - The type of post i.e status, video & photo
Tags - The list of tags used by a Pulsar user when manually grouping the results to segment their dataset.
Likes - The number of Likes (Type of engagement)
Comments - The number of Comments (Type of engagement)
Video Views - The number of Video Views (Type of engagement)
Retweets - The number of Twitter engagements like a share (Type of engagement)
ER - Engagement Rate
Visibility -The Visibility is a score we assign to each post, across all channels, designed to measure the impact of a piece of content.
Potential Impressions - (Also known as PEI) is the potential amount of times your post has appeared in a timeline or feed to be viewed.
Actual Impressions - Also known as AEI) predicts the actual number of times that a piece of content has been delivered to a timeline or feed to be viewed.
Message - The main body/copy of the post
We hope you enjoyed reading this article! 📚
If you have any questions or would like to learn more, please don't hesitate to reach out to our support team via live chat. 🚀