WorksheetsMarketing Analytics quiz 1
Total questions: 30
Worksheet time: 22mins
Marketing analytics helps businesses to:
Increase ad spend
Make data-driven decisions
Replace the HR department
Create branding taglines
Which of the following is not a function of marketing analytics?
Data interpretation
Predicting consumer behavior
Conducting technical SEO audits
Decision making
What is the main difference between Marketing Research and Marketing Analytics?
Analytics is theoretical
Research is real-time
Analytics emphasizes predictive tools
Research uses AI and automation
Which of the following is the correct sequence of Levels in Marketing Analytics?
Descriptive → Predictive → Prescriptive
Predictive → Descriptive → Diagnostic
Prescriptive → Descriptive → Predictive
Diagnostic → Prescriptive → Descriptive
Business Intelligence supports marketing analytics by:
Providing CRM systems
Storing marketing data only
Enabling visual storytelling and real-time data insight
Running advertisements
In MS Excel, what is a PivotTable used for?
Formatting text
Predicting future trends
Summarizing large datasets
Protecting a sheet
You need to organize sales data by region and product. Which Excel tool do you use?
Filters
Conditional Formatting
PivotTable
Charts
Before using a PivotTable, data should be:
Filtered and protected
Structured in a tabular format
Color-coded
Combined into one cell
If a dashboard shows an increase in sales but customer satisfaction is falling, what should be investigated?
Sales team incentives
Marketing analytics data on customer feedback
Brand color palette
Campaign slogan
Which software is commonly used in Marketing Analytics at beginner level?
Canva
MS Excel
Adobe XD
WordPress
(a) Analytics answers the question: “What happened?”
The branch of analytics that forecasts future outcomes is called (a) Analytics.
A (a) is an interactive table that allows users to quickly summarize large data sets.
To use a PivotTable effectively, the data must be organized into (a) .
MS Excel can be used for both data visualization and ________.
Marketing research is more data-driven than marketing analytics.
True
False
Marketing analytics can help predict customer churn.
True
False
You can use Excel PivotTables to create interactive dashboards.
True
False
Business Intelligence tools work independently of marketing data.
True
False
Marketing analytics includes only digital marketing data.
True
False
Match the following terms with their correct definitions:
Descriptive Analytics
Predictive Analytics
Prescriptive Analytics
Define Marketing Analytics in your own words.
Explain how marketing analytics is connected to business intelligence.
You are given monthly sales data of 5 products across 10 cities. What Excel features would you use to summarize and analyze this data?
A company’s marketing campaign increased traffic but did not improve conversions. What analytical approach would you take?
In the clip, which market is not mentioned?
Commodity market
Stock market
Labor market
Bond market
SWOT is?
Strong, Weaknesses, Opportunities, Threats
Strengths, Weaknesses, Opportunities, Threats
Strengths, Weaknesses, Options, Threats
Strengths, Weaknesses, Options, Tools
What is the primary goal of marketing analytics?
To analyze customer behavior
To increase brand awareness
To optimize marketing strategies
All of the above
Which of the following tools is NOT typically used for marketing analytics?
R
Tableau
Google Analytics
Photoshop
Marketing analytics can help in segmenting customers based on:
All of the above
Behavioral data
Purchase history
Demographics
