Case Study Marketing Campaigns For Customers - 1679 Words

Chen Liu Professor Joe Dery Homework 3 Nov 4th, 2015 RFM Analysis A. Executive Summary Joe’s Shopping World schedules to launch marketing campaigns for customers. To maximize return of investment of each dollar on campaigns, Joe’s Shopping World is looking to profile the customer segmentation to test incremental response from the marketing campaigns. The dataset contained 225,533 rows of customer transaction records over the last two years. The following elements have been recorded in the dataset: household ID, day (1-711), sales value ($) and total discount ($). I adopted the RFM analysis in this report to analyze the dataset and score each customer based on recency-the number of days since the last purchase, frequency-the number of†¦show more content†¦Ã¢â‚¬ ¢ Frequency is the total number of days per customer visited in the last two years and is assigned the scores from 0 to 4. †¢ Monetary is the total spending in the store over the last 711 days and is also assigned the scores from 0 to 4. 1’st, using SAS coding to calculate recency. 2’nd, grouping R, F and M records by household ID. Then there will be a new dataset that each customer have a row of record including recency (R_Cal), frequency (F_Cal) and monetary (M_Cal), as shown in figure-1. At the same time, I present a part of the original dataset to compare with figure-2. Figure-1: Query Dataset Figure 2: Part of Original Dataset 3’rd, ranking the data with separate customers into 5 groups based on R_Cal and assign R score to each customer. Of course, we need to check the reverse ranking radio-button to make sure the minimum value of recency has the largest value when we rank the customers. Because we use â€Å"recency=712-day† to calculate the R score. Part of the result is shown in figure-3. Figure-3: R Rank 4’th, ranking F and M at the same time. Just repeat s tep 3, but do not forget to uncheck the reverse ranking radio-button. Figure-4 shows part of the resulted dataset. Figure-4: F and M Rank 5’th, summarizing the result R Rank. We place R_Cal as the analysis variable and R as the classification variable. In figure-5, we can see the summary statistics with R_Cal. And the range ofShow MoreRelatedHips Feel Good1124 Words   |  5 Pagesâ€Å"Hips Feel Good: - Dove’s Campaign for Real Beauty Case Study The basis of this case study revolves around Karen Dunleavy a brand manager tasked with the responsibility of further market share growth with the Dove brand. The major problem that Karen Dunleavy is faced with is further establishing the Dove brand in a highly competitive market in the beauty industry. Furthermore the first steps to resolving this problem was by collaborating with the assistant executive brand manager Michael B AllenRead MoreHey there1302 Words   |  6 Pagesattitudes as a result of my new advertising campaign, or two, see what the effects of my new advertising are on the recent sales. 2. If potential customers had heard about my restaurant but had not yet acted on that information and come in to buy, my reaction would be to come up with a new advertising campaign because the message was getting to them, but it was not effective enough to make them want to come in and buy my food. 3. The most effective marketing tool in reaching college-aged students isRead MoreThe Case of Nike1035 Words   |  5 PagesWEEK 1 – CASE STUDY: THE KEY MARKETING STRATEGY OF NIKE Nike is considered to be a leading athletic footwear manufacturer, which makes up over 30 percent and 50 percent of global and US market share respectively. In order to reach customers’ demands and get profits, Nike has executed/implemented a number of marketing strategies. This essay will examine Nike’s key strategies from1962 to 2009. The most essential marketing strategy called â€Å"Pyramid of influence† was expressed by Product, Place andRead MoreMarketing Techniques Of Direct Marketing Essay1144 Words   |  5 PagesDirect marketing is the business of selling products or services directly to the public, e.g., by mail order or telephone selling, rather than through retailers. Nowadays, with the increase in popularity of social media and email usage, there has been a rise in direct marketing. Targeting customers through their personal or business emails and emailing them newsletters, promotions and other similar marketing techniques used on social media, ar e all leading examples of direct marketing. In case of directRead MoreEssay on Kraft Foods Marketing On The Go1555 Words   |  7 PagesKraft Foods is the largest confectionery, food, and beverage corporation headquartered in the United States and the second largest in the world, marketing a vast number of brands in over 155 countries (NYSE, 2010). A big reason Kraft Foods has been so successful over the years is that they are always trying to remain current and creative when they market their products, and really have developed a firm grasp on their target markets. In 2008 Kraft changed the way companies will market their productsRead MoreThe Marketing Strategy Of Bud Light s Super Bowl1195 Words   |  5 PagesThere are different ways on which brands can reach their customers and connect with them. Online Screen channels are becoming of main interest for brands to advertise in. From this, Youtube has become one of the main platforms on which brands decide to promote their conten t, not only because it is cost–effective, but because it can achieve a high impression by reaching a large audience. Different campaigns such as Volvo’s â€Å"The Epic Split†and Carrie’s Telekinetic cafeÃŒ  prank, prove the efficiencyRead MoreVegemite: Marketing and Product1745 Words   |  7 PagesA definition of brand as Muzellec and lambkin (2005) cited from the American Association of Marketing, could be â€Å"a name, term, symbol, design or a combination of them intended to identify goods or services of one seller or a group of sellers and to differentiate them from those of competitors†. After 1922 when the initial product â€Å"vegemite† was invented and had to be positioned at the Australian Market through different kinds of commercials for television, radio, contests, a new challenge appearedRead MorePromotional Marketing : Marketing Campaign887 Words   |  4 PagesPromotional marketing is the use of any special offer intended t o raise a customer s interest and influence a purchase, and to make a particular product or company stand out among its competitors. Promotional materials can exist as a part of direct marketing, like mail or email materials that include coupons (See also Direct Marketing). They can also include contests that encourage participation with a company, or product samples that offer something free to customers to generate their interestRead MoreMarketing Case Study : Marketing Communications Manager With Trublush Cosmetics1578 Words   |  7 PagesSection I In the Marketing Case Study that describes the ethical dilemma of â€Å"Tiff,† an Assistant Marketing Communications Manager with TruBlush Cosmetics, it is clear that she has several decisions to carefully weigh. Clearly, encouraging consumers to use multiple applications of a cosmetics product that has been shown to work with just one application is ethically questionable. However, focus group sessions are notoriously small and statistically unreliable. While the focus group sessions may wellRead MoreCase Study : Disneyland s Consumer Focused Initiative Essay1717 Words   |  7 PagesOcampo, Gerard (14095157B) Stream B Submitted to: Anika Vats Lecturer Date: 13th May 2015 PART A: Disneyland’s Case 1. Disneyland’s consumer focused initiative Analyzing the Disneyland case, Disney focused on market segmentation anchoring on cultural distance and differences. According to Zhu Xu (2010), it is important for companies operating in different countries to study the marketing distance problem. It stated that: â€Å"The larger the distance between the countries, the greater the uncertainty