---
schema_version: "1"
id: 713bce3f518e87da59215c58cb86916489b95e9499bc549a621289a11f244443
title: Integrate Marketing Cloud Personalization with CRM Analytics
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_pers_salesforce_crma.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_pers_salesforce_crma.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 4f70fcc5b55fa0cb064e5803db0500cfa49e8428c49e95bc0b9e88da95a0cc76
description: In Salesforce CRM Analytics, connect to Marketing Cloud Personalization’s Data Warehouse and explore personalization data. Import prediction scores from CRM Analytics into Personalization using ETL data feeds.
products:
  - Marketing
  - Salesforce Personalization
release: "264"
---
# Integrate Marketing Cloud Personalization with CRM Analytics

In Salesforce CRM Analytics, connect to Marketing Cloud Personalization’s Data Warehouse and explore personalization data. Import prediction scores from CRM Analytics into Personalization using ETL data feeds.

## About the Personalization Data Warehouse

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mc_personalization-264-0-0-production-enus/16bf1f60-f44c-4260-a56e-f052cfe515a3/images/icon_note.png)

Note The Data Warehouse is available only for customers who have already purchased the Marketing Cloud Personalization - Data Warehouse add-on product.

The Personalization Data Warehouse contains personalization data that is optimized for analysis and available in a preformatted schema. Marketing Cloud Personalization provides daily updates to the Data Warehouse from its operational data store.

## Integration Prerequisites

To gain access to the Personalization Data Warehouse, you need a user account and connection information. You must also be added to the IP Allowlist. For instructions, see [Set Up Access to the Personalization Data Warehouse](https://help.salesforce.com/s/articleView?id=mktg.mc_pers_data_warehouse_setup.htm&release=264.0.0&type=5 "Set up access to the Marketing Cloud Personalization Data Warehouse by completing the following steps.").

## Connect and Explore Data

CRM Analytics connects to the Personalization Data Warehouse using its Amazon Redshift connector. See [Amazon Redshift Connection](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_redshift_settings.htm&language=en_US).

![Graphic that shows connecting to the Data Warehouse with the Amazon Redshift Connector.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mc_personalization-264-0-0-production-enus/16bf1f60-f44c-4260-a56e-f052cfe515a3/mc_personalization/images/mc_pers_salesforce_crma.png)

After you connect, use SQL commands to explore the data in the Data Warehouse. For schema details, see [Developer Documentation: Marketing Cloud Personalization Data Analytics](https://developer.salesforce.com/docs/marketing/personalization/guide/data-analytics.html).

## Import Prediction Scores from CRM Analytics

Import predictive stores from CRM Analytics for use in segmentation and targeting, or as input to feature engineering for Einstein Decisions.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:11.11111111111111%">
          <col style="width:33.33333333333333%">
          <col style="width:55.55555555555556%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d38350e100">Sequence</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d38350e103">Task</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d38350e106">Description</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Sequence" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d38350e100 ">1</td>

            <td data-label="Task" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d38350e103 ">Generate the Prediction Scores</td>

            <td data-label="Description" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d38350e106 ">Generate the prediction scores using Einstein
              Discovery. For instructions, see <a href="https://help.salesforce.com/s/articleView?id=analytics.bi_edd_prediction.htm&amp;language=en_US" target="_blank">Predict and Improve Outcomes</a>.</td>

          </tr>
          <tr class="">
            <td data-label="Sequence" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d38350e100 ">2</td>

            <td data-label="Task" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d38350e103 ">Create the File to Import</td>

            <td data-label="Description" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d38350e106 ">
              <p>To prepare the file to import, use the data
                integration features in CRMA Analytics. For instructions, see <a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_data_integration.htm&amp;language=en_US" target="_blank">Integrate and Prepare Data for Analysis</a>.
              </p>
              <p style="margin-bottom:0;">The file must comply with the specifications in <a href="https://help.salesforce.com/s/articleView?id=mktg.mc_pers_etl_user_data_feed.htm&amp;release=264.0.0&amp;type=5" title="Use the User ETL data feed to update Unified Custom Profiles, and Unified Account Profiles if you have B2B Detect. Personalization stores user profiles for each anonymous and known user in the system.">User ETL Data Feed</a>.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Sequence" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d38350e100 ">3</td>

            <td data-label="Task" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d38350e103 ">Upload the File Into Marketing Cloud
              Personalization</td>

            <td data-label="Description" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d38350e106 ">Upload the file, either as a one-off upload or posted
              to Personalization’s SFTP site for processing on a recurring (nightly) basis. For
              instructions, see <a href="https://help.salesforce.com/s/articleView?id=mktg.mc_pers_etl_integration.htm&amp;release=264.0.0&amp;type=5" title="Ingest data into Marketing Cloud Personalization using ETL data feeds. ETL integration lets you batch load data using CSV files that are generated externally. Update the catalog, import and export segments, upload historical data, and more. You import CSV files using an SFTP site or uploading them manually.">ETL Integration</a>.</td>

          </tr>
        </tbody>
      </table>

#### See Also

- [Personalization Data Warehouse](https://help.salesforce.com/s/articleView?id=mktg.mc_pers_data_warehouse.htm&release=264.0.0&type=5 "Marketing Cloud Personalization tracks and measures engagement—at the individual and account levels—across your company’s channels. The Data Warehouse is a repository of personalization data that is optimized for analysis. Business analysts can use their preferred business intelligence (BI) tool to access the Data Warehouse and run queries to transform, report on, analyze, and visualize your Marketing Cloud Personalization data.")
- [_Developer Documentation_: Data Analytics](https://developer.salesforce.com/docs/marketing/personalization/guide/data-analytics.html)