CROSSTABBING - Telmar South Africa
Contents
1. Man emo i zmooc s Jeri Arnes fine Y vrs Y Taos Pint Semn Grid Line Layout Settings GrdRos Colume Settings Shana Col Settings Layout Top Manger Bottom Mager Left Margin Fight Magre Grids Y Shark Columee To Fit CEMIS CLOSE PREVIEW 2 fe lt Q SQ 07 37 an Survey 1 Survey AMPS 2005 2006 Main Branded E qi T n Tablez me Code Sample Projected Survey 1 Survey AMPS 2005 2006 Main Branded ADBFE Calumnz Men MAL 12417 Survey 1 Survey AMPS 2005 2006 Main Branded AOGFE Survey 2 Survey AMPS 2006 2007 Main Branded AOTFE Tables Survey 2 Survey AMPS 2006 2007 Main Branded AOTFE Columns 12405 12407 L nh Projected 3074 602 B3B3 Title Western Cape Gauteng kimazulu Hatal L Tithe Projected lo ih ch GD ch Oo jo CO fa z Women RD TELMAR X PC Winning Media Solutions Page 44 Export Exporting can be used in the drop down menu from File or on the Flat tabs TNT Surveys Coding CrossTab Rank Switch mh Em Email Default Data Items Stability Decimal places Filter Highlight Colour Tiles Calc ations Survey order Mew l gt Open Decimal places Filter IS Save 2005 2006 2006 Save As Main Branded Main B Close Create target market Save best rows Print Print Preview Print Audit Report Export CSV Exports Corr2. creen Email Survey Selection Survey Description Survey Date Code 2005 MRI Spring Waves 51 amp 52 09 11 2007 Moss p ABSA 2005 1 28 10 2005 ABSAS1 y Ads 24 Newspapers 2006 1 09 11 2007 ANO61 5 ADS24 Career 24 Survey 2007 28 06 2007 ACRO ADS24 Community Newspapers 2003 09 11 2007 ACNOS ADS24 Community Paper Research 2005 03 10 2005 ACNOS ADS24 Dailies Advertising Research 2005 1 09 11 2007 DAROS1 AMPS 1985 19 04 2007 AMPS85 AMPS 1994 26 01 1995 AMP94 AMPS 1995 17 10 1995 AMPS95 AMPS 1996 16 01 1997 AMP96 AMPS 1997 A 25 08 1997 A974 AMPS 1997 4B 06 04 1998 A97 4B AMPS 1997 AT 28 08 1997 A97AT AMPS 1997 B 16 02 1998 A97B AMPS 1998 29 04 1999 AMP98 AMPS 1998 T 16 11 1998 A98T AMPS 199811999 28 09 1999 49899 AMPS 1999 A 10 08 1999 4994 AMPS 1999 AB 26 07 2001 A99AB Single survey selection AMPS 1999 B 28 02 2000 499B O Multi survey selection AMPS 1999 C 30 11 1999 499C AMPS 19992000 09 11 2000 49900 4MPS 2000 4 10 08 2000 4004 4MPS 2000 4B 04 06 2001 40046 AMPS 2000 B 23 02 2001 400B AMPS 2002AP Main 08 08 2002 4024P AMOS ODM Maie Tatal Nadia 1 TU azina onn2 anann Filter options Filter Anywhere in title exact phrase Description O Starting with exact phrase O Anywhere in title all words TECH CiWINDO Reset Survey Code ic ACT Inbox Micr cuy Document4 Refresh List Tranmene TNT2001
3. 32 wel M 32 Decimal Places of data 33 m EU ES 33 FONON Da rrr cALenReRLoud 34 Ece kid cc MH 35 e e 36 TELMARA SP Page 2 Survey Display Order se eee 38 SO Advanced SOM etario 39 WV ClO MUNG PP CU ES E ET OO PS SEO 40 A ais En mm 41 Bio PPP E O PAS 41 Hol 00 1 AP e A 42 A O UE OU A 42 o lU ERE H 43 A eee ee ner ee eee eer eee 46 Sore IP santos 47 See cent T 48 Tab Formats Directly to Excel esee nennen 48 Rank Formats Directly to Excel sse eee 49 2 A 50 RON e Teh a 51 How loread the lne BINE ET 52 os aM E ES 53 a A e e O un 53 PP E e 54 TELMARA SP Page 3 other Telmar Tranmenu V3 1 File TELMAR amp PEAKTIME Winning Media Solutions Crosstab TNT Home News Downloads About Contact LINKS Television Ratecard changes Quick Reports ms Print 3 Timenhn Just when you thought they were out gt Hew Printplan Printplan Radio Information Latest News RBP2000 RadioTab Release Notes 25 September 2007 Telmar SPC PAMRO Conference Newsletter Tracker ape Click here to download Tracker Data Income Groups 20 September 2007 AMPS 2007 A07FB 12 month Full Branded Transmit survey releas
4. Winning Media Solutions TNI CROSSTABBING USER MANUAL 2008 Winning Media L olutions Page 1 Contents UOC UG UOT erage sien o E CU E 4 SUN SOI cuotas 5 o A A 5 o 6 Single MURESUNeY Mode sinsabores 7 lo A A oe eo ea 7 Multi Survey Mode sss sese 7 ie AAA o we 8 So M 9 Como COTTE E ell o m o mmn 10 Customising Operator Display esse eee eee 11 elec e Eo ssteeoisandeandsetescedsapdoandeetsenedsnsdeapecheece 12 lO AP PP o o III MEME 16 Si E E EE E aa 16 DOO C HOG CUNO CS NER RD 17 I Irzteiqegzbelqel Mir nmt 17 bR 9 EE 20 USO Ml emE 20 o skew teen ceed ater ge vein altrcalepe sansa 21 OGIO eio PEE ETE EEE E A EE E ETETE E S 22 Se O UU E me 23 RUNDO Me A ISl SIS NET ETT 24 OSS A AAA o o T T 24 A o A 25 veru dine TINO zi oO EMEN o UM 26 Somo NTR Tab ORM ae seas ERE 26 EUA le PP T T H 27 Viewing Selected rows On eee ee eee 27 Dragging Columns and ROWS sss sees eee ee ee eee 27 Se Ree IE 28 Table Lavoro 29 A PP e O E E 29 Me Vence 30 Tile Sequential occooccccocncccnccocnoconncnnnocanonnononnnnnnnnonnnonnrnnnnnnnnnnnnnnnonnnennrnenancnnens 30 q v 31 HODIE DITE rs 31 au iro 32 BE ela UU OO E E A 32 Dala HEMSIDISDIA PCT
5. Code Description Tables PO Columns Save own codes as publicatians l Rows w Save 3 Cancel Save only highlighted items Deleting Own Codes Within the same item Codes Deleting own Codes is also available for administration purposes Delete own codes EN ILU XJ See lie food C ALISERSmhfaead PR TELMARASPC Winning Media Solutions Page 47 Export Tab Formats Directly to Excel Excercise book XLS Compatibility Mode Microsoft Excel Audience 000 Resps Col ROW index Audience 000 Resps Col ROW index Audience 000 Resps Each table is in a different worksheet TELMAR SPC Page 48 Rank Formats Directly to Excel eG d 9 G ale Excercise book 1 XLS Compatibility Mode Microsoft Excel DET __o Home Insert Page Layout Formulas Data Review View 32 Insert O Ar 0 0 E iti IF t Cell inl Sort amp Find rl el eae pateo Number la Styles Cells Editing E A B C D E F G H j J BKK L MJ NJ _1 Source AMPS 2006 2007 Main Branded 2 Weight Population 3 Table Western Cape 4 Units 1000 s Bal 6 T0 ota en j j wWemn 8 Audience 000 Resps Coll Row Index Audience 000 Resps Coll Row Index Audience 000 Resps vsCol va Hotel or a34o ioo too 100 1 505 1 666 100 48 9 100 1 569 1 674 10
6. Index Coverage Cow Rank Index Rank a Col Rank Row Rank du Table Table Rank Projected Pro Rank Resps Rank Sigma Tolerence Sigma Tol Rank 2 SIgma o Sigma Rank Load Save Media in Rows T Columns wf Apply to all tables wW OK M Cancel Stability Clicking the Stability tab will switch the Stability flag alternately on and off Stability levels can be changed via the Edit Preferences menu See Preferences e For respondent bases between 50 and 100 e For respondent bases below 50 TELMAR SP Page 32 Decimal Places of data Set decimal places x Total Men Set decimal places for each item Audience 090 esos Seco Audience ooo oo Wy Index Resps 16 24 Audience ood 523 313 o esos ans 461 Cul Col ZI 20 81 n ROW 100 0 50 2 Eo Index 100 0 102 7 Index Used Coded Decimals For Audience 3 Cancel wf Done In order to see the data to decimal places click on Decimal Places and enter the number of digits required after the decimal Filter Filter will display only those items that AMPS 2006 2007 Main Branded meet the specified criteria Audience 000 Resps Col oR OW Index gt gt lt 2 lt gt C AND statements OR statements Clear wf Apply to all tables Y Apply 3 Cancel TELMAR xSP Page 33 Highlight Data In order to quickly find data that meet certain criteria Highlight wil
7. Microsoft P EN English United States KJ 7 ZI SJ 02 The opening screen and first Tab is SURVEYS In the left hand list box is the list of available surveys You can choose one or more surveys The last survey chosen will be used for the coding displayed TELM RASPC Winning Media Solutions Page 5 Finding a Survey To help find a survey within a long list is possible by using filter Searching by characters in the title or having a title beginning with a character s The following example has filtered AMPS so that only those surveys with AMPS in the title appear in the list box A survey can be selected by either highlighting the survey and double clicking or highlighting and using the arrows to select To deselect highlight the survey in the selected list box and use the arrow LAUEU NENNEN 18 x File Edit Codes Options MultiBasing Tables Tools Help TNT T Surveys Surveys Available Survey Description Survey Date Code 4 AMPS 2003Ad Main amp Radio AMPS 2003BP Main AMPS 2004 2005 Main AMPS 200446 Main AMPS 2004AP Main AMPS 2005 2006 Main Branded AMPS 2005 2006 Main Non Branded AMPS 200546 al S 2006 200 Main Branded AMPS 200646 Main Branded AMPS 2006A6 Main Non Branded AMPS 200746 Main Branded BMR Income amp Expenditure Survey CADO2 CAD02 CAD 2002 Nederlands Caxton Comm Newspapers East amp North 2004 CENSUS 2001
8. 2006 406FN AMPS 200546 Main 07 02 2006 A0546 AMPS 2006 2007 Main Branded 19 09 2007 407FB AMPS 200646 Main Branded 15 11 2006 4066B AMS nne c Main Blan Oearndad 14 44 nnc AC EAL Filter options Refresh List Filter amps Reset Anywhere in title exact phrase Description Starting with exact phrase O Survey Code O Anywhere in title all words Survey AMPS 2006 2007 Main Branded Weight Population Report Units 1000 ss start ex CiWINDO Gs ACT Inbox Micr EU 2 Microsof Tranmene TNT2001 Microsoft Po 4 M 02 44 PM Single Survey Mode Immediately on selecting a survey in single survey mode the programme automatically moves to the CODING screen Multi Survey Mode When working in multi survey mode the user is able to select a number of surveys by double clicking on the survey or using the arrows to move the survey into the Selected Surveys list box on the right hand side Once all the surveys required are selected the user will then click on the CODING Tab The user will use this function to do trending eg to see how a radio station is doing over a period of time 1 500 5FM Listenership Profile 1 450 7 ip 000 s wo E o 8 Listenersh Co e o T c e L 1 200 T T T T T T T T T 1 R SPO 2006 1 2006 2 2006 3 2006 4 2006 5 2006 6 2007 1 2007 2 2007 3 2007 4 TELMAR SPC Page F Trending Surveys It is possible to trend surveys from
9. 6Col 2 AROW 101 ROW 101 ROW 101 index 101 index 101 Index 101 50 Audience 000 7 50 Audience 000 4 0 Audience 000 4 Resps 1 0 Resps 3 Resps 6 Co 2 Col 21 Co 2 AROW 101 ROW 101 ROW 101 index 101 Index 101 Index 101 E K vr 4 ADAN Zils KI Survey AMPS 2006 2007 Main Branded Weight Population Report Units 1000 Z start v Inbox Microsoft be NEW TNT 2007 d Y untitled Paint Wer Tranmene TNT2001 B Search Desktop 18 MI 12 39PM ile Sequential amp TNT Untitled E a i xj File Edit Codes Options MultiBasing Tables Tools Help TNT Surveys Coding CrossTab Rank Switch Prit Excel PoF Email Table Free State B lol x BSE Default Data Items Stability Decimal places Filter Highlight Colour Tiles Calculations Survey order Sort Total Men Women P otal Audience 000 2 315 1 184 1 131 Resps 1 268 634 634 6Col 100 0 100 0 100 0 AROW 100 0 SEA 48 9 Index 100 0 100 0 100 0 Audience 000 669 343 327 Resps 393 223 170 96Col 28 9 28 9 28 9 9 6Row 100 0 51 2 48 8 index 100 0 100 1 99 9 25 25 34 Audience 000 577 307 270 Resps 270 130 140 Col 24 9 25 9 23 9 Row 100 0 53 2 46 8 y index 100 0 104 0 95 9 35 49 Audience 000 603 307 296 Resps 392 125 207 96Col con 25 9 26 2 AROW 100 0 50 9 49 1 Index 100 0 99 5 100 5 50 Audience 000 466 228 238 Resps 273 156 117 Col FAUT 19 2 21 0 ROW 100 0 48 9 51 1 4 nz Table We
10. 8 index 100 0 102 7 97 5 25 34 Audience 000 700 353 348 Resps 561 268 293 Col 22 78 23 44 22 15 9 6Row 100 0 50 4 49 6 Index 100 0 102 9 97 2 35 49 Audience 000 965 478 487 Resps 886 407 479 9 6Col 31 40 31 79 31 02 ROW 100 0 49 6 50 4 index 100 0 101 2 98 8 50 Audience 000 785 361 425 Resps 1 088 530 558 Co 25 55 23 96 27 07 ROW 100 0 45 9 54 1 index 100 0 93 8 106 0 E ls Survey AMPS 2006 2007 Main Branded Weight Population Report Units 1000 7 start gt Inbox Micro 62 new TNT 20 ij Y untitled Paint xir Tranmene wr2001 GH Telmarupdater E g p UD 12 59 PM TELMAR KIP e Page 35 Search Desktop Calculations This item is valid only if there is more than one survey tabbed A calculation can be performed on one survey against the other Print Highlight Colour Tiles Calculations urvey order eT Switch Filter TNT Surveys Rank Diefault Data Items Stability Coding CrossTab Decimal places Calculatian C Difference Percentage Difference C Average C Sum Perform calculation against all Survey Display wf Calculate C Calculate all surveys against a base f Calculate all surveys against a previous More Options M cancel TELMAR KIP C Page 36 Calculation Function Perform Calculation against all o If ticked on this will calculate all surveys in two ways 1 Against a base The user can select which survey
11. City Press 2005 Coega Industrial Development Survey 2003 Compass 2007 Daily Sun Advertiser Value 2005 Finansies amp Tegniek 2004 FNB 2004 1 Project 1976 FRSO3 FRS 2003 Future Fact Combined Survey 2006 Media 24 Coding CrossTab Rank CC03A 20034600103 6 44 10 EE GAME Future Fact Combined Survey 2004 General Rel Future Fact Combined Survey 2006 African Res Future Fact Combined Survey 2006 General Rel 07 02 2006 23 11 2007 15 11 2006 14 11 2006 17 10 2007 08 01 2008 08 01 2008 08 01 2008 08 01 2008 09 06 2005 08 01 2008 05 01 2008 21 12 2007 14 07 2005 08 01 2008 05 01 2008 08 01 2008 08 01 2008 07 03 2006 13 03 2006 07 03 2006 Switch Print UV GY S 23 09 2003 4034D 09 03 2005 403BP 22 11 2005 40405 25 08 2004 40446 10 08 2004 A04AP 16 11 2006 AD6FB 16 11 2006 AD6FN 407FB 4066B 4066N 4076B BMROD1 CADO2 CENO4 CCOSA CENO1 CPOS1 COED3 ACNO Dsos1 FTO4 FNBO41 FRSO3 FFO4C FFOSCA FFOSCG FFOSCM Excel PoF Filter options gt Filter Reset Anywhere in title exact phrase Description C Starting with exact phrase C Anywhere in title all words C Survey Code Selected Email Surveys GO ames 2006 2007 Main Branded Single survey selection C Multi survey selection H Mouse click for background information on the survey if available Multibasing Survey AMPS 2006 2007 Main Branded Weight Popu
12. Source Sociomonitor 1999 2000 Based on Audience Zoom Zoom Reset Bubble Radius Bubble Radius Scroll Insert Logo Picture gt Telmar Pmaps 1 0 29 0 K User Training manual gph i lol ES File Edit Options Graph Format Global Format Help zoom P Zoom IN Reset Bubble Radius f Bubble Radius Scrol Insert Logo Picture gt See Pmap manual for creating Pmaps Winning Media Solutions gt Page 42 File Menu New Creates a new run Mew ta Open Open Opens a saved run When opening a el Save saved run survey information is displayed and the a BT user is given the option of whether to proceed or O56 Create target market not Save best raws Print Print Preview Print Audit Report confirm ES No of Surveys 2 t 1 ADEFE Exports b 2 FE Correspondence Proceed 7 PMap Graphs 9 re Open with last survey used Recover Unsaved Runs 1 K User Training 8Jan Trz 2 Ki seri pu Mccann Trz 3 Ko User Training manual Taz d KM Iserletv radio Tnz 5 Ki lseri Manual multi Tra t Save Saves the current run 4 Save As Saves a previously saved run with a e new name Close Closes the current run Exit Create Target market This option creates target market files for use in Print Plan The current run is tabbed as a DEM file and then the Print Plan programme is launched usi
13. the bar between the Selection decision box and the Tables Columns Rows grids These operators can be moved from either the horizontal bar to the vertical and visa versa The two list boxes Selection Tree and Selection Decision can be sized in width by grabbing the edge of the first column and moving it wider or smaller TELMAR SP eo Page 9 Combine Codes OR Always within a Category AND Always between Categories ANY Same as OR ALL Same as AND Combining a section Men AND Age 16 24 OR Age25 34 AND Matric Women AND LSM 5 OR LSM 6 OR LSM 7 AND Gauteng Page 10 Customising Operator Display All Operators can be customised to suit your individual needs Right mouse click on the Horizontal Panel Vertical Panel or Drop Down Box to make your decision Select either Customise buttons this will change the position of the buttons or Set default buttons this will put the buttons back where they originally were TNT Untitled File Edit Codes Options MultiBasina Tables Tools Help TNT Surveys Coding CrossTab Rank Switch Print Es Excel por Coding Survey AMPS 2006 2007 Main Branded A07FB oL Ke x 2 gt WDIV Meanz Num Drum Number RAN More Seletiontres Selection decision g Ba Demographics By Group Demographics No Group Average Data Horizontal Pane Auto Home Information Drop ap Down Activiti Travel Any Box Financial Ser
14. 0 vasa e eos 203 100 100 313 46 208 50 2 1027 310 344 19 8 nesa rs HH 228 100 10 353 268 23 4 50 4 102 9 3as 293 222 i2Bs HII esej ama 100 100 478 407 si8 49 101 2 487 479 3 E os 25 6 100 too 3e sso 4 459 35 425 sse 271 14 45 16 TNT 4 0 20 e2 60 14 17 Report Date 16 01 2008 18 Notes data relatively unstable data highly unstable 19 20 la ll 22 KEN 24 25 26 2T 28 29 30 M 4 gt N Table Western Cape Table Gauteng Table Kwazulu Natal J TELM RASPO Page 49 e Mail This allows you to send an email either to another TNT user or as an Excel file to non users You will have to ensure that your email is set up correctly 1 Setting up your email Click on Edit Preferences and Mail TNT Preferences EE Bic xl SE General LJ Surveys exchange belmar co za 5 Ask your IT for Host 4 2 Coding nenette atelmar co za Your email address Results Cnn EEE 4 Email auna amamauam TELM RASPO Page 50 TNT Default Data Items Surveys Coding How to read the grid Stability Audience 000 Aes os eo eO M index Toals Rank MultiBasing Tables Cross Tab TAT Excercise book Tn2 Table Western Cape FF File Edit Codes Options Decimal places Total Help Highlight Hen Print Women Colour TI 16 24 25 34 35 49 50 Winning Media Solutions Audien
15. 001 Search Desktop E Bia 12 45 PM Rank Format TNT Untitled Table Western Cape FF File Edit Codes Options MultiBasing Tables Tools Help TAT Surveys Coding CrossTab Rank Switch Print Excel PDF Email Default Data Items Stability Decimal places Filter Highlight Colour Tiles Calculations Survey order Total Men Audience 000 Resps Col SAW Index Audience O00 Resps Col RoW index 3 074 3 340 100 0 100 0 100 0 1 505 1 666 100 0 45 9 100 0 50 2 TUE 50 4 102 9 49 6 101 2 45 9 23 8 Sorting in Rank Format Right click on the title e g Audience to sort right click again to change the sort order To sort a selection of rows highlight the rows by clicking on a cell and dragging the mouse up or down Right click on the column title to sort Only the selected rows will be sorted TELMAR KIP C Page 31 Flat Tabs TNT Surveys Coding CrossTab Rank Switch Print BgExce PDF Email Default Data Items Stability Decimal places Filter Highlight Colour Tiles Calculations Survey order 1 2 3 4 5 6 7 8 9 10 Default Grid Default will return your results to the default setting after making any changes to the display sort order highlights filtering etc Data Items Display Data items detail all the items selected or available to be selected for display Data Item 5election Bl x Available data items Selected data items comp Audience 000 Audience Rank P Resps AIR S C0 A L 8 Rank NH OW Comp Rank n
16. 6 01 2008 16 01 2008 16 01 2008 07 03 2006 13 03 2006 07 03 2006 Switch Print Excel tj PDF Email 6 AMPS 2005 2006 Main Branded 4034D AMPS 2006 2007 Main Branded 403BP 40405 40446 4044P 406FB AD6FN 40546 407FB 4066B 4066N 4076B BMROOL CADO2 CENO4 cco3s4 CENOL CPOS1 COED3 J ACNO C Single survey selection DSs051 Multi survey selection FT04 FNBO41 FRSO3 FFO4C FFOSCA FFOSCG FFOSCM TNT Excercise book Tn2 Table Western Cape multibasing Multi Surveys PY File Edit Codes Options MultiBasing Tables Tools Help TNT Surveys Coding CrossTab Rank Switch Print Bs Excel por Em Default Data Items Stability Decimal places Filter AMPS AMPS AMPS AMPS AMPS AMPS 2005 2006 2006 2007 2005 2006 2006 2007 2005 2006 2006 2007 Main Branded Main Branded Main Branded Main Branded Main Branded Main Branded Total Total Men Men Women Highlight Colour Tiles Calculations Survey order Audience 000 Resps Co ROW Index Audience 000 Resps 96Col Audience 000 TELMAR X SPC Winning Media Page 8 Coding Selection Selection Tree Decision Information TNT Untitled LIEZ File Edit Codes Ons MultiBasina Tables Tools Help TNT Survags Coding CrossTab Rank Switch Print Excel por Email Coding Sur ey AMPS 2006 2007 Main Bri nded AO7FB lt lt lt gt VDIV MeanzWNum DNum Number RAN More y Demographics By Group Demographic
17. 6 8 Ro 100 0 Fixed Columns Index 100 i Only show selected rows TV Shaw all rows 16 24 Audience 000 8 214 Besos 6 653 Highlight Selection Cal 26 4 SoA Ww 100 0 51 0 49 0 Index 100 0 102 4 97 6 50 Audience 000 7 091 3 283 3 808 Resps 6 702 3 198 3 504 dal 22 0 eae 24 4 SoA Ww 100 0 46 3 53 7 Ingex 100 0 92 3 107 0 Dragging Columns and Rows By pointing to the titles of a column or row you wish to move just hold down the left mouse button and drag You are able to position the columns or rows in any order TELMAR KSP Page 27 Fixed Columns The default setting fixes the row title data item descriptions and Total column Right mouse clicking while pointing to the row titles will bring up the option to un fix the columns When this option is switched off you are able to resize the row title and data item description columns Default Data Items Stability Decimal places Default Data Items Stability Decimal places Auctence 000 Audience O00 Mesos Besos Saco scat ROW l Sono p Index Index Audience 000 Audience 000 Mesos Resps w Fixed Columns Col Only show selected rows i Sow Show all rows Index Highlight Selection Audience 000 S Mesos sca Sono Index TELMAR k sec Page 28 Table Layout TNT E untitled Table All Specific tables can be Pf File Edit Codes Options MultiBasing Tables Tools Help selected for viewing Surveys
18. Coding Cro Tile horizontally Sort AMPS 2006 2007 Main Branded Tle vertically i from the Tables menu or Default Data Items Stability d ilte multiple tables can be Cascade viewed at the same time w 1 Table All bv tili h Total Audience 000 y tiling them Resps 4 612 TIN 100 0 horizontally vertically AROW 100 0 ntially or Index 100 0 EL d cascading them Tile Horizontally aez 80000 lai x File Edit Codes Options MultiBasina Tables Tools Help Surveys Coding CrossTab Rank Switch Print Bgexce peor Email Default Data Items Stability Decimal places Filter Highlight Colour Tiles Calculations Survey order Sort Total Men Women A otal Audience 000 3 074 Sos 1 569 Resps 3 340 1 666 1 674 Co 100 0 100 0 100 0 ROW 100 0 48 9 ETT Index 100 0 100 0 100 0 16 24 Audience 000 623 313 310 Resps 805 461 344 Col 20 3 20 8 19 8 ROW 100 0 50 2 49 8 Index 100 0 102 7 97 5 Tabie Mpumalanga EE AE Default Data Items Stability Decimal places Filter Highlight Colour Tiles Calculations Survey order Sort Total Men Women E otal Audience 000 2315 1 184 HET Resps 1 268 634 634 Co 100 0 100 0 100 0 ROW 100 0 51 1 48 9 Index 100 0 100 0 100 0 16 24 Audience 000 669 343 327 Resps 393 223 170 Col 28 9 28 9 28 9 ROW 100 0 Gale 48 8 Index 100 0 100 1 99 9 Default Data Items Stability Decimal places Filter Highlight Colour Tiles Calculations Survey order Sort Total Men Women otal A
19. Metropolitan Areas Morthern Cape Detailed Metropolitan Areas Free State Development Bank Regions Eastern Cape Community Size Kwazulu Natal Detailed Community Size Mpumalanga B Children Information Limpopo Age Group of Children Gauteng Age of Children Living with yot North West Age of Dependent Children amp Dependents amp Detailed Occupation Domestic Servants Education Gender Household Status Decision Maker T income T Language Lifestages gt TRR EL d wd KB aet tw p e rbe b Winning Media Solutions E The first list box is the Selection Tree code book Click on a heading and the tree will open up another level When there is a sign there is still a further level When the is reached then that is the last level When an item in the last level is highlighted and clicked on it will move over to the Selection decision column For ease of use text that has the option of both long titles and short titles is displayed in italic e An item s in the codebook can be selected for tables or columns or rows They can be selected in a variety of ways For example having opened Demographics Age and Province groups are opened and the options within that group are moved to the Selection Decision box ee From the Selection Decision tree coding is done See coding procedure You can select data from the Selection tree straight to the table column and row grids Pag
20. Page 37 Survey Display Order This item is valid only if there is more than one survey tabbed Then the survey displayed and the order of display can be selected within this dialog box Calculations created under Calculations can be removed from here Survey Display X AMPS 2005 2006 Main Non Branded Delete w Ok 3 Cancel TELMARA SP 3 Page 38 Sort Advanced sorting iol xi Sorting options Show Top ji Rows Show Bottom lio Rows Sort Item Sort order audience 000 Sort Ascending f Sort Descending Starting at raw li Apply to all tables Sort options Setas Default Reload Defaults w Done 3 Cancel TELMARA SP 3 Page 39 Weighting In general the application of ration estimation to adjust in tab sample data from samples so that the weighted sample is in balance with the universe for various household persons characteristics The way that questions are asked will affect the weights used In general there are four weights 1 Population 2 HouseholdHousehold Decision Maker 4 Household Purchaser Population This weight is used e Apply to all surveys for questions that are directed at the Survey AMPS 2006 2007 Main Branded A07FB y individual in the questionnaire The question normally includes the word PERSONALLY or YOU For example How old are you Weights Household Decision Maker Purch i i urchaser Household The weight
21. Print Excel irr Email Coding Survey AMPS 2006 2007 Main Branded A07FB CI Esse hL 2 3 4 5 A 4 En fe 1 Animal Talk ANI 2 Baba amp Kleuter OBAB 3 Cosmopolitan COSM 4 Elle ELLE 5 Essentials ESSEN 6 Fair Lady FAI 7 Femina FEMI 8 9 10 T 12 13 14 T5 16 TE 18 19 20 Ha En Test All Reset Small Grid Survey AMPS 2006 2007 Main Branded Weight Population Report Units 1000 7 start Inbox Microso i91 NEW TNT 2007 We Tranmene Y untitled Paint FY TNT2001 Search Desktop p i YQ DS 08 27 am Clicking on the heading bar of the Tables Columns or Rows can enlarge the display further This will then zoom in and display only the selected item This is useful for editing long coding Reset will take it back to the default look To get back to the small grid click on Small Grid and it will move back to the original grid layout TELMAR KIP C Page 23 Running the Analysis There are two options to running the analysis Crosstab and Rank CrossTab will show the data with multiple data items per row as determined by the items selected below each other Rank will show the data with multiple data items in columns as determined by the items selected To run an analysis select either the CrossTab item or the Rank item on the flat tabs TNT 4 Untitled File Edit Codes Options MultiBasing Table anls Help TNT T Surveys Coding crossTab R
22. an Switch Print BsgExce PoF Email Coding Survey AMPS 2006 lt u07 main Branded 4A07FB CrossTab Format Total Men Total Audience 000 31 109 15 501 Mesos 24 6012 12 405 Ol 100 0 100 0 PAROW 100 0 439 5 Index 100 0 100 0 16 24 durence 000 o 214 4 190 esos 56 553 3 008 eC ot 26 4 2r 0 ZO UU 100 0 31 0 Index 100 0 102 4 25 34 Audience ono 7 471 3 897 Resps a 246 2 ool aC ol 4 0 al TO UU 100 0 Se ad Index 100 0 104 7 Winning Media Solutions E Page 24 Total 1 16 24 2 25 34 d 35 49 4 50 Data Item Selection Available data items Comp Rank Coverage Cov Rank Index Rank Col Rank Row Rank Table 2 Sigma Tolerence 2 Sigma Tol Rank 2 Sigma 2 Sigma Rank Media in Rows Columns Rank Format hen Sudience DOOO esos 15 501 4 190 3 897 4 131 3 283 ITS Selected data items wv Apply to all tables WwW OK 3 Cancel 12 405 3 808 2 550 2 849 3 198 Layout SC ol ROW 100 0 49 5 e O 31 0 25 1 S 6 7 49 6 el z 46 3 Saving Loading a Layout Index 100 0 102 4 104 7 994 5 92 9 In order to see more or less data per row the layout can be changed via TELMAR X PC Winning Media Solutions Page 25 Saving the layout Having selected items to be displayed the layout can be saved for future use or as default TRACKER TRAMSMIT E E PERS isa newlayout thy PROGRAMS File nam
23. ce 00g Aes os Ol SAO Wy index Audience 000 Aes os al SiO U Index audience Ogg Besos AO ARO index Auctence 000 Mesos Seo cO U Index zu 100 0 100 0 965 gab 100 0 100 0 foo 1 055 ob 100 0 100 0 361 93 9 2I 30 4 20 5 425 Dog Aral v4 1 106 0 Page 51 Audience Always read in 000 Resps Respondents This is the amount of people that answered the question positive Read this as you see it do not add 000 4 Col Reading it by starting with the column heading and read it downwards 9eRow Reading it by starting with the row heading and read it upwards Index Base is 100 A percent in relation to a norm of 100 For instance a 123 Index means that a number is 23 higher than the norm An 83 index means that a number is 1796 below the norm How to read the grid TNT Excercise book Tn2 Table Western Cape Total The total population F File Edi Codes Options MultiBasina Tables Tools Help o There are 31 109 000 adults in the TNT T i l Surveys Coding CrossTab Rank Switch population Default Data Items Stability Decimal places Filter Highlight Colour Ti T o 24 812 people where interviewed OOO A o ST Audience 000 which are grossed up to represent the population PCG SDS al Soo Wy i N ith th R h TU ow starting with the men column Reading the r lock Audience ago grey Bice pus N Audience There are 15 501 000 me
24. ce See explanation later in document Search The Search option helps finding required NAAA options questions 50 Only Search Selected Search Again Filter The filter option reduces the display to the required 0 elements Filtering can be done on either the 50 e Selection Tree Selection Decision Selection Tree cell or by the Selection Decision cell The required filter text is entered into the filter box and then click on Go TELMAR KIP C Page 16 Selection Methods There are many ways to select an item for inclusion in the analysis Selecting a Single item Click on Women highlight and use the ez to move across to the focused window eg Tables 18 x TNT Untitled File Edit Codes Options MultiBasina Tables Tools Help TNT Surveys Coding CrossTab Rank Switch Print Excel Peor Email Coding Survey AMPS 2006 2007 Main Branded A07FB 4 gt gt lt lt lt gt VDIV MeanZ Num DNum Number RAN More y 2 amp Summary Title 0 Columns Demographics By Group All Respondents Bg Age Summary Detailed amp Areas Province Metropolitan Areas Detailed Metropolitan Areas Development Bank Regions Community Size Detailed Community Size B Children Information Age Group of Children Age of Children Living with pot Age of Dependent Children amp Dependents amp Detailed Occupation Domestic Servants Educati
25. e Files of type TNT layout files Cancel Sorting in Tab format To sortin tab format right mouse click on the column title choose Ascending or Descending and then an item to sort on To sort a selection of rows highlight the rows by clicking on a cell and dragging the mouse up or down Then right click on the column title and sort Only the selected rows will be sorted The sort order used will be displayed in the top left hand corner of the results TNT Surveys Coding CrossTab rank g itch Print BS Excel TJ PDF Sort AMPS 2006 2007 Main Branded womao Col Desc Default Data Items Stability Decimal places Filter Highligh Sort Asc P Audience O00 Sort Desc F Resps Total Men ronnen o Col otal Audience 000 31 109 15 501 15 608 OB o Resps 24 812 12 405 12 407 O 100 0 100 0 100 0 PAROW 100 0 49 5 30 2 22 0 Index 100 0 100 0 Index Audience PG SDS Sec O Sono Index Audience 000 esos Col SO UU Index eum vde olutions Page 26 Results Grid Viewing Selected rows only To reduce the rows viewed highlight the rows with the actual grid and right mouse click within the rows then select Only Show Selected Rows Clicking on DEFAULT will restore all the rows Default Data Items Stability Decimal places Filter Highlight Colour Tiles Total Men Women Aucience 000 Mesos dol PARON Index 35 49 Audience 000 8 332 4 131 4 201 Resps 6 209 2 845 3 360 eco 2
26. e Add to option without needing the focus of the grids to be set TELMARA SP D Page 18 Selecting multiple items to be joined together with coding automatically The program can join together multiple items with the minimum of effort by the user Auto Coding a Select multiple items within a group and click Auto and the program will automatically join these items together with OR b Select multiple items from within a group and then also within other groups and click on Auto and the program will automatically join the items within each group with OR and then between groups with AND and will add parentheses Brackets as appropriate Big Grid Selection Tree F Only Search Selected C Selection Decision Search Again Survey AMPS 2006 2007 Main Branded Weight Population Report Units 1000 IDO T start Gl CIDO Bar E inbox cr W 2 Mkrosof dr Tranmene Y untied Pant S 112001 MQ c Select multiple items and click on ALL and all the items will be joined together with AND Note This gives the duplication between codes d Select multiple items and click on ANY and all the items will be joined together with OR Brackets will be added to the coding automatically Note This gives the net value of the codes e E g Outdoor Past 7 days total have you seen ANY of the following outdoor types e Select multiple items and click on SUM and all the items will be joined together
27. e 12 The example below shows that having highlighted ACTIVITIES and then used the double arrows in the vertical panel to select all the ACTIVITIES and move them straight into the grid without having to open up each one into the Selection Decision box amp Lifestyle Groups Meter Universe No of People in HH a Past 12 Months w Moved House or flat v Changed jobs T Pets Part Time Correspondence Ed amp Purchaser Got Married Race 5 Accessed Internet WWW amp Status 12M Work Information 0 PAW Demographics No Group PD Average Data Yesterday Home Information amp Interested In Activities Dancing Past 12 Months Billiards Pool Snooker mmm Aerobics Accessed Internet WWW Walking Hiking L Place Accessed Internet L Boxing Wrestling eSent Received e mail P4W Gymnastics Used Internet WWW P12M Martial Arts Used Internet Athletics Internet Connection At Home Basketball Netball amp Sport Activities Cricket Interested In Cycling eParticipated P12M Fishing Attended P12M Golf amp Personal Freq of each activity L Hockey Personally bought p12m Horse Riding abate B nekk 147 deh ee Fa Uria i Chantina Reset Categories Moved House or flat Past 12 Months Changed jobs Past 12 Months 0 Columns MOVED JOBS Part Time Correspondence Educ Past 12 STUDY Months Got Married Past 12 Months P12M Accessed Internet W ww P4w Accessed Inte
28. ed Programmes Manuals Dayparts Training 11 September 2007 AMPS 2007 A07FB Click here to Quarter Hours download the order form Profiles Downloads 27 August 2007 Transmit for Windows V4 6 Release 17 Post Campaign Trami Bois available Click here to see Release Notes Share of Voice Programme Revenue Tracker Data Ebb and Flow Midas Dat 26 June 2007 Telmar s Research Guru Click here for full Press EXE 9 Release potmate Program Releases Transmit Data Super Midas Survey Releases Midas Data Hasp Drivers SABC short term rates March 2008 Combined Media l S Crypkey Drivers Useful info Adplus General FIDEM Click here to view DSTV Channel Reshuffle N 1o Know Other Products eeh do wow dons Product Info Click here to download a basic RBP export template E F TELMAR TranMene exe No Proxy used 7 start iv Inbox Microsoft Outlook lo NEW TNT 2007 doc Co dir Tranmene TELMAR Winning Media Solutions gt Introduction TNT Crosstab is a cross tabbing programme designed to analyse different variables against each le xi G6 O s f Last Updated 2007 11 14 Product Versions a Telmar Media Systems 2007 p Pu DS 08 00 am Search Desktop Page 4 TNT Untitled File Edit Codes TNT T Surveys Options Surveys MultiBasing Coding Tables Tools jssTabD Open S Help r 1 Rank gt WiItcn Available Surveys
29. ermines whether analysis by Household Decision Maker Weight is meaningful Household purchaser Any respondent of either sex who claims to be solely or partly responsible for the household purchases These respondents weighted to households form the basis of the values relating to household FMCG categories Household Weight The weight is used for questions that refer to the household and is used with regard to certain products such as having a stove in the home Household weights can only be used on the following demographics 1 Household Income 2 Geographical Location 3 Living Standards Measures Housewife A housewife is the female household purchaser only The term Housewife does not imply that she does not work Page 54 Impact The relative degree of assumed awareness or measured ad noting achieved by a particular creative execution in ant given medium Index A percent in relation to a norm of 100 For instance a 123 Index means that a number is 2396 higher than the norm An 83 index means that a number is 1796 below the norm LSM Living Standard Measurement is one type of segmentation tool based on wealth access and geographic indicators Wealth is used and dependable differentiator and the AMPS variables are particularly suited to this P Population Also Universe Group of persons being investigated form which some are selected in a systematic fashion to form a sample Population weight This weig
30. espondence Export TAB delimited PMap Graphs pl a o Excel Open with last survey used Recover Unsaved Runs LireTab TBR File 1 K JUsertExcercise book Tn2 Export To SP55 saw File 2 KilseriTraining amp Jan TnZ Export Excel Pivot Data 3 KiLlseri pu Mccann Tnz d K LlseriTraining manual Tnz 5 KilLiserteby radia Tnz E 100 0 Excel File For MapPoint ExiE Open with last survey used TNT will open up all new run with the last survey used Recover unsaved runs If something has happened where you could not save the run this option will recover these runs lt List of files last used A list of files that was used last will be shown next to a number TELMAR KIP e Page 45 Edit Menu Preferences Changes made in the Preference Screens will be remembered for future analysis Results TNT Preferences TNT Preferences SE General Results SE Genera Results Surveys A Surveys a Relatively unstable fo Highly unstable D Printing S sa 3 Exports 43 Exports fh MultiBasing Eh MultiBasing SZ Email Email SL US 4 TNT Preferences S Ganid Results Surveys L amp E Coding fee a Printing 3 Exports fh MultiBasing Email TELM RASPO Page 46 Code Menu Saving Own Codes From the menu bar select Codes Save Own Codes Tables Columns or Rows can be selected and given a title Those codes saved as Own codes will appear in the coding tree lox
31. her Tables Columns Rows 19 Set columns text with alternative text TT TT ae R ESM I na d lt Send to Send selected items to Clear grid Clear entire grid Delete selected rows Delete selected row Insert row Insert row where required Highlight that row and add your code Test This option is used to ensure that individual coding is correct and to calculate and display the audience and respondents This does not take into account any of the other filters added to Table column rows Tidy Will remove all duplicate text from the Title of each table column row CDRINK M or Heavy CDRIME H Diet Cold Drinks DORINK M Medium or Heavy DORINK H Cold Drinks Medium CDRIMNK M or Cold Drinks Heavy CORINK H Diet Cold Drinks DORINK M Medium ar Diet Cold DDRIMEK HJ Drinks Heavy Iced Tea Medium ar ICEDTE M ICEDTE M ICEDTE Hj ICEDTE Hj Set Columns The view defaults to showing codes and titles to the right are Respondents and Population The user can control the order of and viewing of these columns Right mouse click on a column to obtain the menu Click on set columns w ok 3 Cancel TELMARA SP c Page 15 Y Ntiles N Tiles allows the user to create their own frequency distribution and group the results into sections or tiles For example N tiles could be used to create light medium and heavy breakdowns of the user s choi
32. ht is used for questions that are directed at the individual in the questionnaire The question normally includes the word PERSONALLY or YOU For example How old are you Psychographics 1 The classification of people in the audience of media on the basis of their personality characteristics and attitudes which impact on their life styles and product purchasing behaviour see Life otyle and demographics 2 Amethod of population segmentation based on attitudes values beliefs and lifestyles R Reach The number of persons within your target market who are exposed to the advertiser s message at least once This is usually reflected as a percentage and is often referred to as coverage or cover Reach No of Readers Viewers Listeners x100 Number of targeted consumers S SAARF South Afican Advertising Research Foundation Conducts advertising research on behalf of the advertising industry SABRE South African Business Research Evaluation A media research survey specifically aimed at the business market Sample In statistics a group of individuals regarded as representative of a whole population that are selected for study questioning Sample Area In research the geographical area within which a respondent sample is obtained Winning Media wee E Page 55 Sample Error In statistics the deviation between the observed characteristics of a sample and the characteristics of the population fro
33. ht mouse clicking while pointing to the Selection Tree list box will bring up a menu Reset Will collapse the grid Expand Will expand all groups to the widest level Categories Will limit the display to selected items Clear Removes all items from the selection decision box Remove Item To remove just one category on the selection decision box Select all Highlights all items in the selection decision box Reset Filter f a filter has been processed this option returns all the original items to the selection decision box Expand To expand the category to see the coding Collapse To collapse the category Page 14 In the grid by R Click you will find the O Tables Bases 0 Columns NN O ST uai mena Mrored 00 6 O lt Cut Cut the selected cells 2 Changed jobs cae Ctrl C 3 part Time Cori paste DAMM Y Copy Copies the selected cells antris 4 Got Married 1 Undo CHIZ R P P h i MN s cu M iom Paste astes the copied cut eplace r c rw acres aw cells to a new location 7 PFD Accesse SE Tables 8 Yesterday A Sane Undo Undo the last command Clear gri a D Int x i ipa A SNS SE Find Finds specified text either in 10 Billiards Ponl 11 A erobics Inte 12 Walking Hiking Test 13 Boxing Wrestli Tidy Insert row the codes or the titles Replace Replaces the specified 14 Gymnastics 15 Martial Arts I 16 Athletics Inte NTiles 17 MTilesz 18 Expand eit
34. is to serve as the base against all the other surveys This is done by selecting the relevant base survey from the Primary Survey list 2 Against a previous If this is selected each survey will be trended against the previous survey in the Primary Survey list e g In the example below 2007A6 will automatically be trended against 2006A6 o df ticked off this will calculate the second selected survey against the first This option will only calculate two surveys at a time To trend more than 2 surveys click on More Options and select the surveys you want to trend For example to trend AO1BP on AO1AP click on AO1BP in Primary Survey click on AO1AP in Survey to Subtract and click on AO1AP in Dividend I EE Untitled Table Western Cape Pf File Edit Codes Options MultiBasino Tables Tools Help TNT Surveys Coding CrassTab Rank Switch Print BX Excel por Em Default Data Items Stability Decimal places Filter Highlight Colour Tiles Calculations Survey order AMPS AMPS AMPS AMPS AMPS AMPS 2006 2007 2005 2006 2006 2007 2005 2006 2006 7007 2005 7006 Main Branded Main Main Branded Main Main Branded Main Total Non Branded Men Non Branded Women Non Branded Total Audience G00 3 074 Mesos 3 340 SCO 100 00 pat op 100 0 Index 100 0 Audience 000 Resps sco EOI Index Aucience G00 Resps Col Sow index Audience G00 Ress col TROU Index Audience gag Mesos scot HO Index TELM RASPO
35. is used for questions that refer to the household and is used with regard to certain products such as having a stove in the home Decision Maker If the analysis is to be done to establish media OK 3 Cancel usage or other personal demographics for household questions then the Household Decision Maker Weight should be used after filtering on the HH Decision Maker Male Head of Household or Female Housewife The wording of the question and the purpose of the analysis determines whether analysis by Household Decision Maker Weight is meaningful Purchaser Any respondent of either sex who claims to be solely or partly responsible for the household purchases These respondents weighted to households form the basis of the values relating to household FMCG categories TELMAR KIP Page 40 Graphing Telgraph The user needs to create a normal crosstab run In the actual grid the user highlights the area that needs to be graphed by clicking and dragging Note When clicking and dragging release the mouse button within the last block that needs to be part of the graph Graph Data Item Audience 000 i l i te tonus Graph By Column Raw Rows Axis Title ss After highlighting the area the user now need to specify what needs to be graphed by selecting the relevant data item and then the required type of graph See further notes in Telgraph manual Telmar Graph Manager AMPS 2008 Main Branded BA Ju
36. l 2007 Jun 2008 m a File View Help zi x x ELI R X E se Edit pen Save Print E 7 Hew LL Audience 000 Men 145 44 517 76 Em Audience 000 Women 13 12 973 56 gganRm L 5563 69 Total TV Cinema Pew Print P amp r Total Radio Outdoor DD Internet PrO AMPS 2008 Main Branded BA Jul 2007 Jun 2008 DIP Audience 0 Audience 0 14940 62 14517 76 TELM RASPO Page 41 Correspondence Telmars Correspondence program offers a pictorial representation of a Crosstab showing data plotted according to correlation It s a quick method of summarising a lot of data and is commonly used for showing brands by lifestyle Correspondence is used to understand a market understand users of a brand or to identify potential market gaps It also identifies the most discriminating or important lifestyle statements prior to running a cluster Pmaps Telmar Correspondence 1 0 8 0 c luserta tbc ay x File Edit Options Graph Format Global Format Help Telmar Correspondence a All Races Factor 1232 5 Factor 2220 2 Son do Capsules R and Change R Authority RW to Technglpay BB iiio ional Identity Kal Rima BRIDE B Waffe AS T ia ial Harmony elonging and Approval R ofthe Sexes e inded rand Extrinsics LS 50 ompra randpa Tablets ensation Seeking Britis B soa Empathy et dol senol 9 Active Columns Mm Active Rows Passive Columns
37. l allow the user to specify a single or a series of criteria e g index 100 and all the rows that meet that criteria will be highlighted The highlight colour can be changed by clicking on Highlight Colour and selecting a preferred colour iBl x survey Data Item AMPS 2006 2007 M Highlight Colour R gt mo Xu Columns lt i gt f AMD statements f OR statements El Clear w Apply to all tables Apply A Cancel TELMAR ipe Page 34 Colour Tiles Colour Tiles will colour each block of data according to size So a high index would be Red a low index would be Blue Any data item can be used for the tiling Highlight colour X Tiling Colours Lowest Medium High Highest W Calculate tiles per column l Exclude the Total Row Data Itern to colour Audience Ooo Resps Scal o R ON Clear w Apply to all tables w Apply 3 Cancel TNT Untitled Table Western Cape E le x PW File Edit Codes Options MultiBasina Tables Tools Help 81 x TNT Surveys Coding CrossTab Rank Switch Print Excel Peor Email Default Data Items Stability Decimal places Filter Highlight Colour Tiles Calculations Survey order Sort Total Men Women a otal Audience 000 3 074 1 505 1 569 Resps 3 340 1 666 1 674 Col 100 00 100 00 100 00 ROW 100 0 48 9 5151 Index 100 0 100 0 100 0 16 24 Audience 000 623 313 310 Resps 805 461 344 Co 20 27 20 81 19 76 ROW 100 0 50 2 49
38. lation Report Units 1000 7 start v Inbox Microsof bu NEW TNT 2007 A Yer Tranmene Y untitled Paint rwrz001 Search Desktop p E Ya D S 08 03 am TELMARASPC Winning Media Solutions Page 6 Single amp Multi Survey Mode TNT Untitled EN English United States EJ 7 Lfe File Edit Options M j it T Help TNT Surveys Coding Surveys Available Surveys Selected Surveys Survey Description Survey Date Code AMPS 2004 2005 Main AMPS 1997 A 25 08 1997 A974 Gamers 2005 2006 Main Branded AMPS 1997 AB 06 04 1998 A97AB GO amps 2006 2007 Main Branded AMPS 1997 AT 28 08 1997 A97AT AMPS 1997 B 16 02 1998 A97B AMPS 1998 29 04 1999 AMP98 AMPS 1998 T 16 11 1998 A98T AMPS 19981999 28 09 1999 49899 AMPS 1999 A 10 08 1999 4994 AMPS 1999 AB 26 07 2001 A99AB AMPS 1999 B 28 02 2000 499B AMPS 1999 C 30 11 1999 499C AMPS 19992000 09 11 2000 49900 AMPS 2000 A 10 08 2000 4004 4MPS 2000 4B 04 06 2001 400468 AMPS 2000 B 23 02 2001 400B AMPS 2002AP Main 08 08 2002 4024P AMPS 2002BD Main Total Radio TV 07 04 2003 A02BD AMPS 2003Ad Main amp Radio 23 09 2003 4034D AMPS 2003BP Main 09 03 2005 403BP f E AMPS 2004 2005 Main 22 11 2005 40405 O Single survey selection AMPS 200446 Main 25 08 2004 40446 Multi survey selection AMPS 2004AP Main 10 08 2004 4044P AMPS 2005 2006 Main Branded 16 11 2006 406FB AMPS 2005 2006 Main Non Branded 16 11
39. m which it is drawn inherent in all samples and inversely related to sample size Solus A guaranteed position as the only ad on a page or in a commercial break W Weighting In general the application of ration estimation to adjust in tab sample data from samples so that the weighted sample is in balance with the universe for various household persons characteristics The way that questions are asked will affect the weights used In general there are four weights e Population e Household e Household Decision Maker e Household Purchaser TEUMAR k SPC Page 56
40. n Main Total Branded Branded Men Branded Total Total Men Audience G00 Resps Seco PAROW Index Audience gaa Resps Co dudience 000 TELM RASPO Page 53 Glossary A Adults A person over the age of 16 years as defined by AMPS AMPS The All Media amp Product Survey examines the readership listenership television and cinema viewing levels as well as product amp service consumption usage and purchase habits F Frequency The number of times on average that a person within the target market is supposed to have been exposed to the advertiser s message Freq Cumulative total of ratings Total Unduplicated Audience Reach H Household One person or a group of persons usually but not always members of one family who live together and whose expenditure on food and other household items is jointly managed Boarders or lodgers may be included as members of a household provided that they have at least one main meal a day communally Resident domestic servants are excluded and regarded as forming a household of one or more persons in their own right Household decision maker weight If the analysis is to be done to establish media usage or other personal demographics for household questions then the Household Decision Maker Weight should be use dater filtering on the HH Decision Maker Male Head of Household or Female Housewife The wording of the question and the purpose of the analysis det
41. n in the AO 3 32 Rou population Index Respondents 12 405 men where interviewed Audience 000 Resps 9eRow 49 8 of the total population are men Seco eO Mu Index A Audience 4 190 000 men are between 16 24 Audience 000 years old PG SDS Col Y Respondents 3 808 men said yes they are Sono p l Index between the ages of 16 24 years old Aucience BO0 9eCol 27 of men are between 16 24 years esos Col old Sex ut E Row 51 of all 16 24 year old are men Rex Index 2 4 higher than the norm TELMARA SP Page 52 How do l Trend surveys Select the surveys that needed to be trended In selecting the survey either double click or highlight the ones needed and click on the arrow button In order to select more than 1 survey click Multi Survey selection gt Select the columns amp rows that is required If a question was not in one survey will get following error click on Ignore to continue CrossTab or Rank Report p There are syntax errors in coding ey Do you want to view the errors Cancel Ignore Result Screen TNT Surveys Coding CrossTab Rank Switch Print BS Excel por Em Default Data Items Stability Decimal places Filter Highlight Colour Tiles Calculations Survey order AMPS 200546 AMPS 200646 AMPS 200746 AMPS 200546 AMPS 200646 AMPS 2007 46 Main Main Main Mai
42. ng the selected target market s LIEN alo xi Audit Report module You need to select Emsa Options Print Launches the TNT printing which items to print and also lZ Tables h Include universes which audiences to print If there a Ras are multiple reports then you SAA Iw Print Tables Select All Tables Table Western Cape must select or deselect which to ESSERE Table Gauteng print Preview w Print 3 cancel TELMAR KIP C Page 43 9 ey Print Preview Same dialog box appear Click on Preview bottom left When click on Configure change eg Insert a logo change header or footers report settings Wi Telrmar Report Print Preview Report Style Load Set As Defaut Save As a TNTPirStyle TabDelaut I Report Date 16 01 2008 TNT 4 0 20 e2 60 14 Run Excercise book Page 1 of 2 Table Western Cape AMPS AMPS AMPS AMPS AMPS 2005 2006 2006 2007 2005 2006 2006 2007 2005 2006 Main Branded Main Branded Main Branded Main Branded Main Branded Total Total Men Men Women 1 665 D 3 051 3 074 1 493 Audience 000 Resos 9 ey Print Audit Report Audit Report wv Print Audit Report Options Items IZ Include universes lw Tables Columns Rows v Print Tables Select All Tables Select Tables To Print festern Cape zulu Matal Table Gauteng w Print 3 Cancel Preview fires
43. on Gender Household Status amp Decision Maker EE income amp Language Lifestages rh bien Chan ded Ma emori b Reset Categories Clear Use short titles Add to Tables Columns Rows Options e m Go Go Selection Tree Only Search SWected Test All Big Grid Selection Decision Search Again Survey AMPS 2006 2007 Main Branded Weight Plgulation Report Units 1000 7 start v Inbox Microsof Ei NEW TNT 2007 xir Tranmene Y untitled Paint S TNT2001 Search Desktop i ouo 08 19 AM Click on Women highlight and use the Add To option to move to whichever window you require Tables Columns Rows Double click on Women and it will automatically move over to the focused window eg Tables TELMAR KIP C Page 17 Selecting Multiple Items As Separate Tables Columns Or Rows a Click on the heading of the category within the selection decision box or within the Selection tree box and use the ud to move across the items to the focused window e g Columns b Double click on the heading of the category window in the selection decision box and all the items will automatically move over to the focused window c Highlight the required items by either clicking on each item with the ctrl key or the shift key held down and use the to move across the items to the focused window e g Columns d Do either of the above and use th
44. rnet W ww P7D Accessed Internet W WW esterday Accessed Internet WWW G MAR IACP12M IACP4W IACCP7D IACCYES When selecting all option under one category you can simple just double click on the category heading in the Selection Decision Box and it will automatically move into the selected tab Winning Media LR Page 13 E Lifestyle Groups Meter Universe EB Ae of People in HH Br Pets amp g Purchaser Reset e Race i h Status ez Work Informati EStegonies Font Demographics b Average Data Home Information Activities Past 12 Months Internet i Accessed Internet MW WW i Place Accessed Internet Sent Received e mail Paw Used internet WWW P12M Used Internet Internet Connection At Home Ee Spart dctiiities Interested In Participated P12M dended PISM Personal Freg of each activity Personally bought p12rn i Ta added Oe n4 Witte e an k Reset Categories Past 12 Months Moved House or flat Changed jobs Part Time Correspondence Ed Got Married e Accessed Internet WWW P12M Lu Clear PRD l Yesterday 5 Interested I z Dancing Billiards Pot Expand Aerobics Walking Hil z Boxing Wrestling 7 Gymnastics Martial Arts z Athletics Baskethall Nethall z Cricket z Cycling Fishing Golf Hockey 2 Horse Riding D M HI a al SA S Remove Item Select all Reset Filter Collapse Winning Media Solutions gt Rig
45. rows and the old set will be substituted with the new set For example Heavy consumers of drinks have been replaced with Medium consumers of drinks 1 Table a Columns 1 Table 0 Columns Selection decision amp Enld Drinks Juices Mineral Cold Drinks Medium Auto i Cold Flavoured Milk Medium Cold Flavoured Milk FMILKC H Cold Flavoured Milk FMILEC M Diet Cold Drinks Medium n Heavy Medium Iced Tea Medium Diet Cold Drinks DDRINK H Diet Cold Drinks DDRINMK M Mineral Water Medium Heim E f Iced Tea Medium ICEDTE M Fruit Juice Medium Mineral Water MIN M Medium B Fruit Juice Medium FJUICE M Replace Arrows TELMARA SP Page 21 Coding Grid To change focus of the Tables Columns and Rows windows click on the title of the Window banner The active item is shown in Teal O Tables Bases 0 Columns O Rows Coe fe Title All OR AND soy Coy lt l L oy cof Ef cal Poy rp NOT mr e SUM G o A ET J aa mil El cal ral e TELMAR ksPc Page 22 Big Grid The user can switch to Big Grid by clicking on Big Grid at the base of the coding grid The display then changes so that the coding grid fills the screen While in this view highlighted selected items can be dragged and dropped between the Tables Columns and Rows TNT Untitled E File Edit Codes Options MultiBasina Tables Tools Help TNT Surveys Coding CrossTab Rank Switch
46. s No Group Average Data Home Information Activities gt 0 Columns Operators Financial Services Vehicles Transport Modes of Transport Shopping Appliances Products Personal Usage Products HH Purchased Brands Personal Usage Brands HH Purchase TV Information Radio Information Cinema Dutdoor Advertising Print General Print Readership By Group Print Readership No Group Reset Categories Clear Use short titles Add to Tables Columns Rows IA WA options y Go y Go Selection Tree Only Search Selected Test All Big Grid Selection Decision Search Again Survey AMPS 2006 2007 Main Branded Weight Population Report Units 1000 7 Start C WINDO BL cT Inbox Mer NEW TNT 2 TNT Crossta dir Tranmene AY TNT2001 Ol Qa DS 07 13 am Moving to the second screen Coding the window opens with the codebook at the summary level in the left hand list box Selection Tree The second list box Selection decision is to hold those options opened from the codebook When selecting coded codes they will move to the right hand side into the required tables columns and rows grids on the right Items of interest pertaining to the survey chosen can be viewed by clicked on the Information icon Which is also available on the survey selection screen eo Operators can be found on the bar above the selection boxes and on
47. stern Cape ini xi Default Data Items Stability Decimal places Filter Highlight Colour Tiles Calculations Survey order Sort y Search Desktop P e d 12 41PM Survey AMPS 2006 2007 Main Branded Weight Population Report Units 1000 A start li Inbox Microsoft fa NEW TNT 2007 d Y untitled Paint We Tranmene I Ff TNT2001 EN TELMAR Winning Media ASPE Page 30 Cascade 218 x File Edit Codes Options MultiBasina Tables Tools Help Surveys Coding CrossTab Rank Switch Prnt Excel por AE rabie Mpumalanga ioi x WIE Default Data Items Stability Decimal places Filter Highlight Colour Tiles Calculations Survey order Sort Total Men Women otal Audience G00 3 074 1 505 1 569 Resps 3 340 1 666 1 674 Co 100 0 100 0 100 0 YRow 100 0 48 9 51 1 Index 100 0 100 0 100 0 Audience 000 623 ara 310 Resps 805 461 344 96Col 20 3 20 8 19 8 ARROW 100 0 50 2 49 8 Index 100 0 102 7 97 5 Audience 000 700 353 348 Resps 561 268 293 Co 22 8 23 4 22 2 ROW 100 0 50 4 49 6 Index 100 0 102 9 97 2 Audience 000 965 478 487 Resps 886 407 479 96Col 31 4 31 8 31 0 ARROW 100 0 49 6 50 4 Index 100 0 101 2 28 8 Audience 000 785 361 425 Resps 1 088 530 558 Co 25 6 24 0 27 1 ROW 100 0 45 9 54 1 Survey AMPS 2006 2007 Main Branded Weight Population Report Units 1000 7 start Inbox Microsoft a bw NEW TNT 2007 d Y untitled Paint We Tranmene Il AY TNT2
48. udience 000 1 999 1 028 971 Resps 2 027 1 036 991 6Col 100 0 100 0 100 0 Row 100 0 51 4 46 6 Index 100 0 100 0 100 0 16 24 Audience 000 499 255 243 Resps 437 260 177 Col 24 9 24 8 25 1 ARROW 100 0 EIZ 48 8 Index 100 0 99 5 100 5 Survey AMPS 2006 2007 Main Branded Weight Population Report Units 1000 7 start v Inbox Microsoft El tw NEW TNT 2007 d Y untitled Paint dir Tranmene AY TNT2001 Search Desktop 2 E MI 12 38 PM TELMARA SP e Page 29 ile Vertically TNT Untitled BHE File Edit Codes Options MultiBasing Tables Tools Help Surveys Coding CrossTab Rank Switch Print excel por Email ratio Western Cape Lois 101 inixi Default Data Items Stability Decimal places Default Data Items Stability Decimal places Default Data Items Stability Decimal places otal Audience 000 3 0 otal Audience 000 E otal Audience 000 1 9 Resps dis Resps aled Resps 2 0 96Col 10 Co 101 Co 101 ROW 10 ROW 101 ROW 101 index 101 Index 101 Index 101 Audience 000 6 Audience 000 6 Audience 000 4 Resps 8 Resps B Resps 4 Co 21 Co 2t 9 6Col 2 AROW 101 ROW 101 ROW 101 index 101 Index 101 Index 101 5 34 Audience 000 7 25 34 Audience 000 5 5 34 Audience 000 4 Resps 5 Resps 2 Resps 4 96Col 2 Co 2e 9 6Col E ROW 101 ROW 101 ROW 101 index 101 Index 101 index 101 5 49 Audience 000 9 35 49 Audience 000 6 35 49 Audience 000 5 Resps 8 Resps 3 Resps 5 Co cH Co 2t 9
49. vices All Yehicles Transport Modes of Transport B shopping AND Appliances Vertical Pane Products Personal Usage Xen Products HH Purchased SLM Brands Personal Usage Brands HH Purchase oJ TV Information Radio Information Cinema Dutdoor Advertising Ey Print General Print Readership By Group Print Readership No Group Placement of buttons In order to move buttons to different areas R click on either the _ imi xl horizontal or Vertical Operator bars and then A alabie UE Plate S LEN rion on vertical panel click on Customize Toolbars N Position an horizontal panel S Add to dropdown box gt es 2 vVDIV Meanz Num D Num Number RAM Auto Add A wW Ok 3 Cancel Winning Media Solutions gt Page 11 Selection Tree Demographics By Group All Respondents A Age Summary Detailed mm Province Metropolitan Areas Detailed Metropolitan 4reas z Development Bank Regions Community SIZE Detailed Community Size E Children Information Age Group of Children Age of Children Living with pot n age of Dependent Children Dependents H Detailed Occupation Domestic Servants Education Gender Household Status amp Decisian Maker H income Language Lifestages ri I Pe CAL re dl wed hd detin ede Pa m Demographics By Group amp Summary All Respondents 16 24 5 Age 25 34 Summary 35 49 Detailed 50 E Areas 5 Province Western Cape
50. with PLUS Note This gives the gross value of the codes e Eg All those who read 1 Daily Newspaper title only Thus it will add everyone together Readership TELMAR KIP C Page 19 Test All D Tables Bases 0 Columns 4 Rows By clicking on Test All under the coding E388 588 H window will calculate the Population and S Respondents for the active cell Tables Columns or Rows r Note the results are NOT filtered it is the z total respondents for the specified coding 16 17 18 19 20 En 22 23 24 25 26 Use Short Titles To remove appended titling click on Use short titles For example using TV viewership P7D where Past 7 days is appended to the titling If use short titles is switched on then Past 7 days is omitted from the titles Title Code e TY Past 7 days E TVP7D Mnet Main Service Past 7 days MNETMP7D 1 Z 3 4 S For ease of use text that has the option of both long TV Information Past 4 Weeks z Past 7 gays Yesterday HH Times Watched any Tl Working TV Set in HH z Pay TV Information titles and short titles is displayed in italics TELM R Y SPC Winning Media Solutions Page 20 Replace To replace one set of tables columns rows with an alternative set highlight select the set to be replaced in the coding grid and highlight select the new set in the Selection decision box then click on the replace ar
51. within TNT Select two or more surveys at the survey selection window If data is missing in one survey then the cell will be blank TNT Excercise book Tn2 File Edit Codes ations MultiBasing Tables Tools Help TNT Coding Surveys CrossTab Rank Available Surveys AMPS 2003Ad Main amp Radio AMPS 2003BP Main AMPS 2004 2005 Main AMPS 200446 Main AMPS 2004AP Main AMPS 2005 2006 Main Branded AMPS 2005 2006 Main Non Branded AMPS 2005A6 Main AMPS 2006 2007 Main Branded AMPS 2006A6 Main Branded AMPS 2006A6 Main Non Branded AMPS 200746 Main Branded BMR Income amp Expenditure Survey CADO02 CAD02 CAD 2002 Nederlands Caxton Comm Newspapers East amp North 2004 CC03A 2003460010306 410 EE GAHE CENSUS 2001 City Press 2005 Coega Industrial Development Survey 2003 Compass 2007 Daily Sun Advertiser Value 2005 Finansies amp Tegniek 2004 FNB 2004 1 Project 1976 FRSO3 FRS 2003 Future Fact Combined Survey 2004 General Rel Future Fact Combined Survey 2006 African Res Future Fact Combined Survey 2006 General Rel Future Fact Combined Survey 2006 Media 24 Survey Description Survey Date code la 23 09 2003 09 03 2005 22 11 2005 25 08 2004 10 08 2004 16 11 2006 16 11 2006 07 02 2006 23 11 2007 15 11 2006 14 11 2006 17 10 2007 16 01 2008 16 01 2008 16 01 2008 16 01 2008 09 06 2005 16 01 2008 16 01 2008 11 01 2008 14 07 2005 16 01 2008 1
Download Pdf Manuals
Related Search