1. Project Title & Company Review

Product Campaign Metrics: Comparing Marketing Campaigns against Competitors.
INDUSTRY: Technology & Electronics
TechTech, a prominent and enduring presence in the ever-evolving landscape of technology and electronics. With a legacy spanning over a decade, TechTech has solidified its reputation as a stalwart in the industry. The company specializes in a diverse array of electronic products, encompassing smartphones, laptops, and cutting-edge smart home devices.
TechTech's journey through the dynamic world of technology has been characterized by not only innovation but also resilience in the face of escalating competition. Over the years, the company has honed its expertise, adapting to industry shifts, and consistently delivering high-quality products to a discerning customer base.
As a technology trailblazer, TechTech's commitment to excellence is reflected not only in its product offerings but also in its unwavering dedication to customer satisfaction. The company's ability to anticipate market trends and swiftly respond to consumer demands has been instrumental in maintaining its prominence.

ROLE: Marketing Data Analyst.

2. Business Problem

TechTech faces a multifaceted business challenge that demands astute resolution. The core elements of this challenge encompass:
- Competition Management: TechTech operates in an industry where competition is fierce, with both established giants and nimble newcomers vying for market share. Navigating this competitive landscape requires not only vigilance but also strategic acumen.
- Resource Allocation: In an era of resource constraints, the judicious allocation of marketing resources is critical. Ensuring that every marketing dollar is optimally spent to yield the highest return on investment is an ongoing challenge.
- Performance Evaluation: To thrive in a competitive environment, TechTech must continually assess the effectiveness of its marketing campaigns. Understanding how its campaigns perform relative to competitors is crucial for maintaining a strong market presence.
- Brand Enhancement: In a marketplace teeming with choices, enhancing brand visibility and positioning is an imperative. TechTech must devise strategies that not only resonate with consumers but also strengthen its brand's foothold in the minds of its target audience.

3. Business Objectives

This project has well-defined objectives aimed at addressing the business challenges through Power BI:
- Performance Analysis: Evaluate TechTech's marketing campaign performance.
- Strategy Enhancement: Identify strengths and weaknesses in marketing strategies.
- Channel Optimization: Determine the most effective marketing channels and tactics.
- Actionable Insights: Provide actionable recommendations for improving campaign effectiveness.

4. My Approach

- I carried out the ETL:
• I used MS Excel to check for duplicate data in the csv files of the datasets.
• I imported the csv file into the Power query.
• I created new calculated columns, merge tables in the Power Query.
- Exploratory Data Analysis.
- Data Visualization/Dashboard building.
- Insight generation.
- Recommendation.

TOOL USED: Power BI

5. Key Deliverables

Delivered a Power BI dashboard to improve data-driven decision.

6. Insights

- July generated the highest revenue at $92,084,355, contributing 12.55% of annual revenue, while December recorded the lowest revenue at $31,296,743.
- Competitor C dominated competitor performance, generating $73,114,202 (47.5% of total competitor revenue), outperforming Competitor B and Competitor A.
- Regular customers were the most valuable segment, contributing 40.81% of total revenue ($299,482,122), indicating strong retention and repeat purchase behavior.
- Female customers generated the highest revenue contribution at $282,937,569, outperforming male customers by 48.66%.
- Top-performing campaigns (144, 112, 157) consistently exceeded average revenue benchmarks, making them ideal candidates for budget scaling.
- Several campaigns underperformed despite high impressions, indicating potential inefficiencies in click-through or conversion strategy.

7. Recommendations

- Increase investment in top-performing campaigns
Campaigns 144, 112, and 157 consistently outperformed other campaigns in terms of revenue generation, conversion rate, and overall campaign efficiency. TechTech should allocate a larger share of its marketing budget toward these high-performing campaigns while analyzing their success factors (target audience, messaging, timing, and channels) for replication across future campaigns.
- Optimize underperforming campaigns
Several campaigns generated high impressions but relatively lower conversions, suggesting inefficiencies in audience targeting or campaign messaging. TechTech should conduct periodic campaign audits to assess:
• Audience relevance.
• Ad creatives.
• Landing page experience.
• Conversion funnel bottlenecks.
Poorly performing campaigns should either be redesigned or discontinued.
- Strengthen retention strategies for Regular customers
Regular customers contributed the highest revenue share (40.81%), making them TechTech’s most valuable customer segment. The company should implement retention-focused initiatives such as:
• Loyalty rewards.
• Personalized promotions.
• Email remarketing campaigns.
• Exclusive offers for returning customers.
This can improve customer lifetime value and repeat purchases.
- Expand marketing efforts toward high-performing demographics
Female customers generated the highest revenue contribution, indicating stronger purchasing behavior within this segment. TechTech should design more targeted campaigns tailored toward this audience through:
• Personalized messaging.
• Product bundling.
• Targeted digital advertising.
At the same time, strategies should be developed to improve engagement among underperforming customer groups.
- Benchmark against Competitor C
Since Competitor C recorded the highest competitor revenue, TechTech should conduct competitor benchmarking to understand:
• Product positioning.
• Pricing strategy.
• Promotional tactics.
• Customer acquisition channels.
Insights from competitor analysis can help refine TechTech’s market positioning and competitive strategy.
- External factors such as inflation and GDP significantly influence campaign performance by affecting customer purchasing power, spending confidence, operational costs, and conversion behavior. Rising inflation may reduce consumer willingness to purchase discretionary products, while stronger GDP growth supports improved campaign outcomes and revenue performance.