Marketing Analytics - Excel Data Analysis of Influencer Activity

Order the writing of a tailor-made Business strategy Research papers

Tutorials/exercises Format .pptx

Marketing Analytics - Excel Data Analysis of Influencer Activity

Download

Themes

EMV Earned Media Value, total creators, efficiency, brand strategy, marketing efficiency, creator exclusivity, influencer marketing, social media marketing, brand loyalty, digital marketing strategy, influencer, strategy evaluation, marketing analytics

Reader
Abstract
Extract

Abstract

The assignment is to produce a 5-page PowerPoint report based on an Excel dataset containing real influencer marketing activity. The goal is to analyze the data and answer two business questions:
- Question 1. General Market Analysis: Analyze the data to assess the success of the brands in this category. What can you infer about their marketing strategies? What insights can be drawn from the data?
- Question 2. Strategy Evaluation: Evaluate the effectiveness of collaborating with exclusive creators--those who partner with only a single brand. Does this strategy make sense in this category?

Extract

[...] The majority of the success in this market is secured by loyalty to a single brand (Success dominance ) B-Exclusive creators are more efficient, with an EMV per Post (25,646) higher than that of nonexclusive creators (24,851). Although the difference is small, it is translated into millions of additional EMV when extended across the entire volume of activity (Proof of efficiency) As a recommendation, brands should focus their efforts on retaining their creators to ensure exclusivity, as this generates slightly higher-performing content and helps secure the majority of the market's media value Recommendations and conclusion: synthesis of the results Domain Key finding Key evidence Leadership Red Bull is the leader in absolute success (Total EMV) Efficiency outweighs volume 302 million EMV (vs 189 million for the 2nd CocaCola) Bang Energy (1st in EMV/Creator) is 11 times more efficient than Coca-Cola (1st in volume) Exclusive creators are more efficient ( EMV/Post) and dominate market success (708M EMV) Strategy Exclusivity The strategy of exclusive creators is the most effective norm Recommendations 1-Prioritize efficiency over Volume (Stop pursuing maximum reach exclusively. [...]

[...] 2-The key to success in this category lies in the efficiency of the message and the creator, and not in the number of partnerships. Strategy evaluation (Exclusivity): comparison of total EMV and EMV per post The analysis of collaboration with exclusive creators is crucial. We compare creators who work with only one brand (Exclusive) and those who work with several brands (Non-Exclusive). Creator status Total EMV Total posts EMV per post Exclusive 708 million NonExclusive 569 million A-Exclusive creators generate 708 million in EMV, compared to 569 million for non-exclusive creators. [...]

[...] Pepsi Gatorade Total EMV Red Bull is the clear market leader, having generated 302 million in EMV. Strategies and efficiency (EMV per creator) • The comparison between Total Creators (Activity) and EMV per Creator (Efficiency) reveals three distinct strategies: Brand Total creators (Rank) EMV per creator (Efficiency) Strategies Bang Energy 441 (10th) (1st) Utilizes a minimal yet extremely relevant and high-performing network.(Hyper-efficiency strategy ) Red Bull 6008 (4th) (3rd) Achieves absolute success by combining decent reach with efficiency that is well above average (Balance strategy ) Coca-Cola (8th) Prioritizes maximum reach, but its low average efficiency suggests less precise targeting or less viral content (Volume strategy ) Strategic analysis: volume vs efficiency visualization Insights: 1-Total Creators (volume of activity) is not correlated with success (Total EMV). [...]

[...] Alani Nu • Determination of Exclusivity Status We grouped all data rows by the unique identifier of each creator (Creator ID). Then, counting unique brands, Here, for each creator ID, we counted the number of unique brands they appeared in. -If the count of unique brands for a Creator ID is equal to they are classified as EXCLUSIVE. -If the count is greater than 1 or more), they are classified as NONEXCLUSIVE. [...]

pptx