Back

Client Linking

Contents

Introduction

Link Individual Clients

Link Multiple Clients

Create in Tamarac

Finding Linked Contacts

 

Introduction

Using client integration allows you to simplify data management between Tamarac CRM and Tamarac Reporting. Client integration bi-directionally integrates the client’s name, email address, and date of birth between Tamarac CRM and Tamarac Reporting. You will also be able to see information about a client’s portal for linked clients.

From Tamarac CRM, you can create a new client in Tamarac Reporting with the click of a button, making it fast and easy to manage your clients. The client will be automatically linked, and your updates to the client will then sync across the products. Use the Create in Tamarac button for clients who are members of households that have already been linked to Tamarac Reporting.

Note

When you link a Tamarac CRM contact with a Tamarac Reporting client, the Tamarac CRM name will overwrite the Tamarac Reporting client name.

Link Individual Clients

In order to take advantage of the client integration such as name and email address synchronization, Tamarac Reporting clients need to be linked with Tamarac CRM contacts. You can link clients in Tamarac Reporting to contacts in Tamarac CRM either manually one at a time or in bulk using an upload.

To link a client individually, follow these steps in Tamarac Reporting:

  1. On the Accounts menu, click Clients.

  2. Click an existing client. You can also perform this step when you create a new Household.

  1. On the Settings page, click the Add CRM Client button.

  1. In the Search CRM Client names box, Tamarac Reporting automatically searches for the client's email address.

    If the Tamarac CRM contact email is different, type the name or email of the contact you want to sync. When you see it in the list, click the associated radio button and then click Link Selected Client. All integrated fields (Contact Name, email address, and date of birth) will then be synced to Tamarac Reporting from Tamarac CRM.

Note

You may not find a match immediately if the email in Tamarac Reporting does not match the address in Tamarac CRM. If you don’t see a match, try clearing the search bar and searching by last name only.

The search only includes Tamarac CRM contacts that are not already linked.

Link Multiple Clients

In order to take advantage of the client integration such as name and email address synchronization, Tamarac Reporting clients need to be linked with Tamarac CRM contacts. You can link clients in Tamarac Reporting to contacts in Tamarac CRM either manually one at a time or in bulk using an upload.

To link multiple Households, you will use this general procedure:

  1. Export account information from Tamarac CRM.

  2. Export a bulk report from Tamarac Reporting.

  3. Match the Tamarac CRM and Tamarac Reporting data in Excel.

  4. Upload the Excel file in Tamarac Reporting.

Step One: Export Tamarac CRM Data

  1. Under Clients, select Contacts.

  2. On the Contacts page, select the Tamarac Reporting Client Upload view.

  3. Click Export to Excel. This generates an Excel file you can download.

  4. In the Excel file, click Enable Editing.

    Columns A through C are hidden. You need only the Email Address and Contact GUID columns. Additional columns are included to help with the comparison to Tamarac Reporting data and can be deleted.

Step Two: Export Tamarac Reporting Data

  1. In Tamarac Reporting, create a Client Information bulk report. Include the following columns:

  1. Run the Client Information bulk report.

  2. Save and open the bulk report Excel file.

Step Three: Match the CRM and Tamarac Reporting Data in Excel

  1. Copy and paste the GUID from the CRM export into the matching row in the Tamarac Reporting bulk report.

Important

It is critical that each CRM GUID is correctly matched with the corresponding Tamarac Reporting client. This is what Tamarac Reporting uses to link the records, so incorrect matching will result in mixed up data.

  1. Spot-check to confirm GUIDs were correctly copied into the Tamarac Reporting file.

Step Four: Upload the Excel File in Tamarac Reporting

  1. In Tamarac Reporting, under Setup, click Upload.

  2. Create a Client Information upload.

  3. Add the Excel file containing the matched Client data to the upload.

  4. Click Upload. When the upload is complete, check in Tamarac Reporting to confirm that Households are linked with the correct CRM account.

Create in Tamarac

Using the Create in Tamarac button allows you to create and link clients in Tamarac Reporting with just one click. Use this button to create clients that are members of households that have already been linked. The Create in Tamarac button is used to create and link records in Tamarac Reporting one at a time. To link multiple records, refer to the Link Multiple Clients information.

To create Clients in Tamarac Reporting, follow these steps:

  1. Under Clients, select Contacts.

  2. Open the record for the contact you want to create in Tamarac Reporting.

  3. Click Create in Tamarac.

    You will receive a confirmation message that the client has been created successfully in Tamarac Reporting. A Contact must have an email address to be created in Tamarac Reporting.

  4. Click Open in Tamarac to finish the onboarding process in Tamarac Reporting.

Finding Linked Contacts

On the contact record, you can identify a linked contact using the Linked to Tamarac field. This field will show as Not Linked for any contact that has not been linked to Tamarac Reporting and the Create in Tamarac button will be visible.

Linked to Tamarac will show as Linked for any contact that has been linked to Tamarac Reporting and the Create in Tamarac button will not be visible.

You can create a view to identify all linked or unlinked Account/Households in Tamarac CRM. To create a view, follow these steps:

  1. Under Clients, select Contacts.

  2. Click to open the advanced filtering panel.

  3. Select Linked in Tamarac and choose Equals and Linked.

  4. Click Apply.