Home Inspire Application File Imports Release Notes Sync Web Services FAQ Search

Member RFM Sync

The Member RFM Sync is used to export RFM information and basic member information for all members in the database.  

Upon each execution, all members will be included in the sync file with current RFM information. Files are then FTP’d to the predetermined location.  

Note: This information is also available in PDF form for portability. Member RFM Sync.pdf

Member RFM Sync

Name Standard_Member_RFM_Sync_XXXXX_MMDDYYYYHHMMSS_##.txt  
## = File Number 
Format Pipe delimited
No header record
Frequency  Daily
Source Aimia
Contents All members with RFM and basic core information.

 

Field Name  Type  Notes 
Internal Member Id  Numeric(10)   
First Name  String(60)   
Middle Name String(30)   
Last Name String(60)    
Suffix String(5)  
Member Account Id  Alphanumeric(60)  Primary Account Id 
Recency Number  Integer  
Frequency Number Integer  
Monetary Number Integer  
Member RFM Integer  

Example Data

InternalMemberId|FirstName|MiddleName|LastName|Suffix|MemberAccountId|RecencyNum|FrequencyNum|MonetaryNum|MemberRFM  

61675|Thomas|C|Nestor|Jr.|200501468|4|2|3|423  
61676|Rufus||Holmes||200601670|3|4|3|343 

Kognitiv Logo

Please note: All external Kognitiv Loyalty links and references are directed to US datacenter unless specifically noted.

Tags:
Home: Kognitiv Loyalty © 2023 Kognitiv Corporation. All Rights Reserved.