---
schema_version: "1"
id: 4315952a2ab3757f72189715a45d4a71ba7e80e5ba602916f47b25b519ecc441
title: Account ETL Data Feed
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_pers_etl_account_data_feed.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_pers_etl_account_data_feed.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: db1f9e808670923bd6258956d5e734666bd20e5afe1adcc5576483c38f02f0bf
description: Use the Account ETL data feed to update account information in Unified Account Profiles.
products:
  - Marketing
  - Salesforce Personalization
release: "264"
---
# Account ETL Data Feed

Use the Account ETL data feed to update account information in Unified Account Profiles.

## About Ingesting Account Data

If you market to businesses, you can use Unified Account Profiles to display aggregate information that Personalization collects about a particular account. Unified Account Profiles provide a comprehensive view of each of your accounts according to the cross-channel interactions of customers and prospects.

The accounts can be linked with firmographic data to gain more information. Any previously known information about the accounts can be loaded into the system by creating attributes to reflect the keys in the source system. Custom attributes can also be defined.

## Requirements

- ETL files must be in a CSV file format that adheres to the schema for the data feed. Files that don’t follow the file naming conventions or the appropriate schema result in errors and fail to process.
- Field names that begin with `attribute:` must match the custom attribute names on the Account Attributes tab of the Settings > Attributes page.

## Filename Format

`account-YYYY-MM-DD_HH-MM-SS.csv`

## Schema

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:17.81701444622793%">
          <col style="width:32.74478330658106%">
          <col style="width:22.150882825040128%">
          <col style="width:13.643659711075443%">
          <col style="width:13.643659711075443%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d23122e90">
              <p style="margin-bottom:0;">Field Name </p>
            </th>
            <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d23122e96">
              <p style="margin-bottom:0;">Description </p>
            </th>
            <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d23122e102">
              <p style="margin-bottom:0;">Example Values </p>
            </th>
            <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d23122e108">
              <p style="margin-bottom:0;">Maximum Length </p>
            </th>
            <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d23122e114">
              <p style="margin-bottom:0;">Data Type </p>
            </th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Field Name" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d23122e90 ">
              <code>accountId</code>
            </td>

            <td data-label="Description" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d23122e96 ">
              <p style="margin-bottom:0;">Represents the unique identifier for an account, and its value must match
                an account ID in the system. Account IDs must be all lowercase with no
                spaces.</p>
            </td>

            <td data-label="Example Values" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d23122e102 ">
              <p>salesforce </p>
              <p style="margin-bottom:0;">6413150145</p>
            </td>

            <td data-label="Maximum Length" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d23122e108 ">
              <p style="margin-bottom:0;">120</p>
            </td>

            <td data-label="Data Type" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d23122e114 ">
              <p style="margin-bottom:0;">String</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Field Name" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d23122e90 ">
              <code>attribute:name</code>
            </td>

            <td data-label="Description" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d23122e96 ">
              <p style="margin-bottom:0;">The display name for an account.</p>
            </td>

            <td data-label="Example Values" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d23122e102 ">
              <p>Salesforce</p>
              <p style="margin-bottom:0;">Example Company</p>
            </td>

            <td data-label="Maximum Length" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d23122e108 ">
              <p style="margin-bottom:0;">120</p>
            </td>

            <td data-label="Data Type" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d23122e114 ">
              <p style="margin-bottom:0;">String</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Field Name" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d23122e90 ">
              <code>attribute:</code>
            </td>

            <td data-label="Description" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d23122e96 ">
              <p style="margin-bottom:0;">The custom attributes for the account. Column headers begin with <code>attribute:</code> and are followed by the
                attribute name as it appears on the Attributes page. The header value
                must match the attribute name in the system, and the values must conform
                to the configured data type.</p>
            </td>

            <td data-label="Example Values" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d23122e102 ">
              <p>attribute:numEmployees</p>
              <p>1250</p>
              <p>attribute:companySize</p>
              <p>medium</p>
              <p>attribute:inBusinessFlag</p>
              <p style="margin-bottom:0;">true</p>
            </td>

            <td data-label="Maximum Length" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d23122e108 ">
              <p style="margin-bottom:0;">1023</p>
            </td>

            <td data-label="Data Type" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d23122e114 ">
              <p style="margin-bottom:0;">Any valid system data type</p>
            </td>

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

