Adobe Connect Support Blog

May 3, 2013 /General /Reporting /

Downloadable Reports

How to generate Downloadable Reports

  1. Log in to Adobe Connect Central.
  2. Click the Administration tab.
  3. With Account selected, choose Reports.
  4. Click View Downloadable Reports.
  5. Click Report Filters and choose how to filter the data that the report returns.
  6. Click one of the Download Report Data buttons.

You can download five different kinds of reports as CSV files that you can export to external systems.

Note: Each downloaded report that you save is named “data.csv” by default. When you save the file, give it a unique identifying name; for example, “interactionsMarch05.csv.”

Interactions downloadable report data

This report summarizes user access. A unique transaction ID is generated each time a user attends a meeting, attends a seminar, views content, takes a course, or accesses a curriculum. The Interactions report presents the following data:

Column name

Description

transaction-id Unique ID for this transaction.
sco-id Unique ID used by Learning Management System (LMS) to identify different Shareable Content Objects (SCO).
type Type of object accessed, such as content, meeting, or event.
name Object name as it appears in the content listing.
url Object that the user accessed.
principal-id Unique ID for the user.
login Name of user who accessed this transaction.
user-name Unique user name.
score The score of the user.
status Status of transaction: passed, failed, complete, or in‑progress.
date-created Date this transaction occurred.
date-closed Date this transaction ended.

The Interaction report excludes certification numbers and max scores.

Users downloadable report data

This downloadable report lists users and associated profile attributes using data listed in the following table:

Column name

Description

principal-id Unique ID for the user.
login Unique user identifier.
name Unique user name.
email E‑mail address of the user.
manager The login of the manager of the user (manager is always set to NULL).
type User or guest (type is always set to user).

Data is generated in this view whenever a user creates, updates, or deletes a user.

If you select the Include Custom Fields option, custom information from user profiles is added to the report. When customizing user profiles, there are three mandatory fields (first name, last name, and e‑mail) and you can include up to eight additional custom fields. To customize user profiles, choose Administration > Users and Groups > Customize User Profile. Move the eight additional fields you want to include to the top of the list.

The Users report excludes the following information:

  • Password, which is not stored in plain text.
  • Time zone and language, which are not available in human readable form; for example, PST is 323.

Note: Deleted users do not appear in the Users report. Deleted users continue to exist in the Interactions report.

Assets downloadable report data

Data is generated in an Assets report whenever a user creates a meeting, event, seminar, curriculum, or course, or uploads content. The report lists the following data on system objects (such as meetings, content, courses, and so on):

Column name

Description

sco-id Unique ID used by Learning Management System (LMS) to identify different Shareable Content Objects (SCO).
url Unique identifier for the object.
type Either a presentation, course, FLV file, SWF file, image, archive, meeting, curriculum, folder, or event.
name Object name as it appears in the content listing.
date-created Date on which the object is scheduled to begin.
date-end Date on which the object is scheduled to end.
date-modified Date this object was modified.
description Object summary information entered when a new meeting, content, course, or other object type is created.

Questions downloadable report data

The Questions report lists responses to questions and quizzes from all the Adobe Connect applications. Data is generated in this report whenever a user answers a quiz question in a course or curriculum, answers a registration question, responds to a poll in a meeting or seminar, or adds a custom form to a meeting, seminar, course, or curriculum. The report provides the following information:

Column name

Description

transaction-id Unique ID for this transaction.
question Text of the question.
response Response to the question.
score Number of points awarded for the response.
principal-id Unique ID for the user.
date-created Date the record was created.

If a question has multiple answers, each answer is presented in its own row.

The Question report excludes the following information:

  • Correct or Incorrect, which can be determined by checking for a nonzero score
  • Date answered, which does not exist in the version 410 schema

Slide Views downloadable report data

The Slide Views report describes the slides or pages viewed by Adobe Connect users. Report data is generated whenever a user views content, a course, or a curriculum. The report provides the following data:

Column name

Description

transaction-id Unique ID for this transaction.
page Number of the slide or page that was viewed.
date-created Date of the viewing.
principal-id Unique ID for the user.

 

General, Reporting

Join the discussion