Segment
Lists segments leveraged in campaign execution for audience targeting.
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.Segment;
Columns
| Name | Type | References | SupportedOperators | Description |
| segmentId [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the segment record within Eloqua. | |
| lastModifiedDate | Datetime | Timestamp of the most recent update made to the segment record. | ||
| segment | String | =,<>,>,<,>=,<=,IN,NOT IN | Name of the segment, typically representing a defined audience group or filter. | |
| segmentCreatedByUserId | Int |
User.userID | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the user who originally created the segment in Eloqua. |
| segmentDescription | String | Text description explaining the purpose, criteria, or targeting logic of the segment. | ||
| user_userID | Int |
User.userID | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the segment record to the user account responsible for managing it. |