Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
61 Cards in this Set
- Front
- Back
The Customer Marketing Database
|
A comprehensive collection of interrelated data serving multiple applicaitons, allowing timely and accurate on demand retrieval of relevant data, and having a data management system independent of application
|
|
How is each customer database interrelated?
|
Each customer record is connected to every other one so that customers who have something in common can be picked out as special lists or as part of an analysis
|
|
What are the multiple applications of the customer marketing database?
|
Database is used by marketers for analysis, communications and servicing?
|
|
List some internal data sources for the customer database:
|
Personal customer data
transaction data (purchases) communication history data (the campaign and the responses) New contact channels product registration/warranties credit card details subscription details questionnaires contests events sampling |
|
What are some external customer database data sources?
|
List purchases
data building schemes (geodemographic) Lifestyle databases (profiling) |
|
The typical customer record should be designed to capture what sort of information?
|
Contact and geographic information
demographic information profile information marketing information behavioral information |
|
What is the four step approach to database management?
|
Manage the sources
Manage data capture manage the database manage the applciation |
|
What are the standards of data capture?
|
Verification (enter it twice)
Validation De-duplication Merge/purge (same customer 2 files) |
|
What are the three elements of managing the database? (the third step in the four step approach to database managment) And, what are the major concerns for each?
|
Updating --- Timely Data
Auditing --- Trace data back to original Archiving --- Policy |
|
What are the three elements of managing the application? (the fourth step in the in the four step approach to managing the database)
|
Sources
Output (selecting, analyze, report) Campaign Responses |
|
What are three types of lists (external databases)
|
House
Response Compiled |
|
Who are the major list participants?
|
Users
Owners Managers Compilers Brokers Service Bureaus |
|
What are the measurements of results for lists (external databases?
|
Key codes on promotional pieces
Different Toll Free Numbers Hotline Names identified and Tracked |
|
What do customer databases have that lists do not?
|
All around, they have more information, such as:
Purchase History Demographic information Social information |
|
What is a geodemographic Analysis built from?
|
Built from census data purcahsed and processed by third parties
|
|
What two types of data do geodeomgraphic analysis mix?
|
Geographic and demographic data
|
|
What do profilers do to compile geodemographic analysis?
|
use cluster analysis to place households into groups by age, social class, income, etc.. They then allocate descriptions of each postal codes based on dominant profiles
|
|
Where do Lifestyle Databases come from?
|
Product registrations, questionnaires, trade shows, subscriptions, contests, etc.
|
|
What type of data is in a lifestyle database?
|
Attitudinal data, opinion data, purchase data, brand preferences and interests
|
|
What are the three components of the 3 legged school?
|
Database - Media - Offer
|
|
What are the steps to DM Campaign Planning?
|
Set the objectives for the campaign, determine the DM Mix (between database, offer and media) than design a detailed test program
|
|
When determining the DM Mix in planning the DM Campaign, what are the important actions for the database?
|
Segment the database based on existing customers, and decide on the final target markets
|
|
When determining the DM Mix in planning the DM Campaign, what are the important actions for deciding the offer?
|
Decide on the product/price proposition
Decide on incentive approach Decide on Timing Develop creative platforms |
|
What are the two key performance indicators for a DM Campaign?
|
Measurements of Heft and Measures of Rate
|
|
What is measures of heft?
|
One of the key performance indicatiors for a DM campaign, include: Number of contacts, orders, revenue, direct costs, marketing costs, profile, etc.
|
|
What is measures of rate?
|
One of the performance indicators for a DM Campaign, include:
ROI (return on investment) CPR (cost per response) CPA (cost per acquisition) CPM (cost per thousand) OPM (orders per thousand) |
|
What is Standard Industrial Classification Coding System (SIC)?
|
The Basis for statistical data used by governments, trade associations and busienss
|
|
What does NAICS stand for?
|
The North American Industry Classification System. It builds upon the SIC system
|
|
What are some identifiable groups or segments that DM users can use to target better?
|
Demographics
Geographics Lifestages Psychographics or Lifestyle Behavioral Affinity or Interest Groups |
|
What is the value of segmentation?
|
Huge volumes of information can be derived from large databases meaning more reliable results. Segmentaiton reflects actual behaviour, not projected behvaiour. Once Segments are created, each customer can be precisely allocated to a group. Direct strategies can be affiliated to an individual level.
|
|
What are the characteristics of Demographics?
|
Gender
Age Ethnicity Marital Status Family Size HH Income Occupation Social Class Education |
|
What are the different location classifications marketers can use to segment geographically?
|
Region
Province City Postal Code Neighborhood Trade Area |
|
How many houses does a FSA cover in a postal code?
|
7500 households
|
|
How many households does a LDU cover in a postal code?
|
Approximately 100 households
|
|
What are some of the different life stages dm marketers can segment by?
|
Post Secondary Students
Single, No Children Married, No Children New Nesters, Children <6 Full Nesters Youngest Child <6 Empty Nesters (children gone) Retired couples Solitary Working Retiree Retired Solitary Survivor |
|
What are typical needs or activities of post secondary students?
|
Electronic Gadgets
Clothing Entertainment |
|
What are some needs or ativities for New Nesters?
|
Baby food
Toys Furniture New Homes |
|
What are some needs and activities for empty nesters?
|
Travel
Cruises Retirement Planning |
|
Who are innovators?
|
Customers receptive to new ideas. They buy upscale niche products and services
|
|
Who are Thinkers?
|
Seek out information to make decisions, buy durability, functionality and value in products
|
|
Who are Believers
|
customers that are slow to change. Technology adverse. They buy familiar products and establish brands.
|
|
Who are Achievers?
|
Customers with goal oriented lifestyles centering on family and career. They buy premium products that show success to peers.
|
|
Who are Strivers?
|
Trendy and fun loving customers with little discreitionary income. They buy stylish products to emulate those with greater material wealth
|
|
Who are Experiencers?
|
Active and impulsive customers who take risks, spend on fashion,socializing and entertainment
|
|
Who are Makers?
|
Practical and self sufficient customers who spend time with family and close friends. They buy value products rather than luxury products
|
|
Who are survivors?
|
Customers with vary few resources. They buy products and services for safety and security, often discounted. They are brand loyal.
|
|
What is the Pareto Principle?
|
20% of your customers provide 80% of your profit
|
|
What is Customer Lifetime Value?
|
A forecast that projects how much gross profit will ultimately be made from a customer
|
|
What is Allowable Marketing Spend?
|
A simple calculation that tells us how much we can invest in an individual
|
|
What are some segmentation applications?
|
Using Purchase behavior to segment by customer value
Use purchase behavior to forecast lifetime value Use purchase behavior to segment by product need and to assess product/market strategy Maximize Response USe profile data to target new customers accurately |
|
What is the basic assumption when using profile data to segment to target new customers and prospects?
|
New customers will have a similar profile to existing customers. Therefore, by understanding the profile of your best customers you can find more just like them.
|
|
What techniques are best to set budgets?
|
Lifetime Value analysis and Available Market Spend analysis
|
|
Which techniques are best for understanding customer value?
|
RFM analysis and Lifetime value analysis
|
|
Which technique is best to target spend and maximize ROI?
|
RFM analysis and modeling techniques
|
|
What information is required to do an LTV analysis?
|
The Number of years a customer buys from the company. The percentage of customers remaining loyal to the company, and the amount spent annually and the cost of delivering those annual amounts
|
|
What does an RFM analysis stand for?
|
Recency/Frequency/Monetary
|
|
What is a Cluster Analysis
|
The profiling of similar cusotmers. It is used for initial modeling techniques but does not predict. It helps product development, targeting and market mix decisions.
|
|
What is a neural network?
|
Artificial intelligency that replicates a human pattern recognition process using a computer. As you refresh results, it 'learns' and extrapolates future outcomes
|
|
What is a CHAID analysis?
|
a Chi-Squared automatic interaction detector. It usually runs before regression analysis. DM'ers intuitively pick the independent variables that will affect responses. The CHAID analysis splits customers into segments according to market potential
|
|
What is the process to a CHAID Process?
|
Compare record of responders vs non responders
Determine which variable best explains the diffirences Split into two segments or cells Break each segment down again by variables Continue splitting segments until not significant anymore |
|
What do regression coefficeints do?
|
Tehy explain customer response (the dependent variable) against other variables in the database to identify a reason for responding
|