Weekly Spins Report posted on June 3rd, 2013
By Paul Ziino
Do you need to see what your top 40 songs were last week?Â There is a quick way to do this using the History Browser in MusicMaster.Â Either go to Dataset/Analysis/History Browser, or click the History Browser icon in the Toolbar.
The first tab on your History Browser Options box is â€śTime Periodâ€ť.Â Here you select the first and last hour you wish to include in the report.Â You can also use the default setting of Last Complete Week which uses the Broadcast Week settings in Tools/Options to determine what is considered a week in your database and produces a report based on it.Â If you wish to exclude hours from the week, use the space bar to clear the green dot from those hours in the â€śIncluded Hoursâ€ť grid.
Next youâ€™ll go to the â€śCategoriesâ€ť tab.Â Here youâ€™ll check only the categories you wish to include in your spins report.Â Remember, if youâ€™ve moved songs to new categories since scheduling the week in question, youâ€™ll want to check the categories of where those songs currently reside in order to include them in your report.
Generally for your weekly spins report you will not need to enter anything on the â€śFiltersâ€ť tab.Â But if you wanted to only include songs by a certain artist you could filter for that artist, or you could exclude a specific artist or attribute, etc.
Next is the â€śDisplayâ€ť tab.Â Change the Display Mode to â€śIndividual Songsâ€ť.Â Depending on what youâ€™d like to see in your report, you can toggle the Song ID, Category, RunTime, Turnovers, Total Time, and Rank between inclusion and exclusion.Â If you just want the top 40 songs, set that as your Maximum Rank.
Now you may click OK and your report will be generated.
You can now print this report via that icon.Â Or if youâ€™d prefer to copy it, click that icon, then paste the contents of the report to Excel, Word, an email, or wherever you like.
You can click the â€śFavoritesâ€ť icon to save the report layout as a favorite.Â Next time you need to run your report, select the Favorite design and click OK.Â Then adjust your dates and youâ€™re all set!
You can also run a Generic Spins Report via Dataset/Analysis/Special History Reports.Â You can learn about how to run Special History Reports here.
Using the History Browser in MusicMaster you can run history reports based on many fields in the database.Â Just remember to adjust the Display Mode on your Display tab to see all the options available.Â As always, if you have any questions, make sure to reach out to your Music Scheduling Consultant for assistance.