cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
3655members
1189posts
This is a verified product documentation article. For case-based resolutions articles, please reference the Knowledge Base section of Invoca Community.
stevestormoen
Employee
Employee

If you route your phone calls to many different call centers using lookup tables , you can choose to have this routing data reflected in your Basic Knowledge: Invoca reports. This is useful if you want to see additional information in reporting — such as which local branch received your phone call — that is not captured directly from your customer's browser session (as detailed in Basic Knowledge: Capturing Marketing Data with Invoca). 

For example, if you route your phone calls to different local branches based on the caller’s ZIP code, Invoca only captures the ZIP code, not the location that ends up receiving the phone call. However, we can also use your lookup tables to associate those ZIP codes with the name or location of each of those local branches. You can then view the call data for each of your local branches in your Invoca reports.
 

Before you get started

Did you know you can use lookup tables for dynamic phone call routing as well? To get started, or if you want to know more, see How to route your phone calls to many different call centers using lookup tables.

Also, if you use more than one lookup table in your call routing, we recommend only following these instructions once, and associating marketing data with only one of your tables. This is to keep your records clear and avoid overwriting any marketing data values by accident.
 

Step 1: Create a new Marketing Data field

Follow our guide to create a custom Marketing Data field, then repeat this process for each reporting field you want to associate with your lookup table advanced routing. If you have enough Category-type fields available in your account, select the type: Category. Otherwise, select Short Text.
 

Step 2: Add your new Marketing Data field to your routing lookup table

  1. Log in to your Invoca account. In the sidebar menu, click Settings; then in the Network section, select Marketing Data.
  2. Click the Tables tab. This will take you to a summary page that displays all tables that have been added to your platform. 
  3. Click on the name of the table you would like to edit, then go the most recently downloaded version of the table (see Date column for last upload).

    report-lookup-1.png

  4. In the Actions column, click on the blue download button, then open the downloaded document with any spreadsheet software.
  5. To the right of the Destination Column in your spreadsheet, add a new column for each Marketing Data field you created in Step 1 of this guide. In the header row of your spreadsheet, enter the Partner (API) Name of each Marketing Data field exactly as it appears in your Marketing Data dictionary.

    report-lookup-2.png
  6. Save your spreadsheet. We recommend saving it under a new name, using a consistent naming convention, such as “Table Name - (date of upload)”.

 

Step 3: Upload the new spreadsheet file

  1. Return to the Tables tab in your Invoca account. Click on the three dots in the upper right-hand corner of the Details box and choose Upload rows. 
  2. Drop the updated spreadsheet into the File box and click Upload. 
  3. Under Summary, you will see “In progress” while the table uploads. Refresh the page to see an updated status. Once the upload is complete, you will get a status update.


That’s it! Now your Invoca account will associate every phone call that’s routed through your lookup table with the Marketing Data value you added to your spreadsheet. Whenever you access your Invoca reports, you’ll see your new Marketing Data field included, making it easy to sort and filter your reports based on the criteria — such as location — that you chose!
 

Related:
• How to route your phone calls to many different call centers using lookup tables 
• Basic Knowledge: Capturing Marketing Data with Invoca 
• Basic Knowledge: Invoca reports 

Need more help?

Don't see what you are looking for? You can ask the Community or contact support.