Exporting Campaign Data from the Campaign Module
View events are recorded as videos are watched using Campaign-enabled players. Lead data is captured as users enter data into Campaign lead forms. The Campaign module offers two types of lead forms:
- Campaign lead forms - These forms are built by selecting from a set of predefined fields in the Campaign module. These forms save lead data in Video Cloud. For information on creating Campaign lead forms, see Creating a Campaign Lead Form.
- Custom lead forms - These forms are built using your marketing automation platform. The form embed code is then used in the Campaign module to create a custom lead form. These forms send lead data to the marketing automation platform. For information on creating lead forms, see the document for your marketing platform:
When exporting lead data from the Campaign module, only data captured using Campaign lead forms will be exported. Lead data from custom lead forms will be stored in your marketing automation software.
To export data, follow these steps:
- Open the Campaign module.
- Click Export Campaign Data in the left navigation.
- Select a Data Connection to export data from. The Data Connection dropdown will list all the integrations that have been configured.
- Select the data to export.
- View Events - Recorded by Campaign-enabled players
- Leads - Captured using lead forms
- Use the date picker to select a Start Date and End Date.
- Select an Export Format.
- Comma-Separated Values (CSV)
- Excel (XLS)
- Click to download the lead data.
- Lead form and view event data will be downloaded in separate files. Leads data will contain the data that was entered on the lead form as well as the following fields:
- externalId - This is the External ID that shows up on the All Recent Activity page. In the case of Oracle Eloqua, it is the Eloqua guid. With Marketo, it is the Marketo guid
- playerId - Player ID of the player being used when form was displayed
- videoId - Video ID of the video being played when form was displayed
- pageURL - Page URL that displayed the lead form (Gallery experiences only)
- createdAt - Date and time the data was captured
- experience - Gallery experience that collected the data (Gallery experiences only)
View events data will contain the following fields:
- externalId - This is the External ID that shows up on the All Recent Activity page. In the case of Oracle Eloqua, it is the Eloqua guid. With Marketo, it is the Marketo guid
- videoId - Video ID of the video
- videoName - Name of the video
- watched - Percentage of video watched (to nearest percent)
- timeWatched - Total time watched
- playerId - Player ID of the player used to watch video
- pageUrl - URL of page containing player
- createdAt - Date and time the data was captured
- updatedAt - Date and time the event was last saved, which translates roughly to when the viewer stopped watching; if the video is only a minute long, createdAt and updatedAt will be very close
- isSynced - Specifies whether this view event has been automatically exported to the publisher’s marketing automation tool
- trackingId - Tracking ID passed as a URL parameter. For information on working with a tracking ID, see Creating Custom Integrations with the Campaign Module.
- UTM fields - utmSource, utmMedium, utmCampaign, utmTerm and utmContent. For information on working with UTM fields see Working with UTM Fields in the Campaign Module.
- metric1-3, event1-3 - Used when using custom metrics and events