Marketing Analytics Unit 1

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