Issuances Data
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?
| Column Name | Type | Nullable | Default | Comment |
|---|---|---|---|---|
| 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 |
Sample Query
–- 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 almost 2 years ago