Cross-Sell Database

Created by Josh Mentzer, Modified on Tue, 06 Feb 2024 at 11:35 AM by Mosie Duhe

TABLE OF CONTENTS


What is the Cross-Sell Database?


The Cross-Sell Database resides in our CWSP Sales application. It lists all of the companies a Cristo Rey school currently partners with. Information is updated on an hourly basis. Moreover, it utilizes Dun & Bradstreet, a clearing house for corporate infromation. The Cross-Sell Database uses Dun & Bradstreet to bring information like a company's location, size, coporate hierarchy, related partners, and more into Salesforce. It provides real-time data based on your input within the Job record. This help doc is a walkthrough of the Cross-Sell Database. 


This video tutorial will walk you through using the cross sell database. It mirrors the info detailed below.



Accessing the Cross-Sell Database


You can access the Cross-Sell Database in 2 ways:


Option 1: If you are looking to analyze trends, industries, etc., go to the Cross-sell Database Dashboard


You will then see a similar page like below, which shows aggregate information like Top 10 Indsutries, Top Mult-City Employers, Total Partners, and more! Due note that you need to manually refresh by clicking on the Refresh button to get the updates to the Cross-Sell Database.



Option 2: If you are looking for details on a specific company, go to Explore Cross Sell, then click "Explore the database"



On the explore page, you can use the filters to search for partners by company name, # schools, # students, industry, funding type, location, and/or school. When you find a partner of interest in the Partner list, you can click on the row to see school/student-detail in the School list OR click on the partner name to access the Cross-Sell Record within Work Studyforce.


Note: Folks without a Salesforce login (e.g. Jobs Committee members) can access the Cross-sell Database through this link.


Navigating a Cross-Sell Record


Once you click on a partner record in the Cross-Sell Database view, you will see a similar page like the images below. This page includes a lot of information for the partner selected but here are some key fields to look for. 


On the top, we see:


  • Cross-Sell - Schools with Partnership:  Number of schools that currently have students employed for that company


  • Cross-Sell - Total Student: Number of students currently employed for that company


NAICS - Stands for North American Industry Classification System. This is used to provide common definitions of a business' industrial structure.


  • NAICS Industry Sector - The top-level industry category for the current company


  • NAICS Industry Sub Sector - The sub-level industry category for the currenty company


Here's an example:



Below this is the School Partnerships section. This lists all the Cristo Rey schools that have partnered with the company for this school year, listing the school name and other relevant information such as:


  • Student Count - Number of students currently employed for the Cristo Rey school. 


  • School Funding Model - Type of funding model. Click here to learn more about the funding models.


  • School Job Location - Location of the current job (e.g. Onsite, Remote, Hybrid)


  • School Partner Name - The name of the partner according to the school; the local name (vs the national name) of the partner. 


  • D&B School Partner Name - The name of the partner (at the school level) according to Dun and Bradstreet. 


Here's an example:



If you see an error for your school, modifications can be easily made in the Job record. Click here to learn on how to do so. 


Below this is the Yearly Totals section. This section informs you about the historical changes (# of students employed & # of schools working with the partner) for the current company based on the School Year.  


Here's an example:



We are currently working on bringing the historical changes for the prior year!


Finally, the information below comes directly from Dun & Bradstreet. This is additional information, including the company's contact information, website, what the company does, its top and sub-level NAICS Code, number of current employees for the primary and subsidary locations, and more! 


Feel free to look at this information and the field descriptors if you are wondering what these values are.


Here's an example:



What is a NAICS Code? It's a six digit code that categorizes a business based on their industry. For instance, 522110 signifies Commericial Banking. A sub category code can be applied numerous times. Find more info here.



Accessing Cross-Sell Reports


You can access several different reports related to Cross-Sell companies. Here's how to do so.


1. Go to Reports


2. Under Folders, click on All Folders


3. Go to CWSP Sales Reports


4. Click on Cross-Sell Reports 


There are numerous reports here so feel free to look at what each report offers.


These reports intentionally filter out jobs without students, professional development, and those that were cancelled. 


If you export a report, note that any recent updates to a Cross-Sell company will NOT go through. Our Cross-Sell Database updates each hour within Salesforce.



Fixing your School's Cross-Sell Data


If you notice there is incorrect data such as Student Count or Student Job Location on the Cross-Sell partner record page, this can be fixed by navigating to the Job record of that partner. Here's how to do so.


Any changes made to the Student Count and the Location: Onsite / Remote fields in the Job record will reflect back to the Cross-Sell Database within an hour.


1. Navigate to the Job record


2. Edit the # of Students or Location: Onsite / Remote field by clicking on the pencil icon. 


 



Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article

z