These are five questions based on the excel spreadsheet below.
- How often should the database be cleansed and updated?
- Segment and profile data according to demographic, psychographic and behaviouristic characteristics.
- Identify database fields with cross-selling and value-adding opportunities and any changes in consumer behaviour.
- Outline how the organisation could use data analysis findings to design or test new direct marketing offers or for other direct marketing purposes.
- Outline how to modify and enhance existing direct marketing offers or other marketing activities in accordance with analysis findings.
City Stat Zip Countr |Gend Househ | Do Not Call Do Not Mail Would your first What New Products Last Last Purchase Prefered Member er old Indicator Indicator preference be to buy would you like to see in Purchase Value Method of Since Inco Statu: Y Status `Australian Mad store? Date Y Conta North Adelaid SA 5006 Australia M >250K No No Unknown Australian bush foods 17/172015 $1.188.00 Phone 2004 Sydney NSW 2000 Australia M 71K-10OK No No Yes Australian bush foods 16/172015 $4,321.00 Email 2007 Prospect SA 5082 Australia M 41K-70K No No Unknown Dutch Jams 16/172015 $9.754.00 Email 2008 Parramatta NSW 2150 Australia M 41K-70K No No Yes Australian Camping Gear 16/12015 $2.000.00 Email 2009 Sydney NSW 2000 Australia F >250K No No Yes Australian bush foods 16/172015 $10,998.00 Email 2005 Marrickville NSW 2204 Australia M 41K-70K No No Unknown Australian bush foods 18/10/2015 $1,454.00 Email 2013 Clovelly NSW 2031 Australia F 10K-40K No No Unknown Damper Bread Range 18/10/2015 $564.00 Phone 2004 South Perth WA 6151 Australia 41K-70K No No No Australian bush foods 18/10/2015 $876.00 Email 2006 Sydney NSW 2000 Australia F 41K-70K No No Yes Australian bush foods 18/10/2015 $7.907.00 Uknown 2008 Parkside SA 5063 Australia M >250K No No No Australian bush foods 16/10/2015 $6.875.00 Email 2003 Perth WA 6000 Australia M 41K-70K No No No Australian Camping Gear 29109/2015 $3,213.00 Email 2013 Brunswick VIC 3056 Australia F 41K-70K No No Yes Australian bush foods 29092015 $4,000.00 Email 2006 Beijing 100033 China >250K No No No Australian bush foods 25/09/2015 $8.465.00 Email 2015 Sydney NSW 2000 Australia M 41K-70K No No No Australian bush foods 23/09/2015 $1,067.00 Email 2003 Hawthorn VIC 3122 Australia My 71K-10OK No No Yes Australian bush foods 16/08/2015 $3.432.00 Phone 2003 Mascot NSW 2020 Australia F 71K-10OK No No Unknown Damper Bread Range 16/08/2015 $343.00 Email 2006 South Yarra VIC 3141 Australia 10K-40K No No Yes Australian bush foods 16/08/2015 $2.454.00 Phone 2013 Sydney NSW 2000 Australia 101K-250K No No No Dutch Jams 308/2015 $432.00 Email 2003 So V Hanoi 116806 Vietnam F >250K No No No Australian Camping Gear 1707/2015 $2,365.00 Email 2015 Dandenong VIC 3175 Australia M 10K-40K No No Yes Dutch Jams 9/07/2015 $5,654.00 Email 2004 West Perth WA 6005 Australia M 10K-40K No No Yes Australian Camping Gear 907/2015 $1,232.00 Email 2015 Port Adelaide SA 5015 Australia M 101K-250K No No Yes Australian Bush type food 1704/2015 $2.121.00 Uknown 2003 St Marys NSW 2760 Australia M 71K-100K No No No Australian Camping Gear 28/03/2015 $10.00 Email 2010 Canberra ACT 2601 Australia M >250K No No Yes Australian bush foods 17/03/2015 $3.456.00 Email 2003 Fitzroy VIC 3065 Australia M 101K-250K No No Yes Australian bush foods 17/03/2015 $4.345.00 Uknown 2003 Surry Hills NSW 2010 Australia M 71K-100K No No Yes Australian bush foods 17/03/2015 $2,786.00 Email 2013 North Sydney NSW 2060 Australia 10K-40K No No Unknown Damper Bread Range 17/03/2015 $332.00 Phone 2004 Sydney NSW 2000 Australia 101K-250K No No No Australian bush foods 17/03/2015 $4.345.00 Phone 2006 Canberra ACT 2601 Australia 41K-70K No No Yes Australian bush foods 16/03/2015 $5,565.00 Uknown 2009 Chicago 60601 USA M >250K No No No Australian bush foods 1203/2015 $11,789.00 Email 2015 Mt. Barker SA 5251 Australia M 71K-100K No No Unknown Australian bush foods 1703/2015 $1,876.00 Email 2004 wer > Paualehar 5409006 Singapore F 250K No No No Australian Camping Gear 271072015 $16 500 00 Email 2015
