Marketing Influencer Campaign ROI Data

This dataset provides detailed performance metrics for influencer marketing campaigns, including engagement rates, conversions, costs, and calculated ROI. It enables brands and agencies to benchmark influencer strategies, optimize campaign investments, and analyze cross-platform effectiveness for data-driven marketing decisions.

  • opened 19 times
  • last updated 20 Aug 2025
  • by GoMask
The brief that made it

Benchmarking influencer campaign effectiveness across platforms and brands

Sample rows

preview · 8 of 200 rows · all 22 columns
campaign_idstringcampaign_statusstringengagement_ratefloatplatformstringcampaign_namestringbrand_namestringinfluencer_idstringinfluencer_namestringinfluencer_handlestringcampaign_start_datedatecampaign_end_datedatecontent_typestringfollowers_countintegerimpressionsintegerengagementsintegerclicksintegerconversionsintegerconversion_ratefloatcampaign_costfloatrevenue_generatedfloatroifloatcurrencystring
CMP1001Completed12.14InstagramSpring Style BlastUrbanWearINF2001Sophia Martinez@sophia.martinez2022-03-052022-03-20Story1200000420000051000032000420013.13850001750001.06USD
CMP1002Completed11.92YouTubeTech Trends LaunchTechifyINF2002Lucas Chen@lucas_chen.tech2023-09-102023-09-25Video670000260000031000018000270015570001150001.02USD
CMP1003Completed13.41TikTokSummer Glow UpGlowCosmeticsINF2003Amelia Green@amelia.green2021-06-012021-06-15Video505000185000024800011500160013.9142000680000.62USD
CMP1004Completed12.06InstagramAutumn AdventureTravelMateINF2004Noah Fischer@noah_fischer2022-10-012022-10-21Live19900006300000760000520007800151250002450000.96USD
CMP1005Completed15.26FacebookBack To School BuzzEduTechProINF2005Emily Carter@emily.carter2023-08-152023-08-30Post7500038000580012001801595048004.05CAD
CMP1006Completed18.54InstagramWellness WeekendPureHealthINF2006Isabella White@isabella_white2024-03-192024-03-27Story87500410000760004500900202500105003.2USD
CMP1007Completed14.19TikTokFitness FrenzyActiveLifeINF2007Mason Thompson@mason.thompson2022-05-102022-05-22Live230000620000880003200480158000215001.69USD
CMP1008Completed9.05YouTubeGadget GiveawayGizmoWorldINF2002Lucas Chen@lucas_chen.tech2021-08-012021-08-10Video670000210000019000010500160015.2434000590000.74USD

What the 200 rows show

from the 200-row sample

Completed (campaign status) stands out: mean engagement_rate is 14.2, against 0.0 for the rest.

  • 12.2median engagement_rate
  • 5content types
  • 6currencies
  • 66,000median followers_count
  • 208,500median impressions
  • 23,850median engagements
Mean engagement_rate by campaign_status200 rows
05010014.2Completed181 rows0.0Paused3 rows0.0Cancelled16 rows
engagement_rate200 rows, in bands of 10
0701405613192000002050100engagement_rate →

Median 12.2, from 0.0 to 100.0.

platform200 rows · 6 values
  1. Instagram62
  2. YouTube39
  3. Facebook37
  4. TikTok29
  5. Other22
  6. Twitter11
22 columns by typefrom the column list below
  • string 10
  • integer 5
  • float 5
  • date 2

Columns

