ug
sub_id
tx_id
|
645D2A50-1D53-40B7-9DD5-8238AFAF8029
VAQ1234 or 123456
VAQ1234 or 123456
|
varchar(36)
varchar(20)
varchar(20)
|
Optional
Optional
Optional
|
Lead's Unique identifier
External Member Id
Transaction Id
* Note : one of these three is required.
|
|
reward
|
1.2
|
numeric or decimal
|
Yes
|
Reward amount for the member in $ or if any conversion exists it will be in the respective conversion(Coins, Points)
|
|
status
|
S or T or R or Q
|
varchar(5)
|
Yes
|
Status = S, means member completed the Survey Preliminarily.
= T, means member failed or terminated from the Survey.
= Q, means memeber quota full for the Survey.
= R, means, member completed the Survey Preliminary but finally rejected by the
Client.
Initially when the member completes the survey preliminarily we fire a Pixel with
status = S and then after 2 to 3 weeks (means, when we have the Updated final completes
list from the client side people), if this member is not in the final completed
list we fire the pixel with Status = R. So always the status “S” indicates that
member can get reward and the Status “R” cancels the rewards issued preliminarily
(Status = S).
|
|
title
|
Health Survey
|
varchar(250)
|
Yes
|
Name of the Survey, member completed
|
|
surveyid
|
9345
|
int
|
Yes
|
Id of the Survey, member completed
|
|
es_id
|
1234
|
int
|
Optional
|
Entry Id of the Survey, member participated
|
|
gross
|
2.4
|
numeric or decimal
|
Yes
|
Partner Gross revenue Share amount in $
|
PostBack URL