Learn about the default data model
Oracle Audience Segmentation gives you a default data model with a pre-packaged set of data objects and attributes. Once your default data model is set up, you can make the necessary customizations to make sure the data model meets your organization's specific needs.
The default data model organizes data objects into object groups: Profile, Behavioral, Transactional, Product, and Other. You can move data objects to other object groups at any time, but a data object can belong to only one object group.
Review the data objects and data object groups below that are included with your data model.
Business-to-consumer data model (B2C)
The business-to-consumer data model comes with the following default data objects.
Profile data objects
The profile object group lists the group of data objects related to a customer.
- Customer: Characteristics that identify customers. Also includes communication preferences. Attributes in this data object include First Name, Birth Date, and Ok To Call.
- Address: Any address associated with a customer. Attributes in this data object include City, State, and Zip Code.
- Social identity: A customer's identity in social interactions. For example, Facebook name or Twitter handle. Attributes in this data object include Handle, Display Name, and Is Active.
- Customer_Associate: A cross-referenced object between the customer and associate objects. It links the interactions between a customer and a salesperson. Attributes in this data object include Customer ID, Associate ID, and Organization ID.
- Customer_Group: A cross-referenced object between the customer and group objects. It links the customer and any groupings associated with the customer. Attributes in this data object include CustomerI D and Group ID.
Behavioral data objects
The behavioral object group lists the group of data objects in the data model related to customer actions.
- Message: Content that a customer sees. For example, an email message or a text message. Attributes in this data object include Subject, Content, and Campaign ID.
- Launch: An instance of a campaign. It is used mostly for recurring campaigns to track statistics and behavior connected to the launch. Attributes in this data object include Execution Date, Created By, and Status.
- Promotion: A marketing promotion that can be tied to a purchase, campaign, or other similar entity. Helps track the effectiveness of a promotion across different touch points. Attributes in this data object include URL, Name, and Is Active.
- Campaign: A marketing campaign that can represent different marketing execution efforts. Attributes in this data object include Type, Start Date, and Medium.
- Event: A single action taken by a customer. For example, liking a review or viewing a video. Attributes in this data object include Cookie, Email, and Order ID.
- Social engagement: A social event focused on social outreach and interaction. Attributes in this data object include Handle, Title, and Hashtags.
- Incident: A support event focused on support interaction with customers. Attributes in this data object include Summary, Severity, and Channel.
Transactional data objects
The transactional object group lists the group of data objects in the data model related to customer transactions.
- Associate: The salesperson selling a product or service. Attributes in this data object include Name, Role, and Team.
- Order: The purchase of one or more products, services, or subscriptions. Can be used to track the order life-cycle and revenue. Attributes in this data object include Total, Qty, and Discount Total.
- Order item: The line item for an order that can track data such as the product, price, or tax. Attributes in this data object include List Price, Cost, and Tax.
Product data objects
The product object group lists the group of data objects in the data model related to product catalogs.
- Product: Represents a product. It tracks data such as the SKU, brand, or model. Attributes in this data object include SKU, Brand, and Size.
- Category: The category of a product. This object can store a hierarchy of four levels of product categories. For example, level one could be Electronics, level two could be TVs, and level three could be 4K TVs. Attributes in this data object include Name, Level 1 Name, and Level 2 Name.
- Subscription: Represents the recurring delivery of a product. It can be used to track when it is time for a customer to renew. Attributes in this data object include Name, Type, and Start Timestamp.
- Product_Category: A cross-referenced object between the product and category objects. It links the product purchased with the category of the product. Attributes in this data object include Type, Product ID, and Category ID.
Other data objects
The other object group lists data objects that don't belong to any of the other object groups.
- Organization: Represents the location a product was purchased or some interaction with a customer occurred. Attributes in this data object include Territory, Status, and Division.
- Group: A generic grouping mechanism that can be used to export segments from Oracle Audience Segmentation to other marketing platforms. Attributes in this data object include Name, Type, Source Group ID.
- Currency: Maintains currency conversion data. Attributes in this data object include Base Currency, Exchange Rate, and Exchange Date.
- GeoDemographics: Tracks demographics of geographic areas. Joining this entity with the Address object allows you to group people based on geographical demographics. Attributes in this data object include City, Country, and State.
- DataDeletionRequest: The data object used to process requests to delete customer data. Learn more about Deleting data.
Business-to-business data model (B2B)
The business-to-business data model comes with all the data objects in the default business-to-consumer data model as well as the Account data object and additional attributes in the Customer data object.
- Account: Characteristics that identify business accounts. Attributes in this data object include Account Source, Ownership Type, and Annual Revenue.
- Customer: This data object has the following additional attributes for the business to business data model: Business Phone, Fax, Job Title, Job Title Description, Job Title Level, Job Department, and Job Specialty.
Automotive data model
The Automotive data model comes with all the data objects in the default business-to-consumer data model as well as the following additional data objects.
- Vehicle: Stores details on vehicles purchased. Attributes in this data object include Model, Trim, and Next Service Date.
- MasterVehicle: This data object represents the master copy of vehicle records. After Oracle Audience Segmentation performs tasks for ID resolution (deduplication, merge, and promotion of vehicle records), the results are stored in MasterVehicle. Data cannot be imported into this data object.
- Vehicle Finance: Stores financial details on vehicle purchases. Attributes in this data object include ARR Percent, Financed Amount, and Account Maturity Date.
- Vehicle IOT KPI: Represents Internet of Things (IOT) and Key Performance Indicators (KPI). This data object captures all data points that are streamed from various sensors and components in the vehicle, such as the battery, air conditioning unit, and radiator. Attributes in this data object include Diagnostic Trouble Code, Severity, and Next Best Action.
- Vehicle Plate: Stores vehicle plate information. Attributes in this data object include Vehicle ID, Number, and Start Date.
- Vehicle Sale: Stores information on vehicle sales. Attributes in this data object include Sales Type, Odometer Reading, and Registration Date.
- Vehicle Optional: Represents additional features on vehicles. Attributes in this data object include Vehicle ID, Code, and Name.
- Vehicle Ownership: Stores ownership information for vehicles. Attributes in this data object include Start Date, Is Primary Owner, and Average Annual Mileage.
- Vehicle Service: Stores vehicle service information. Attributes in this data object include Description, Severity, and Resolved by.
- Vehicle Warranty: Stores vehicle warranty information. Attributes in this data object include End Date, Name, and Description.
- Vehicle Subscription: Stores vehicle subscription information. Attributes in this data object include Status, Asset ID, and Subscription Order ID.
Managing the Oracle Audience Segmentation data model