Marketing Data Analysis Assignment
Instructions
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 |
| Example: Sales data | Monthly sales by specific product | Average sales that month in US dollars for each of 10 products. Data can be segmented by business and consumer markets. | Can be used for trend analysis, projections, and to measure effectiveness of promotions. |
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 |
| Example: retail store analytics | Dollar value of sales by quarter by major product categories | Total sales of major players | Market Share Analysis
Seasonal patterns |
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 |
| Example: Focus group | Product usage, motives, identify group level satisfaction, decision process, etc. | Qualitative | Identify different reactions of market segments to product. Identify marketing opportunities, product/service flaws and opportunities |
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 |
| Example: Customer profile information on website | Starts the account for visitors: name, geography, email address (Customer acquisition)
|
Presale: geographic location; customer id, source of reference
Email address Post sales: address, product purchased, quantity, price. |
Track new and returning customer counts, total period purchases by customer ID, geographic sales data. Can be used for loyalty rewards, retention, and targeted marketing. |
| Starts the account for visitors: name, geography, email address (Customer acquisition) | Post sales: address, product purchased, quantity, price. | ||