data analysis.

Stuck with a difficult assignment? No time to get your paper done? Feeling confused? If you’re looking for reliable and timely help for assignments, you’ve come to the right place. We promise 100% original, plagiarism-free papers custom-written for you. Yes, we write every assignment from scratch and it’s solely custom-made for you.


Order a Similar Paper Order a Different Paper

data analysis.

data analysis.
BAU Marketing Analytics, 615 Page | 4 BAU 615 Marketing Analytics – Midterm Exam (Four Sections) “TERMINOLOGY APPLICATION AND UNDERSTANDING”: after each term, given an example from the “Digitas” Case [if the information is not found in the case, then find it through research on the Internet OR (capitalized for emphasis only), describe what you would do to get the answer, if it is not shown in the case].” Product – Price – Promotion – Place / Distribution – Positioning – People – Platform – Packaging – “TERMINOLOGY APPLICATION AND UNDERSTANDING”: after each term, given an example from the “In-Depth Performance Marketing” Case [if the information is not found in the case, then find it through research on the Internet OR (capitalized for emphasis only), describe what you would do to get the answer, if it is not shown in the case].” Product – Price – Promotion – Place / Distribution – Positioning – People – Platform – Packaging – “ANALYSIS” Using the data from the PROBLEM that your team worked this semester, from chapter 1 of the assigned text (see reference at bottom). get the spreadsheet and to the following: (… you may refer to the assigned textbook if helpful: provide an answer for each of the following). “Describe” the data. Give an example of a marketing action, related to the “Four Ps – Plus” that you might “Prescribe” based on the data (example, increase price to generate more profits, or add a new feature to sell more of product X). Explain why the action would be helpful for the client in the problem. Give an example of a marketing action, related to the “Four Ps – Plus” that you might “Predict” based on the data (example, I predict we will lose clients if the competition costs less than our product) increase price to generate more profits, or add a new feature to sell more of product X). Explain why the prediction would be helpful for the client in the problem. MARKETING “COMMUNICATIONS”: using what you have learned from reading the “In-Depth Performance Marketing Case” and the “Digitas” Case, Prescribe what BlackFinnDC should consider trying to meet its business goals for the five-block area around its location. Please imagine that you are the BlackFinnDC Vice President of Marketing Analytics when writing the communication. Use the information from the cases as examples and ideas. Limit the prescription to no more than one (1) paragraph, with a maximum of 10 sentences. The prescription should include recommendations and at least two data finding(s) that you think are convincing. REFERENCE MATERIAL FOR QUESTION #3 (ABOVE) – REVISIT THE SPREADSHEETS AND USE THE DATA Exercises The Makeup2007. xl sx file (available for download on the companion website) gives sales data for a small makeup company. Each row lists the salesperson, product sold, location of the sale, units sold, and revenue generated. Use this file to perform the following exercises: Summarize the total revenue and units sold by each person of each product. Summarize the percentage of each person’s sales that came from each location. Create a PivotChart to summarize this information. Summarize each girl’s sales by location and use the Report Filter to change the calculations to include any subset of products. The Station. xl sx file contains data for each family including the family size (large or small), income (high or low), and whether the family bought a station wagon. Use this file to perform the following exercises: Does it appear that family size or income is a more important deter­ minant of station wagon purchases? Compute the percentage of station wagon purchasers that are high or low income. c. Compute the fraction of station wagon purchasers that come from each of the following four categories: High Income Large Family, High Income Small Family, Low Income Large Family, and Low-Income Small Family. The cranberrydata.xlsx file contains data for each quarter in the years 2006–2011 detailing the pounds of cranberries sold by a small grocery store. You also see the store’s price and the price charged by the major competitor. Use this file to perform the following exercises: Ignoring price, create a chart that displays the seasonality of cranberry sales. Ignoring price, create a chart that shows whether there is an upward trend in sales. Determine average sales per quarter, breaking it down based on whether your price was higher or lower than the competitor’s price. The tapedata.xlsx file contains data for weeks during 2009–2011 for the unit sales of 3M tape, price charged, whether an ad campaign was run that week (1 = ad campaign), and whether the product was displayed on the end of the aisle (1 = end cap). Use this file to perform the following exercises: Does there appear to be an upward trend in sales? Analyze the nature of the monthly seasonality of tape sales. Does an ad campaign appear to increase sales? Does placing the tape in an end-cap display appear to increase sales? Email to: [email protected]
data analysis.
In-Depth Performance Marketing Case Study Or how we increased ROI by over 2,000% in just 6 weeks. The case for performance marketing. In-Depth Performance Marketing Case Study February 2021 TL;DR – Our client approached us to work on their Search and Facebook Ad campaigns, which they were running in-house. With cunning, multi-approach strategies, split testing, and ad optimisation we took their ROI from 1.2x to 19x in a couple of months for Search and from 1.07x to 35x on Facebook over the same period. This means that the client multiplied sales many times over without an increase in ad spend, all the time increasing their net brand awareness. In-Depth Performance Marketing Case Study February 2021 Scenario A client that operates in a highly competitive, almost completely commoditized market, approached us to discuss their search campaigns. Their numbers, 1.2 x return on their Google Ads (revenue of €1.20 for every €1 spent), seemed low and they’d heard of our revenue multiplying magic. Seems obvious, but we kicked off the project by applying the scientific method to test the best way forward. Every week we chose one hypothesis to test, changed that factor in 50% of the ad spend and ran the ads for a week, comparing results, choosing the winner and testing another factor aggressively the following week. These tests of fundamentals are what allow us to rapidly increase ROI from one week to the next. In fact, by doing so, the first 6 weeks of working on the account saw us increasing the return on investment from ad spend across the whole account by over 2,000%. These fundamentals varied in scope, in some cases they were technical (setting up ad placements manually vs allowing Facebook to split budgets) whereas in others they were tactical (comparing how ads with different benefits of the product performed in comparison to each other). By rapidly testing the fundamentals we also made it much easier for us to focus on the creative and brand details down the line, safe in the knowledge that we don’t need to test basics for a while. Approach We maintained the client’s presence across the two main platforms they were running on already (Facebook Ads & Google Search) and aggressively tested which placements and ad types would work better, and for which reasons. The Client in question operates in a highly competitive market, which is why we can’t divulge this much detail and the client name, We had to choose one or the other, and we chose to leave the client’s name shrouded since the performance gains can be this great in most markets. Feel free to contact us for further proof. In-Depth Performance Marketing Case Study February 2021 Glossary Conversion The definition of a conversion changes from one campaign to another, however in this case we were measuring actual sales as conversions. For some other campaigns, however, we might count a filled form as a conversion. Fundamentals Some fundamental rules that we applied based on tests that we ran early on in the campaign. LT V Lifetime Value (of a customer). This is the average amount of money a customer spends with a company over the entire lifecycle of the relationship. ROI Return on investment Measured as a multiplier of money spent vs revenue generated. An ROI of 1X would be achieved if we sold €1 for every €1 spent on advertising, 10X is where we sold €10 for every €1 of advertising. In-Depth Performance Marketing Case Study February 2021 Search Engine Marketing (SEM) Strategy This approach is key. With such a wide audience, a single strategy would be a great underutilisation of resources. The beauty of search is that one can create a unique campaign per audience – and every audience can be very minutely defined, especially since the keywords used will usually tell us a lot about the intention of the prospective customer. For this set of campaigns, we split audiences by search intent. Ultimately, this guides purchase behaviour so we could stratify by the aggression of search intent and greatly improve ROI. We’ll get to the numbers in a moment. First, let’s look at a parameter called customer lifetime-value (LTV). While some customers will only ever effect a single purchase, others are repeat customers. The latter can handle more aggressive campaigns than the former. And we know the detail – every one of our campaigns is measured all the way to the moment of purchase. Having this granular tracking allows us to analyse the campaigns that are delivering the highest ROI and to fine-tune from there. As geeky as it sounds, we’re thrilled by the sheer amount of data that this approach delivers because it means we understand our every move and use it to improve the performance of the next in a cycle of continuous optimisation. Put in another way, why put money into campaigns that are not performing when you have the data that tells you exactly what’s working and what isn’t? We ran regular A/B testing to determine which campaigns, ads, ad copy variants, and budget allocations were working best. We ran our analyses over several weeks, fine-tuning as we went along. As we progressed, we optimised to reduce Ad Cost-Per-Click – all the while optimising conversion rate and conversion value. Using a combination of manual, human- supervised optimisations and AI algorithmic conversion optimisation, we could achieve a steady increase in performance that allowed us to increase spend while maintaining a good ROI. We also use a number of Google Ad tactics to ensure the highest quality scores possible for the Ads being run. Ad quality is significant. It means that we are charged the lowest rates possible for every ad that’s displayed. As always, we looked at the market first. It takes a thorough analysis to create a multi-approach strategy and the market gleans heaps of data for us to analyse and work with. In-Depth Performance Marketing Case Study February 2021 Most campaigns are typically run at quality scores of 7/10. Most of our campaigns run at a quality score of 10/10. This allows us to run ads at the cheapest possible rates. In-Depth Performance Marketing Case Study February 2021 Results We said we’d get to the numbers. Remember that 1.2X ROI? Here is the ROI we achieved, jumping to 9X in the very first month then doubling it: 1 3 2 4 Month Month Month Month 9X ROI 19X ROI 17X ROI 16X ROI ROI is liable to drop in some months based on search volumes. An improvement of 1,333% on performance in just 4 months! In-Depth Performance Marketing Case Study February 2021 Costs vs Conversions As cost per conversion decreased dramatically, we gradually increased our client’s ad spend, observing a proportional increase in sales. We kept a watchful eye on ROI however – as the return on our spend inevitably tends to plateau it is wise to know when to scale back spend while retaining the same sales figures. Check out this graph. The point where the two lines meet is the point we were waiting for and, even though we significantly tapered off the spend (the blue line), we did not dip the sales. Cost per Conversion The next graph shows cost per conversion – we halved the cost over four months and retained the same sales, allowing us to obtain twice the sales for the same ad spend. In-Depth Performance Marketing Case Study February 2021 Or how we insert checks & balances. VV Q C Volume Quality Cost Effectiveness Value You’ve all heard that there’s “Lies, damned lies, and statistics”. We have to really be vigilant to never let a set of statistics / results, skew our efforts. It is very easy to obsess about a specific number, especially with certain “vanity” metrics such as reach or engagement, which is why we always set up our reporting keeping VQVC in mind. Where we measure the numbers in their purest form. Are we getting more of whatever we’re trying to do? If we’re spending a lot of money, bringing in a lot of traffic but not converting, we’re doing something wrong. We need to ensure that our marketing efforts are actually bringing in revenue (or other value we attribute to the campaign) We measure how much return we’re getting on our spend. Profitability is a cornerstone of marketing efforts. In-Depth Performance Marketing Case Study February 2021 Facebook Ads Strategy Our strategy here was consistent with our search strategy, only Facebook is a different playing field. Of course, we examined audiences with a fine tooth comb, worked out appropriate budget splits, and established a rock-solid set of KPIs. What we did not have was a strong performance history to learn from so we dug in and employed widespread, short-term, A/B testing, ruthlessly scrapping the lower performing assets while promoting the ones our audiences were responding to. It helps to have a creative team in-house during this period! As testing progressed our optimisation efforts paid off exponentially. We analysed a slew of data points that included, for instance, audience profiles, timings, content nature, and ad copy – fine-tuning as we went along. “Besides the manual supervision, we also ensured that we were using the capabilities of the Facebook platform to its fullest potential. By leveraging the platform’s AI tools for audience building and optimisation, we could give it what it needs to achieve peak performance.” After 6 weeks of testing we had established a base structure for eCabs Facebook ads. This meant we could focus on the stories we wanted to tell and we created more beautiful and engaging content, strictly observing the rules we’d established during the testing phase. In the same way as we’d done for Search (Google Ads), we focused on the number of sales we could generate for the client. But Facebook also delivers the goods when it comes to brand awareness. Using an entirely different set of KPIs and a strategy tuned to Brand rather than conversion, we ran multiple intent campaigns simultaneously. The beauty of this approach is that each campaign supports the other, synergistically delivering results that one or the other alone could not have managed. The result? Even more significant returns on our client’s investment in the short term while creating long-term returns of brand equity as well. Sales conversion ads deliver immediate results while brand loyalty builds long-lasting, value-based relationships with a growing customer base. In-Depth Performance Marketing Case Study February 2021 Results ROI 1 3 2 4 Month Month Month Month 27X ROI 25X ROI 32X ROI 26X ROI The dips in ROI coincide with the slowest months of the year for our client – this is a very seasonal business so while a dip appears, it represents significant gains over previous years. We started with 1.07X ROI so we knew we’d see gains. We exceeded our own expectations here, multiplying our client spend effectiveness by 32x in just 8 weeks: In-Depth Performance Marketing Case Study February 2021 Cost per Conversion The Cost Per Conversion dipped significantly as a result of the strategy we employed, down to a point where our client was suggesting an increase in spend to benefit from the surge in ROI and sales conversions they experienced. Conclusion In the end, they saw the real benefit of Search and Facebook advertising when it is done strategically. With low ROI it is an expensive and frustrating endeavour. Simply approaching the matter strategically, having the skills to test and optimise, and the staying power to observe returns gave our client what they wanted and much more – a massive multiplier effect between their ad investment and sales, with a huge boost to brand awareness as a bonus. In-Depth Performance Marketing Case Study February 2021 Interested in learning more? We will be more than happy to look into how we can work with you to set up your campaigns and run them in a way that will also see you increasing your performance dramatically. Our experts are always dying to combine their guile with the technology available to us to give you performance boosts that most businesses can only dream of. Send us an email on [email protected] and we’ll be happy to have a chat with you to see how we can help you get much more out of your digital spend. Let’s work together to change your spend into an investment. In-Depth Performance Marketing Case Study February 2021
data analysis.
SP R I T E Fa cin g a H ate r SU M MARY W e p u t a H ate r in f r ont o f h i s v ic tim s . PR O J E CT L IN KS D ig it a s A r gen tin a C H ALL EN G E Fo r S p r it e ’ s # I LO V E YO U H AT E R c a m paig n, o ur o b je ctiv e s w e r e t h r ee- fo l d : in c r ea s e b r an d a w a r en e ss a n d b oo s t t r an s actio n s , b eco m e a b a d ge b r an d f o r G en Z b y b ein g r ele va n t, a n d c r eate a o ne-o f- a -k in d e x p e r ie n ce w hile a l s o r ein fo r cin g S p r it e ‘ s p r o du ct in t r in s ic q u alit ie s : 1. T r an s pa r en cy ( o w nin g w ho y o u a r e) 2 . R ef r e s hm en t (a ctin g s ponta n eo us ly a n d c r eativ e ly ) 3 . L em on-lim e a ci d it y ( w it ty h u mo r & t o u ch o f i r ony) IN S I G H T We w an te d t o b eco m e a b a d ge b r an d f o r G en Z s o w e n ee d e d a w ay t o in vo lv e o urs elv e s in o ne o f t h ei r m o s t h o t b u tto n i ssu e s : o nlin e b u llin g . I n ord e r t o b e r ele va n t w e k n e w t h at w e n ee d e d it t o b e a s r eal a s p o ss ib le . U s in g T w it te r d ata , w e d eve lo p e d a n d t r ain e d a c us to m m ach in e-le a r nin g alg o r it h m t h at h elp e d le a d us t o t h e p r ota g oni s t o f o ur s to r y, o ur h ate r : @Ag u an te E lC ofle r . SO LU T I O N Via t h e T w it te r A P I , w e d o w nlo a d e d 15 , 000 t w eet s f r om A r gen tin e s no to r io us f o r b ein g b u llie s o r b ein g b u llie d . T hei r c o nve rs atio n s , a lo ng w it h a p r op r ie ta r y d ic tio na r y o f A r gen tin e S p an i s h w o rd s a n d p h r a s e s th at h elp e d us n av ig ate a c o m ple x ja r gon a n d d ecip he r t h e c o nno ta tio n of e ach t w eet, t r ain e d o ur m ach in e-le a r nin g m o d el. O nce t h e t r ain in g w a s c o m ple te d , w e h a d it p r oce ss m o r e t h an f iv e m illio n t w eet s f r om o ve r 10 0 , 000 u niq u e us e rs f r om S p r it e ́ s T w it te r co m m u nit y a n d o th e r b r an d ́ s a cco u nt s w it h a h ig h a ffin it y t o S p r it e ́ s te en t a r get. C la ss if y in g e ach t w eet a s o ffe n s iv e o r n o n-o ffe n s iv e a n d dif fe r en tia tin g t h e h ate rs f r om t h e n o n-h ate rs . To b ette r u n d e rs ta n d o ur a ud ie n ce a n d t h e c urr en t c o nte x t o f b u lly in g in A r gen tin a, w e us e d n at ur al la n g u ag e p r oce ss in g t e ch niq u e s t o i d en tif y t h e o ve r -a r ch in g t h em e s us e d b y h ate rs t o a ss a u lt t h ei r v ic tim s : Id eo lo g y, B o d y S ham in g , T r ollin g , G en d e r W a rr in g , a n d Id en tit y . F in ally , w e g en e r ate d a s co r in g , w hic h b r o u ght us t o o ur h ate r : @Ag u an te E lC ofle r . Slid e i nto o ur DM s * All in fo r matio n i s r eq u i r e d . * FI RST N AM E * LAST N AM E * EM A I L AD DR E SS * C O M PA N Y/O RG A NI ZAT I O N TI TL E * RE G I O N * CO M M EN TS M ake a Co nnec tio n Ne w B us ine ss Mic he lle T a ng , E VP H ea d o f N e w Bus ine ss m ic he lle ta ng @d ig it a s .c o m . M e d ia I nq u i r ie s Ba r ba r a N ona s , V P/G D M a r ke ting & C om m u nica tio n s co m m u nica tio n [email protected] d ig it a s .c o m In The N e ws Pr e ss R ele a s e s Me d ia K it S ay H ello P R I VA CY TE RMO FU S E ©20 23 D ig it a s   I’M IN T E R E ST E D IN C O U N TR Y  W o r k Se r vic e s Ne ws Peo p le C a r ee rs O ffic e s LE T’S C O NNE CT UP NE XT · T a co B ellMob ile O rd erin g A pp Ye s , I w o u l d lik e to r eceive th e la te s t D ig it a s e m ail. * I c o n s ent t o D ig it a s ‘ t e r m s a n d pr iv a cy p olic y . SU BM I T    

Writerbay.net

We’ve proficient writers who can handle both short and long papers, be they academic or non-academic papers, on topics ranging from soup to nuts (both literally and as the saying goes, if you know what we mean). We know how much you care about your grades and academic success. That's why we ensure the highest quality for your assignment. We're ready to help you even in the most critical situation. We're the perfect solution for all your writing needs.

Get a 15% discount on your order using the following coupon code SAVE15


Order a Similar Paper Order a Different Paper