FormSubmissionActivities
Tracks detailed activities for each form submission, including captured data fields.
Select
The driver uses the Oracle Eloqua Reporting API to access entities. To query a view, a fully qualified query consisting of both the schema name and table name is required to avoid any ambiguity.
For example, the following query specifies the schema name followed by the table name to access this view:
SELECT * FROM FormSubmission.FormSubmissionActivities;
Columns
| Name | Type | References | SupportedOperators | Description |
| eloquaCampaignID [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the form submission activity metrics to the related Eloqua campaign. | |
| emailID [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the email asset that directed the contact to the form, if applicable. | |
| formID [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier of the form asset associated with the submission activity. | |
| formSubmissionDateHour [KEY] | Datetime |
Calendar.dateHour | =,<>,>,<,>=,<=,IN,NOT IN | Date and time, rounded to the hour, when the form submission activity was recorded. |
| landingPageID [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the landing page hosting the submitted form. | |
| webPageID [KEY] | Int |
WebPage.webPageID | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the web page where the form submission occurred. |
| fieldsCompletionRate | Double | Percentage of form fields completed by users compared to the total available fields. | ||
| fieldsIncompleteRate | Double | Percentage of form fields left incomplete by users during submissions. | ||
| formCompletedFields | Int | Total number of fields completed in the submitted forms during the activity period. | ||
| numberofFields | Int | Total number of fields defined on the form. | ||
| totalFormsSubmissions | Int | =,<>,>,<,>=,<=,IN,NOT IN | Total number of form submissions recorded during the activity period. | |
| calendar_dateHour | Datetime |
Calendar.dateHour | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the form submission activity record to the corresponding calendar date and hour. |
| campaign_eloquaCampaignId | Int |
Campaign.eloquaCampaignId | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the submission activity record to the related campaign record. |
| emailAsset_emailID | Int |
EmailAsset.emailID | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the submission activity record to the related email asset record. |
| landingPageAsset_landingPageID | Int |
LandingPageAsset.landingPageID | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the submission activity record to the related landing page asset record. |
| webPage_webPageID | Int |
WebPage.webPageID | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the submission activity record to the related web page record. |