22 columns in three groups
blueprint · 22 columns
columntypedescriptionexample
Text 10 columns
campaign_idstringUnique identifier for each influencer marketing campaignuniqueCMP1001
campaign_namestringName or title of the influencer campaignSpring Style Blast
brand_namestringName of the brand sponsoring the campaignUrbanWear
influencer_idstringUnique identifier for the influencer involved in the campaignINF2001
influencer_namestringName of the influencerSophia Martinez
influencer_handlestringSocial media handle or username of the influencer@sophia.martinez
platformstringSocial media platform where the campaign was run (e.g., Instagram, YouTube, TikTok)6 valuesInstagram
content_typestringType of content used in the campaign (e.g., post, story, video, live)Post · Story · Video · Live · OtherStory
currencystringCurrency code used for cost and revenue (e.g., USD, EUR)6 valuesUSD
campaign_statusstringCurrent status of the campaign (e.g., completed, ongoing, paused, cancelled)Completed · Ongoing · Paused · CancelledCompleted
Numbers 10 columns
followers_countintegerNumber of followers the influencer had at the time of the campaign0 or more1200000
impressionsintegerTotal number of times the campaign content was displayed0 or more4200000
engagementsintegerTotal number of engagements (likes, comments, shares, etc.) on campaign content0 or more510000
engagement_ratefloatEngagement rate as a percentage (engagements/impressions * 100)0 to 10012.14
clicksintegerNumber of clicks generated by the campaign content0 or more32000
conversionsintegerNumber of successful conversions attributed to the campaign (e.g., purchases, sign-ups)0 or more4200
conversion_ratefloatConversion rate as a percentage (conversions/clicks * 100)0 to 10013.13
campaign_costfloatTotal cost incurred for running the campaign (in USD)0 or more85000
revenue_generatedfloatTotal revenue generated from the campaign (in USD)0 or more175000
roifloatReturn on investment for the campaign ((revenue_generated - campaign_cost) / campaign_cost)1.06
Dates and times 2 columns
campaign_start_datedateStart date of the campaign2022-03-05
campaign_end_datedateEnd date of the campaign2022-03-20

15 SQL practice questions for the Marketing Influencer Campaign ROI Data

Written for this data and checked against it: 12 SQL and 3 Power BI exercises from beginner to advanced. Try the first three free; the practice kit has all 15, a starter .sql file and an answer key with every expected result.

  1. 01BeginnerFreeSELECT · ORDER BY · LIMIT

    Top 10 campaigns by revenue

    Return campaign_id, campaign_name, platform and revenue_generated for the 10 campaigns with the highest revenue_generated. Order by revenue_generated descending, then by campaign_id ascending.

    Tables: marketing_influencer_campaign_roi_data · your result: 4 columns, 10 rows
  2. 02BeginnerFreeDISTINCT · ORDER BY

    Distinct platforms and content types

    Return each distinct combination of platform and content_type, using those two column names. Order by platform, then by content_type.

    Tables: marketing_influencer_campaign_roi_data · your result: 2 columns, 14 rows
  3. 03BeginnerFreeWHERE · AND · ORDER BY

    Completed Instagram campaigns

    Return campaign_id, brand_name, campaign_cost and conversions for campaigns where platform is 'Instagram', campaign_status is 'Completed' and conversions is greater than 3000. Order by conversions descending, then by campaign_id ascending.

    Tables: marketing_influencer_campaign_roi_data · your result: 4 columns, 17 rows
  1. 04Campaign count per platformBeginner
  2. 05Revenue and cost by campaign statusPower BI
  3. 06Platforms with high average ROIIntermediate
  4. 07Follower size bucketsIntermediate
  5. 08Campaigns above overall average costIntermediate
  6. 09Yearly campaigns and profitIntermediate
  7. 10Conversion rate by platformPower BI
  8. 11Top 3 campaigns per platformAdvanced
  9. 12Running revenue by monthAdvanced
  10. 13Yearly revenue change with LAGAdvanced
  11. 14Platform share of total revenueAdvanced
  12. 15ROI anomalies versus platform averagePower BI

Get the practice kit: the full dataset, all 15 exercises, a starter .sql and the answer key. One-time $3.99.

Get the practice kit · $3.99

Use it for

  • median engagem…12.2200 rowsmean engagement rate …14.2Comple…0.0Paused0.0Cancel…

    A marketing dashboard

    Engagement_rate by campaign_status and a breakdown of platform. Excel, Power BI or Tableau.

  • Why do the 181 Completed rows have a mean engagement_rate of 14.2?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable campaigns with campaign_name, brand_name and influencer_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 22 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows22 columns
Yours1,000 rows22 columns

blueprint · marketing-influencer-campaign-roi-data

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 22 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Campaign, influencer, and brand anonymized
  • Engagement metrics and conversion tracked
  • Campaign spend and calculated ROI included
  • Platform and audience segment annotated
  • Outlier campaigns with high/low ROI marked
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
marketing-influencer-campaign-roi-data

More in Marketing

Browse all
Also in MarketingCampaign Conversion AnalyticsMarketing Campaign AI Optimization LogsAd Spend to Revenue AnalysisAll 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.