Last Updated: Tuesday, December 7, 2021
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 previous day. For example, if you are looking at the data set today, 7/18/2019, it will contain data for codes issued from 7/11/2019 to present.
What data is included?
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 Mobiledb) |
| 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 |
What are some sample queries to pull this data?
–- A query that will pull all sms messages from yesterday
SELECT
INCENTIVE_CODE
, INCENTIVE_POOL_NAME
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)
Overview
Content Tools