Sprout Social

Import social media analytics for cross-channel marketing insights

Overview

Sprout Social is a comprehensive social media management platform that provides publishing, engagement, and analytics across social channels. Import your Sprout Social data into Scoop to combine social metrics with other marketing data sources for unified cross-channel analysis.

What You Can Analyze

Data TypeExample Questions
Engagement"Which content types drive the most engagement?"
Reach"How has our audience reach grown month-over-month?"
Cross-Channel"Compare social engagement to email and web traffic"
Publishing"What posting times get the best engagement?"
Sentiment"Track brand sentiment trends over time"
Team Performance"Response time by team member"

Importing Sprout Social Data

Option 1: Export Reports

  1. In Sprout Social, navigate to Reports
  2. Select your report type (Profile, Post, Tag, etc.)
  3. Set your date range and profiles
  4. Click Export → CSV or Excel
  5. Upload to Scoop as a new dataset

Option 2: Scheduled Report Emails

  1. In Sprout Social Reports, click Schedule
  2. Set the delivery frequency (daily, weekly, monthly)
  3. Add your Scoop ingest email address
  4. Select CSV attachment format

See Email Automated Imports for setup.

Key Reports to Import

Profile Performance Report

Overall social presence metrics:

  • Impressions and reach
  • Engagements (likes, comments, shares)
  • Follower growth
  • Post frequency

Post Performance Report

Individual content analysis:

  • Post text and type (image, video, link)
  • Engagement metrics per post
  • Publishing time
  • Platform breakdown

Engagement Report

Interaction analysis:

  • Messages received and sent
  • Response time
  • Engagement by type
  • Sentiment analysis

Tag Performance Report

Campaign tracking:

  • Performance by tag/campaign
  • Content category effectiveness
  • Hashtag performance

Team Performance Report

For teams using Sprout for publishing:

  • Posts by team member
  • Average response time
  • Engagement by author

Available Metrics

CategoryMetrics
ReachImpressions, Reach, Audience Growth
EngagementLikes, Comments, Shares, Clicks, Saves
VideoViews, Watch Time, Completion Rate
PublishingPosts Published, Post Types, Best Times
CommunityFollowers, Following, Messages
SentimentPositive, Neutral, Negative sentiment

Blending with Other Marketing Data

Social media data is most powerful when combined:

SourceAnalysis Enabled
Google AnalyticsSocial traffic to conversion analysis
Meta AdsPaid vs. organic social comparison
HubSpot/CRMSocial engagement to leads
Email MarketingCross-channel campaign performance
Revenue DataSocial media ROI attribution

Example: Cross-Channel Analysis

Ask Scoop:
"Compare cost per engagement across
Facebook organic, Facebook paid, and Instagram"

Best Practices

Export Consistently

  • Weekly exports for trend analysis
  • Daily exports if tracking real-time campaigns
  • Include all managed profiles

Use Tags for Campaigns

Leverage Sprout's tagging for:

  • Campaign tracking
  • Content category analysis
  • A/B test grouping

Include All Platforms

Export data for all social platforms:

  • Facebook (organic and paid)
  • Instagram
  • Twitter/X
  • LinkedIn
  • Pinterest
  • TikTok

Common Use Cases

Content Strategy

Find what resonates:

"Which content types have the highest engagement rate by platform?"

Posting Optimization

Identify best times:

"Show average engagement by day of week and hour"

Campaign Analysis

Track campaign performance:

"Compare engagement rates across our Q4 campaigns"

Platform Comparison

Benchmark platforms:

"Which platform has the best reach-to-engagement ratio?"

Growth Tracking

Monitor audience growth:

"Show follower growth rate by platform over the last 6 months"

Team Performance

Track team output:

"Average response time to messages by team member"

Social Media vs. Other Marketing

Understanding where social fits:

MetricSocial StrengthLimitation
EngagementDirect measurementNot revenue
ReachBrand awarenessQuality varies
SentimentReal-time feedbackSample bias
CostLow per impressionAttribution hard

Use Scoop to connect social metrics to business outcomes by blending with revenue and conversion data.

Troubleshooting

Metrics Don't Match Sprout Dashboard

  • Check date ranges are identical
  • Verify timezone settings
  • Some dashboard metrics may be aggregated differently

Missing Platform Data

  • Ensure all profiles are included in the report
  • Check that platform is connected in Sprout
  • Verify API permissions haven't expired

Engagement Counts Off

  • Sprout may count total vs. unique differently
  • Check metric definitions in your export
  • Organic vs. paid engagement may be separate

Related Resources