Question

Please help. I will give thumbs up. Thanks

While growing up in Oulu, Finland, Anastasia's family instilled in her three core values: (1) hard work. (2) diligence, and (3) fitness. When she moved to Seattle, Washington, Anastasia decided to open a gym for women, modeled according to her ideals and principles. She met you through social media, and because of your expertise in marketing, she asked you to help her with analyzing the success of her multi-platform social media fitness campaign to increase women's engagement in physical activities. She informed you that research has found that 75 percent of women want to increase their level of physical activity or work out more, but may not do so because of inhibition or embarrassment. Therefore, there is a need to approach and convert some of these women into customers at her gym. Anastasia has decided to create a social media fitness campaign targeting women aged 15-50 to inspire them to adopt her values by increasing their engagement in physical activities during the week and ignoring others' judgment and criticism. You inform Anastasia that when planning a social media campaign, it can't be approached from a conventional or across-the-board, big media advertising mindset. Instead, it must be well-planned. pertinent to viewers, and most importantly, inherently shareable. People will only communicate a message if it resonates with them personally when connecting with friends, family, and followers (i.e.. groups). Ultimately, when someone decides to share a concept, such as increasing physical activity. she must feel that it defines her in every way. You conclude that the fitness campaign should manage perceptions of the new gym and communicate its values to others. Then, you move on to analyze the data of several variables, ratios, and a Pearson correlation. Figure 1: Social Media Marketing Metrics (Share of Voice and SM ROI Ratios) Measuring the Success of Various Platforms Social Media Marketing Metrics Linkedin Twitter Facebook YouTube Blog Views and Reach of Anastasia's Gym Connections: 150 Followers: 260 Likes: 170 Visitors: 195 Subscribers: 110 Engagement with Anastasia's Retweets, Mentions and Comments: 70 Shares: 88 Ratings: 56 Clicks: 49 Gym Direct Messages: 60 Total Number of Online Activities (Reach + Engagement) of 120 155 140 150 123 Competitor's Gym Online Lead Generation Webinar Registrations for Content Phone-in Online Sales: Conversion Form Registrations: 45 Downloads: 85 Leads: 26 95 Completions: 35 Social Media Investment 5000 6000 5500 7500 2500 Social Media Return 7000 10000 6500 9000 4500

Answer 1

The question is solved in excel.

Excel Formulations:

Solution of Metrics is as follows,

If you like the answer please give an up-vote, this will be quite encouraging for me, thank you.

If you have further suggestions in answer, please write below on the comment section, I will certainly look into it.