SaaSquatch Help Center

This guide outlines how to upload users and trigger Program Goals by only using our Bulk Import processes.

🔗 Adding users

You can use the Bulk User Import to upload both Referrers and Referred Users, or Loyalty users.

  • All you will need to include at minimum is accountId and id, but we recommend also including the user's first and last names as well as email.
  • To connect up a referral, the referrer's code (FRIENDCODE in the example file below) will need to be provided in a referredBy.Code column.

Supply both an account ID (accountId) and a user ID (id) field for the users being imported. Unless you are using our Shared Accounts feature, both the account and user ID fields should be the same value and ideally match your internal user IDs.

You can include any other additional information about the user by using the fields outlined on our Bulk User Import page.

🔗 Example user import

Screenshot 2023-11-23 at 5.19.50 PM

  • Row 1 "Referred User" will be referred to an existing user whose referral code is FRIENDCODE.
  • Row 2 "Loyalty User" will not be referred to any existing users, and simply be created or updated.

🔗 Importing the User File

Once the file has been filled with all relevant user information, export it as a .csv file and proceed with importing the file.

🔗 Triggering program goals

Your program should be set up with Program Goals that trigger on either:

  • User events
  • User custom fields

You'll need to identify the event or custom field that triggers your goal and apply that logic to the below instructions.

🔗 User event trigger

For goals that trigger when a user performs an action, you'll need to build a Bulk Event Import.

🔗 User custom field trigger

You can use the same Bulk User Import to send along the custom field. In the below example, the program goal is met when the custom field status is subscriber.

Screenshot 2023-11-23 at 5.20.00 PM

You're able to send this custom field along with the user creation in order to trigger the goal if the user has already met the conditions.