PeopleSoft Enterprise CRM Warehouse

When customers drive your bottom line, enhancing the effectiveness of interactions with this critical constituency is essential to your success. Are you retaining your best customers? Why are customers migrating from one market segment to another? Which communication method yields the best results for the least investment?

Oracle's PeopleSoft Customer Relationship Management (CRM) Warehouse captures all customer-related data into a single repository and combines it with complex analysis of your sales, marketing, and service initiatives. With this level of insight into your customers' preferences and behavior, as well as the effectiveness of sales and marketing campaigns, you can make the right strategic decisions to increase customer satisfaction and bottom-line profitability.


  • A Powerful Foundation for Increasing Customer Profitability: The PeopleSoft CRM Warehouse offers four seamlessly integrated but stand-alone data marts that deliver the maps, measures, and models required for maximizing the return on your customer-facing initiatives. Deployed together, the marts provide a single source of customer data for complete reporting and analysis. Deployed independently, the marts provide best practice analysis in a single discipline without requiring a complete warehouse implementation. Each of the data marts has been rationalized to accept and store content from PeopleSoft Enterprise, JD Edwards EnterpriseOne, and JD Edwards World product families, allowing you to bring data together from these source systems into one place for reporting and analysis.

    Customer Mart: Customer Mart provides insight into the complete customer lifecycle across business processes and market segments.
    Marketing Mart: Marketing Mart captures information about both traditional and online marketing activities including respondent profiles, number of click-throughs and generated leads, lead qualification mechanisms, and campaign return on investment to help you analyze the effectiveness of marketing activities.
    Sales Mart: Sales Mart provides visibility into pipeline status, discount analysis, sales cycle time, and fallout analysis so you can examine your sales processes and evaluate the effectiveness of sales-related activities.
    Service Mart: Service Mart captures information about all contact center activities including calls, cases, chats, e-mails and resolutions, allowing you to analyze the effectiveness of these activities.
  • Partner for Success: Because partnerships play a large role in your sales and service efforts, having the tools to evaluate these important relationships is critical. CRM Warehouse enables you to analyze partner performance and calculate ROI so that you always invest in the right partner companies. Gain insight into lead acceptance, opportunity influence, and support inquiries for each partner. Understand where the company stands relative to others in the channel and how it measures up to stated goals. Evaluate partners, reward and retain the best-and most profitable-ones, and identify areas for improvement for under performers.
  • Flexible Information Access: PeopleSoft CRM Warehouse supports third party BI tools, including those from Cognos, Microstrategy, and Business Objects. With these flexible information access tools and PeopleSoft CRM Warehouse, knowledge workers, business analysts, and managers can perform sophisticated business analysis with ad-hoc querying and reporting, personalized scorecards and dashboards, multidimensional analysis and exploration, and formatted production-style reports.
  • Single, Analytics Framework: PeopleSoft CRM Warehouse is built on Oracle's PeopleSoft EPM Foundation, a single analytics framework that provides IT organizations with one platform and toolset from which to manage and support your warehouse. PeopleSoft EPM Foundation includes best-in-class extract, transform, and load (ETL) tools, powerful metadata management tools, multi-currency and multi-language support, and built-in security features that enable unparalleled flexibility, openness, and modularity.