Rewards Identifier attaches external identifiers — loyalty, ticketing and partner ids — to members who already exist. You can hold as many of these per member as you need. The most common one is the pid that Ticketmaster uses.
Find it in the admin under Reports & Imports › Imports, at app.fanmaker.com/admin/settings/imports. Pick Rewards Identifier from the What are you importing? picker, then click Download example CSV to start from a file with the right headers.
Import Rules
The first column
The first column of your file is how we find the member each row belongs to, and it has to come first. Use whichever one of these you already have:
email — their email address
username — their username
user_id — Fanmaker's own id for the member
member_id — your membership number for them
student_id — student number, for education programs
ticketmaster_id — their Ticketmaster account id
cust_id — external customer ID
pid — external customer ID
oktaid — their Okta id, for sites using Okta SSO
phone_number — their mobile number. We match on the last 10 digits, so 19522177561 and (952) 217-7561 both work.
Required columns
identifier — the rewards identifier to attach to the member
identifier_type — which type of identifier it is
Optional column
exclusive — set to true to switch off any identifiers of the same type already active on that account
Which identifier types are accepted
identifier_type has to be one of: pid, cust_id, oktaid, netid, pbr_id, qrcode, outbox_id, gpsid, ssbid, usatrimemberid, nfl_oidc, mlb_oidc, tunespeak_user_id, stripe_cid, nba_id, hubspot_cid, tdc_id, seat_geek_oidc, ringside_client_id.
Not every type applies to every program — it depends which integrations you run. A row with a type outside this list is rejected, and the results file will say so.
Example Entries
A file with the headers email, identifier and identifier_type, and one row reading:
email — [email protected]
identifier — 1234
identifier_type — pid
This adds a rewards identifier of 1234, of type pid, to [email protected].
Add the optional exclusive column and set it to true:
email — [email protected]
identifier — 1234
identifier_type — pid
exclusive — true
Same result, except any pid identifier already active on that account is switched off first.