Note: This article only applies to Brand Super Admins or applicable custom roles. For more details on Creator Studio access, please refer to the Defining Roles and Permissions article.

Direct Data Export allows Brand Super Admins to easily export Firstup user engagement data in daily increments. This allows for seamless integration into your own reporting tools, making data analysis straightforward and self-served. Additionally, it helps you assess the value of your investments in driving key business initiatives.

With Direct Data Export, you can seamlessly export user, content, and activity data to your data warehouse.

• Include Firstup reporting in your favorite BI tools
• Easy merge with other data sources for a comprehensive view
• Independent value studies for leadership insights

Note: If data anonymization is enabled for your community, direct data exports will not include raw Personally Identifiable Information (PII). If a full export of existing data is needed, please contact your Firstup Service Manager.

How to Access Direct Data Export

Under Insights > Downloads, a folder will be added to the data export list at the end of each day (UTC). Folder files can be downloaded in bulk, or individually by clicking on the vertical ellipses next to the folder and clicking Download. 

Files

The folder can contain up to three files consisting of updated records of users, campaigns, and user activities, respectively. The presence of each file is dependent upon the updates for that day. For example, if no campaigns were created or updated that day or if there wasn't any user activity, those files would be absent from that day's folder.

Clicking on a folder in the folder list will open its contents, where all files can be downloaded in bulk or individually. Files are available for download for seven days before they expire from the system.

Note: Please refer to the Glossary of Terms for more details on the data columns listed below.

User-level - Includes users whose demographic data has been updated within the last 24 hours

Data columns included: 

• User ID
• First Name
• Last Name
• Email
• Universal Identifier
• Experience Status
• Blocked At
• Studio Role
• Last Visited Date
• Account Created Date
• Registered Date
• Preferred Name
• Standard Attributes
  • profile_zip
  • profile_job_title
  • profile_birthdate
  • attribute_company
  • attribute_department
  • attribute_job_description
  • attribute_gender
  • attribute_city
  • attribute_state
  • attribute_country
  • attribute_region
  • attribute_hire_date
  • attribute_start_date
  • attribute_language
  • attribute_work_location
  • attribute_timezone
  • attribute_locale
  • attribute_cost_center
  • attribute_division
  • attribute_manager
  • attribute_employee_type
  • attribute_business_unit
• Custom Attributes (all attributes sent via user sync)

Campaign-level - Includes all campaigns that have been newly created or updated within the last 24 hours

Data columns included: 

• Campaign Name
• Campaign ID
• Publish Date
• Archive Date
• Publisher User ID
• Publisher Name
• Author User ID
• Author Name
• Content Version
• Studio URL
• Topics
  • Topic ID
  • Topic Name
  • Topic Subscriber Count
• Initiatives
• Is Featured
• Is Shareable
• Is Commentable
• Is Translatable
• Duration
• Priority
• Acknowledgeable
• Author Alias ID
• Author Alias Name
• Publication State
• Source Type
• Audiences
• Content Type

Activity-level - Includes hourly (UTC) aggregated engagement data per user, campaign, and channel

Data Columns included: 

• Content ID
• Content Name
• Content Published At
• User ID (user ID of the user who engaged with the content)
• User Name (name of the user who engaged with the content)
• Likes
• Shares
• Bookmarks
• Email Opens
• Feed Clicks
• Emails Delivered
• Emails Clicks
• Push Clicks
• Impressions
• Downloads
• Poll Responses
• Acknowledge Counts
• Platform
• Date (date of engagement)
• Assistant Delivered Count
• Assistant Opens
• Video Plays