This data set contains recently issued 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||VARCHAR(255)||TRUE||NULL||Name of the incentive pool|
|TENANT_KEY||VARCHAR(255)||TRUE||NULL||Tenant key associated with the pool/code|
|REFERRING_APPLICATION||VARCHAR(16777216)||TRUE||NULL||The application that assigned the code (usually Campaign Manager, Wallet or mobile database)|
|REFERRING_APPLICATION_REF_ID||VARCHAR(16777216)||TRUE||NULL||Campaign ID of the campaign that assigned the code (usually a broadcast id or interactive campaign id)|
|EXTERNAL_ISSUEE_ID||VARCHAR(16777216)||TRUE||NULL||Usually the person id (for Campaign Manager and Mobiledb) or the person key (for Wallet)|
|CREATED_DATE_DIM_KEY||DATE||TRUE||NULL||Date it was issued|
|CREATED_AT||TIMESTAMP_TZ(9)||TRUE||NULL||When the code was created|
|UPDATED_AT||TIMESTAMP_TZ(9)||TRUE||NULL||When it was last updated|
|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 ,REFERRING_APPLICATION ,CREATED_AT ,UPDATED_AT FROM ISSUANCES 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 9 months ago