metrics-normalization-formatter
You are an expert in creator marketing data operations who specializes in cleaning, standardizing, and merging influencer campaign metrics across platforms and reporting tools. You have spent years untangling the spreadsheets that creator marketing teams actually work in — columns named differently across exports, duplicate rows from overlapping data pulls, engagement numbers that mean different things on different platforms, and metrics scattered across screenshots, CSVs, and dashboard exports that all need to land in one tracker.
Assessment Tone
Write normalization outputs like a meticulous data ops lead handing off a clean dataset to the reporting team — precise field names, consistent formatting, zero ambiguity about what each column means. Assume the reader manages creator campaigns daily and already knows what reach, impressions, and engagement rate mean. Do not explain basic metric definitions. Focus on mapping, cleaning, and delivering a table they can paste directly into their master tracker.
Check for Brand Context
Check if .claude/brand-context.md exists.
- If it exists: Read it. Use the brand's platform presence, campaign details, creator roster, and preferred metrics to pre-populate field mappings and skip questions the context already answers.
- If it does not exist: Proceed to information gathering below.
Information Gathering
Before normalizing any data, establish these inputs. Most creator marketing teams pull metrics from three to five different sources — Instagram Insights screenshots, TikTok analytics exports, YouTube Studio downloads, third-party tools like HypeAuditor or CreatorIQ, and their own manual tracking spreadsheets. The result: column names that do not match, duplicate rows for the same creator, numbers that mean different things on different platforms, and a master tracker nobody trusts. This skill replaces the hour of manual cleanup before every reporting cycle.
Required Inputs
More from archive-dot-com/creator-marketing-skills
multi-platform-format-adapter
Adapt a single master creator brief into platform-specific versions for TikTok, Instagram Reels, and YouTube Shorts with correct specs, safe zones, and platform-native guidance. This skill should be used when converting a brief for multiple platforms, adapting a campaign brief from TikTok to Reels, creating platform-specific content briefs from a master brief, adjusting video specs for different short-form platforms, building TikTok and Reels and Shorts versions of one brief, formatting creator deliverables by platform, splitting a campaign brief into platform versions, or generating platform-adapted briefs for a multi-platform creator campaign. For writing the master brief itself, see content-brief-builder. For generating content concepts before briefing, see creator-content-concept-generator. For checking submitted content against a brief, see content-to-brief-compliance-checker.
65creator-content-concept-generator
Generate 5-10 tailored content concepts for a creator partnership that feel native to the creator's style rather than brand-dictated. This skill should be used when brainstorming content ideas for a creator campaign, generating influencer content concepts, ideating creator deliverables, coming up with content angles for an influencer partnership, developing video concepts for TikTok or Reels or YouTube Shorts, creating content hooks for a creator collab, building a concept menu for a creator brief, generating native-feeling content ideas for a sponsored post, or planning what a creator should actually make. For writing the full content brief after selecting concepts, see content-brief-builder. For building the campaign brief that precedes content planning, see campaign-brief-generator. For adapting a single concept across platforms, see multi-platform-format-adapter.
55creator-outreach-sequence-generator
Generate a multi-touch outreach sequence for reaching creators across email, Instagram DM, TikTok DM, YouTube email, or X DM. This skill should be used when writing creator outreach messages, building an outreach sequence, drafting influencer DMs, creating a follow-up cadence for creators, writing cold outreach to influencers, generating partnership pitch messages, building a creator recruitment sequence, writing collab DMs, drafting outreach emails to creators, planning multi-touch creator outreach, or creating a creator outreach campaign. For building the brand context file first, see brand-context. For writing individual content briefs to send after a creator agrees, see content-brief-builder. For vetting creators before reaching out, see creator-vetting-scorecard.
53paid-social-creative-brief
Generate a paid social creative brief from a whitelisted or Spark Ad creator post, covering hook analysis, messaging angle, audience targeting, caption variants, and placement recommendations. This skill should be used when turning a creator post into a paid ad brief, writing a creative brief for whitelisted content, briefing the paid team on creator content, generating Spark Ads briefs from organic posts, creating paid media briefs from influencer content, translating UGC into a paid social strategy, building a media buyer brief from a creator video, preparing whitelisted content for ad spend, or generating placement recommendations for boosted creator content. For adapting captions into ad copy variants, see paid-ad-copy-adapter. For organic repost captions, see organic-repost-caption-writer. For FTC compliance, see ftc-disclosure-spot-checker.
52campaign-roi-calculator
Calculate influencer campaign ROI and build a leadership-ready narrative summary from raw performance data. This skill should be used when calculating ROI for a creator campaign, building a campaign performance report for leadership, turning raw influencer metrics into an executive summary, computing CPM CPE ROAS and EMV for a creator program, summarizing campaign spend versus revenue for a stakeholder meeting, proving influencer marketing ROI to a CMO or VP, creating a campaign wrap report with financial metrics, or comparing influencer channel efficiency against paid social. For setting KPI targets before a campaign launches, see performance-benchmark-setter. For tracking creator posting compliance, see creator-posting-compliance-tracker. For full end-of-campaign reporting with qualitative analysis, see post-campaign-creator-scorecard. For building UTM links to enable attribution, see utm-parameter-builder.
49organic-repost-caption-writer
Input the original caption, creator handle, and brand voice and receive 3 ready-to-post captions for reposting creator content to your brand's social channels with proper credit and attribution. This skill should be used when writing a repost caption for a creator's content, drafting captions to reshare UGC on your brand account, creating branded captions for reposting influencer content, writing credit captions for sharing creator videos on your brand feed, adapting a creator's post for your brand's Instagram or TikTok, generating repost captions with proper creator attribution, repurposing creator content captions for brand channels, or writing share captions for UGC reposts. For generating ad copy from creator content, see paid-ad-copy-adapter. For writing a paid social brief from whitelisted posts, see paid-social-creative-brief-from-creator-content. For building content briefs before production, see creator-content-concept-generator.
49