Social Reporting CSV Normalizer
Clean, normalize, and summarize multi-platform social media CSV exports in your browser. Deduplicate campaign post IDs and calculate weighted engagement without OAuth or cloud storage.
Multi-Platform CSV Import
Upload or paste your campaign post exports. Local browser execution ensures total client confidentiality.
6 total lines imported
Filtered out duplicate post IDs
Likes + Comments + Shares + Saves
1 collab posts identified
• Filtered out 1 duplicate post IDs to avoid double-counting interactions.
• Unique reach cannot be summed across individual posts to represent deduplicated total audience size. Summed reach represents gross post impressions without audience deduplication.
Platform-by-Platform Summary
Weighted engagement rates calculate interactions over total observed impressions.
| Platform | Posts | Total Interactions | Total Impressions | Summed Reach | Weighted Engagement |
|---|---|---|---|---|---|
| 2 | 1,431 | 30,900 | 24,000 | 4.63% | |
| tiktok | 2 | 5,945 | 107,000 | Missing / Blank | 5.56% |
| youtube | 1 | 395 | 8,500 | 7,200 | 4.65% |
The Three Fatal Flaws in Influencer Campaign Reporting
Social media managers and agency buyers lose hundreds of hours reconciling contradictory spreadsheets at the end of each monthly billing cycle. The three most common mathematical errors include:
Average of Percentages
Averaging 10% engagement on 100 views with 1% engagement on 100,000 views produces a misleading 5.5% average, when the true weighted engagement is 1.01%.
Summing Unique Reach
Summing Reach across 5 posts creates duplicated impressions. A brand with 10,000 actual reach is mistakenly reported as having reached 50,000 distinct individuals.
Duplicate Collab Imports
When co-authoring Instagram Reels, both creator accounts export the exact same post. Unfiltered imports artificially double likes, comments, and views.
How to use Social Reporting CSV Normalizer
- Export Post Metrics from Meta, TikTok, or YouTube. Download native campaign or post-level analytics exports from Meta Business Suite, TikTok Ads Manager, or YouTube Studio.
- Upload or Paste CSV Data. Import your raw CSV. The normalizer matches column dimensions, retains missing data flags, and cleans duplicate post tracking IDs.
- Export Clean Normalized Summary. Review weighted interaction rates by platform and download a standardized, formula-safe CSV summary for your client decks.
Guide updated .
Social Media Reporting Best Practices
Audit Post ID Uniqueness First
Always verify that each campaign post has a distinct identifier before sending performance recaps to agency sponsors.
Keep Numeric Zeroes Distinct from Missing Values
A post with 0 comments had active views but no feedback. A post with blank comment tracking was unmeasured. Conflating the two damages report integrity.
Combine with the Instagram Engagement Calculator
For fast single-profile checks, use our Instagram Engagement Calculator to audit median versus mean post interactions.
FAQ
Why can’t I sum unique reach across multiple posts to find total audience?
Unique reach measures distinct user accounts that viewed a specific post. If User A views Post #1 and Post #2, summing reach counts User A twice. Adding unique reach across posts creates gross reach (which is effectively impressions), not a deduplicated total audience size. Only platform native APIs with identity graphs can compute deduplicated multi-post reach.
What is the formula for Weighted Engagement Rate?
Weighted Engagement Rate = [Total Interactions across all posts ÷ Total Impressions across all posts] × 100. Calculating the simple mathematical average of individual post percentages skews your metric because smaller posts with high volatility distort the true campaign performance.
How does this tool handle collab posts?
Collaboration posts on Instagram and TikTok display shared engagement on both creator profiles. When brands export data from both partners, collab posts are often double-counted. Our normalizer tracks unique post IDs to filter out duplicated records.
Are client analytics files or confidential performance data uploaded?
No. All processing, column normalization, and CSV generation occur 100% client-side in your browser via the HTML5 File API. No client identifiers, post metrics, or proprietary brand figures are sent to any server.
Sources and further reading
Auditing individual Instagram profile engagement rates?
Calculate mean and median engagement across your latest 10 posts with follower and reach benchmarks.