---
title: "User Goal ETL Load Method"
slug: "user-goal-etl-load-method"
updated: 2024-11-15T19:07:27Z
published: 2024-11-15T19:07:27Z
canonical: "docs.interprose.com/user-goal-etl-load-method"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.interprose.com/llms.txt
> Use this file to discover all available pages before exploring further.

# User Goal ETL Load Method

## User Goal ETL Overview

The ETL load method allows you to update user goals directly within ACE. Below are the fields that can be utilized with this method, instructions for file upload, and steps to confirm data mapping.

### Available Fields

The following fields can be populated in your import file to update user goals:

1. User ID
2. Username
3. Month - Standard date formats can be used, but only the month and year will be imported. Examples:
  1. YYYY-MM
  2. YYYY-MM-DD
4. Goal Amount

![](https://cdn.document360.io/6c7303ca-5ffc-4149-8868-8ea498eee635/Images/Documentation/unnamed - 2024-11-14T122447.303.jpg?sv=2026-02-06&spr=https&st=2026-10-31T18%3A51%3A42Z&se=2026-10-31T19%3A51%3A42Z&sr=c&sp=r&sig=tIz9b2HaHvWe00dG%2B9pJCV5C0C362eR2HTmXh5XL9cg%3D)

Image Displays Example User Goal ETL Profile Configuration

> [!NOTE]
> Important Note
> 
> If data fails to load using this ETL Load Method, error messages will appear in ETL History Messages but will not be shown in Job Log Messages.
> 
> 
> 
> Navigate to **Accounts → ETL Import → History** to review the ETL history for specific error details.

#### Steps for Importing User Goals

1. Go to **Accounts → ETL Import → Profiles, New**
2. Upload the User Goal File
3. Load Method: User Goals
4. Enter Data into the following Fields:
  1. Enter Label:
  2. Description:
  3. Start at Row:
  4. File Type:
5. Click Apply
6. Map the data:
  1. Data Display: The system displays the first 10 rows and the last 4 rows of data from your file to help you confirm mapping accuracy.
7. Mapping:
  1. Each column includes a Mapped Field Placeholder just above the first data row. This placeholder is where you assign each imported data column to the correct ACE field.
  2. ACE will attempt to automatically map fields based on your initial upload. However, it’s crucial to review each field mapping for accuracy.
8. Save for Future Use:
  1. After mapping all fields correctly, save the Import Placements Profile to reuse it with files formatted in the same structure.
9. Load the Data.
10. Verify User Goals
11. Open the User Profile
12. Locate the Agent Goals Section
13. Verify the data loaded correctly.

## Troubleshooting

If the goals imported incorrectly, you can [Rollback](https://docs.interprose.com/docs/etl-import-history#rollback) the ETL load.