Influencer marketing case study: compare your past campaigns and draft the one you send to new clients

The brand's starting point, what was run (how many creators, which tiers, which platforms, which dates), three or four results with the figure behind each, what the agency learned, and what it would do next. Results a brand can check, such as public views and engagement, carry more weight than adjectives. Reach, clicks and sales come from the platforms' own dashboards, so name where each one came from.

Compare views and cost per 1,000 views first. Engagement rate is not like for like: TikTok shows shares and Instagram does not, so the same post reads lower on Reels. Put the posts in one sheet with a Campaign column, upload it, and each campaign comes back split by platform.

ROI needs revenue: (revenue from the campaign − creator fees) ÷ creator fees, with revenue from a discount code, an affiliate link or the shop's own reports. Public data gives the cost side: fees divided by views gives cost per 1,000 views, which you can compare across campaigns and creator tiers. Add revenue from your exports to the optional field and the case study quotes it as reported; the free earned media value calculator works out ROI and EMV for one campaign.

It depends on your campaigns, so compare your own instead of an industry average, and check the median. In the November 8 example the Macro tier looked best at $5.83 per 1,000 views until its one breakout post was set aside: the other three Macro posts cost $14.74. The two Mega posts cost $36.01 per 1,000 views, too few to call a pattern.

No. Views, likes, comments, shares and saves are read from the public posts. Reach, watch time, clicks and sales are only in each platform's own dashboard; paste or upload those exports if you want them in the case study.

Yes, in the optional results field: the PDF's text is added to the field in your browser, and the case study quotes its figures as reported, apart from the public counts. Put the post links themselves in the sheet field, because links in the results text are not looked up. Scanned PDFs have no text to read; paste the figures instead.

The campaign report is for one campaign and one client: totals per creator and a recap email. This tool compares several campaigns against each other by campaign, platform, tier and content type, and writes a case study for a prospective client.

You can start free: new accounts get 100 one-time credits, no card required, enough for one comparison the size of the 33-post example. Failed lookups and repeated links are not charged. Paid plans add monthly credits: Plus has 1,500, about 28 runs of that size a month.

To run it, yes: sign in with Google. It is free and asks for no card. You can read the example and fill in the form before signing in.