Schema · Entity relationship diagram
Impact.com tables and relationships
Affiliate and partnership program data from impact.com: every conversion (action) with its order ID, state, sale amount, commission and partner, daily program performance (clicks, impressions, actions, revenue and cost) and your media partner roster. Approvals and reversals from the last 90 days are picked up automatically.
ConnectPaste an API key
Default schema
impactSource API docshelp.impact.com
DestinationsAmazon Redshift, Google BigQuery, Snowflake, PostgreSQL, Amazon S3
actionshas one row per conversion with its order id, state, amounts and partner. Approvals and reversals from the last 90 days are picked up automatically.- Timestamps are UTC;
actions.dateis the account-local calendar date. Clicks and impressions inperformance_by_dayare unique counts.
Primary keyForeign keyReferencesJoins on (not a key)
Drag to pan, scroll or pinch to zoom, click a table to see what it joins to.
Table reference
3 tables · click a table for its columnsactions38 columnsshow in diagram
Primary key: action_id
| Column | Type | Key | Description |
|---|---|---|---|
| date | date | ||
| action_idPrimary key. | varchar(64) | PK | Primary key. |
| order_id | varchar(128) | ||
| state | varchar(32) | ||
| event_date | timestamp | ||
| creation_date | timestamp | ||
| locking_date | timestamp | ||
| cleared_date | timestamp | ||
| referring_date | timestamp | ||
| amount | decimal(18,2) | ||
| payout | decimal(18,2) | ||
| intended_amount | decimal(18,2) | ||
| intended_payout | decimal(18,2) | ||
| delta_amount | decimal(18,2) | ||
| delta_payout | decimal(18,2) | ||
| client_cost | decimal(18,2) | ||
| currency | varchar(8) | ||
| media_partner_idReferences media_partners.partner_id. | varchar(32) | FK | References media_partners.partner_id. |
| media_partner_name | varchar(512) | ||
| campaign_id | varchar(32) | ||
| campaign_name | varchar(256) | ||
| action_tracker_id | varchar(32) | ||
| action_tracker_name | varchar(256) | ||
| ad_id | varchar(32) | ||
| promo_code | varchar(128) | ||
| shared_id | varchar(256) | ||
| event_code | varchar(128) | ||
| referring_type | varchar(64) | ||
| referring_domain | varchar(512) | ||
| customer_id | varchar(64) | ||
| customer_status | varchar(32) | ||
| customer_postcode | varchar(32) | ||
| customer_area | varchar(64) | ||
| customer_city | varchar(256) | ||
| customer_region | varchar(256) | ||
| customer_country | varchar(64) | ||
| note | varchar(1024) | ||
| _jsdata_syncedWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
performance_by_day16 columnsshow in diagram
clicks / impressions are UNIQUE counts (the report does not expose raw clicks).
Primary key: _jsdata_key
| Column | Type | Key | Description |
|---|---|---|---|
| _jsdata_keyPrimary key. | varchar(32) | PK | Primary key. |
| campaign_idJoins to actions.campaign_id. | varchar(32) | FK | Joins to actions.campaign_id. |
| date | date | ||
| partner_count | integer | ||
| impressions | decimal(18,2) | ||
| clicks | decimal(18,2) | ||
| actions | decimal(18,2) | ||
| calls | decimal(18,2) | ||
| revenue | decimal(18,2) | ||
| action_cost | decimal(18,2) | ||
| click_cost | decimal(18,2) | ||
| cpc_cost | decimal(18,2) | ||
| other_cost | decimal(18,2) | ||
| total_cost | decimal(18,2) | ||
| cpc | decimal(18,8) | ||
| _jsdata_syncedWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
media_partners16 columnsshow in diagram
Primary key: partner_id
| Column | Type | Key | Description |
|---|---|---|---|
| partner_idPrimary key. | varchar(32) | PK | Primary key. |
| name | varchar(512) | ||
| website | varchar(512) | ||
| state | varchar(32) | ||
| partner_type | varchar(64) | ||
| currency | varchar(8) | ||
| country | varchar(64) | ||
| promotional_method | varchar(64) | ||
| promotional_categories | varchar(1024) | ||
| contract_id | varchar(32) | ||
| contract_name | varchar(256) | ||
| group_name | varchar(256) | ||
| program_join_date | timestamp | ||
| date_created | timestamp | ||
| date_last_updated | timestamp | ||
| _jsdata_syncedWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |