Marketing Data Analysis
.docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
630
Subject
Marketing
Date
Feb 20, 2024
Type
docx
Pages
4
Uploaded by DukeGalaxyPelican38
In this week's assignment, we're going to get our hands dirty with some data compilation and analysis work.
In the Google Sheets file titled
BusinessMusicMarketing_Assignment_9_Data_Questions
(linked below), you will find raw data (performance and internal conversion tracking) illustrating eight different marketing campaigns (labeled campaigns A-H).
This raw data includes results of sales qualified leads (SQLs), marketing qualified leads (MQLs), click through rate (CTR), cost per thousand impressions (CPM aka cost per mille), cost per registration (Cost/Reg), the promo identification number of the campaign (PID), and additional data.
To complete this week's assignment, follow these instructions:
Click on the link below to open the Google Sheets file:
BusinessMusicMarketing_Assignment_9_Data_Questions
(
please note that this is a
View Only
file, so
you'll have to make a copy. To do so, please sign in to your Google Account
).
Make a copy of the file by clicking on
File
, then selecting the option
Make a copy...
Name your copy
LastName_L09_BusinessOfMusicMarketing
(e.g., Smith_L09_BusinessOfMusicMarketing) and save it to "My Drive."
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Assume that Young Corporation is introducing a new heartburn relief medication as an over the counter treatment. Young's marketing team used data to determine how to meet the minimum sales goals. The team determined that switching to an online marketing plan would be the best to maximize sales. This is an example of using
Question 8 options:
a)
descriptive analytics
b)
diagnostic analytics
c)
predictive analytics
d)
prescriptive analytics
arrow_forward
While querying the company's databases, marketing researchers for
a convenience store
chain discovered that when consumers bought a sandwich, many
also purchased
toothpaste. Researchers used
out
estion
to uncover the statistical link
between the two
product categories.
Select one:
a. data mining
O b. business intelligence
c. linear trend extrapolation
d. descriptive research
e. heuristic modeling
arrow_forward
Briefly explain how the organization forecast sales for its products (digicel)
arrow_forward
Use PivotTables to construct cross-tabulations between each pair of variables for the data provided.
LOADING...
Click the icon to view the soda preference data.
Question content area bottom
Part 1
Complete the cross-tabulation for Gender vs. Favorite Brand.
(Type whole numbers.)
Gender vs Favorite Brand
Count of Consumption Time
Column Labels
Row Labels
7UP
A&W Root Beer
Coke
Dr Pepper
Mountain Dew
Other
Pepsi
Sunkist
Grand Total
Female
enter your response here
enter your response here
enter your response here
enter your response here
enter your response here
enter your response here
enter your response here
enter your response here
enter your response here
Male
enter your response here
enter your response here
enter your response here
enter your response here
enter your response here
enter your response here
enter your response here
enter…
arrow_forward
How is market intelligence used in marketing?
O It is used to do media research
OIt is used to do economic forecasting
O It is used to define potential target markets and to determine how to reach them
It is used to define a product and to determine how it should be packaged
arrow_forward
As a marketing research consultant hired by a company that manufactures sports drinks, the company is considering the use of social media advertising for its premium sports drink product "Gatorade 0" that has been on the market for the past four (4) years. Conduct research on the impact of social media advertising on the use of sports drinks by athletes. You have decided to use one qualitative and one quantitative method in your research. Prepare the problem definition and the research design for this ztufy
arrow_forward
Quetion in picture
arrow_forward
2. Ways data analytics can help Hotel and Restaurant industry? Give specific example
and practical application in terms of its Marketing Management Sales and Revenue
Management, Operations Management, and Total Quality Management
HOTEL OPERATIONS
Marketing Management
Sales and Revenue Management
Operations Management
Total Quality Management
RESTAUTANT OPERATIONS
Marketing Management
Sales and Revenue Management
Operations Management
Total Quality Management
arrow_forward
I need help answering these 3 questions
2.For retailers and channel members, an important method of forecasting sales is
A.time series models
B.econometric models
C.sales force composite estimates
D.point-of-sales (POS) based projections
3.
In primary research, once data has been collected and the questionnaire has been coded, the next step for the researcher is to
A.analyze the data
B.interpret the data results
C.make recommendations from the findings
D.input the data into a computer program
4.Among the sampling decisions that must be made, researchers must select the _____, which is the group of individuals who will be included in the survey.
A.sample size
B.sampling procedure
C.sampling unit
D.random probability sample
arrow_forward
3. Discusses how these groups will be targeted (once identified), by explaining three (3) digital marketing options such as email, voice, text, app alert, app redemption token, etc. The report should be in MS Word format (or equivalent). For the purpose of this assessment, the following assumptions apply: ●95% of sales are electronic (credit card/phone), 5% are cash; ●55% of customers use a loyalty card at time of transaction; ●customers who have a loyalty card have provided credit card/phone/email details; and ●Imagine P/L has a smartphone app, which supports tokens (price discounts, etc) and alerts. 25% of customers have downloaded and use the app. Report Structure Your report should include the following sections: ●Introduction: Briefly explaining the purpose of the report ●Technology Options: Where you describe each type of technology ●Sales Solution: Where you explain how the options will increase sales ●Marketing Channels: Where you discuss how to reach customers…
arrow_forward
To carry out their analysis, planning, implementation, and control responsibilities, marketing managers need a marketing information system (MIS) to assess information needs, develop the needed information, and distribute it in a timely manner. Assume that you are a Marketing Manager of Khaddi and your company wants you to deploy an efficient Marketing information system.
Explain how all the components of the Marketing Information system will help Khaadi in collecting information and forecasting demand?
arrow_forward
Hello,
Please prepare a marketing research report in MS word and upload the file here.
You should follow the steps blow.
1 Define the research problem
2 Conduct a literature review
3 Develop the research questions
4 Design the research methodology
5 Collect the data
6 Analyze the data
7 Draw conclusions and make recommendations
8 Present the findings
9 Evaluate the research process
Please use the same sample project and draft a research report which should include table of contents, literature review and all the important ingredients of the report.
The contents of the report can be brief but it should cover all the important heading.
arrow_forward
1. Review the provided CRM data to guide you in selecting the buying firm that will maximize revenue for DataLocker. Once you have analyzed the CRM data, select the appropriate industry that will maximize revenue for DataLocker:
Small Size Manufacturing
Small Size Hospitality
Small Size Services
Medium Size Manufacturing
Medium Size Hospitality
Medium Size Services
Large Size Manufacturing
Large Size Hospitality
Large Size Services
arrow_forward
1.You are a new brand manager for a product line of Coach purses. You are considering the purchaseof customer data from a company that sells a large variety of women’s products online. In additionto the name, mailing address, and e-mail address of customers, the data provides an approximateestimate of customers’ annual income based on the zip code in which they live, census data, andthe highest level of education achieved. You could use the estimate of annual income to identifylikely purchasers of your high-end purses and use e-mail addresses to send e-mails announcing thenew product line and touting its many features. List the advantages and disadvantages of such amarketing strategy. Would you recommend this means of promotion in this instance? Why or whynot?
2. When asked about Google releasing personal information to law enforcement agencies, Google’sCEO Eric Schmidt told CNBC: “If you have something that you don’t want anyone to know, maybeyou shouldn’t be doing it in the first…
arrow_forward
These are type of information currently available in the files of the company's market information system (MKIS) and these are safely kept on the active files or considered as:
Group of answer choices
a. high profile data
b. primary data
c. secondary data
d. marketing intelligence
arrow_forward
Describe the purpose of OLAP (Online Analytical Processing) in data warehousing.
arrow_forward
Wiid and Diggines (2021) Qualitative research is the collection, analysis and interpretation of data that cannot be meaningfully quantified. Based on this definition discuss characteristics of qualitative market research.
arrow_forward
Belbin Beverages Ltd flagship product, a honey flavoured beer targeted to women in the agebracket 21 to 40 has been experiencing slow sales over the past year. However, Belbin’s otherbeer products have continued to perform well. Your task is to conduct marketing research todetermine whether the product should be continued.You must write a report about the marketing research process and your findings.Your report should include:2. An analysis of the data presented graphically (use fictitious/self created data)3. A presentation of the findings and conclusion
arrow_forward
Express the ethical issues that can arise when communicating the results of data analytics. How do these ethical issues could be circumvented?
arrow_forward
Wat is the purpose of the Situation Analysis section of a Marketing Plan?
Select one:
a. To provide an overview of the internal and external conditions impacting the firms.
b. To develop decision criteria on which markets to enter.
c. To create of market support for a firms product or service.
d. To only focus on which products in the market to compete against.
arrow_forward
How does predictive analytics benefit CRM? Give examples of predictive analytics models used in CRM for sales forecasting or customer churn prediction.
arrow_forward
Based on the underlying research, which of the following statements accurately interprets the model (above) for the relationship between SFA usage and its outcomes?
SFA usage increases the integration and application of customer information which directly improves salesperson performance.
Job experience positively influences SFA usage and that increase in SFA usage results in greater salesperson adaptability which indirectly improves relationship quality.
SFA usage increases the integration and application of customer information which directly improves the relationship quality with customers.
Job experience negatively influences the integration and application of customer information which directly improves salesperson.
arrow_forward
Explore the concept of data warehousing and its role in data modeling. How does data warehousing support complex analytical queries and reporting?
arrow_forward
In at least 150 words, examine internal secondary data. What types of data are considered internal? What is the importance of each and why might it be used? Provide an example of each type of internal secondary data.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Principles Of Marketing
Marketing
ISBN:9780134492513
Author:Kotler, Philip, Armstrong, Gary (gary M.)
Publisher:Pearson Higher Education,
Marketing
Marketing
ISBN:9781259924040
Author:Roger A. Kerin, Steven W. Hartley
Publisher:McGraw-Hill Education
Foundations of Business (MindTap Course List)
Marketing
ISBN:9781337386920
Author:William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:Cengage Learning
Marketing: An Introduction (13th Edition)
Marketing
ISBN:9780134149530
Author:Gary Armstrong, Philip Kotler
Publisher:PEARSON
Contemporary Marketing
Marketing
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Cengage Learning
Related Questions
- Assume that Young Corporation is introducing a new heartburn relief medication as an over the counter treatment. Young's marketing team used data to determine how to meet the minimum sales goals. The team determined that switching to an online marketing plan would be the best to maximize sales. This is an example of using Question 8 options: a) descriptive analytics b) diagnostic analytics c) predictive analytics d) prescriptive analyticsarrow_forwardWhile querying the company's databases, marketing researchers for a convenience store chain discovered that when consumers bought a sandwich, many also purchased toothpaste. Researchers used out estion to uncover the statistical link between the two product categories. Select one: a. data mining O b. business intelligence c. linear trend extrapolation d. descriptive research e. heuristic modelingarrow_forwardBriefly explain how the organization forecast sales for its products (digicel)arrow_forward
- Use PivotTables to construct cross-tabulations between each pair of variables for the data provided. LOADING... Click the icon to view the soda preference data. Question content area bottom Part 1 Complete the cross-tabulation for Gender vs. Favorite Brand. (Type whole numbers.) Gender vs Favorite Brand Count of Consumption Time Column Labels Row Labels 7UP A&W Root Beer Coke Dr Pepper Mountain Dew Other Pepsi Sunkist Grand Total Female enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here Male enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter…arrow_forwardHow is market intelligence used in marketing? O It is used to do media research OIt is used to do economic forecasting O It is used to define potential target markets and to determine how to reach them It is used to define a product and to determine how it should be packagedarrow_forwardAs a marketing research consultant hired by a company that manufactures sports drinks, the company is considering the use of social media advertising for its premium sports drink product "Gatorade 0" that has been on the market for the past four (4) years. Conduct research on the impact of social media advertising on the use of sports drinks by athletes. You have decided to use one qualitative and one quantitative method in your research. Prepare the problem definition and the research design for this ztufyarrow_forward
- Quetion in picturearrow_forward2. Ways data analytics can help Hotel and Restaurant industry? Give specific example and practical application in terms of its Marketing Management Sales and Revenue Management, Operations Management, and Total Quality Management HOTEL OPERATIONS Marketing Management Sales and Revenue Management Operations Management Total Quality Management RESTAUTANT OPERATIONS Marketing Management Sales and Revenue Management Operations Management Total Quality Managementarrow_forwardI need help answering these 3 questions 2.For retailers and channel members, an important method of forecasting sales is A.time series models B.econometric models C.sales force composite estimates D.point-of-sales (POS) based projections 3. In primary research, once data has been collected and the questionnaire has been coded, the next step for the researcher is to A.analyze the data B.interpret the data results C.make recommendations from the findings D.input the data into a computer program 4.Among the sampling decisions that must be made, researchers must select the _____, which is the group of individuals who will be included in the survey. A.sample size B.sampling procedure C.sampling unit D.random probability samplearrow_forward
- 3. Discusses how these groups will be targeted (once identified), by explaining three (3) digital marketing options such as email, voice, text, app alert, app redemption token, etc. The report should be in MS Word format (or equivalent). For the purpose of this assessment, the following assumptions apply: ●95% of sales are electronic (credit card/phone), 5% are cash; ●55% of customers use a loyalty card at time of transaction; ●customers who have a loyalty card have provided credit card/phone/email details; and ●Imagine P/L has a smartphone app, which supports tokens (price discounts, etc) and alerts. 25% of customers have downloaded and use the app. Report Structure Your report should include the following sections: ●Introduction: Briefly explaining the purpose of the report ●Technology Options: Where you describe each type of technology ●Sales Solution: Where you explain how the options will increase sales ●Marketing Channels: Where you discuss how to reach customers…arrow_forwardTo carry out their analysis, planning, implementation, and control responsibilities, marketing managers need a marketing information system (MIS) to assess information needs, develop the needed information, and distribute it in a timely manner. Assume that you are a Marketing Manager of Khaddi and your company wants you to deploy an efficient Marketing information system. Explain how all the components of the Marketing Information system will help Khaadi in collecting information and forecasting demand?arrow_forwardHello, Please prepare a marketing research report in MS word and upload the file here. You should follow the steps blow. 1 Define the research problem 2 Conduct a literature review 3 Develop the research questions 4 Design the research methodology 5 Collect the data 6 Analyze the data 7 Draw conclusions and make recommendations 8 Present the findings 9 Evaluate the research process Please use the same sample project and draft a research report which should include table of contents, literature review and all the important ingredients of the report. The contents of the report can be brief but it should cover all the important heading.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles Of MarketingMarketingISBN:9780134492513Author:Kotler, Philip, Armstrong, Gary (gary M.)Publisher:Pearson Higher Education,MarketingMarketingISBN:9781259924040Author:Roger A. Kerin, Steven W. HartleyPublisher:McGraw-Hill EducationFoundations of Business (MindTap Course List)MarketingISBN:9781337386920Author:William M. Pride, Robert J. Hughes, Jack R. KapoorPublisher:Cengage Learning
- Marketing: An Introduction (13th Edition)MarketingISBN:9780134149530Author:Gary Armstrong, Philip KotlerPublisher:PEARSONContemporary MarketingMarketingISBN:9780357033777Author:Louis E. Boone, David L. KurtzPublisher:Cengage Learning
Principles Of Marketing
Marketing
ISBN:9780134492513
Author:Kotler, Philip, Armstrong, Gary (gary M.)
Publisher:Pearson Higher Education,
Marketing
Marketing
ISBN:9781259924040
Author:Roger A. Kerin, Steven W. Hartley
Publisher:McGraw-Hill Education
Foundations of Business (MindTap Course List)
Marketing
ISBN:9781337386920
Author:William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:Cengage Learning
Marketing: An Introduction (13th Edition)
Marketing
ISBN:9780134149530
Author:Gary Armstrong, Philip Kotler
Publisher:PEARSON
Contemporary Marketing
Marketing
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Cengage Learning