CVENT | Event Registration Standard Dataset
Seth Bishop
Below are the metrics and dimensions ChannelMix considers standard for CVENT - Event Registration dataset. There is a one day lag on CVENT and data is pulled for seven days.
(v_cvent_event_registration)
| Field Name | Type | Description |
| Registration ID | Dimension | Registration Identifier |
| Registration ID | Dimension | Registration Identifier |
| Invitee ID | Dimension | Invitee Identifier |
| Contact ID | Dimension | Contact Identifier |
| Source ID | Dimension | Source Identifier |
| First Name | Dimension | The first name of the person registered for the event |
| Last Name | Dimension | The Last name of the person registered for the event |
| Company Name | Dimension | The company name for the person registered for the event |
| Title | Dimension | The job title for the person registered for the event |
| Email Address | Dimension | The email address of the person registered for the event |
| CC Email Address | Dimension | The email address of the person who will copied on the email |
| Event ID | Dimension | Event Identifier |
| Invitee Status | Dimension | The status of the invite for the event |
| Internal Note Registration | Dimension | An internal note related to the registration |
| Invited By | Dimension | Who invited the person |
| Registration Date |
Timestamp |
The date the person registered for an event |
| Cancelled Date | Timestamp | The date the person cancelled |
| Original Response Date | Timestamp | The date/time when the person originally responded |
| Last Modified Date - Registration | Timestamp | The date/time when the registration was last modified |
| Modified By | Dimension | The person who modified the registration |
| Response Method | Dimension | The method the person responded to the invitation |
| Confirmation Number | Dimension | Confirmation Identifier |
| Registration Type | Dimension | The type of registration for the event |
| Registration Type Code | Dimension | The code for the type of registration |
| Participant | Boolean | Whether or not the person is was a participant in the event |
| Reference ID | Dimension | How the attendee was referred to the event |
| Is Test Registrant | Boolean | Indicates if this is a test registration |
| Order Detail - First Name | Dimension | The first name of the person who is listed on the order |
| Order Detail - Product Name | Dimension | The name of a product that is listed on the order |
| Order Detail - Last Name | Dimension | The last name of the person who is listed on the order |
| Order Detail - Product Description | Dimension | The description of a product that is listed on the order |
| Order Detail - Start Time | Timestamp | The start time of the event/session |
| Order Detail - Product Type | Dimension | The type of product or event session on the order |
| Order Detail - Participant | Dimension | Whether or not the person is was a participant in the event session/product |
| Order Detail - Action Date | Timestamp | The date/time with the product was ordered |
| Order Detail - End Time | Timestamp | The end time of the event/session |
| Event Code | Dimension | Event Code |
| Event Title | Dimension | The Title of the Event |
| Event Description | Dimension | A description of the event |
| Event Status | Dimension | Status of the Event |
| Planning Status | Dimension | The planning status of the event |
| Total Invited Count | Number | The total number of people that are invented to the event |
| Registered Attendee Count | Number | The number of attendees who are registered for the event |
| Participant Count | Number | The number of participates of the event |
| Declinee Count | Number | The number of people who declined the event invitation |
| Cancelled Count | Number | The number of people who cancelled their registration |
| Event Start Date | Timestamp | The Start Date/Time of the Event |
| Event End Date | Timestamp | The End Date/Time of the Event |
| Event Launch Date | Timestamp | The Event Launch Date/Time |
| Timezone | Dimension | The TimeZone the event details is in |
| Internal Note Event | Dimension | An internal note |
| Capacity | Number | Capacity of the Venue |
| Event Attendance Format | Dimension | Indicates whether the event is in-person, virtual, or hybrid |
| Category | Dimension | The type of event |
| Currency | Dimension | Currency used |
| Location | Dimension | The name of the venue |
| City | Dimension | The city the event is held in |
| State | Dimension | The state the event is held in |
| State Code | Dimension | The state code in which the event is held in |
| Postal Code | Dimension | The zip code for the location of the event |
| Country | Dimension | The country the event is held in |
| Country Code | Dimension | The Country code in which the event is held in |
| Last Modified Date - Event | Timestamp | The most recent date the event details were modified |
| RSVP By Date | Timestamp | The RSVP Due Date |
| Archive Date | Timestamp | The date in which the event was archived |
| External Authentication | Boolean | Indicates authentication method |
| Insert Date | Timestamp | Internal use: when the row was inserted in the table |
| ChannelMix Profile | Whole Number | DimensionWhen needed, distinguishes between CVENT accounts - Contents defined by Alight. |