---
schema_version: "1"
id: cbf22d9de04b1e91a226bf0df918c12cff8829831f9e5189f15c7ee290cd3836
title: Create a Flat Table Report
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_dat_create_a_flat_table_report.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_dat_create_a_flat_table_report.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 868363e0946229def06bb7fa5db58a10973e8a03cdc196c465f604adbf0ed17e
description: You can create a flat table report when you want a report that extracts your raw data into a CSV or Excel file.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# Create a Flat Table Report

You can create a flat table report when you want a report that extracts your raw data into a CSV or Excel file.

### 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: Intelligence Reports and Intelligence Reports Advanced</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="d45401e57">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d45401e57 ">To create and edit reports</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d45401e57 ">Schedule / “Create &amp; Edit”</td>

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

1. From **Analytics Builder** select **Intelligence \[Datorama\] Reports**.
2. Select the Reports tab.
3. Click **Create New Report**.
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mc_data_management_and_analytics-264-0-0-production-enus/7988f60d-cd94-4b42-8836-dc11773564b5/images/icon_note.png)
    
    Note You can also create the same report from the Pivot Table module by using schedule export as a flat table.
4. Define your General details.
    1. Enter a Name.
    2. Select the Export Format: CSV or Excel.
        
        ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mc_data_management_and_analytics-264-0-0-production-enus/7988f60d-cd94-4b42-8836-dc11773564b5/images/icon_note.png)
        
        Note The configuration settings change according to the format type you select. For example, if you select CSV, not all the fields are available.
5. Define your Configuration details:
    1. To determine the dates you want to pull data from, select the Time Period. You can use a predefined time period, such as week, month, or year, or you can define a custom date.
    2. In **Measurements**, select the measurements you want pulled into the report, for example, email sends. You can select up to 100 measurements.
    3. In **Dimensions**, select the dimensions you want pulled into your report, for example, send date. You can select up to 80 dimensions.
        
        ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mc_data_management_and_analytics-264-0-0-production-enus/7988f60d-cd94-4b42-8836-dc11773564b5/images/icon_note.png)
        
        Note For a detailed explanation of the metrics available, see [Dimensions and Measurements](https://help.salesforce.com/s/articleView?id=mktg.mc_dat_dimensions_and_measurements.htm&release=264.0.0&type=5 "Dimensions and measurements are included when viewing dashboards, pivot tables, and reports. Use categories to find the data that’s most relevant to you.").
6. Customize your report in the Configuration settings area:
    1. To include the total numbers in the report, select the **Show Totals** checkbox.
    2. From the **Sort By** dropdown, search for and choose the dimension or measurement you want to sort the report by. You can choose from any of the selected dimensions or measurements.
    3. From the **Sort Order** dropdown, select the way you want to sort, either descending or ascending order.
    4. To add another filter to your report, click **Add Filter**. For example, you can also filter by Campaign Name. For more information about filters, refer to Apply Filters.
7. Define scheduling and delivery methods for the report. Refer to [Define Scheduling and Delivery Methods](https://help.salesforce.com/s/articleView?id=mktg.mc_dat_set_report_schedule_and_delivery_method.htm&release=264.0.0&type=5 "You define scheduling and delivery methods for a report to decide how you want to run and share it. As a result, you decide when the report is sent. For example, if you want the report to go out every day at a specific time, you can set a daily frequency and the time, say, 10:00 PM. You can also define how you want the report to be executed and shared.").

#### See Also

- [User Roles and Permissions in Intelligence Reports](https://help.salesforce.com/s/articleView?id=mktg.mc_dat_user_roles_and_permissions.htm&release=264.0.0&type=5 "To use Intelligence Reports for Engagement, your account must be assigned the Intelligence Reports for Engagement user role. The user role has the following permissions: Access, View and Export, Schedule, and Create and Edit.")