This article will guide you through using the Database Query tool to generate detailed reports about your listeners. These reports can help you better understand your audience—such as their birthdays, age ranges, gender, household size, and more.
For example, you can use this feature to find the median age of your listeners or to identify specific demographic segments for targeted campaigns.
Accessing the Database Query Tool
-
Navigate to:
Front Desk→Database Query -
Under Criteria, select a station.
-
You can select multiple stations at once.
-
Adding Conditions to Your Report
-
Click Add Condition to specify the information you’d like to include in the report (e.g., Age).
-
Once you select your first option, a second dropdown menu will appear, allowing you to choose a condition such as:
-
Between
-
Greater Than
-
Less Than
-
Is
-
-
Selecting one of these options may prompt a third dropdown to refine your criteria further (e.g., choosing a specific birthday range).
-
Continue adding conditions until you’re satisfied with your criteria.
-
If you only want a single category, select it and click Submit.
-
Viewing and Adjusting Results
-
Your results will appear below the search area.
-
If no results appear, adjust your criteria and resubmit.
Modifying the Report Layout
-
Click Modify Layout.
-
The right column shows the fields currently included in your report.
-
Click the red “X” next to any field to remove it.
-
-
The left column lists all available fields you can add.
-
Drag and drop any field from the left to the right column to include it in your report.
-
-
Click Apply to update your report.
Saving and Exporting Your Report
-
Once your report is set, click Save.
-
Enter a Query Name so you can reuse it later.
-
To download the report, use the Export (e.g excel, print, pdf, etc) options in the toolbar.
Tip: Saving commonly used queries can save you time when running frequent audience reports.