---
schema_version: "1"
id: 594880e620f33deddfa97b96b776e1c61fca94f90d8665eff7659bf98584560d
title: Map Reporting Snapshot Fields
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/data_mapping_analytic_snap.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.data_mapping_analytic_snap.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: c7c73254c067631c36d2e452476f450496124c124c3d6c9e43495ed6a46fc977
description: After you create a source report, target object, target object fields, and define your reporting snapshot, you can map the fields on your source report to the fields on your target object. You map source report fields to target object fields so that when the report runs, it automatically loads specific target object fields with data from specific source report fields.
products:
  - Cross Cloud
release: "264"
---
# Map Reporting Snapshot Fields

After you create a source report, target object, target object fields, and define your reporting snapshot, you can map the fields on your source report to the fields on your target object. You map source report fields to target object fields so that when the report runs, it automatically loads specific target object fields with data from specific source report fields.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: both Salesforce Classic and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Professional</strong>, <strong>Enterprise</strong>, <strong>Performance</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d49983e75">User Permissions
              Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d49983e75 ">
              <span id="data_mapping_analytic_snap__SnapshotPermName"><a name="data_mapping_analytic_snap__SnapshotPermName"><!-- --></a>To create, save, and schedule a reporting
                snapshot:</span>
            </td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d49983e75 ">
              <span id="data_mapping_analytic_snap__SnapshotPermDesc"><a name="data_mapping_analytic_snap__SnapshotPermDesc"><!-- --></a>Manage Reporting Snapshots</span>
            </td>

          </tr>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d49983e75 ">To run a reporting snapshot as a running user and add the results to
              a custom object, the running user must have:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d49983e75 ">
              <p>Run Reports</p>
              <p>AND</p>
              <p style="margin-bottom:0;">Create on the target object</p>
            </td>

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

1. From Setup, enter Reporting Snapshots in the Quick Find box, then select **Reporting Snapshots**.
2. Select the name of the reporting snapshot whose fields you want to map.
3. Click **Edit** on the Field Mappings section.
4. For summary reports, select the Grouping Level at which summary data is extracted from the source report. Data loaded into the target object is taken from summary fields at the grouping level you specify. The Grand Summary summarizes on the total for all grouping levels.
5. In the Fields from Source Report column, click a Load No Data drop-down list and select a field from the source report to map to a custom object field in the Fields in Target Object column. Only summary fields can be mapped for reporting snapshots based on summary reports. Note that the fields for summary reports may vary depending on the grouping level selected.
6. Click **Quick Save** to save field mappings and continue mapping fields, or click **Save** to save field mappings and return to the reporting snapshot's detail page.
7. Next, [schedule](https://help.salesforce.com/s/articleView?id=analytics.data_scheduling_analytic_snap.htm&release=264.0.0&type=5 "After you create a source report, target object, target object fields, define your reporting snapshot, and map its fields, you can schedule when it runs. You can schedule a reporting snapshot to run daily, weekly, or monthly so that data from the source report is loaded into the target object when you need it.") the reporting snapshot to run.

Consider these tips for mapping reporting snapshot fields.

- You must map at least one field from the source report to one field on the target object or data will not load from the source report to the target object when the reporting snapshot runs.
- You can only map fields with compatible data types. For example, you can map a currency field to a number field.
- A custom summary formula can be mapped only if the grouping level in the reporting snapshot and the grouping level in the custom summary formula match.
- If you select Load No Data in the Fields from Source Report column, no data will load into the corresponding field in the Fields in Target Object column when the reporting snapshot runs..
- The (No fields with compatible data type) field displays in the Fields from Source Report column when a field on the target object does not match the data type of a field on the source report.
- The fields on the target object determine field mapping availability. For example, your source report may include ten fields, but if your target object includes one field, then you can only map one field in your reporting snapshot.
- You cannot map fields from the source report to the following fields on the target object: Created By, Last Modified By, Created Date, and Last Modified Date.
- When you map fields from the source report to the target object, some data may lose its context when loaded to the target object. For example, if you map a date and time field from the source report to a text field on the target object, the date and time load to the target object without the time zone.
- When executing a reporting snapshot, if the running user does not have “read” or “write” access to a mapped field in the target object, that field is dropped from the mapping, but does not cause the execution to fail. If a required field in the target object is not mapped, the execution fails. To ensure that fields are always mapped, make them required or set default values for them.
- To map a field in the source report to a lookup field on the target object, you must map to the ID of the object associated with the lookup. For example, to map to an opportunity lookup field, you must map to the Opportunity ID. To get the Opportunity ID in the source report, you may need to use a custom report type to include ID and other related fields.

#### See Also

- [Report on Historical Data with Reporting Snapshots](https://help.salesforce.com/s/articleView?id=analytics.data_about_analytic_snap.htm&release=264.0.0&type=5 "A reporting snapshot lets you report on historical data. Authorized users can save tabular or summary report results to fields on a custom object, then map those fields to corresponding fields on a target object. They can then schedule when to run the report to load the custom object's fields with the report's data. Reporting snapshots enable you to work with report data similarly to how you work with other records in Salesforce.")
- [Add a Summary Formula Column to a Report](https://help.salesforce.com/s/articleView?id=analytics.building_custom_summary_formulas.htm&release=264.0.0&type=5 "Before adding a summary formula to your report, be sure to group report data. Summary formula columns require at least 1 group.")