Ch-08 Reports
Contents
1. You may select the desired margins in inches for top bottom left and right Font You may select any font that has been installed for your printer FontSize You may select any available font size for the printout Natural M usic User M anual Page 8 7 Memorize Report Settings If you want to save and reuse the customized formatting of certain Reports and lists as described on the previous pages you may Memorize the report settings and recall them under the Memorized Reports menu choice On the Report Design screen make any customizations and then click Memorize You must give this Report a unique name so you can recall it for future use Memorize Report Settings Ea Enter a UNIQUE NAME for this Memorized Report Cancel To use a Memorized Report click Reports Memorized Reports from the Natural Music main screen w Memorized Reports OF Xx Category Songs Reporting Service Page 8 8 Natural M usic User M anual Preview and Print Report In the Report Design screen select View Print to preview the Report You may also set the column widths from this preview screen by dragging the column dividers left or right Click Print when ready to print the Report or Export to send the report to a text file is Report Preview BEE Song List Sorted by Title Artist for Sample Source Category Title Artist Intro Length EndType Tempo Year E 10012. i Report Designer ioj x vat mee EY Help Close Report Type BM Report Report Name JBM Report Report Title BMI Report Report Sub Title Start Date fori 00 End Date 3724700 Report Period Report Name For customized Reports this is the unique name by which you may recall a customized report design Report Type This is one of the Natural Music Report Types y Song List Performance Rights y Play History y Packet List Report Title This is the main title heading to be printed at the top of the printed page in large print Report SubTitle This is a sub heading to be printed as the second line of the page header in medium print Report Period For Play History or Performance Rights Reports this will allow you to select the date or time period to be printed Page 8 2 Natural M usic User M anual Selecting Report Columns To set the Columns Song Properties to be printed on the Report you first need to display the Report Design screen by selecting the desired Report from the Reports menu on the main Natural Music screen w Report Designer iof xi vat weal Help E Close Album AlsoProtect Burn CategoryD ate CategoryPlays CategorpStack FadeLength Gender You may drag and drop the columns Song Properties to be included in the Report back and forth between the Available Columns and the Included Columns boxes to either include or exclude a column from the song li
3. Performance Reports RIAA Webcast Report You will then see the screen on the following page on which you should enter the information NM5 needs to create the RIAA file Notes on Electronically Filed RIAA Reports The RIAA output file is created and named in accordance with the specifications issued by RIAA for electronic reporting It is recommended that you NOT change this filename as it identifies your company to RIAA for licensing purposes The entries are described below When ready to export the file click Create Please do NOT change the name of the RIAA report output file The file name is assigned by NM5 according to standards set by RIAA There are several unusual fields such as UPC code ISRC code and Track Label P Line that must be entered for each song in the RIAA report See Song Data Entry Album Data in Chapter 2 of this User Manual for a discussion of these fields This electronic RIAA file must cover a calendar month and NM5 can only prepare the report for a period for which the song play histories are saved in the NM5 database Therefore you must set the Save Song History for Days in SetUp Station to enough days so you always have at least a calendar month of play history in the database on the day you generate this report The times listed in the RIAA report will be the Scheduled Time unless you perform the Log Reconciliation in the Music Log Editor to read the exact times from an automation Play Log or
4. Air Log Page 8 14 Natural M usic User M anual RIAA Webcast Report cont w RIAA Webcast Report for Electronic Filing OF x Station Settings Licensee Name IN atural Broadcast Systems Inc Channel or Program Idenitifer kex Channel or Program Type Ps Prescheduled x Channel or Program Genre KxxX Time Zone Hours from GMT je Hours Report Month Year Api x 2002 Create Use PkZip compression Include NM5 Category s V AMAOSA a Z Christmas Traditional Y Cruising Classic Q Q Disco UnSelect All A Group One Hot Help C Group One Low B Group One Medium Select All E Group Two Hot x Cancel G Group Two Low x Licensee Name This is the name under which your RIAA performance license is granted Channel or Program Identifier This is the unique channel or program identifier that differentiates this channel or program s play list from all other channels or programs you operate Channel or Program Type This is the type of streamed programming A Archived L Looped V Live PS PreScheduled Most radio broadcasters will use PS or V Channel or Program Genre This is the category of musical content the channel is offering Radio broadcasters would probably use their format as the genre Report Mont Year Each Report may contain only one month s data Do a separate report for each month you are reporting Time Zone This is the offset in hours from Greenwich Mean Time of lo
5. Ascending Title 7 p C Descending Then Sort By Q fait Ascending i C Descending Then Sort By Tt sC SS Ascending C Descending First Sort Use the first Sort dropdown box to select the data column to be used as the primary sort column for the song list Ascending or Descending The buttons to right of the Sort boxes allow you to sort in Ascending or Descending order Secondary Sort Any songs with matching entries in the primary Sort data column are then sorted by the column selected in the second Sort dropdown box Third Sort Any songs with matching entries in the primary and secondary Sort data columns are then sorted by the column selected in the third Sort dropdown box Page 8 6 Natural M usic User M anual Report Page SetUp To set the Report page settings you first need to display the Report Design screen by selecting the desired Report from the Reports menu on the main Natural Music screen i Report Designer ioj x La fal R View Print Memorize Help Close m Paper Orientation Printer Font t Portrait Font jc G Times C LandScape Size 8 28 SetFont m Margins Top Margin fs Bottom Margin fos Left Margin fos Right Margin jos Orientation If your printer permits you may select Portrait or Landscape paper orientation Landscape will rotate the apper 90 degrees and allow more width for printing data on each line Margins
6. NI Non Interactive v Format Code C Country X Country of Origin of Server jus Report Start Date joni 00 Report End Date 3 8700 Create Include NM5 Category s v AMAURI a Z Christmas Traditional Y Cruising Classic UnSelect All Q Disco Help 4 Group One Hot C Group One Low Select All B Group One Medium E Group Two Hot x GG Two L i roup Two Low x ae ASCAP Account Number This is the number assigned by ASCAP to identify your account with them Broadcaster Webcaster URL Name This is the company name under which you are licensed with ASCAP Channel Type This is IT for interactive when a choice selection listening or downloading activity is made by the listener for a specific song This is NI for non interactive when a choice selection listening or downloading activity is not specific to a particular song regular broadcasts and streaming where the listener does not select specific songs Country of Origin of Server Country where the audio server is located Report Start Date Enter in the logging period to be reported Natural M usic User M anual Page 8 13 RIAA Webcast Report RIAA performance licenses are generally required for Internet audio streaming RIAA requires very detailed reports of these online performances Natural Music 5 has the capability to create these reports in the RIAA required format for electronic filing with RIAA From the Main Menu select Reports
7. A 1 2 3 Len Barry 12 2 15 Fade 3 3 65 x 12 Days Of Chnstmas John Denver Muppetts 04 4 14 Cold 3 3 Ps x 12 Days Of Christmas Ray Conniff 4 19 Fade 1002 A 16 Candles Crests 2 49 Cold 1 2 58 1818 F 19th Nervous Breakdown Rolling Stones 05 3 49 Fade 315 66 25 Miles Edwin Starr 0l 3 14 Fade 314 3 P 25 Or To 4 Chicago 27 2 51 Cold 415 8 1279 G 409 Beach Boys 04 1 53 Fade 214 66 3108 634 5789 v Wilson Pickett 09 2 56 Fade 3 3 56 1003 A 96 Tears Question Mark 10 2 53 Fade 3 3 66 98 6 Keith 31 2 56 Fade 3 3 1 1621 E A Beautiful Moming Rascals 07 2 26 Fade 1 3 68 3011 G A Big Hunk o Love Elvis Presley 04 2 10 Fade 4 4 58 1259 F A Fool Such As I Elvis Presley 07 2 20 Fade 2 3 59 1817 F A Girl Like You Rascals 04 2 43 Fade 2 3 67 1422 B 4 Groovy Situation Gene Chandler 06 3 08 Fade 314 70 1556 E A Hard Days Night Beatles 02 2 23 Cold 3 4 64 X A Holly Jolly X mas Burl Ives 13 2 07 Fade 373 P A Horse With No Name America 07 3 59 Fade 3 3 72 1891 C 4 Hundred Pounds Of Clay Gene Mcdaniels 15 2 13 Fade 3 3 6l 1885 c A Little Bit Of Soap Jarmels 06 2 05 Fade 3 3 61 1857 F A Little Bit Of Soul Music Explosion 06 2 15 Fade 3 4 67 1004 A A Lover s Concerto Toys 15 2 30 Fade 213 65 1504 B 4A Lovers Question Clyde Mcphatter 2 27 Fade 3 3 58 3096 v A Million To One v Jimmy Charles 2 28 Cold 33 60 1416 B A Place In The Sun Stevie Wonder 09 2 44 Fade 3 3 66 X A Soalin Peter Paul And Mary 3 40 Fade 1967 G A Su
8. Main Menu select Reports Performance Reports SoundExchnage Small Webcaster Report You will then see the screen on the following page on which you should enter the information NM5 needs to create the SoundExchange file Notes on Electronically Filed SoundExchange Small Webcaster Reports B As of 2 1 03 The Librarian of Congress had not adopted final reporting standards for the small webcaster report The report created by NM5 is based on the format submitted by SoundExchange to the Librarian of Congress and is subject to change We therefore provide this report WITHOUT WARRANTY OF ANY KIND and you therefore use this report AT YOUR OWN RISK Furthermore this report is only usable by those entities who qualify as small webcasters for 2003 2004 under the agreement negotiated between SoundExchange and webcasters There are several unusual fields such as ISRC code and Track Label P Line that must be entered for each song in the SoundExchange report See Song Data Entry Album Data in Chapter 2 of this User Manual for a discussion of these fields SoundExchange is extremely picky about the reporting of artist names They must be match tha artist names in their SoundExchange database exactly Individual artists must be listed as firstname a space then lastname Be sure you properly enter the names of groups Example They won t accept BEATLES you must submit THE BEATLES and they won t accept THE EAGLES they must be listed as EAGLES b
9. file you can use to electronic file for reporting Internet Music Use NM5 can create a file in the appropriate format From the Main Menu select Reports Performance Reports ASCAP Webcasi Report You will then see the screen on the following page on which you should enter the information NM5 needs to create the ASCAP Internet Music Use Webcast Report file Notes on Electronically Filed ASCAP Reports B NM5 can only prepare the report for a period for which the song play histories are saved in the NM5 database Therefore you must set the Save Song History for Days in SetUp Station to enough days so you always have at least a calendar month or longer for quarterly Internet reporters of play history in the database on the day you generate this report The times listed in the ASCAP Music Use Report will be the Scheduled Time unless you perform the Log Reconciliation in the Music Log Editor to read the exact times from an automation Play Log or Air Log Page 8 12 Natural M usic User M anual ASCAP Webcast Report The ASCAP output file is created in accordance with the ASCAP Music Use Report Format for Internet Sites and Services specifications issued by ASCAP The required entries are described below When ready to export the file click Create w ASCAP Internet Music Use Report for Electronic Filing Station Settings ASCAP Account Number 0123454678 Broadcaster webcaster URL company Name Channel Type Code
10. Reports and Music Lists Natural Music has several standard Reports accessible from the Natural Music main screen under Reports All may be printed to paper or to a text file for electronic filing To print to a text file select Export on the Report Preview screen or Print to File on the Printer selection screen ij Sample Natural Music 5 Song Lists You can print standard lists sorted by Title Artist and Music Category Performance Rights You can create logs for performance rights agencies such as BMI APRA RIAA on paper or to a text file for electronic filing Play History is kept for 45 days but this may be changed in Station Setup Play History This is a summary or detail play history of a song for a period of time Play History is kept for 45 days but this period may be changed in the Station Setup Packet List If you use Packets this will list your Packet information Customizing Reports You may customize the formatting of your reports and lists as described on the next few pages of this manual If you want to save the custom design changes for future use you may Memorize the report settings and recall them under the Memorized Reports menu choice Natural M usic User M anual Page 8 1 Report Title and Headings To set the Title and SubTitle to be printed you first need to display the Report Design screen by selecting the desired Report from the Reports menu on the main Natural Music screen
11. Type cowmery O Use PkZip compression Report Start Date 9 1 00 through 9 8 00 j Create Include NM5 Category s REAUS UE SA a Z Christmas Traditional Y Cruising Classic Q Q Disco UnSelect All A Group One Hot Help C Group One Low B Group One Medium Select All E Group Two Hot x G Group Two Low x Cancel BMI Account Number This is the number assigned by BMI to identify your account Submitter Entity NamMe This is the company name under which you are licensed with BMI Submitter Type This is the type of entity which is reporting This may be STA for radio station INT for Internet reporters or OTH for other Call Sign or Website Name Radio station must always put their 4 letter call sign in this entry Do NOT put Am Fm after it Put AM or FM in the station type field Non radio entities should put thier website or company name in this field Report Start Date Enter in the logging period to be reported NOTE Each EMR report can only contain data for one calendar month If your reporting period falls in 2 or more calendar months create one report for each calendar month Use PkZip Compression You may also elect to compress Zip the file to reduce its size for transmission to BMI Include NM5 Categories Use this to omit any non music categories such as liners and jingles from the report Natural M usic User M anual Page 8 11 ASCAP Webcast Report ASCAP has issued a standard for creating a
12. cal times listed in the report Use PkZip Compression You may also elect to compress Zip the file to reduce its size for transmission to RIAA Include NM5 Categories You may select the NM5 caetgories to be included This allows you to exclude any categories you use for liners jingles or other non music program elements Natural M usic User M anual Page 8 15 RIAA Webcast Report cont Creating a Combined RIAA Report for Multiple Streams If your company streams more than one station or channel this file needs to contain the reports for all channels streamed by a single licensee After you export the report for the first channel NM5 will warn you when you try to export additional channels reports to the same file To add the new channel s report to the existing report file click YES Q C Temp Sample_Play_List102000 already exists Would you like to ADD THIS REPORT DATA to the existing file If you click YES this report will be ADDED TO the existing file If you click No the existing file will be REPLACED by this report Page 8 16 Natural M usic User M anual SoundExchange Small Webcaster Report SoundExchange performance licenses are generally required for Internet audio streaming SoundExchange requires very detailed reports of these online performances Natural Music 5 has the capability to create these reports in the SoundExchange required format for electronic filing with SoundExchange From the
13. ecause that is how they are named in the SoundExchange database Good luck This electronic file must cover the time period required by SounfdExchange and NM5 can only prepare the report for a period for which the song play histories are saved in the NM5 database Therefore you must set the Save Song History for Days in SetUp Station to enough days so you always have at least a calendar month of play history in the database on the day you generate this report The times listed in the SoundExchange report will be the Scheduled Time unless you perform the Log Reconciliation in the Music Log Editor to read the exact times from an automation Play Log or Air Log Please do NOT change the name of the SoundExchange report output file The file name is assigned by NM5 according to standards set by SoundExchange Per SoundExchange requirements the file is zipped compressed Natural M usic User M anual Page 8 17 SoundExchange Small Webcaster Report cont ij SoundExchange Small Webcaster Report Ol x Report Settings Report Dates from 5 1 02 through 5 5 02 Aggregate tuning Hours for this Channel during this period Channel Name Service Name Licensee Contact Name Street Address City State Zip Phone e Mail Include NM5 Category s v eneee Create Z Christmas Traditional Q Disco UnSelect All gt ae Select All gt Cancel A Group One Hot C Group One Low B Group One M
14. edium Aggregate Tuning Hours This is the aggregate tuning hours on a monthly basis for the channel as computed by a recognized ratings service or as computed by the eligible small webcaster from its server logs E Group Two Hot G Group Two Low Channel Name This is the unique channel or program identifier that differentiates this channel or program s play list from all other channels or programs you operate Service Name This is the name under which your SoundExchange performance license is granted Contact Name Person who may be contacted by SoundExchange regarding this report Include NM5 Categories You may select the NM5 caetgories to be included This allows you to exclude any categories you use for liners jingles or other non music program elements Page 8 18 Natural M usic User M anual SoundExchange Small Webcaster Report cont Creating a Combined SoundExchange Report for Multiple Channels or Streams If your company streams more than one station or channel this file needs to contain the reports for all channels streamed by a single licensee After you export the report for the first channel NM5 will warn you when you try to export additional channels reports to the same file To add the new channel s report to the existing report file click YES C Temp Sample_Play_List102000 already exists Would you like to ADD THIS REPORT DATA to the existing file If you clic
15. eriod for which the song play histories are saved in the NM5 database Therefore you must set the Save Song History for Days in SetUp Station to enough days so you always have at least a calendar month or longer for quarterly Internet reporters of play history in the database on the day you generate this report The times listed in the BMI EMR report will be the Scheduled Time unless you perform the Log Reconciliation in the Music Log Editor to read the exact times from an automation Play Log or Air Log The BMI output file is created and named in accordance with the specifications issued by BMI for electronic reporting It is recommended that you NOT change this filename as it identifies your company to BMI for licensing purposes The entries are described below When ready to export the file click Create Please do NOT change the name of the BMI report output file The file name is assigned by NM5 according to standards set by BMI Page 8 10 Natural M usic User M anual BMI Electronic Music Report EMR Provide the requested information and click Create Please don t change the name of the BMI report output file The file name is assigned by NM5 according to standards set by BMI w BMI Music Use Report for Electronic Filing EMR Station Settings BMI Account Number 012345678 Submitter Entity Name company Name Submitter Type STA Radio Station f Cal Sign without AM FM oox Station Type amt v Format
16. f you do not include some categories the report of total plays and the computed will not include items logged from those excluded categories Special Considerations 1 This report is only accurate for the time period during which the play history is maintained by NM5 as set by the user on the NM5 station setup screen 2 This report can not be memorized because its format is significantly different from other NM5 reports However this report has few settings and they are easily selected when the report is run 3 When you select a report property such as AlsoProtect or Artist which can have 2 values assigned to a single song each play of the song counts twice Example A song with 2 artists would count as 2 song plays if you select Artist as the property to be reported If you select any other property the song will be counted only once Page 8 20 N atural M usic U ser M anual
17. k YES this report will be ADDED TO the existing file If you click No the existing file will be REPLACED by this report Natural M usic User M anual Page 8 19 Logged Song Statistics If you need a breakdown of the songs scheduled over a period of time select Reports Play History Logged Song Siatistics This is a simple report that shows the percentage of songs logged in any time period that have a particular attribute or property mm Log Statistics for a Song Property i Get hepart Song Property to Report 3650 Total Plays in the Period Country H Count Plays Z Total Undefined 1942 53 212 E Sort By Country x 24 19 22 60 Date is Time is Required Optional Start 9 1 00 End 9 8 00 af M Include Category s Y Christmas Pop a v Z Christmas Traditional v Y Cruising Classic vO Disco v Group One Hot v C Group One Low v Ca Y B Group One Medium E Group Two Hot G Group Two Low All None Uses for this report While this report can be based on any song property it is most often used by broadcasters who are required to report the of music content from their home country This can be done by selecting the Country property to report Selected Categories You may select which categories to include most often all This option is offered for those stations that use some categories for jingles Liners ID s etc and do not want to include them in the report I
18. mmer Place Percy Faith 2 16 Fade 2 2 60 1677 F A Summer So Chad And Jerenv 0 2 34 Cold 3 3 E Ka i of You may adjust the column widths by S Ree the column dividers left and right fa ae Check Print to File on the screen shown below if you want to create a text output file rather than rint r Printer Properties Name Status Default printer Ready Type HF LaserJet 4 Plus Where LPT1 Comment J Print to file r Print range Copies All Number of copies fC Pages from E to fi C Selection pi Natural M usic U ser M anual Page 8 9 BMI Electronic Music Report EMR BMI has issued a standard for creating a file you can use to electronic file your music use reports for radio and Internet usage NM5 can create a file in the appropriate format From the Main Menu select Reports Performance Reports BMI Electronic Music Report e filing button on the report design screen You will then see the screen on the following page on which you should enter the information NM5 needs to create the BMI EMR file Notes on Electronically Filed BMI Reports This electronic BMI report file can only contain music information for a single calendar month If your reporting period spans 2 or more months such as if you are a quarterly Internet reporter you need to generate a single EMR file for each month and transmit them as separate files to BMI NM5 can only prepare the report for a p
19. st Setting Column Widths Click View Print on the Report Design screen to preview any report When you preview a report you may drag the column separators these are the vertical lines between the columns headings left or right to adjust the column widths for the printed Report page Natural M usic User M anual Page 8 3 Report Filtering To set the Report Filtering you first need to display the Report Design screen by selecting the desired Report from the Reports menu on the main Natural Music screen You may set up to 4 Filter Restrictions for each Report Each Restriction may be AND both are true or OR either is true with the previous Restriction w Report Designer iof xi Filter Field Comparison Filter Yalue Artist 7 Beatles Clear Filter Filter Field Use this dropdown box to select the song data field Song Property to be filtered Comparison Use this dropdown box to select the comparison to be performed to determine if the song should be included in the Report See description of these comparison types on the next page Filter Value This text box is where you enter the value for the filtering AND or OR Only if you want to add another filter restriction click the AND or OR selection on the next line and repeat the above entries for the second filter line Page 8 4 Natural M usic U ser M anual Report Filtering Comparison Types Report Filtering comparisons are described below q Mos
20. t of the comparison operators are common arithmetic operators like for equal gt for greater than and lt for less than lt gt means not equal to q IN means that the filtered field must be INCLUDED in the list you print in the Filter Value box for the song to be included in the list Example You set up a filter of Category IN A B C This would list all songs with category A B or C Be sure to include commas between the values in the Filter Value box if you use the IN comparison q NOT IN means the songs would be included only if their filter field is NOT IN the Filter Value box See Above q LIKE means the filtered field must be like the Filter Value Example If you select Artist LIKE Beat you will get a list including all songs with Artists starting with Beat followed by any other characters Be sure to put the at the end of the Filter Value q BETWEEN means the data field must be like the between 2 values in the Filter value box Be sure to put AND between the values in the Filter Value Box Example If you select Category BETWEEN A AND C you will get a list including all songs with Category between A and C Natural M usic User M anual Page 8 5 Report Sorting To set the Report Sorting you first need to display the Report Design screen by selecting the desired Report from the Reports menu on the main Natural Music screen i Report Designer ioj x Lad fal R View Print Memorize Help Close Sort First By
Download Pdf Manuals
Related Search