Preloaded Data Assets

When provisioning new accounts in Oracle Cloud Portal, system administrators can choose to have a predefined set of assets (a profile list, PETs, supplemental tables, filters, and audiences) automatically included in the account. With these preloaded assets in place, marketers have the advantage of starting without an empty account. They can start using Oracle Responsys immediately, without having to create a profile list, PETs, supplemental tables, filters, or audiences from scratch.

Each set of assets is based on an industry vertical. Under Select industry vertical for account in Cloud Portal - My Services, administrators can choose from the following industry data models:

Note: Selecting a vertical data model is not mandatory.

Once the administrator has configured the account, marketers can find these preloaded assets in a folder whose name highlights the specific industry model. For each model, there is a profile list, a set of profile extension and supplemental tables, sample filters and an audience. The following section lists these for each data model:

Travel (airline)

This data model describes an air traveler’s profile, preferences, loyalty membership, recent trip information, and data for flight routes and airports.

Folder name: airline

Profile list name: Resp_Airline_Customers

Profile extension table names:

  • Resp_Airline_Cust_Loyalty
  • Resp_Airline_Cust_Preferences
  • Resp_Airline_Cust_Recency_Agg
  • CrowdTwist_Loyalty_Profile

Supplemental table names:

  • Resp_Airline_Airport
  • Resp_Airline_Flight
  • Resp_Airline_Route
  • Resp_Airline_Trip
  • CrowdTwist_Loyalty_User_Activity
  • CrowdTwist_Loyalty_User_Redemption

Sample filter names:

  • Resp_Airline_Email_Active_Customer
  • Resp_Airline_Profile_Gold_Member
  • Resp_Airline_Profile_High_Value_Traveller
  • Resp_Airline_SMS_Active_Customer

Sample audience name: Resp_Airline_Audience

Banking

This data model describes a retail banking customer’s profile, preferences, recent transactions, and data for bank accounts and branches.

Folder name: banking

Profile list name: Resp_Banking_Customers

Profile extension table names:

  • Resp_Banking_Cust_Financial_Highlights
  • Resp_Banking_Cust_Financial_Profile
  • Resp_Banking_Cust_Loyalty
  • Resp_Banking_Cust_Summary_Recency
  • CrowdTwist_Loyalty_Profile

Supplemental table names:

  • Resp_Banking_Account
  • Resp_Banking_Branch
  • Resp_Banking_Cust_Accounts
  • CrowdTwist_Loyalty_User_Activity
  • CrowdTwist_Loyalty_User_Redemption

Sample filter names:

  • Resp_Banking_Emai_Active_Customer
  • Resp_Banking_Profile_Branch_Visitor
  • Resp_Banking_Profile_Conservative_Home_Owner
  • Resp_Banking_SMS_Active_Customer

Sample audience name: Resp_Banking_Audience

Hospitality (hotel)

This data model describes a hotel customer’s profile, preferences, loyalty membership, recent stays, transactions, and data for hotel properties.

Folder name: hospitality

Profile list name: Resp_Hotel_Customers

Profile extension table names:

  • Resp_Hotel_Cust_Abandoned
  • Resp_Hotel_Cust_Loyalty
  • Resp_Hotel_Cust_Value_Revenue_Recency
  • CrowdTwist_Loyalty_Profile

Supplemental table names:

  • Resp_Hotel_Booking
  • Resp_Hotel_Property
  • Resp_Hotel_Transaction
  • CrowdTwist_Loyalty_User_Activity
  • CrowdTwist_Loyalty_User_Redemption

Sample filter names:

  • Resp_Hotel_Email_Active_Customer
  • Resp_Hotel_Profile_High_Value_Guest
  • Resp_Hotel_Profile_Recent_US_Guest
  • Resp_Hotel_SMS_Active_Customer

Sample audience name: Resp_Hotel_Audience

Retail

This data model describes a retailer’s customer profile, preferences, recent purchases, and data for retailer stores and products.

Folder name: retail

Profile list name: Resp_Retail_Customers

Profile extension table names:

  • Resp_Retail_Cust_Recency_Aggregate
  • CrowdTwist_Loyalty_Profile

Supplemental table names:

  • Resp_Retail_Product
  • Resp_Retail_Store
  • CrowdTwist_Loyalty_User_Activity
  • CrowdTwist_Loyalty_User_Redemption

Sample filter names:

  • Resp_Retail_Email_Active_Customer
  • Resp_Retail_Profile_High_Spender
  • Resp_Retail_Profile_North_Calif_Birthday
  • Resp_Retail_SMS_Active_Customer

Sample audience name: Resp_Retail_Audience

Telecom

This data model describes a telecom customer’s profile, preferences, mobile device, summarized spending, and data for mobile plans and phone types.

Folder name: telecom

Profile list name: Resp_Telecom_Customers

Profile extension table names:

  • Resp_Telecom_Cust_Highlights
  • Resp_Telecom_Cust_Summary_Recency
  • CrowdTwist_Loyalty_Profile

Supplemental table names:

  • Resp_Telecom_Mobile_Device
  • Resp_Telecom_Mobile_Plan
  • Resp_Telecom_Phone_Lines
  • CrowdTwist_Loyalty_User_Activity
  • CrowdTwist_Loyalty_User_Redemption

Sample filter names:

  • Resp_Telecom_Email_Active_Customer
  • Resp_Telecom_Profile_May_Lose_Customer
  • Resp_Telecom_Profile_Recent_Complainer
  • Resp_Telecom_SMS_Active_Customer

Sample audience name: Resp_Telecom_Audience

Learn more