This report analyzes the Click-Through Rate (CTR) performance and overall conversions of digital marketing campaigns conducted by a fictitious company named PopCrt. The primary goal is to evaluate the efficacy of various campaigns and offer insights to enhance future strategies.
Project Brief
Hey 👋
PopCrt has been pouring resources into their digital marketing campaigns, but they're a bit in the dark about the effectiveness of these strategies. They need our help to figure out what's working and what isn't.
So, here's our mission: we need to dive deep into their marketing advertisement data to shed some light on a few key areas:
- Product Popularity: Which product categories resonate most with different customer segments? Are there specific products that stand out among certain demographics?
- Campaign Performance: How do campaigns perform based on gender? Are there campaigns that perform exceptionally well with either males or females?
- Location-based Engagement: Where are users most likely to interact with our marketing content? Which geographical locations show the highest engagement?
Feel free to share any additional ideas you come across during your research that could help PopCrt succeed.
The presentation to the client is in two weeks, so we have quite a tight timeline. But I know you can do it! Let's dive into this data and get them the answers they need.
Thanks to all of you for your hard work. Let's crush this one 💪
Note: PopCRT is a fictional entity, and the insights drawn from this simulated dataset are solely intended to showcase the capabilities of data analysis and visualization in informing strategic business decisions.
Background
PopCrt, an emerging e-commerce entity, has garnered attention in the Philippines since its inception in 2021, specializing in lifestyle and fashion brands from local independent merchants. Featuring a user-friendly interface and efficient online shopping functionalities, it has attracted a steady stream of customers and maintained growth momentum. Notable for its marked revenue upticks, PopCrt has positioned itself as a notable player in the e-commerce landscape.
Methodology
Six-Stage Data Analysis Lifecycle
Findings
Below are the insights gathered from analyzing the data.
1. Impressions
Impressions According to Campaigns
- The '12 Days of Christmas Deals' campaign garnered the most impressions, totaling 36,191 among the ten campaigns, followed by 'Tech Madness Sale' and 'Mid-Year Mega Sale,' which received 19,717 and 14,568 impressions, respectively.
- From a total of 128,858 impressions, the '12 Days of Christmas Deals' campaign attracted engagement from 66,502 unique users, showcasing a well-distributed impression count across all five regions, with each region accumulating over 4,000 impressions.
- Sports and outdoors attained the highest number of impressions, closely trailed by Health and Beauty, accumulating 43,917 and 31,765 impressions.
- Across various age groups, notably capturing significant impressions among individuals aged 35–44 years with the highest impression count reaching 21,197 and closely followed by the 25–34 age group with 14,439 impressions, sports and outdoors emerged as the dominant category.
- Male customers exhibited a clear preference across all product categories, particularly dominating impressions for sports and outdoor products, accumulating a total of 36,297 reach compared to their female counterparts.
- The impressions from all categories displayed a uniform distribution across diverse regions, totaling 128,858 impressions. Notably, sports and outdoor products alone accumulated over 8,000 impressions in each region.
2. Click-Through Rate
- The collective Click-Through Rate (CTR) across all product categories attained 38.76%, Flash Sale being the highest with 51.92% clicks followed by Tech Madness Sale with 42.53%.
- Electronics and gadgets emerged as the pinnacle of engagement, showcasing an impressive CTR of 47.67%, closely trailed by Health and Beauty with 43.33% and Home and Garden with 40.33%.
- Male clientele exhibited a discernibly superior CTR compared to their female counterparts.
- CTR distribution across all categories showcased a fine balance across five geographical regions.
- Electronics and gadgets exhibit the highest CTR among all age groups, except for the 35-44 age group, where Home and Garden boasted the largest CTR.
- The highest CTR of each campaign significantly varies across product categories, with 'Flash Sale' demonstrating Health and Beauty as its top CTR, while 'Spring Deals' and 'Tech Madness Sales' feature Home and Garden as their leading categories.
3. Conversion
- Out of the total sales revenue of 353 million pesos, a mere 24% was attributed to the administered campaigns, amounting to 87.9 million pesos.
- In terms of overall conversion performance, female customers contributed 13.65% to the revenue distribution, while men accounted for a significant 86.35%.
- 25-44 years old dominated the overall campaign revenue with a total of 71.48% share which is equivalent to 62.8 million pesos.
- Revenue distribution across all five regions demonstrated a fine balance with an average of 20% share from each area.
- From the total campaign revenue of 87.9 million pesos, '12 Days of Christmas Deals' stands out as the highest earner, generating PHP 21.4 million, despite recording purchases from a relatively smaller pool of 1,162 users.
Summary
Conclusion:
PopCrt's digital campaigns have demonstrated success by effectively converting impressions into sales, contributing significantly, with a notable 24% impact on overall revenue. This success is particularly evident in the Sports and Outdoor, as well as Health and Beauty product categories. Impressions and conversions are noteworthy across all regions and among the 25-44 age group. However, there is a distinguished gap in reaching female users when compared to the considerable engagement observed among male counterparts, as well as in the age groups of 18-24 and 55 years and older.
Recommendations
1. Targeted Marketing to Female Users:
- Create gender-specific ad campaigns highlighting products or promotions that resonate with female interests, such as skincare bundles or fitness apparel.
- Conduct market research to understand the specific preferences and pain points of female customers, then tailor marketing messages and offers accordingly.
2. Diversify Ad Campaigns Across Age Groups:
- Develop age-specific landing pages or microsites that cater to the interests and needs of different age groups, featuring relevant products and promotions.
- Launch targeted social media advertising campaigns on platforms popular among younger and older demographics, utilizing demographic targeting options to reach specific age groups.
- A/B test ad creatives and messaging to identify the most effective approaches for engaging different age segments and refine campaign strategies accordingly.
3. Optimize Product Offerings:
- Analyze sales data and customer feedback to identify popular products within the Sports and Outdoor, as well as Health and Beauty categories, and prioritize promoting these items.
- Introduce limited-time offers or bundle deals on high-demand products to encourage conversion and increase average order value.
- Create promotions and bundles that combine sports outdoor products with items from the lagging categories to incentivize customers to purchase across different product categories.
4. Enhance User Experience:
- Conduct usability testing and website analytics to identify potential friction points in the online shopping journey and implement improvements to streamline the checkout process.
- Implement personalized product recommendations based on user browsing history and purchase behavior to enhance product discovery and encourage repeat purchases.
- Invest in mobile optimization to ensure a seamless shopping experience across devices, particularly as mobile traffic continues to grow.
Tagged in: Data Analysis, Data Science, PopCrt