## Sample File

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:15.384615384615385%">
          <col style="width:24.358974358974358%">
          <col style="width:20.192307692307693%">
          <col style="width:22.275641025641026%">
          <col style="width:17.78846153846154%">
        </colgroup>
        <tbody>
          <tr class="">
            <td class="slds-cell-wrap" style="text-align:left;vertical-align:top;">accountId </td>

            <td class="slds-cell-wrap" style="text-align:left;vertical-align:top;">attribute:name </td>

            <td class="slds-cell-wrap" style="text-align:left;vertical-align:top;">attribute:numEmployees</td>

            <td class="slds-cell-wrap" style="vertical-align:top;">attribute:companySize</td>

            <td class="slds-cell-wrap" style="text-align:left;vertical-align:top;">attribute:inBusinessFlag</td>

          </tr>
          <tr class="">
            <td class="slds-cell-wrap" style="text-align:left;vertical-align:top;">
              <p style="margin-bottom:0;">6413150145</p>
            </td>

            <td class="slds-cell-wrap" style="text-align:left;vertical-align:top;">
              <p style="margin-bottom:0;">Example Company</p>
            </td>

            <td class="slds-cell-wrap" style="text-align:left;vertical-align:top;">
              <p style="margin-bottom:0;">1268</p>
            </td>

            <td class="slds-cell-wrap" style="text-align:left;vertical-align:top;">
              <p style="margin-bottom:0;">medium</p>
            </td>

            <td class="slds-cell-wrap" style="text-align:left;vertical-align:top;">
              <p style="margin-bottom:0;">TRUE</p>
            </td>

          </tr>
          <tr class="">
            <td class="slds-cell-wrap" style="text-align:left;vertical-align:top;">
              <p style="margin-bottom:0;">8418416741</p>
            </td>

            <td class="slds-cell-wrap" style="text-align:left;vertical-align:top;">
              <p style="margin-bottom:0;">Sample Company</p>
            </td>

            <td class="slds-cell-wrap" style="text-align:left;vertical-align:top;">
              <p style="margin-bottom:0;">7358</p>
            </td>

            <td class="slds-cell-wrap" style="text-align:left;vertical-align:top;">
              <p style="margin-bottom:0;">medium</p>
            </td>

            <td class="slds-cell-wrap" style="text-align:left;vertical-align:top;">
              <p style="margin-bottom:0;">True</p>
            </td>

          </tr>
          <tr class="">
            <td class="slds-cell-wrap" style="text-align:left;vertical-align:top;">
              <p style="margin-bottom:0;">9177215300</p>
            </td>

            <td class="slds-cell-wrap" style="text-align:left;vertical-align:top;">
              <p style="margin-bottom:0;">Obsolete Company</p>
            </td>

            <td class="slds-cell-wrap" style="text-align:left;vertical-align:top;">
              <p style="margin-bottom:0;">21</p>
            </td>

            <td class="slds-cell-wrap" style="text-align:left;vertical-align:top;">
              <p style="margin-bottom:0;">small</p>
            </td>

            <td class="slds-cell-wrap" style="text-align:left;vertical-align:top;">
              <p style="margin-bottom:0;">false</p>
            </td>

          </tr>
          <tr class="">
            <td class="slds-cell-wrap" style="text-align:left;vertical-align:top;">
              <p style="margin-bottom:0;">salesforce</p>
            </td>

            <td class="slds-cell-wrap" style="text-align:left;vertical-align:top;">
              <p style="margin-bottom:0;">Salesforce</p>
            </td>

            <td class="slds-cell-wrap" style="text-align:left;vertical-align:top;">
              <p style="margin-bottom:0;">56,606</p>
            </td>

            <td class="slds-cell-wrap" style="text-align:left;vertical-align:top;">
              <p style="margin-bottom:0;">large</p>
            </td>

            <td class="slds-cell-wrap" style="text-align:left;vertical-align:top;">
              <p style="margin-bottom:0;">true</p>
            </td>

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

#### See Also

- [ETL File Requirements](https://help.salesforce.com/s/articleView?id=mktg.mc_pers_etl_file_requirements.htm&release=264.0.0&type=5 "ETL files contain entries such as users, products, subscription list members, promotions, transactions, and more. These files must be in a CSV format and can be encrypted or compressed. The file formats must follow the explicit schema requirements for each ETL data feed. Typically, you upload ETL files automatically using the SFTP site, but you can also manually upload a file.")
- [Monitor ETL Feed Jobs on the Feeds Dashboard](https://help.salesforce.com/s/articleView?id=mktg.mc_pers_etl_feeds_dashboard.htm&release=264.0.0&type=5 "The Feeds Dashboard provides details about ETL feed jobs.")
- [Limits for Marketing Cloud Personalization](https://help.salesforce.com/s/articleView?id=mktg.mc_pers_limits.htm&release=264.0.0&type=5 "Learn about the limits and capabilities in Marketing Cloud Personalization.")