Part C – Strategic Marketing Plan
Part B: Marketing Data Analysis
Part B: Marketing Data Analysis
Internal Data
Evaluate internal sources of information available to you inside the organization and what information you will receive from each source. Identify 3-6 sources of internal data. Insert or remove rows as needed.*
|
Source |
What it Measures |
Data |
Potential Usage |
|
Sales data |
Monthly Revenue |
Monthly Purchases by customers |
Identifies the sales volume for tracking purposes |
|
Financial |
Monthly expenditures on products and services |
The variance of the costs of the goods and services |
To promote efficiency in the company resources |
|
Human resources |
The number of employees recruited and trained |
The costs of training and recruiting |
Helps identify personnel areas of improvement |
|
Marketing |
Monthly promotion, brand awareness, and target marketing and advertising |
Identify customer reach across each channel |
It helps the company identify most powerful channels |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
*(Add a brief summary about what the information in the table means)
Secondary Data
Evaluate secondary data sources and the specific information you need from each source. Insert or remove rows as needed.*
|
Source |
What it Measures |
Data |
Potential Usage |
|
Statistical data obtained from the census
|
Location, age, gender
|
Customer age, gender, location
|
Helps to market products according to the needs of target customers
|
|
Sales data analysis
|
Products pricing
|
Provides the cost of the products sold in a given month
|
Helps in understanding customer's behavior and preferences and improves decision making.
|
|
Product sales of competitors
|
Similar products sold by competitors
|
Product type, sales volume,
|
Identifies competitor's product sales to track trends
|
*(Add a brief summary about what the information in the table means)
Primary Data
Evaluate primary data needs to create and evaluate the marketing plan. Insert or remove rows as needed.*
|
Source |
What it Measures |
Data
|
Potential Usage |
|
Surveys |
Information on a given population in terms of who they are, what they do, what they like
|
Answers to relevant questions about the company and products.
|
Forecast the given population future behavior
|
|
In depth interviews
|
Personal information
|
Detailed insights about each customer their habits and goals
|
Identifies ways to tailor offerings to fit customer-specific needs
|
|
Social media monitoring
|
Customer reach,
|
Product reviews, personal testimonies
|
Identifies the needs of customers and boosting their satisfaction.
|
*(Add a brief summary about what the information in the table means)
Customer Relationship Management
Establish customer touchpoints and develop appropriate CRM events for customer acquisition, retention, and profitability. Insert or remove rows as needed.*
|
CRM Touchpoint |
Purpose & CRM Objective |
Data |
Potential Data Usage |
|
Chatbots
|
Customer interaction through automated responses
|
Potential customer information
|
Helps in acquiring the new leads
|
|
|
Acquire new customers and purchase new products from the current customers
|
Name, location, and purchases of new and current customers
|
Helps in improving relationship with current customers and obtaining new customers
|
|
Blogs and forums
|
Collects specific data on existing and potential clients
|
Customers, the email address, and location
|
Information obtained will prove helpful in identifying customer needs
|
*(Add a brief summary about what the information in the table means)