Supported file format: .csv/.xlsx only. Please convert all your files into a .csv/xlsx before attempting to import data to the web application.

 

There are 4 important things that you'd need to know about when you import sales goals from a file. They are described in detail below:

 

Preparing your CSV/XLSX file

  1. The first row of the file will be treated as the header. Make sure the header rows have all the mandatory columns.

  2. Fields available for mapping

    1. Mandatory fields

  1. User email - Email of the user to whom the goal will be assigned 
  2. Goal type - Specify whether it is a User goal or a Team goal
  3. Goal period - Whether it is a Weekly, Monthly, Quarterly, or Yearly goal
  4. Goal start date - This should be either the first day of the week, month, quarter, or year depending on whether the period is weekly, monthly, quarterly, or yearly
  5. Goal end date - This should be either the last day of the week, month, quarter, or year depending on whether the period is weekly, monthly, quarterly, or yearly
  6. Target - What is the target of this goal (Must be a number)
  7. Team - This field is mandatory when the row contains a team goal
  8. Activity -  The sales activity for which the target has to be set


                b. Optional field

  1. Outcome - The outcome of the sales activity selected


Note: The difference between the Goal start date & Goal end date should be one week, one month, one quarter, or one year depending on the goal period. For example, if you are setting a goal for the month of September 2021, then the goal start date should be 09/01/2021 and the Goal end date should be 09/30/2021.

  1. To import team goals:

  1. You would need to have value as Team under the Goal type column and the team name under the Team column
  2. You need to have a row for each team member. In case you miss adding a team member in the file, the user won’t be considered as part of the team goals
  3. Summation of individual team members goals will be the team goal

Importing the file

  1. Go to Deals Management > Activity Goals

  2. Click on Add Goals dropdown and select Import goals.

  3. Upload the CSV file and click . This presents you with a mapping screen where you can map the fields in the file with the fields of your application.

  4. Click to commence importing the goals.


Why did some of my data not get imported? (Reasons for failure of data import)

When importing sales goals, these are the possible reasons for the failure of data import:

  1. Invalid user email: If the user is not present in your system or the email is in incorrect

  2. Wrong goal start date: If the Goal start date is greater than the Goal end date

  3. Wrong goal end date: If the Goal end date is in the past

  4. Long-range: When the Goal start date and Goal end date is greater than the goal period