CSV data migration for targets per product line
Column list
| Name | Description | Type | Required |
|---|---|---|---|
| USER_EXTERNAL_ID | User identifier | Text | ✅ |
| PRODUCT_LINE_EXTERNAL_ID | Product line identifier (empty = target across all product lines) | Text | |
| YEAR | Year | Integer | ✅ |
| MONTH | Month (from 1 to 12) | Integer | ✅ |
| SALES_AMOUNT | Amount target on won businesses | Decimal | |
| SALES_MARGIN | Margin target on won businesses | Decimal | |
| SALES_QUANTITY | Quantity target on won businesses | Decimal | |
| TURNOVER_AMOUNT | Target on the invoiced revenue amount | Decimal | |
| TURNOVER_MARGIN | Target on the invoiced revenue margin | Decimal | |
| TURNOVER_QUANTITY | Target on the invoiced revenue quantity | Decimal |
How it works
- Each line of the file corresponds to a monthly target: uniqueness is based on USER_EXTERNAL_ID + PRODUCT_LINE_EXTERNAL_ID + YEAR + MONTH.
- If the target already exists, it is updated; otherwise it is created.
PRODUCT_LINE_EXTERNAL_IDcan be left empty: the target then applies to the user across all product lines.- The six target columns 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 amount targets, then the margin targets in a second file.
- Users and product lines must have been imported beforehand (see CSV data migration for users and CSV data migration for product lines).
- A line whose user is unknown is ignored and reported in the import log.
- A line whose product line is filled in but unknown is ignored and reported in the import log, so that a target across all product lines is not created by mistake.
- Lines whose month is not between 1 and 12 are ignored and reported in the import log.
Units
- Amounts and margins (
SALES_AMOUNT,SALES_MARGIN,TURNOVER_AMOUNT,TURNOVER_MARGIN) are 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€. - Quantities (
SALES_QUANTITY,TURNOVER_QUANTITY) are expressed in the product unit, without conversion. - 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.
