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 Type | Example 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
- In Sprout Social, navigate to Reports
- Select your report type (Profile, Post, Tag, etc.)
- Set your date range and profiles
- Click Export → CSV or Excel
- Upload to Scoop as a new dataset
Option 2: Scheduled Report Emails
- In Sprout Social Reports, click Schedule
- Set the delivery frequency (daily, weekly, monthly)
- Add your Scoop ingest email address
- 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
| Category | Metrics |
|---|---|
| Reach | Impressions, Reach, Audience Growth |
| Engagement | Likes, Comments, Shares, Clicks, Saves |
| Video | Views, Watch Time, Completion Rate |
| Publishing | Posts Published, Post Types, Best Times |
| Community | Followers, Following, Messages |
| Sentiment | Positive, Neutral, Negative sentiment |
Blending with Other Marketing Data
Social media data is most powerful when combined:
| Source | Analysis Enabled |
|---|---|
| Google Analytics | Social traffic to conversion analysis |
| Meta Ads | Paid vs. organic social comparison |
| HubSpot/CRM | Social engagement to leads |
| Email Marketing | Cross-channel campaign performance |
| Revenue Data | Social 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)
- Twitter/X
- 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:
| Metric | Social Strength | Limitation |
|---|---|---|
| Engagement | Direct measurement | Not revenue |
| Reach | Brand awareness | Quality varies |
| Sentiment | Real-time feedback | Sample bias |
| Cost | Low per impression | Attribution 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
- Meta (Facebook) Analytics - Facebook/Instagram direct
- LinkedIn Integration - B2B social analytics
- Google Analytics - Web traffic analysis
- Blending Datasets - Combine with other sources
- Email Automated Imports
Updated 3 days ago