Anjum Hotel Digital Marketing Campaigns.

In that project, in my work at The Analyst company, I analyzed Digital Marketing Campaigns for Anjum Hotel. Analyze CPA(Cost per acquisition), CTR(The Click-Through Rate), Conversions
Social Media, Customer Patterns, Forecasting, and recommendations to help them to achieve growth. Tools I used (Python, Tableau, PowerPoint)

1. Digital Marketing Campaigns Analysis Analysis by: Begad Osama

2. Total Cost CPA CTR Conversions Contents

3. Total Cost

4. This chart shows the count of Campaigns by Campaign Type and platform Count of Camps 100

5. Minimum Q1 Q3 Maximum Total Cost 1.36 M This chart shows the ranges of exchange amounts, the minimum, Q1 is 25% of the total, the average is, Q3 is 75% of the total, and the maximum.

6. Facebook Linked in

7. This chart shows the total cost by platform per each Campaign Type, The number above column shows the total campaign type 522K 324K 292K 225K

8. This chart shows the Average cost for each camp according to type, from lowest to highest

9. CTR

10. Minimum Q1 Q3 Maximum Impressions Clicks CTR 5 M 560 K 41.6% CTR : is the ratio of users who click on an ad to the number of total users who view the ad (impressions). This chart shows the ranges of exchange CTR, the minimum, Q1 is 25% of the total, the average is, Q3 is 75% of the total, and the maximum.

11. This chart shows Top 10 Campaigns achieved a high CTR , These 10 campaigns have a CTR of 291%, while the other 94 campaigns have a CTR of 14%.

12. This chart shows the CTR by platforms per each Campaign Type

13. CPA

14. Minimum Q1 Q3 Maximum CPA : CPA is the cost associated with acquiring a conversion. It measures the cost-effectiveness of a campaign in driving the desired actions. This chart shows the ranges of exchange CTR, the minimum, Q1 is 25% of the total, the average is, Q3 is 75% of the total, and the maximum. CPA 7K

15. This chart shows the CPA by platforms per each Campaign Type

16. Conversions

17. Minimum Q1 Q3 Maximum Conversion Conversion Rate 54K 10.2% Facebook Conversion Rate 10.4% Linkedin Conversion Rate 10.02% This chart shows the ranges of exchange Conversion Rate, the minimum, Q1 is 25% of the total, the average is, Q3 is 75% of the total, and the maximum.

18. This chart shows the Conversion Rate by platforms per each Campaign Type

19. Recommendations

20. Recommendations 1. Optimize Campaign Spending Reallocate Budget : Shift budget towards platforms and campaign types with higher conversion rates (e.g., Facebook for conversions) to maximize ROI. Cost-Effective Strategies : Focus on strategies that provide high engagement at lower costs. For instance, LinkedIn shows high efficiency in lead generation compared to other campaign types. 2. Improve Campaign Performance Enhance CTR : To boost the Click-Through Rate (CTR), create more compelling ad content, experiment with different formats, and use A/B testing to identify the most effective ad variations. Lower CPA : Implement retargeting campaigns and optimize landing pages to reduce the Cost Per Acquisition (CPA), thereby improving the overall cost-effectiveness of campaigns. 3. Leverage Platform Strengths Platform-Specific Strategies : Utilize Facebook’s strengths in engagement and conversion by designing interactive and visually appealing campaigns. For LinkedIn, focus on professional and informational content that drives lead generation.

21. Recommendations 4. Audience Targeting and Segmentation Refine Targeting : Use detailed audience segmentation to target ads more precisely. Tailor content to specific demographics, interests, and behaviors to improve relevance and effectiveness. Retargeting Campaigns : Implement retargeting strategies to re-engage users who have shown interest but not converted. This can significantly increase the conversion rate by reminding potential customers of your offerings. 5. Content Strategy Create High-Quality Content : Develop content that resonates with your audience, including informative articles, engaging videos, and compelling images. High-quality content can improve engagement and increase the likelihood of conversions. Regular Updates : Keep your content fresh and relevant by regularly updating your campaigns. Monitor trends and update your content strategy accordingly to maintain audience interest. 6. Performance Monitoring and Analysis Regular Performance Reviews : Continuously monitor campaign performance metrics such as CTR, CPA, and conversion rates. Use this data to identify successful strategies and areas needing improvement. Advanced Analytics : Leverage advanced analytics tools to gain deeper insights into campaign performance. Analyze customer behavior, ad interactions, and conversion paths to optimize future campaigns.

22. Recommendations 7. Test and Experiment A/B Testing : Conduct A/B testing for various elements of your campaigns (e.g., ad copy, images, CTAs) to determine what works best. This iterative approach can help fine-tune campaigns for better performance. Experiment with New Formats : Explore new ad formats and platforms to expand your reach and discover additional opportunities for engagement and conversions. 8. Enhance User Experience Optimize Landing Pages : Ensure that landing pages are user-friendly and mobile-optimized, and provide a clear path to conversion. Fast-loading, intuitive pages can significantly improve conversion rates. Clear CTAs : Use clear and compelling Calls to Action (CTAs) in your ads and landing pages to guide users toward the desired action. Effective CTAs can boost both CTR and conversion rates. 9. Foster Brand Loyalty Customer Engagement : Engage with your audience through social media, email newsletters, and personalized communications. Building a strong relationship with your audience can lead to increased loyalty and repeat business. Loyalty Programs : Implement loyalty programs that reward repeat customers. Offering incentives such as discounts, exclusive offers, and early access to new products can encourage customer retention.

23. Thank You For Your Time Analysis by: Begad Osama