Note: This article only applies to Odyssey and eBET clients using TalkBox in mirror mode. If your account is in mirror mode but you use a different loyalty system, please see Mirror mode: uploading & tagging contacts and Mirror mode: using TalkBox forms to gather data.
If your TalkBox account is in mirror mode you may want to tag contacts. In order to do this you will need to upload and tag a .csv file that contains just the unique identifier. This article contains information on how you would find the unique identifier in Astute.
Finding the external ID
Member Identifier in Astute Cube will be your TalkBox external ID. Member Identifier is located under the Player dimension group.
Use case: Extracting the top 50 players
Log in to the Astute Cube. If you do not have a connection to The Cube already set up, contact the Astute support team to get a login and instructions.
In the 'Pivot Table' field list, locate the 'Member Identifier' attribute (under the Player dimension group) and drop it into the Rows section of the pivot table.
Locate the 'Avg Play Per Visit' measure (under the Player Session dimension group) and drop it into the Values section of the pivot table.
Locate the Calendar dimension and drop it into the Filters section of the pivot table.
You should have a pivot table that looks something like this:
In the Calendar filter, choose the time period for which you want to see 'Avg Play Per Visit' data (in this example November 2018):
Right-click on any value in the 'Avg Play Per Visit' column. Select 'Sort' then 'Sort Largest to Smallest'. This will sort your list from the most valuable to least valuable players.
Click on the arrow next to Row Labels in the pivot table. Hover over 'Value Filters' and select 'Top 10'.
In the window that pops up, change the Top 10 value to match the number of top players you require (in this example it's 50).
Save your data as a .csv file for upload to TalkBox and follow the instructions in our article Mirror mode: uploading & tagging contacts.
If you drop the Name attribute in the Player dimension underneath the Member Identifier in the rows section, you can check that the member identifiers correspond to the players you’re expecting to see. If you see duplicate records for a name, ignore it, as you are looking at 'P_ID', which is an internal database identifier used by Astute to link changes in membership together. This should be used only for checking your member identifiers.