OnTarget Sample

Summary Report

The Summary Report provides a summary of the subscriber records in the database. The report displays the total number of subscribers on the report; a breakdown by country and state; and the number of subscribers signed up for each of the interest categories.

This information is also provided in graph form, with pie charts representing the distribution of country and state and a bar chart to represent the interest subscriptions.

At the bottom of the report is displayed the total number of records returned and the SQL statement used to retrieved the records (for use in evaluating the selected report options).

Total Visitors: 54

By Country

Country          Count

USA              51
COLOMBIA         1
CANADA           1
CA               1

By State

Country          State            Count

USA              CA               9
USA              Tn               6
USA              FL               4
USA              TX               4
USA              MA               3
USA              OK               3
USA              AZ               2
USA              IA               2
USA              IL               2
USA              Mi               2
USA              MN               2
USA              NJ               2
USA              WY               2
CA               AB               1
CANADA           Ontario          1
COLOMBIA         medellin         1
USA                               1
USA              CO               1
USA              LA               1
USA              MO               1
USA              New York         1
USA              NY               1
USA              South Carolina   1
USA              WA               1

Interests

Previous visitor 11

Send more information 15

Filters: WHERE visitor_id IN (SELECT visitor_id FROM vsignups WHERE group_id IN (1))

Database and reports provided by
NetEffect