Reports – Audience Builder (OnQ) Reporting
Overview
We offer several ways for you to further segment the customers within your query to enable more targeted marketing and reporting. Click on Report and here are your options:
Audience Report – This report allows you to analyze your magazine subscription date using the basic circulation reports required by auditors such as BPA and ABC.
Audience Overlap Report – This report allows you to select up to 5 queries and display the results as a VENN diagram so that you can see where the queries overlap.
Cross Hatch – This report explores and compares two pieces of information about the customers.
Demo Report – This report helps you understand the breakdown of the demographics of your queried customers. Your demographic report can contain single response, multi-response and yes/no type demographics.
Field Count – This report allows you to create a report that breaks out information about your queried customers.
Geo Heat Map -This report allows you to visualize where your customers are located on a map.
Profile Report
Audience Report
This report allows you to analyze your magazine subscription date using the basic circulation reports required by auditors such as BPA and ABC. Audience reports are only available for brands that have audited magazine products. To create this report:
Ensure you have a query created already.
Click Report > Audience Report and the Audience Report window will appear.
Choose the following information:
Audience Report – choose any of your audited magazines
Report All Subscribers as Active Qualified – Selecting “yes” allows you to view your circulation numbers if all customers in your query were active qualified.
Data Source – Choose Live data or modeling data for an issue that is being prepared
Audit Date – allows you to look at your circulation as of your next audit, today or on any date of your choosing.
Click Get Report and your report will be prepared.
You can page export the report in a variety of formats, by selecting your desired format and then clicking on the export link.
Audience Overlap Report
Within Audience Builder, you now have an option to run an Audience Overlap Report. This can be found in the Audience Builder menu bar under “Report”. This report allows you to select up to 5 saved queries to see how the audiences within those queries overlap, resulting in a Venn diagram. Venn diagrams enable you to organize your audiences visually so you are able to see the relationships between two or more sets of data.
For instructions on pulling this report, check out Audience Overlap Report
Cross Hatch Report
With this report, you can explore two pieces of information about the queried customers. For example, to determine which business types in the medical industry have the highest Sales or customers from which states had the highest attendance at your conference. To create this report:
Ensure you have a query created already.
Click Report > Cross Hatch Summary and the Cross Hatch report window will appear.
Select the field you want for the Row and for the Column
Click Get Report to view the report
Within the report, you may click on any count and get a list of customers who match those criteria. The file contains the customer id, email address, first and last name, title, company name, street, city, state/province, zip/postal code and country.
To switch the row and column value, click the Switch button.
To export the report to a comma delimited file which can be opened in excel, click the Export button.
Product Membership Cross Hatch Report
When viewing a Product Membership cross hatch report in Audience Builder, you have the ability to toggle between active and all. The criteria of ‘active’ and ‘all’ can be found here.
Demo Report
This report helps you understand the breakdown of the demographics of your queried customers. Your demographic report can contain single response, multi-response and yes/no type demographics. Please contact your Account Representative for assistance in configuring the demographics that you want included in your report. To create this report:
Ensure you have a query created already.
Click Report > Demo Report and the report window will appear.
Click the “Export Demo Report Email” button to receive a copy of this report via email.
Field Count Report
This report allows you to view and export counts for one of your database fields based on the customers selected in a query. For example, how many people live in each US state or how many people work for the various divisions of IBM. To create this report:
Ensure you have a query created already.
Click Report > Field Count and the report window will appear.
Select the field in which you are interested in receiving counts.
Choose the number of characters you want the report based on. For example, the first 5 characters of the company name. If you select a single or multi-response demographic field, you do not need to enter the number of characters for the report to generate.
Click Get Report to view the report.
To export the report to a csv file which can be opened in excel, click the Export button.
Geo Heat Map
You can visualize where your customers are located on a map using the Geo Heat Map. To create this report:
Ensure you have a query created already.
Click Report > Geo Heat Map and the report window will appear.
Select any of the display formats(Countries, US States, Canadian Provinces, SCF) and click Get Report.
The contact rule chosen in OnQ determines the address of the customer displayed in the map. Customers Selected = Customers On Map + Not Applicable. If you select US States display, then a customer with a Canadian address will be counted as “Not Applicable”.
The display color ranges from blue (few customers) to purple (moderate number of customers) to red (many customers). The regional information and the exact customer count will be displayed as you hover over each region. If you select SCF display,a dot will be placed for each SCF that has at least one customer. The size and color of the dots reflects the number of customers in each SCF.
Table of Contents