RAJAR CROSSTAB
Contents
1. Station TS As G TS As National Stations Excluding Groups E Bac Stations TSAS SS Stations fa OON Growuos J BBZ Radi 2 ae TSA BBZ Radio 3 Q TSA BEZ Radio 4 Q TSA BEZ Radio FIVE LIVE Q TSA L tra from the BBC Qi TSA BEZ 6 Music Qa TSA BPa y TZA J Search Options Search text contains O Any keyword O All keywords f Exact phrase Starting with C Search All Description lear choice tree O Code d V Search Selected A V Search All In Selected i avg nasa tefault Vv OK Clos Own Publications BBC Radio 1 Q B 880C Radio 1 Q Monday BBC Radio 1 Q Mon Qtr Hr Aud B 88C Radio 1 Q Tuesday BEC Radio 1 Q Tue Qtr Hr Aud 0645 0700 VAM AVA AA B BBC Radio 1 Q Wednesday a Bec Radio g Ol Wed Bertie Aud p p a 2 For further assistance call the Helpdesk on 020 7467 2575 teimar Copyright 2012 By Telmar Group Inc All rights reserved the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 33 How do I code the average hours spent listening to a radio show i e average hours spent listening to the Breakfast Show on R1 in a week Cont Step 6 Click on the Mean and at the end of the a o l coding click on the Click on Number and enter the GEE ae Number value of 4 Click on OK Value 4 w ok cancel PS Always divide by 4 to get the hourly results Dividing by 2 gives you the half hourly results Step 7 In the Title box to ch2. Demographics Basic Men Women ildren 4 14 Click on the Options facility This will allow you to search by Description Select Description Click on OK Type the station you require in the Search box in this example we have used Radio 1 Click on Go Double click on BBC Radio 1 TSA Search Options Search text contains Addto Tables Columns Rows O any keyword All keywords Exact phrase O Starting with Search z Tree options Search level z Search All rea ptians tf Clear choice tree Oco Search Selected Save settings as default wh Ok Close Surveys Coding CrossTab Rank Switch Autocomplete Print BRJExce Coding Survey Rajar Wave 4 2004 RJ044 4 gt oe lt lt lt gt VDIV MeanZ Num DNum Number RAN More Own Codes 0 Columns iain a aa T Station TSAs TSAs National Stations Excluding Groups 3 BBC Stations TSAs Nationa Stations Excluding Groups 3 TSAs Local SLations Excluding Groups Click on Columns to begin to define your columns In the coding screen click on Reset to get back to the original screen For further assistance call the Helpdesk on 020 7467 2575 telmar Copyright 2012 By Telmar Group Inc All rights reserved the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 7 FM 103 Horizon 1027 4 Severn Sound FM H Classic Gold 774 H 96 3 Radio Aire H Beacon FM H Radio Borders Y
3. and click on Save Enter a short filename e g Test then click on OK This is saved as a TN2 file To print your file select File click on Print then press OK For further assistance call the Helpdesk on 020 7467 2575 telmar Copyright 2012 By Telmar Group Inc All rights reserved the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 9 This is all you need to learn The Survey Selection Screen Surveys ICE104 AARO4 Aberdeen Agricultural Research May 2004 27 06 2004 AARO4 ABO4L 2004 Premier TGI 11 02 2004 ABO4L ABOSL 2005 Premier TGI 16 02 2005 ABOSL ABMO2 Absorbing Media 2002 03 09 2002 ABMOZ ARO4R Aberdeen Readership Survey 2004 07 10 2004 ARO4AR AR04S Aberdeen Readership Survey 2004 Incl 07 10 2004 AR04S ASBO4 Asian Business Readership Survey 2004 25 02 2004 ASBO4 ATMO3 ATMS 2003 20 01 2004 ATMOS AW203 AIM Wave 2 May 2003 15 07 2003 AW203 AW303 AIM Wave 3 November 2003 09 01 2004 AWw303 AW404 AIM Wave 4 May 2004 20 06 2004 AW404 AW504 AIM Wave 5 November 2004 13 12 2004 Aws04 B3744 KRT 03 syys 2003 marraskuu 2003 28 11 2003 B3744 BAMO4 TGI 2004 April 2003 March 2004 for 07 10 2004 Bamo4 BAPO3 BBC World Audience Profiling Study 2003 15 12 2003 BAPO3 BB024 BBC Daily Life Oct 2002 Sep 2003 Wav 11 12 2003 BBO24 BB02a BBC Daily Life Oct Dec 2002 All Week 30 05 2003 BBO2A BBOZe BBC Daily Life Oct Dec 2002 Non Wildca
4. Search Selected Search All In Selected Save settings as default wr Ok Close For further assistance call the Helpdesk on 020 7467 2575 telmar Copyright 2012 By Telmar Group Inc All rights reserved the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 15 To speed up your search you can use the Filter box In this example we have used Weekly Reach Reset Categories Use short titles Weekly Reach Ww i L F Search searches for the keyword s within the whole database If you want to type more than one word to search for the words must be separated by a semi colon i e capital virgin radio Type your Keywords in the Search box In this example we have used capital virgin heart Click on Go lt gt YDIY MeanZ Num ONur Numb Add to Tables Columns Rows Weekly Reach A Weekly Reach National Stations Excluding Groups B Commercial Stations Weskiy Beach Matona Stations Excluding Grou Virgin Radio 4h fH Capital Disney Q ee ere ae Heart Digital iQ e Virgin Radio Classic Rock Q Virgin Radio Groove Q E Weeki Geach Loca Stations Excluding Groups J ECommerce Stations Weskiy Reach Local Stations Exctucing Groups 95 8 Capital FM 0 Capital Gold Hampshire 1170 amp 1557 H Capital Gold South Wales H Capital Gold Birmingham 1152 H Capital Gold Manchester H 100 7 Heart FM H Virgin FM London Q If nothing was found af
5. You can sort Ascending or sort Descending Make sure the tick next to Apply all tables has been taken off Sort Item Index Sort Ascending Sort Descending Starting at row Apply to all tables Sort options C Set as Default Reload Defaults wf Done a en Steg For further assistance call the Helpdesk on 020 7467 2575 telmar Copyright 2012 By Telmar Group Inc All rights reserved the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 25 How do I code up the Demographic Profile of a station i e age class and sex breakdown of Mercury FM Herts listeners Step 1 In Tables double click on Demographics then on All Adults Step 2 Click on the And button then click on the Reset button to get back to the original screen Step 3 Double click on Station TSA S In the Search box type in the word Mercury Click on Go Step 4 Double click on Mercury FM or use the arrow to take across the coding Click on the Reset button Step 5 Double click on Weekly Reach In the Search box use the arrow to select Mercury and click on Go Step 6 In Columns double click on Mercury FM Click on Reset to get back to the original screen For further assistance call the Helpdesk on 020 7467 2575 All rights reserved Copyright 2012 By Telmar Group Inc 0 Tables Bases 0 Columns a Rese Cluse short titles Station TSAs TSA4s Local Stations Excluding Groups Ado to Mes Coum
6. then click on the gt to take the demographics over to the rows separately a e E E E Own Codes Own Publications INFORMATION FOR USERS Rajar Wave 4 2004 asic From the coding screen click on the Options menu then Weight choose Latest 3 Months Weight click on OK when finished EY File Edit Codes Options Tables Tools Help TNT Surveys Coding CrossTab Rank Switch Autocomplete Default Data Items Stability Decimal places Filter Highlight Weights Total BBC Radio 1 Q BBC Apply to all surveys Stations Weekly Survey Selection Reach National Mnkians Z survey RJOd4d RAJAR WAVE 2004 RiOd4 3 Stations eae Tables Tools Help fedudine Groups Weights ps Se Audience 48 862 Resps 6 Month Weight H se 12 Month Weight CY Row i Open Style sheet Index i Save Style sheet Men Audience 23 627 iDemographics Basic Resps 58 101 Co 468 4 Load default Style sheet SPAN 100 0 Save Style sheet as default Index 100 0 Women Audience NTiles Demographics Basic Resps Co Niles Row Index I Cancel lage 15 24 Audience Demographics Basic Resps Co AROW Index Now you have finished coding click on Run or Crosstab or Rank this will process your results and then present them as either a Tabular or Rank format The results will show a demographic profile of Radio 1 listeners To save your file select File
7. 0100 0115 0115 0130 0130 0145 0145 0200 0200 0215 0215 0230 0230 0245 0245 0300 0300 0315 0315 0330 0330 0345 0345 0400 0400 0415 0415 0430 0430 0445 0445 0500 0500 0515 0515 0530 0530 0545 0545 0600 0600 0615 0615 0630 0630 0645 0645 0700 0700 0715 0715 0730 0730 0745 0745 0800 0800 0815 The codes are made using an average of Monday Friday quarter hours Combining these codes would produce inaccurate results These categories are only to be used when looking at individual 4 hrs and tracking listening patterns across a day They are not to be used with and or buttons How do I get individuals age 4 in the survey The rajar survey records listening for those aged 4 or over To code all respondents combine males 4 with females 4 Adults are defined as those age 15 so you would highlight the Station TSA and All Adults in your Table base to make sure that your results correspond with the results in the hard copy For further assistance call the Helpdesk on 020 7467 2575 telmar Copyright 2012 By Telmar Group Inc All rights reserved the FUTURE of Media Planning
8. All rights reserved weekly Reach ato Weekly Reach Ni Weekly Reach Loca Stations Excluding Groups Weekly Reach Station Groups Weekly Reach FM Stations Excluding Groups a Weekly Reach AM Stations Gochicing Groups nal Stations Excluding Groups i sn is nent pent hp oO 1 Column the FUTURE of Media Planning A RAJAR CROSSTAB User Manual Page 24 How do I code up station duplication i e Classic listeners listening to other stations cont Step 7 Select Options and then Weights from the z rotokypes fille menu Choose the latest 3 month weight Click on OK F Weights Apply to all surveys Open Style sheet 3 Month weight 014 Save Style sheet l A Save Style sheet 4 6 Month weight CH SS ae 12 Month Weight v3 Load default Style sheet r T Save Style sheet as defa Mpe F sS Step 8 To Rank your report click on the Rank option to view the results sic FM Q TSA Commercial Stations TSAs National Stations Excludin Filter ghlight Colour Tiles Calculations Survey order So Step 9 To sort by Index click on the Sort option If TTT you want to sort all of the report put a tick in the box Sorting options next to Apply to all tables and click on Done A rarpe C Show Bottom Survey to use If you want to sort just one of the columns click on the sort option next to the column you want to view
9. REPORT DIMENSIONS Once you have tabbed the run you can change the width or height of the rows or columns as you like position the cursor to the black line between the column or row headings a double headed arrow will appear click and drag the line to the required position Changing the dimensions of any one row or column will change those dimensions for all rows or columns STYLE SHEETS Once you have modified the presentation of your report to suit your needs you can then save that format as a style sheet This enables the user to display the data in any report in a given format without changing the display settings saved on file Once you have selected all the required report options select Save Style Sheet from the Options menu Enter a file name in the Save Style Sheet as box and click on OK To apply this style of presentation to a report select Open Style Sheet from the Options menu select the style sheet file you need and click on OK The program will then return you to For further assistance call the Helpdesk on 020 7467 2575 telmar Copyright 2012 By Telmar Group Inc All rights reserved the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 21 the Editor grid Click on Tab again to run the report Style sheets can be selected before or after coding If you have a preferred style of presentation you can set this as your default style sheet by selecting Save Style Shee
10. an i G BBC Radio 2 Q TSA 0A A BBC Radio 3 Q TSA OPtiOnS gemm BBC Radio 4 Q TSA BBC Radio FIVE LIVE Q TSA H Lmtra from the BBC Q TS4 BBC 6 Music Q TSA i i a a ee F Beg Step 4 Double click on BBC1 or use the arrow to take across the coding Click on the Reset button Step 5 Skip Columns and go to rows Double click on Solus Listening eI Solis Listening Mational Sao LEs cluding Groups i Solus Listening Now select the station you wish to code ee solus listening for i e BBC Radio 1 k BBC Radio 2 a H BBZ Radia 3 tQ BBZ Radio 4 Q L BBZ Radio FIVE LIVE O3 Letra from the BBO m3 BB 6 Music H BBC Q L FIVE LIVE SPORTS EXTRA Cm E5 Con ne noe Stetiaos Sofas Listening Waetones Staetrons E Oon a Solus Listening Loc Stations Excluding Groups E Solus Listening Sta mn Groups olus Listening EEI Skim agente oem SOUPS 3 EN at pae Step 6 Click on Crosstab or Run You will see 1 054 000 Jr me tat Codes Options prototypes MUHBSSNI lanes TT Surveys Coding MmrossTtab Rank People listen to Radio 1 and no other station That s 2 2 Default Data Items Stability Decimal places of the population Total Wotal Aaecrence OOD 415 562 eS oS 127 00 TATO 100 0 TAO M 100 0 Enae 100 0 BEC Radio 1 Tash _ BBC ane eS 000 1 054 Stations Solus Ress 2 595 Listening Socio BE ye Seo hH 100 0 Deh oe For further assistance call the Helpdesk on 020 7467 2575
11. assistance call the Helpdesk on 020 7467 2575 teimar Copyright 2012 By Telmar Group Inc All rights reserved the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 11 Explanation of Telmar s Electronic Code Book Mean L 7 Al F Z ot i SOLUS WIR WOUD Sums figures for selected codes together Multiplication symbol Greater than Greater than or equal to Less Than Smaller than or equal to Equal To Establish the average of coding Used in conjunction with gt etc Defines a range Puts brackets around the selected coding Establish the solus users of a brand or group of publications stations Returns the Index of the 2 weighted vectors taking into account their totals Variable 1 col Variable 2 Col 100 Compares two audiences Audience 1 Audience 2 100 8 ry P E MoT co LIT u For further assistance call the Helpdesk on 020 7467 2575 Copyright 2012 By Telmar Group Inc All rights reserved View Survey Information Places the selected items in separate rows columns or tables Combines selected codes with an OR Between them and brackets Combines selected codes with an And between them and brackets Joins selected codes together to forma larger target group Joins selected codes to form a more detailed description of a target group Excludes the given code Adds items together for a result combines selected codes wit
12. lt Reset Categories i Use short titles o I Double click on Weekly Reach to open the category Double click on Weekly Reach National Stations Excluding Groups Double click on BBC Stations Highlight BBC Radio 1 and use the to take the coding across to the Columns Surveys Coding CrossTab Rank Switch Autocomplete Prin Coding Survey Rajar Wave 4 2004 RJ044 gt gt lt lt lt gt YDIV MeanZ Num DNum Number RAN More Own Codes 1 Table 1 Column Own Publications INFORMATION FOR USERS Rajar Wave 4 2004 Demographics Basic Demographics Grouped Internet Usage Regions Individual Ages Acorn 2001 Mosaic 2001 Financial Mosaic 2001 Scottish Mosaic 2001 Station TSAs Weekly Reach a Weekly Reach National Stations Excluding Groups amp BBC Stations Weekly Reach National Stations Excluding Groups BBC Radio 2 Q BBC Radio 3 Q BBC Radio 4 Q BBC Radio FIVE LIVE Q Click on the Rows to begin defining your rows e g Demographics In the coding screen click on the Reset option to get back to the original screen For further assistance call the Helpdesk on 020 7467 2575 telmar Copyright 2012 By Telmar Group Inc All rights reserved the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 8 Go back and open up the Demographics category and highlight your chosen demographics e g men women age class etc
13. sheet 12 Month weight Er Load default Style sheet Save Style sheet as default NTiles a a tien Step 9 Click on Crosstab or Run to view the results TNT Surveys Coding CrosstTab Rank Switch Autocomplete Print Default Data Items Stability Decimal places Filter Highlight Total Mercury FM Herts H Weekly Reach Local Stations Aucience 000 Men Aucience 000 Demographics Basic Resps Cor Row index Women Audience 000 Demographics Basic Resps Cor 2R W index Age 15 24 Aucience 000 Demographics Basic Row F ane a a wr nde xg annas paa For further assistance call the Helpdesk on 020 7467 2575 teimar Copyright 2012 By Telmar Group Inc All rights reserved the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 27 How do I code up the Solus listeners of a station i e people who listen to Radio 1 and do not listen to any other station Step 1 In Tables double click on Demographics then on All Adults 0 Tables Bases 0 Columns as Step 2 Click on the And button then click on the Reset button to get back to the original screen ae Categoriesg Cluse short titles a j A 4 Step 3 Double click on Station TSA S In the Search Stati on TS4s5 box type in the word BBC 1 Click on Go TS4s National Stations Excluding Groups Addto Tables Columns Rows E S5C Stations TSAS Matona Stations Exot Search f BBC Radio 1 TS A E adia E i J
14. telmar Copyright 2012 By Telmar Group Inc All rights reserved the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 19 Highlight rows ina report You can highlight rows in the report that meet certain criteria so these are highlighted To highlight rows that show Index figures over 100 click on Highlight in the green bar at the top then under Column click on the item you want to show then under Data Item click on Index then click on gt then type 100 into the Parameter box and click on Apply BB Highlight Color Columns talkSPORT Parameter Enter the value you want to compare against 100 W Apply to all tables WwW Apply 2 Cancel 5 OTHER REPORT OPTIONS There are other report options you can specify if you select the Edit menu and choose Preferences Select Results It lets you specify various options that affect the way your report looks TNT Preferences J Surveys Use these settings to configure result options lt b Coding General Stability l TABBED RESULTS RANKED RESULTS Show column totals Show row totals Fixed row totals Separate columns Word wrapping MultiB asing T Query highlight color 3 SZ Email Ignore zero weighted respondents Size all columns at the same time Use survey codes Show trend colours Restore System Defaults Tabbed Results Show column totals Displays the column totals Fixed row
15. totals Displays the row totals For further assistance call the Helpdesk on 020 7467 2575 telmar Copyright 2012 By Telmar Group Inc All rights reserved the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 20 Ranked Results Show row totals Displays the row totals Separate columns Displays beneath down the screen instead of across the top Word wrapping The titles can be read as they are displayed beneath rather then across Row numbers Turn this option on if you want the rows in your report to be numbered Audit Report If this is turned on the Audit Report option in the print dialog box will automatically be checked This means that printing the audit report will be the default If it is not turned on the audit report will not be printed by default Stability Flagging If this option is turned on stability flagging will be enabled Using stability will display single and double asterisks for various degrees of data stability as recommended by data suppliers CHANGING FONTS To change the fonts click on the Options menu and Fonts Heine Prototypes Font Font style al Bold Italic Open Style sheet Save Style sheet v 5 Arial Regular E E a T Ga 4 Arial Black Italic g i i Bold me 5 Antiqua Effects Sample Load default Style sheet Place AaBbYyZz C Underline Save Style sheet as default Color Mi Eck v Script o NTiles Western v Mtilesz CHANGING
16. user to update their basic coding knowledge using the Rajar Wave data The following examples are constructed from Rajar Wave 2 2003 survey Using the Manual We have attempted to make this manual as user friendly as possible by using examples of frequently asked coding questions This manual describes each coding example in detail leading you through it step by step For further assistance call the Helpdesk on 020 7467 2575 telmar Copyright 2012 By Telmar Group Inc All rights reserved the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 5 RUNNING TNT RAJAR CROSSTAB Select TNT from the Telmar Integrator applications TNT Ch stab 3045 Mtab 3045 to M 2006 Mtab for PP2000 PP2000 Prod There will be a list of surveys to choose from Type in RJ in the Filter box to search for the Rajar Surveys TNT Surveys Surveys Coding CrossTab Rank Switch Autocomplete Available Surveys Survey Description Survey Date Code 2004 1 febr ar 02 03 2004 ICE104 44R04 Aberdeen Agricultural Research May 2004 27 06 2004 44R04 4B04L 2004 Premier TGI 11 02 2004 4B04L 4BOSL 2005 Premier TGI 16 02 2005 4B05L 4BMO2 Absorbing Media 2002 03 09 2002 S4BM02 4RO4R Aberdeen Readership Survey 2004 07 10 2004 4RO4R 4RO4S Aberdeen Readership Survey 2004 Incl O7 10 2004 ARO4S 4S5B04 Asian Business Readership Survey 2004 25 02 2004 4S5B04 z z A
17. vececessecsssessessesesesensesseserseseessnsesseseseees 22 How do I code up station duplication i e Classic listeners listening to other stations 23 How do I code up station duplication i e Classic listeners listening to other stations cont 24 How do I code up the Demographic Profile of a station i e age class and sex breakdown of Mercury FM Her ts listeners oo cccccccccscscsscssescssessescsscsecsesesscseseesscscsscsscsesecsecsesecsscscsecsecsesecaseacseeaseaees 25 How do I code up the Demographic Profile of a station i e age class and sex breakdown of Mercury FM Herts listeners Cont ccccccccccccscsscsscscsscssesesscsscsesscsecsesscsscsesscsecsesecsecscsecsecseseeseesesecaeenees 26 For further assistance call the Helpdesk on 020 7467 2575 telmar Copyright 2012 By Telmar Group Inc All rights reserved the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 3 How do I code up the Solus listeners of a station i e people who listen to Radio 1 and do not listen to any other Station ea a AE EE een ee ete 27 How do I code up the average number of hours spent listening to a station i e How many hours does the average KISS listener tune into the station 0 0 0 0 cccccccsscssescsecssesesscssescseeseesees 28 How do I code up a station s share of listening i e BBC RADIO 1 s share of total weekly BUST ANN AEE EE EN EE A EE ee peri A vas oceans cusses sessed E 29 How do I code up Weekly Reach with
18. A 18 02 2004 CM3AXx CMPO1 Compose TGI Recontact September 2004 03 11 2004 CMPOL Refresh List Filter Reset Anywhere in title Description O Starting with O Survey Code The Editor Grid N TNT Surveys Coding CrossTab Rank Switch Autocomplete coding Survey Rajar Wave 1 2005 RIO51 Edlir YDIY meanz Mum DNum Number Own Codes Own Publications INFORMATION FOR USERS Rajar Wave 1 2005 Demographics Basic Demographics Grouped Internet Usage Regions Individual Ages Acorn 2001 Mosaic 2001 Financial Mosaic 2001 Scottish Mosaic 2001 Station TSAs Weekly Reach Weekly Hours Solus Listening Share of Listening All Listening Share of Listening Commercial Non Commercial Listened at Home Listened in Car Listened Elsewhere Listened at Work Readership Claimed T Viewing Cinema Choice of Radio Station BBC Radio 1 Q BBC Radio 2 Q BBC Radio 3 Q BBC Radio 4 Q BBC Radio FIVE LIVE Q gt Classic FM Q Classic Gold 1521 H Mercury FM Surrey amp Sussex H 97 6 Chiltern FMC Duns Luton H Northants 96 H Classic Gold 1557 tH FM 103 Horizon 102 4 Severn Sound FM H Classic Gold 774 H 96 3 Radio Aire H Beacon FM H Radio Borders gt Reset Categories lu hore titi Tables Columns Rows se sno mies Big Grid r Weights Weights 6 Month Weight H 12 Month Weight CY Canc
19. P TOnmnOCrGE Stetiors TSAS Loce SIaNONS kiss me iss 100 FM Q TSA G TSAS Stetian Growos lt y G Gonmei SaN Ons TSAS Stadion Grouos H Total Kiss Q TSA E Might Kiss H TSA i EM AaF adio London Magic 105 4 Kiss L003 Q TSA G TS s FM St Oe cluding Groups Dns geb Enf Statin sexoj s Jan m i Gees l gt Uwn Publications Weekly Hours 8 Weekly Hours Local Stations Excluding Groups m e Commercial Stations Weelly Hours Local Statio mess 100 FM iQ Weekly Hours Station Groups C eater Stations Weekly Hours Station Groups Total Kiss 9 A ht jpet 1 Table Base TNT Surveys Coding CrossTab Rank Switch Default Data Items Stability Decimal places Filter Highlic Average hours listened to Kiss 100 FM Value 10 435 03 Resps Pyare Co AROW index teimar the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 29 How do I code up a stations share of listening i e BBC RADIO 1 s share of total weekly listening Step 1 In Tables double click on Demographics then on as 0 Columns All Adults Step 2 Click on the And button then click on the Reset button to get back to the original screen Rese Categories Cluse short titles Step 3 Double click on Station TSA S In the Search box type in the word BBC Radio 1 Click on Go Station TRAS G TS As National Stations Excluding Groupsi e o J SET Srat TSAS MEAT t Sra E n F Click on Reset to g
20. RAJAR CROSSTAB User Manual Page 1 RAJAR CROSSTAB User Manual 2012 For further assistance call the Helpdesk on 020 7467 2575 telm ar Copyright 2012 By Telmar Group Inc All rights reserved the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 2 INTRODUCTION 3 cos scus cosseeeneeosuvesoseesacedconawannesssoues saree seseosewsen esse REA EAA EEES 4 CSG TS GID eects cee caee ae pene AE NE NOA NE A tesa pacers ae teen eee 4 RUNNING TNT RAJAR CROSSVAB c cccssnsacucsemescucavececteecusecucseusecucneuescewneasecasavees 5 COING SCHON eecccsscscssesessesessecesecesesccsesessescesessssessssessssessssesssssessscesssesssseessseesssecsssessesessesesacsesseseescsesseseceeseeecseeeeseees 6 VISITS Gi VOU MELO TO VOI ar na EEA A TAE teeters ener ene eS 9 Explanation of Telmar s Electronic Code BOOK ieeesesssssssssssssevsssssvssssssvsssssevssscssnsssesensssesetsssesensssesensssesenssseees 11 Extra Facilities ON the coding SCEEN ececsessessssessesssessessrssssesenssssesesessessssessessssesseseseseesessessesessessesesseseesenseseess 12 GETTING STARTED WITH CODING carves ete tree ee eee eeaseengess 13 SEARCHING FOR CODING icacast rw ote ers on oasis rn cs ot a ote os a ete ae een eae sane 14 To SECM Ch OF CSCC TIO OF CONG csc esp tctinsd ss csantodianssasetea one ceiprese ctinctaneedunepiesanantenaiaesctoetentetoeqarecaussenteauneetees 14 To Search for coding within the whole database cccccccsccsesessescssescssesessesesesessesesessesseecsee
21. S s are Station TSs45 5 Ts45s National Stations Excluding Groups B SST Stations TSAS Maetione Stations fe cluoiing Grous J mE Radio 1 Q TSA BBZ Radio 2 Q TSA BBZ Radio 3 Q TSA BBZ Radio 4 Q TSA BBZ Radio FIVE LIVE Q TSA L L stra from the BBC Q TSA BBZ 6 Music Q TSA pra paT 3 TS 5 alr F Search Options Search text contains O Any keyword Exact phrase Tree options C Search all Description Clear choice tree O Code Search Selected Search All In Selected O All keywords Starting with Ho BEC Radio I Q Atiwk Qtr Hr Aud Mav nasemault oa OK B Clos a Total Hrs BEC Radio 1 gt a at AT err A Own Publications BBC Radio 1 Q B 88C Radio 1 Q Monday BBC Radio I Q Mon Qtr Hr Aud B 88C Radio I Q Tuesday BEC Radio 1 Q Tue Qtr Hr Aud 0645 0700 B BBC Radio 1 Q Wednesday S Bac Radio g Ol Wed r tie Aud e s 1 Table Base 0 Columns telmar the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 31 How do I code up Weekly Reach within a Daypart i e How many people listen to the Breakfast show on R1 during the week Cont Step 7 Click on Options Weight and choose the latest 3 month weight Click OK Step 8 Leave the Rows blank Click the Crosstab button or click on Run The results show that BBC R1 s audience for the breakfast show is 6 95 million people Prototypes Open Style sheet L
22. TMO3 ATMS 2003 20 01 2004 ATMO3 Filter options AwW203 AIM Wave 2 May 2003 15 07 2003 Aw203 AW303 AIM Wave 3 November 2003 09 01 2004 Aw303 Filter Reset Aw404 AIM Wave 4 May 2004 20 06 2004 AWw4o04 4w504 AIM Wave 5 November 2004 13 12 2004 Aws04 B3744 KRT 03 syys 2003 marraskuu 2003 28 11 2003 B3744 G yiwhere in title O Description BAMO4 TGI 2004 April 2003 March 2004 for 07 10 2004 BAMO4 2 BAPO3 BBC World Audience Profiling Study 2003 15 12 2003 BAPOS Starting with Survey Code BBO24 BBC Daily Life Oct 2002 Sep 2003 Wav 11 12 2003 BBO24 BBOZa BBC Daily Life Oct Dec 2002 All Week 30 05 2003 BBOZ4 BBOZe BBC Daily Life Oct Dec 2002 Non Wildcard 14 05 2003 BBOZE BB244 Daily Life Apr Sep 2003 JC Decaux Ver 17 12 2003 BB244 BB24B BBC Daily Life Oct 2002 Sep 2003 fo 25 08 2004 BB24B BBCO2 14 10 2002 BBCO2 BBSO3 British Business Survey 2003 01 08 2003 BBSO3 BOSO4 BBC Online Offline Segmentation 2004 01 02 2005 Bos04 BROZH Britannia 1999 2001 Household 05 03 2003 BROZH BROZL Britannia 2002 With First T Lifestyle Clusters 18 03 2003 BROZL BROZP Britannia 1999 2001 Population 05 03 2003 BROZP C4407 CAA Airport Survey 2003 Waves 1 amp 2 14 07 2004 CAA07 CAV21 Caviar 21 2004 07 04 2004 CAV21 01 03 2005 CAV22 A CAV22 Caviar 22 2005 I Meola Highlight the Rajar Survey you wish to use e g Rajar Wave 4 2004 Click on the arrow pointing towards Selected Su
23. ange the title click in the box and type in Average number of hours spent listening to Breakfast Show 1 Table Step 8 Click on Options Weight and choose the latest 3 Prototypes MultiBasirygi Weights Apply to all surveys month weight Click OK Font 3 Month Weight Month Weight WLLL 6 Month Weight H Open Style sheet iene We Save Style sheet Load default Style sheet Save Style sheet as default NTiles Mije ua on m SF Fie Edit Codes Options Tables Tools Help Step 11 To view your results click on Crosstab or Run DIGI Surveys Coding CrossTab Rank Switch Autocompi This will show you the Radio 1 listeners listen to the a a ee I Breakfast Show on average 3 hours a week Howes apene listening to Breakfast For further assistance call the Helpdesk on 020 7467 2575 telmar Copyright 2012 By Telmar Group Inc All rights reserved the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 34 COMMONLY ASKED QUESTIONS Why can t I use weekday coding for creating dayparts There is a section called Series Coding shown for example as the highlighted section below BBC Radio 1 Q H BBC Radio I Q Monday BBC Radio 1 Q Tuesday H BBC Radio 1 Q Wednesday H BBC Radio 1 Q Thursday H BBC Radio 1 Q Friday H BBC Radio I Q Saturday H BBC Radio I Q Sunday E 88C Radio 1 Q Weekdays NOT FOR DAYPART CODING B BBC Radio 1 Q Wkday Qtr Hr Aud 0000 0015 0015 0030 0030 0045 0045 0100
24. ans ROW Commercial Stations TSAs Local Stations Exclu Mercury FM Surrey Sussex H TSA Mercury FM Herts H TSA Chiltern inc Mercury FM Herts H TSA TSAS Station Groups Commercial Stations TSAs Station Groups fhe ions S fort ge Mercury FM Surrey amp Sussex Classic Gold 1___ TS4s FM Stations Excluding Groups 5 fnmercial Stations TSAs FM Stations Excluding SEARA art TRAA en aA Ai a weekly Reach Meet Seach Lace Statians Fxclucing Gr commercial Stations Weeki Seach ic Mercury FM Surrey amp Sussex H ae Mercury FM Herts H Chiltern inc Mercury FM Herts H Weetip Seach Station Groups El Commercial Stations Weeki Geach Station Groups m Mercury FM Sygt s uss eyi telassic Sald l 521 KH Add to Tables Columns Rows Go Options 1 Table Base telmar the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 26 How do I code up the Demographic Profile of a station i e age class and sex breakdown of Mercury FM Herts listeners Cont Step 7 In Rows double click on the Demographics acon category Highlight the Age Class and Social Grades Use the mp arrow to take across the codes separately Step 8 From the Options menu select the latest 6 month weight and click on Ok Prototypes Multibasy Weights Apply to all surveys Font M Apply d apen 7 sheet E Month Weight H 6 Month Weight H gaye Style
25. des Own Publications Station TSAs TSA4s National Stations Excluding Groups BBC Stations TSAs National Stations Excluding Groups BBC Radio 2 Q TS4 BBC Radio 3 Q TSA BBC Radio 4 Q TSA BBC Radio FIVE LIVE Q TSA 1Xtra from the BBC Q TSA BBC 6 Music Q TSA BBC Q TSA iia Surveys Coding CrossTab Rank Switch Autocomplete Print B Excel Email Coding Survey Rajar Wave 4 2004 RI044 te a a a o eee i A a l a ada e J Own Codes A 1 Table Base 1 Column Own Publications F Weekly Reach g Weekly Reach National Stations Excluding Groups F iy Reach National Stations Excluding Groups BB BBC Radio 3 Q BBC Radio 4 0 LXtra from the BBC Q S BBC 6 Music 0 For further assistance call the Helpdesk on 020 7467 2575 telmar Copyright 2012 By Telmar Group Inc All rights reserved the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 23 How do I code up station duplication i e Classic listeners listening to other stations Step 1 In Tables double click on Demographic then on All Adults Step 2 Click on the And button then click on the Reset button to get back to the original screen Step 3 Double click on Station TSA S In the Search box type in the word Classic Click on Go Step 4 Double click on Classic FM or use the arrow to take the coding across then click on Reset to get back to the original screen Step 5 In Columns double clic
26. ecseeeesseecseeeeseees 14 CHOOSING YOUR WEIGH Fae sidutricnecatuins nn catwieswe neers comes eeu os aatetpiwn side esaweneen eaeteenee ene 16 CHOOSING THE DATA ITEMS DISPLAYED 0 ccc cece ccc ce cee cece eee ne eeceeeeeeeeeeeees 16 SELECTING THE REPORT STYLE ios ens hos os oe erro eee sos vest oes meee eca eee ee 17 Fiering dala ina repon eea caer schon E E E EEE E E E E 18 OTN ING E E chester S EE E E O A S NEE A E O O E E N A OA T E 18 PORON OWS EV ATEON air aa E E E EE E EEE EE AEE E EEEE E EEE 19 OTHER REPORT OPTIONS 6 iisscucncutucuuscuiuduwneuseeteneueueuuneuwneu wn eueuneu ws euystweseweaeseserea 19 TODEA RESU S eea e AE AEEA paste dope E cetera TEE nooo E AA EAEE 19 RIEA STS e AE AOPEN T cacao EE EAA IAEE E EARE A OEA TE 20 CHANGING FONTS soeseperirri Ene rErE PENERE ANO OANA TEENE REN EEE EPERERA ENE TARARE ANAR RAEN ENAA 20 CHANGING REPORT DIMENSIONS 0 cece ccc cece cence nee e cece e ee eeeeeseeeeeeeeenes 20 STILE SHEETS o pee ee tactic nee ee ENEE E E E E A E EEE NEN EAR E 20 SAVE OWN CODES oenar as hss e EEEE EE E E E E ETES 21 PRINTING AND PRINT PREVIEW oricsciosite wsiane da eons rds ween cc ecm cat auad ueced anda weed aues 21 OV UO ahaa ete EET EE na trata sence een EN EAE E aac a EIE EEE A N A E sas esa E AAEE E E T 21 PUNTA AAIE ONE A NOE EEEE E EE AE E ENE AEA ETE 21 TV Ape ste hs sere A sess ee aed sues ses Sue suf ee eee eee de soa cesta EANA 22 How and when do I use Total Survey Areas TSAS in CrOSSTAD
27. ect Apply to all tables if you want to the data items to show on the whole crosstab run Data Items Stability Decimal places Filter Highlight Colour Tiles Calculations SL k Data Item Selection Seles Available data items Selected data items P Audience Audience Rank Resps ALR Cal 4 1 Rank oy ALA ww Comp Rank Index Ss loverage Coy Rank Index Rank Col Rank Row Rank 95 Table Table Rank Projected Proy Rank Resps Rank 2 Sigma Tolerence 2 Sigma Tol Rank 2 Sigma 2 Sigma Rank f Apply to all tables w OK 3 Cancel For further assistance call the Helpdesk on 020 7467 2575 tel mMm al Copyright 2012 By Telmar Group Inc All rights reserved the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 17 To add to the list double click on a data item on the list box on the left or select a data item and click on the right arrow gt gt button The data item will move across from the left list to the right list Similarly you can remove a data item by selecting it on the right list and clicking on the left arrow lt lt button or by double clicking the data item The second arrow gt gt button will take the whole list across to the right list The forth arrow lt lt button will take the whole list across to the left list Once you have chosen the data items you want they may not necessarily be in the desired order You can re order them by selecting a data item in the list on the rig
28. eful with such things as getting the optimum column widths Click on the File menu and on Print Preview Printing To print your report click on the File menu and on Print If you also need to print a copy of your codes click on the Audit Report box in the Print window so that a cross appears If you want to print out only your codes and code descriptions click on Print Audit Report from the File menu For further assistance call the Helpdesk on 020 7467 2575 telmar Copyright 2012 By Telmar Group Inc All rights reserved the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 22 TSAS How and when do I use Total Survey Areas TSAs in Crosstab A TSA is a station s Total Survey Area the official area in which a station can be heard They are used for filtering information such as a tool for finding out the weekly reach of a regional station If the weekly reach of a regional station differs on TNT from the information printed in the hard copy then it is normally rectified by filtering the Station s reach through it s own TSA To do this you would combine All Adults and the TSA of the station in your Table base In the Columns you would put the Weekly Reach of the station TNT Surveys Coding CrossTab Rank Switch Autocomplete Print Coding Survey Rajar Wave 4 2004 RJ044 gt gt lt lt MeanZ Number RAN SOLUS VIND VAUD more Own Co
29. el The Output Screen Tabular report For further assistance call the Helpdesk on 020 7467 2575 telmar Copyright 2012 By Telmar Group Inc All rights reserved the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 10 EF File Edit Codes Options Tables Tools Help TNT Surveys Coding CrossTab Rank Switch Autocomplete Default Data Iterns Stability Decimal places Filter Highlight Total BEC Radio 1 Weekly aden i Reach Audience 46 562 Mesos 127 00 tocol 100 0 AROW 100 0 index 100 0 lage 25 34 Audience Mesos ee AROW index Age 35 44 Audience Mesos eco AROW index Audience Mesos eC ol PAROW index lage 55 64 Audience Mesos eco AROW index The Output Screen Rank report TNT Surveys Coding CrossTab Rank Switch Autocomplete Print Default Data Iterns Stability Decimal places Filter Highlight Colour Sort BBC Radio 1 Weekly Reach Index desc BBC Radio 1 Weekly Reach Audience Resps Col 0 ROW index Oeo o ooo o HTD i Age 20 24 1 694 3 777 17 1 4z a3 232 7 Age 15 24 3 553 6 098 35 8 46 9 Age 15 19 1 859 4 321 18 7 46 6 4 ge 5 34 2 945 6 820 29 7 37 4 Class C1 3 608 8 486 36 3 22 5 Men 5 269 12 138 53 1 22 3 Class C 2 442 6 550 24 6 21 5 Age 35 44 1 665 5 375 18 8 20 4 Class AB 1 871 4 786 18 9 20 2 Women 4 657 12 997 46 3 18 5 Class DE 2 005 5 313 20 2 16 4 Age 45 54 924 2 775 3 3 12 0 Age 55 64 399 1 235 4 0 5 7 re Age 65 241 832 24 2 5 For further
30. et back to the original screen as shown aro S Eoen Groups BBZ Radio 2 Q TSA previously BBZ Radio 3 Q TSA BBC Radio 4 fa TSA BBZ Radio FIVE LIVE a TSA L tra from the BBC Qi TSA BBZ 6 Music Q TSA 97 Toia alr a Step 4 In Columns double click to open up the Share of Listening All listening category In the search box select Share of Eea E AllListening 5 E Share of Listening All Listening Mational Stations Excluding Groups BBC Radio 1 and click on Go Share of Listening All Listening Local Stations Excluding Groups gil E Share of Listening All Listening Station Groups n EE Share of Listening All Listening FM Stations Excluding Groups a E Share of Listening All Listening 4M StationstExcluding Groups Share of Listening Commercial on Commercial Listened at Home Listened in Car Listened Elsewhere Liste nigel at J r rk Step 5 Double click on BBC Radio 1 or use the arrow to 1 Table B take across the coding able Base Step 6 Crosstab the run To view your results in 2 7 n E TNT Surveys Coding CrossTab Rank Switch decimal places click on Decimal Places from the menu and O Default Data Items Stability Decimal places ter Highlight in the decimal box use the up arrow to put in number 2 l Total BBC Radio 1 s share of total weekly Click on Done when finished SET Choose the latest 3 month Weight The results should show that BBC Radio 1 s share o
31. f all radio 1 s share of all listening hours is 8 17 For further assistance call the Helpdesk on 020 7467 2575 teimar Copyright 2012 By Telmar Group Inc All rights reserved the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 30 How do I code up Weekly Reach within a Daypart i e How many people listen to the Breakfast show on R1 during the week Step 1 In Tables double click on Demographics then on All Adults Step 2 Click on the And button then click on the Reset button to get back to the original screen Step 3 Double click on Station TSA S In the Search box type in the word BBC Radio 1 Click on Go Click on Reset to get back to the original screen as shown previously Step 4 In Columns click on BBC Radio 1 then in the Search box make sure BBC is showing Click on Options and the Search Options will appear The default is Exact phrase Search Selected and Search All in Selected Click on the OK button Step 5 In the Search box type in 07 08 then click on Go Highlight 0700 to 0900 from Monday to Friday using your Ctrl key between days Step 6 Click on the Any button to put or s between the codes To change the title In the title box type in 0700 0900 BBC Radio 1 Week Day Audience For further assistance call the Helpdesk on 020 7467 2575 Copyright 2012 By Telmar Group Inc All rights reserved 0 Tables Bases 0 Columns E dl i Rese 3 Categories Cluse short titles J
32. h a plus sign Replaces highlighted codes from the electronic code book in the editor grid teimar the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 12 Extra Facilities on the coding screen More A MUL Divide by symbol Subtracts figures for selected codes together Not Equal Divides Codes Extracts Numeric vector from CCP Column Card Punch files Extracts floating point vector from CCP files Selects codes when they are highlighted Assigns values 1 9 for punches 1 9 ina column Assigns values to punches in as if they were binary number Similar to Num statement but extracts columns differently Mean of any numeric vector can be filtered by a prefix within brackets Mid value ina numeric vector Sums a range of punches Assigns given values to diff punches ina column Multiplies tabbed results for two codes For further assistance call the Helpdesk on 020 7467 2575 telmar Copyright 2012 By Telmar Group Inc All rights reserved the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 13 GETTING STARTED WITH CODING 1 In order to code people who are aged between 15 and 34 years Double click on Demographics basic then on Demographics Highlight the 15 24 and 25 34 age categories and then click on the Any option NOTE The coding appears in the editor grid at the right hand of the screen E g Any 15 24 25 34 These ages a
33. ht and clicking on the Up and Down arrows to move that data item up and down the list Once you are satisfied with your choice click on OK If you have any report windows open they will be automatically updated SELECTING THE REPORT STYLE The Sort menu is used for designing the report t Colour Tiles Calculations Survey order Sort Options MES Sorting options C Show Top 10 Rows C Show Bottom Rows Surve y to use Sart column Sart Item Index O Sort Ascending Sort Descending Starting at row Apply to all tables Sort options Set as Default Reload Defaults w Done Cancel The Sort Column drop down list box lets you define the column you want your report sorted on You can choose any of the columns including the totals column and you can also choose all columns If you choose Total and your report is a tab report it will sort the rows by the total column If you choose Total and your report is a rank report instead of the columns appearing next to each other in the report they will appear separately I e all the rows will be shown for the first column and all the rows will be shown for the second column underneath etc The bottom half of the dialog box lets you define how your report will be sorted You can define the data item on which you wish to sort by choosing it from the Sort Item drop down list box For further assistance call the Helpdesk on 020 7467 2575 telmar Cop
34. in a Daypart i e How many people listen to the Breakfast show on R1 during the WEEK ci5icr2ciiceessrerisncinattviasereesinie ae eeernnatit eee siacrar deen onneeeaeee 30 How do I code up Weekly Reach within a Daypart i e How many people listen to the Breakfast Show on R1 during the week Cont cccccccccccssssessssessssessssessscesssseseescsececsesecsseeeseeeesseecseeesseeecseeeesseesseeesaees 31 How do I code the average hours spent listening to a radio show i e average hours spent listening to the Breakfast Show on R1 in a week ooo ccccscsessssessesesseceseceseeeeseeeeseeeeseeeseeecseeeeaees 32 How do I code the average hours spent listening to a radio show i e average hours spent listening to the Breakfast Show on R1 in a Week Cont oo cccccccccccsscscsssscssescsssscssescseescsseseseeecseeecsees 33 COMMONLY ASKED QUESTIONS ce iccteits weunistentuceiteenweeideanenirds voeseds ieee deee season eras 34 Why can t I use weekday coding for creating CAYPAPTS ceeeccssssssssevsvsssensssssesevsssssssscsestsssessnsssenenstsesenses 34 How do I get individuals age 4 in the Survey ececesessesesssssssesessssessssessesessesessesessesessssessesesesseseesesesseseeseseesees 34 For further assistance call the Helpdesk on 020 7467 2575 teimar Copyright 2012 By Telmar Group Inc All rights reserved the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 4 INTRODUCTION TNT Rajar Crosstab Manual is an easy to use set of examples allowing the
35. k on Weekly Reach to open up the category The search box already has Classic in there so just click on Go Double click on Classic FM Click on Reset to get back to the original screen Step 6 In Rows double click on Weekly Reach to open up the category then double click on Weekly Reach All Stations to open up the category Use the to separate the stations k F 1 Table Base VITQUE Rau aoe 2a KUUK Station TSAs TSAs National Stations Excluding Groups Commercial Stations TSAs Nationa Stations Excluding G Classic FM Q TSA 0 Columns 0 Columns K Rese Categories gf Cluse short titles MUY wwe 1aquics wI muy J E ne t Classic FM Outside London Plus Q TSA J virgin Radio Classic Rock Q TSA TSAs Local Stations Excluding Groups Commercial Stations TSAs Local Stations Excluding Groups Classic Gold 1521 H TS4 TO mand a HS Ae oe TO 0 Columns Weekly Reach Weekly gach National Stations Excluding eia i Weekly Reach Station Groups Weekly Reach FM Stations Excluding Groups Weekly Reach AM Stations eens Groups 100 7 Ea FM H 100 102 Century FM H 100 102 Century FM North H 100 102 Century FM South H 102 4 Severn Sound FM H 102 4 Wish FM H 102 4 Wish 107 2 Wire Y m 197 5 Bae dia nal Qn a For further assistance call the Helpdesk on 020 7467 2575 telmar Copyright 2012 By Telmar Group Inc
36. oad default Style sheet Save Style sheet as default NTiles a n THT Default Surveys otal For further assistance call the Helpdesk on 020 7467 2575 Copyright 2012 By Telmar Group Inc All rights reserved Cata Items Stability Weights V Apply to all surveys Survey Selec ion We 13 Month Weight Q 6 Month Weight H 12 Month Weight Y mroassTab Rank Decimal places Total Audience F DOO i teimar the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 32 How do I code the average hours spent listening to a radio show i e average hours spent listening to the Breakfast Show on R1 in a week Step 1 In Tables double click on Demographics then on All Adults Step 2 Click on the And button then click on the Reset button to get back to the original screen Step 3 Double click on Station TSA S In the Search box type in the word BBC Radio 1 Click on Go Click on Reset to get back to the original screen as shown previously Step 4 In Columns click on BBC Radio 1 then in the Search box make sure BBC is showing Click on Options and the Search Options will appear The default is Exact phrase Search Selected and Search All in Selected Click on the OK button Step 5 In the Search box type in 07 08 then click on Go Highlight 0700 to 0900 from Monday to Friday using your Ctrl key between days 0 Tables Bases 0 Columns ae lt ay aa Cluse short titles
37. rd 14 05 2003 BB02E BB244 Daily Life Apr Sep 2003 JC Decaux Ver 17 12 2003 BB244 O Single survey selection Multibasing BB24B BBC Daily Life Oct 2002 Sep 2003 fo 25 08 2004 BB24B multi survey selection BBCO2 14 10 2002 BBCO2 BBSO3 British Business Survey 2003 01 08 2003 BBSO3 BOS04 BBC Online Offline Segmentation 2004 01 02 2005 Boso4 BRO2H Britannia 1999 2001 Household 05 03 2003 BRO2H BROZL Britannia 2002 With First T Lifestyle Clusters 18 03 2003 BRO2L BROZ2P Britannia 1999 2001 Population 05 03 2003 BRO2P CAAD CAA Airport Survey 2003 Waves 1 amp 2 14 07 2004 CAAO CAV21 Caviar 21 2004 07 04 2004 CAV21 CAV22 Caviar 22 2005 01 03 2005 CAV22 CCSO3 CCS Media amp Client Study October 2003 05 05 2004 ccso3 CCS04 CCS Media amp Client Study June 2004 08 10 2004 ccso4 CEB04 The Central European Business Readershi 18 08 2004 CEBO4 C1423 Outdoor Advertising Study Global Merge 16 08 2004 CIA23 CIA24 Sensor 2004 In Store Advertising Study 01 03 2005 CIA24 CIM99 CIM99 CIM 1998 1999 Francais 05 05 2005 CIF99 CIM99 CIM99 CIM 1998 1999 Nederlands 15 09 1999 CIM99 CLCO1 Clear Channel Tracking Survey Aug 2004 19 10 2004 cLco1 CM034 China Marketing amp Media Survey 2003 A 02 12 2003 CM03A CMO3S China Marketing amp Media Survey 2003 S 17 12 2003 CM03S CM04S China Marketing amp Media Survey 2004 S 31 03 2004 CM04S CM3AX China Marketing amp Media Survey 2003
38. re mutually exclusive The coding appears as A15 or A25 2 To code people who are in Social Class AB and aged 15 to 34 Highlight the 15 24 and 25 34 age categories and then click on the Any option Click on And then double click on the required class AB E g AGE 15 34 And CLASS AB 4 The coding appears as A15 or A25 and AB For further assistance call the Helpdesk on 020 7467 2575 teimar Copyright 2012 By Telmar Group Inc All rights reserved the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 14 SEARCHING FOR CODING To Search for a section of coding Simply type the required word s in the Filter box and then click on Go Example enter Cinema in the Filter box then click on Go the Cinema section will be found you can now double click to open the section to show the Cinema section Cinema Reset Categories BB requency of going Once a week or more Use short titles 2 3 times a month i Once a month l Filter Once every 2 or 3 months p 2 3 times a year Cinema wt z f Ae Neyer these days To Search for coding within the whole database To search by Exact Phrase select the Options function Click on OK Search Options Search text contains O any keyword All keywords Exact phrase Starting with Tree options Search level Search All Description Clear choice tree Code
39. rveys and the survey will be shown underneath Selected Surveys TNT Surveys Coding Crosstab Rank Switch Autocomplete Surveys Available Surveys Selected Surveys Survey Description Survey Date E R1044 RAJAR WAVE 4 2004 RJ043 RAJAR WAVE 3 2004 08 12 2004 RJ044 RAJAR WAVE 4 2004 07 02 2005 For further assistance call the Helpdesk on 020 7467 2575 telmar Copyright 2012 By Telmar Group Inc All rights reserved the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 6 Coding Screen Click on the Coding menu This will show the coding screen Surveys Coding CrossTab Rank Switch Autocomplete Pri Own Codes Own Publications INFORMATION FOR USERS Rajar Wave 4 2004 Demographics Basic Demographics Grouped Internet Usage Regions Individual Ages Acorn 7001 Mosaic 7001 Financial Mosaic 7001 Scottish Mosaic 7001 Station TSAs Weekly Reach 2 3 4 5 6 7 a F Co Double click on Demographics Basic to open up the category Double click on Demographics Basic to open up the list Highlight All Adults and use the arrow to take the coding accoss to the Tables Then click on the AND double click on Station TSAs Tables Tools Help CrossTab Rank Switch Autocomplete 4 gt gt lt lt lt gt YDIV MeanZ Num DNum Number RAN More Own Codes 0 Columns Own Publications INFORMATION FOR USERS Rajar Wave 4 2004 Demographics Basic amp
40. t as Default from the Options menu This style sheet will then automatically be adopted when you enter TNT If you have selected an alternative and want to return to the default without exiting TNT select Open Default Style Sheet from the Options menu SAVE OWN CODES Once you have coded your tables columns and rows you can save any or all of these parts in an Own Codes file for use again later This enables the user to quickly make new runs using pre coded parts of old runs For example if you have coded in your rows some very commonly used demographic groups which you will need to use again in the future with the same survey saving them as Own Codes allows you to input them again as precoded product files from the code menu When your coding is complete select Save Own Codes from the Codes menu In the Save Own Codes window tick the part s of the run which you want to save as Own Codes Table Columns or Rows and enter a code description Click on OK and then enter a file name Your codes will appear under this title To open your Own Codes file exit Crosstab first and re enter selecting the same survey Enter the codes menu and double click on Own Codes The name of your file will appear underneath Double click on this and then select your codes as normal PRINTING AND PRINT PREVIEW Preview Print preview can help you design your report by showing what it will actually look like when printed It is us
41. telmar Copyright 2012 By Telmar Group Inc All rights reserved the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 28 How do I code up the average number of hours spent listening to a station i e How many hours does the average KISS listener tune into the station Step 1 In Tables double click on Demographics then on All Adults Step 2 Click on the And button then click on the Reset button to get back to the original screen Step 3 Double click on Station TSA S In the Search box type in the word Kiss 100 Click on Go Click on Reset to get back to the original screen Step 4 Double click on the Weekly Hours category Search for Kiss 100 Highlight Kiss 100 and Click on the Meanz option Step 5 This will automatically put in the codes in the Columns Step 6 Crosstab the run To view your results in 2 decimal places click on Decimal Places from the menu and in the decimal box use the up arrow to put in number 2 Click on Done when finished Choose the latest 3 month Weight The results should show that on average the Kiss 100 FM listener spends 5 63 hrs a week tuned into the station For further assistance call the Helpdesk on 020 7467 2575 All rights reserved Copyright 2012 By Telmar Group Inc 0 Tables Bases 0 Columns ae Categories Cluse short titles eee 4 Ar MALFEE RRP cee SS Addto Tables Columns Rof Station TSAS 3 4 fl TSAS Local Stations Excluding Groups AO
42. ter using Search click on Reset to reset the categories and then type alternative word s in the Search box and try again E g To do a search for Breakfast Show Daypart for BBC Radio 1 Type in BBC in the search for box then click on search only stations with the word BBC in will appear Type 07 08 in the search box and click on Go Highlight 07 00 09 00 codes and click on any For further assistance call the Helpdesk on 020 7467 2575 telmar Copyright 2012 By Telmar Group Inc All rights reserved the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 16 CHOOSING YOUR WEIGHT Before choosing the data items to be displayed choose Options then Weight for choosing your weight You will be shown a Choose Weight box Weights Apply to all surveys Weights 6 Month Weight H 12 Month Weight Y I Cancel The list box displays three options to choose from for your weight Choose your weight and then click OK You can now choose the items to be displayed CHOOSING THE DATA ITEMS DISPLAYED You have a wide choice of data items that can be displayed in your report crosstab the report To select the required items choose Data Items from the menu You will be shown a Choose Data Items box The list box on the right displays the data items you have chosen in the order in which they will appear on the reports Sel
43. yright 2012 By Telmar Group Inc All rights reserved the FUTURE of Media Planning RAJAR CROSSTAB User Manual Page 18 If you choose None your report will not be sorted and the rows will appear in the order in which they appear in the editor grid The Sort At Row box option lets you leave the first few rows unsorted This may be useful if you are a media owner and you wish to compare the performance of your station with the others You can put yours on the top and it will remain there regardless of the order in which the other stations are sorted Type the row number of the first row to be sorted in the Sort At Row box The Ascending and Descending buttons let you decide the sort order Filtering data ina report Sorting You can filter the report so that you only see figures that are below or above a certain figure To filter the report to only show Index figures over 100 and to hide information that does not click on Filter in the green bar at the top then under Column click on the item then under Data Item click on Index then click on gt then type 100 into the Parameter box and click on Apply If you want to get these results for the run click on Apply to all tables C Parameter The Storm Q ep lt gt b e Z O AND statements OR statements Clear Wf Apply to all tables W Apply Cancel For further assistance call the Helpdesk on 020 7467 2575
Download Pdf Manuals
Related Search