Generate Reports

This page talks about how to generated the reports in OQG.

How to configure that?

The actions to achieve this are very simple.

Chose Reporting From the Top Links

This will be the name of your quiz, as well as the page "Title Tag" that displays in the upper left-hand corner of your web browser when the quiz landing page loads.

Chose the Quiz And The Date Intervals

This will be the name of your quiz, as well as the page "Title Tag" that displays in the upper left-hand corner of your web browser when the quiz landing page loads.

Chose the Type of Report You Want to Generate

This will be the name of your quiz, as well as the page "Title Tag" that displays in the upper left-hand corner of your web browser when the quiz landing page loads.

Generate Report

When you use this function, it generates in the dashboard the report for the selected quiz and the selected interval.

Download Quiz Data

This downloads the detailed data in .xls file format for the quiz and date interval selected. The data in the xls files contains much more then just what you see in the picture above. It contains:

• The quiz taker name
• The quiz taker email
• Date when the quiz was taken
• Referring URL
• Time on quiz
• Any custom autoresponder data, you may have set up, such us phone number, address, etc
• And quiz answers

NOTE: The screenshots from the reporting below have been taken from a different quiz not the diet quiz from above:

Detail report example - 1

The picture below is a screenshot from MS Excel with the kind of data you will see in the detailed reporting. As you notice the report has three sheets. This is sheet one:

Detail report example -2

The picture below is a screenshot from MS Excel with the kind of data you will see in the detailed reporting. As you notice the report has three sheets. This is sheet two (part 1). I split this in two parts because the picture was too wide to display in one shot.

Detail report example - 3

The picture below is a screenshot from MS Excel with the kind of data you will see in the detailed reporting. As you notice the report has three sheets.

This is sheet two (part 2). I split this in two parts because the picture was too wide to display in one shot.

It is interesting to notice the autoresponder data. Those cells contains any default variables that you set into your autoresponder system to be gathered by the quiz. In this example I selected:

• Gender
• Country
• Phone number

It is up to you what you will use there. It is very advisable to gather as much as data as possible specially if you do market research.

Here is what you need to set to have this in the report.

1) You will add the fields to your autoresponder form, or the autoresponder provides you with the form where you have more then just name/email.

Possible parameters are:

• Gender
• Country
• City
• Phone number
• Address
• Specific drop-down options
• Occupation
• etc...

2) Then you would modify in the quiz folder the file: /app/config/config.php file and add the new fields

You need to ad both the field name and field label, see example:

$config['formdata']["field_name''] = "gender_2";
$config['formdata']["field_label''] = "Gender";

Note: the value for field name "gender_2" must be equal the HTML input name:

<input type="text" name="gender_2" value="" size="20">

3) OQG would take the data from the optin form and save it.

Detail report example - 4

The picture below is a screenshot from MS Excel with the kind of data you will see in the detailed reporting. As you notice the report has three sheets. This is sheet three.

Download Data From All Quizzes

This downloads detailed reporting data from all the quizzes in the dashboard.

Reset Stats

This resets the stats for the selected quiz. This does NOT remove the data from the database so when you download it you can still the previous answers.

Erase Quiz Data

This deletes the reporting data from the database, for the quiz selected.