CSV data migration for targets per user
Column list
| Name | Description | Type | Required |
|---|---|---|---|
| USER_EXTERNAL_ID | User identifier | Text | ✅ |
| YEAR | Year | Integer | ✅ |
| MONTH | Month (from 1 to 12) | Integer | ✅ |
| SALES_AMOUNT | User's overall amount target | Decimal | |
| APPOINTMENT_QUANTITY | Target number of appointments (Appointment targets) | Integer |
How it works
- Each line of the file corresponds to a monthly target: uniqueness is based on USER_EXTERNAL_ID + YEAR + MONTH.
- If the target already exists, it is updated; otherwise it is created.
- The target columns (
SALES_AMOUNT,APPOINTMENT_QUANTITY) are optional:- a column that is missing from the file or empty does not change the value already saved in MobiCRM;
- you can therefore import only the appointment targets, for example.
- Users must have been imported beforehand (see CSV data migration for users). A line whose user is unknown is ignored and reported in the import log.
- Lines whose month is not between 1 and 12 are ignored and reported in the import log.
Units
SALES_AMOUNTis expressed in the currency of the account (for example in euros), and not in thousands, unlike entry in the MobiCRM interface, which is done in k€.- The decimal separator is the comma (for example
1234,56). A period is rejected: the line causes a conversion error that stops the import of the file.
