FormActivities
Captures metrics for form interactions, including views and submissions.
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 CampaignAnalysis.FormActivities;
Columns
| Name | Type | References | SupportedOperators | Description |
| formSubmitAggKey [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the aggregated form activity record. | |
| dateHour | Datetime | Date and time, rounded to the hour, when the form activity was recorded. | ||
| eloquaCampaignID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the form activity metrics to the related Eloqua campaign. | |
| lastModifiedDate | Datetime | Timestamp of the most recent update to the aggregated form activity record. | ||
| segmentId | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the segment associated with the form activity metrics. | |
| totalFormSubmissions | Int | =,<>,>,<,>=,<=,IN,NOT IN | Total number of form submissions recorded during the specified time period. | |
| calendar_dateHour | Datetime |
Calendar.dateHour | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the form activity record to the corresponding calendar date and hour. |
| campaign_eloquaCampaignId | Int |
Campaign.eloquaCampaignId | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the form activity record to the related campaign record. |
| segment_segmentId | Int |
Segment.segmentId | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the form activity record to the related segment record. |