This data set contains recently created incentive codes associated with the company's account.
How much data is retained?
This data set will contain 7 days’ worth of data starting from the most recent data refresh. Data is refreshed once per day. For example, if you are looking at the data set on 7/18, it will contain data from 7/11 to present.
What data can be pulled?
|INCENTIVE_CODE||VARCHAR(255)||TRUE||NULL||The unique incentive code that is sent to a consumer|
|INCENTIVE_POOL_NAME||VARCHAR(255)||TRUE||NULL||Name of the incentive pool|
|TENANT_KEY||VARCHAR(255)||TRUE||NULL||Tenant key associated with the pool/code|
|CREATED_AT||TIMESTAMP_TZ(9)||TRUE||NULL||When the code was created|
|UPDATED_AT||TIMESTAMP_TZ(9)||TRUE||NULL||When it was last updated|
|ACTIVE||NUMBER(38,0)||TRUE||NULL||Whether or not it is active (1-active; 0-inactive)|
|ISSUED||NUMBER(38,0)||TRUE||NULL||Whether or not it is issued at least once (1-issued; 0-not issued)|
|DW_CREATED_AT||TIMESTAMP_TZ(9)||TRUE||NULL||When it was added to the warehouse|
|DW_UPDATED_AT||TIMESTAMP_TZ(9)||TRUE||NULL||When it was updated last in the warehouse|
–- A query that will pull all sms messages from yesterday SELECT INCENTIVE_CODE , INCENTIVE_POOL_NAME , ISSUED ,ACTIVE ,INSERT_SOURCE FROM INCENTIVE_CODES WHERE CAST(DW_CREATED_AT AS DATE) >= CAST(DATEADD(day,-1,CURRENT_DATE())AS DATE) AND CAST(DW_CREATED_AT AS DATE) < CAST(CURRENT_DATE() AS DATE)
Updated 7 months ago