Referrer
Provides referrer information for visits and activities, identifying traffic sources.
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 ActivityDetails.Referrer;
Columns
| Name | Type | References | SupportedOperators | Description |
| referrerID [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the referrer record within Eloqua. | |
| lastModifiedDate | Datetime | Timestamp of the most recent update made to the referrer record. | ||
| referrerDomain | String | =,<>,>,<,>=,<=,IN,NOT IN | Domain of the referring website or source that directed traffic. | |
| referrerURL | String | =,<>,>,<,>=,<=,IN,NOT IN | Full URL of the referring page that led the visitor to Eloqua-tracked content. | |
| sourceName | String | =,<>,>,<,>=,<=,IN,NOT IN | Name of the traffic source, such as a search engine, partner site, or campaign label. | |
| sourceType | String | =,<>,>,<,>=,<=,IN,NOT IN | Type of source that referred the visitor, such as Organic Search, Paid Search, Email, or Direct. |