Introduction
The article explains how to extract historic profile, registration, and event data from your Certain account using custom reports.
A webinar recording covers this subject.
Certain’s updated Data Retention Policy explains that from September 15, 2019, Certain will retain attendee profile and registration data for a full three years past the date of the last change.
The goal is to help you create the best experience for attendees by providing you with the highest performance from the Event Automation platform.
Parts of this policy involve Certain automatically removing old profiles, registrations, and event data.
Reports
The Reports section explains how to use custom reports to extract data.
The process is very similar for Profiles, Registrations, and Events, which are explained separately below.
In each case, you only need to add the report once. You can then use it regularly in the future, changing just the date filter.
When planning a large data extraction, over 10,000 records, coordinate with Certain Support. Please see Large Data Sets.
There is also an option to use Certain Application APIs to build an integration. See the API 2.0 documentation: https://developer.certain.com/api2docs/
Profile Data
Profile Data shows how to create a report to extract profile data.
Go to PROFILES > Reports.
Click Create Report.
Give the report a name. For example, “Profile – Data Extraction.”
Choose the report’s visibility. Recommended: “All Accounts.”
That setting means you can run it in sub-accounts without having to create new reports.
Choose a report type. Profiles is one option.
Profile and Registrations (that is, profiles with their registration history across events) is another option.
Save.
Next, customize the report’s columns and filters to extract the data you want to retain outside Certain.
Filters: Click Filters in the Left Navigation Panel.
You want to include only the profiles that haven’t been updated in the last three years.
For Interval #1, select Date Modified.
Select Custom (see below) as the filter.
This exposes date fields for you to complete.
For the Start Date, select the date your organization started using Certain.
If you don’t know when that was, select any early date that would definitely be before that.
Select an End Date of three years ago.
Save and Run the report.
It lists the people whose profile data hasn’t been updated in the last three years.
Columns: Click Columns in the Left Navigation Panel.
A report works best using 15 to 20 fields as your columns.
Select the fields for the information that you want to extract and add them to the fields to display.
Save and Run the report.
Ensure that it includes the records you want and the information you want.
If it doesn’t, customize the Filters and Columns accordingly.
Export: When you’re ready, click Export at the top of the page.
Select a file type, such as “Excel Spreadsheet.”
The system generates the report.
You now have that file on your computer.
Move or copy it to the appropriate location, probably on your organization’s network.
Registration Data
To run a report about registrations in all the events in your account, go to Account > Consolidation.
Most of the steps are the same as for Profile reports, so they are summarized here.
Add a report, and name it.
Set its visibility to All Accounts, so that you won’t have to recreate it for sub-accounts.
Select the data to report on, such as “Registrations across events.”
Use 15–20 columns and Save.
(Again, select the data you want to extract to keep outside Certain.)
Filter on the Reg Date Modified, using the same custom date range as before, and Save.
Run the report, which will list registrations that have not been updated in that date range.
Export the results.
Event Data
To run a report about all the events in your account, remain in Account > Consolidation.
Add a report, and name it.
Set its visibility to All Accounts, as recommended for the reports above.
Select the report type “Events” and Save.
Filter on the event end date, (End under “Standard Event Fields”), using a custom date range ending with a date three years ago, and Save.
Use 15–20 columns and Save.
Run the report, which will list all events that ended in that date range.
Export the results.
Large Data Sets
If your data set is large — over 10,000 records — please get in touch with Certain Support to ensure reliable system performance while running huge reports, or if you’d like some help extracting your information.
[JSON-LD content omitted in Markdown format as requested; see separate JSON-LD block below.]