Search the Omeda Knowledge Base

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:

  • Circulation Summary – This report allows you to analyze your magazine subscription date using the basic circulation reports required by auditors such as BPA and ABC.
  • 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.

OnQ Report Menu.png

Circulation Summary

This report allows you to analyze your magazine subscription date using the basic circulation reports required by auditors such as BPA and ABC. Circulation summary reports are only available for brands that have audited magazine products. To create this report:

  1. Ensure you have a query created already.
  2. Click Report > Circulation Summary and the Circulation Summary Report window will appear. OnQ CirSum.png
  3. Choose the following information:
    1. Circulation Product – choose any of your audited magazines
    2. Report All Subscribers as Active Qualified – Selecting “yes” allows you to view your circulation numbers if all customers in your query were active qualified.
    3. Data Source – Choose Live data or modeling data for an issue that is being prepared
    4. Audit Date – allows you to look at your circulation as of your next audit, today or on any date of your choosing.
  4. 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.

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:

  1. Ensure you have a query created already.
  2. Click Report > Cross Hatch Summary and the Cross Hatch report window will appear. OnQ Cross Hatch.png
  3. Select the field you want for the Row and for the Column
  4. Click Get Report to view the report
  5. 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.
  6. To switch the row and column value, click the Switch button.
  7. To export the report to a comma delimited file which can be opened in excel, click the Export button.

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:

  1. Ensure you have a query created already.
  2. Click Report > Demo Report and the report window will appear.
  3. 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:

  1. Ensure you have a query created already.
  2. Click Report > Field Count and the report window will appear.OnQ Field Count.png
  3. Select the field in which you are interested in receiving counts.
  4. 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.
  5. Click Get Report to view the report.
  6. 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:

  1. Ensure you have a query created already.
  2. Click Report > Field Count and the report window will appear.
  3. Select any of the display formats(Countries, US States, Canadian Provinces, SCF) and click Get Report.

OnQ Geo Heat Map.png

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.
OnQ Geo Heat SCF.png

Last Updated On December 07, 2018
Knowledge Base Feedback