Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.io
Send your Impact data to
Impact Connector Reference
5 metrics69 dimensions
The Impact connector exposes 74 fields (5 metrics, 69 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Impact Fields
Impact Actions fields
The Actions report of the Impact connector includes 28 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| action_channel | TEXT | Action Channel | Marketing channel that drove the action. |
| action_cost | NUMERIC | Action Cost | Total cost associated with the action. |
| action_creation_date | DATE | Creation Date | Date when the action was created in impact.com. |
| action_currency_code | TEXT | Action Currency | Original currency of the action. |
| action_customer_status | TEXT | Action Customer Status | Status of the customer, such as New or Returning. |
| action_date | DATE | Action Date | Date of the action event. |
| action_event_date | DATE | Action Event Date | Date when the action event occurred. |
| action_event_type | TEXT | Action Event Type | Display name for the action tracker that tracked the conversion. |
| action_event_type_id | TEXT | Event Type ID | Unique identifier for the action tracker. |
| action_id | TEXT | Action ID | Unique impact.com identifier for the action. |
| action_indirect_tax | NUMERIC | Indirect Tax (VAT) | Tax incurred indirectly on goods and services. |
| action_oid | TEXT | OID | Unique order ID for the action. |
| action_partner_group | TEXT | Partner Group | Partner group(s) in which the publisher is listed. |
| action_partner_id | TEXT | Action Partner ID | Unique identifier of the media partner that drove the action. |
| action_partner_name | TEXT | Action Partner Name | Name of the media partner that drove the action. |
| action_program_id | TEXT | Action Program ID | Unique identifier of the program (campaign). |
| action_program_name | TEXT | Action Program Name | Name of the program (campaign). |
| action_promo_code | TEXT | Promo Code | Promotional code applied to the conversion. |
| action_rate | PERCENT | Rate | Percentage rate, calculated as action cost divided by revenue. |
| action_referral_id | TEXT | Action Referral ID | ID used to tie the referral back to the partner. |
| action_referring_date | DATE | Referring Date | Date of the referring click. |
| action_referring_url | TEXT | Referring URL | URL of the site the consumer came from. |
| action_revenue | NUMERIC | Action Revenue | Total revenue amount associated with the action. |
| action_shared_id | TEXT | Shared ID | Shared ID value associated with the winning click. |
| action_status | TEXT | Action Status | Current status of the action: Approved, Pending, N/A, or Reversed. |
| action_sub_id_1 | TEXT | Sub ID 1 | First Sub ID value associated with the winning click. |
| action_sub_id_2 | TEXT | Sub ID 2 | Second Sub ID value associated with the winning click. |
| action_sub_id_3 | TEXT | Sub ID 3 | Third Sub ID value associated with the winning click. |
Impact Clicks fields
The Clicks report of the Impact connector includes 25 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| click_ad_id | TEXT | Click Ad ID | ID of the ad. |
| click_ad_name | TEXT | Click Ad Name | Name of the ad. |
| click_ad_type | TEXT | Click Ad Type | Type of the ad. |
| click_browser | TEXT | Click Browser | Browser used. |
| click_channel | TEXT | Click Channel | Marketing channel. |
| click_customer_city | CITY | Click Customer City | City of the visitor. |
| click_customer_country | COUNTRY | Click Customer Country | Country of the visitor. |
| click_customer_region | REGION | Click Customer Region | Region of the visitor. |
| click_device_type | TEXT | Click Device Type | Device type (desktop, mobile, tablet). |
| click_id | TEXT | Click ID | Unique identifier of the click. |
| click_is_unique | BOOLEAN | Click Is Unique | Whether this is a unique click. |
| click_landing_page_url | TEXT | Click Landing Page URL | Landing page URL. |
| click_os | TEXT | Click OS | Operating system. |
| click_partner_id | TEXT | Click Partner ID | ID of the media partner. |
| click_partner_name | TEXT | Click Partner Name | Name of the media partner. |
| click_payout | NUMERIC | Click Payout | Payout amount for the click. |
| click_program_id | TEXT | Click Program ID | Program (campaign) ID for the click. |
| click_program_name | TEXT | Click Program Name | Name of the program (campaign) for the click. |
| click_referring_domain | TEXT | Click Referring Domain | Referring domain. |
| click_shared_id | TEXT | Click Shared ID | Shared ID value. |
| click_sub_id_1 | TEXT | Click Sub ID 1 | First sub ID value. |
| click_sub_id_2 | TEXT | Click Sub ID 2 | Second sub ID value. |
| click_sub_id_3 | TEXT | Click Sub ID 3 | Third sub ID value. |
| click_traffic_category | TEXT | Click Traffic Category | Traffic category (e.g. organic, paid). |
| click_traffic_source | TEXT | Click Traffic Source | Traffic source. |
Impact other fields
The Impact connector has 21 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| account_id | TEXT | Account ID | The impact.com Account SID. | Account |
| account_name | TEXT | Account name | The impact.com account name. | Account |
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | Date of the report data. | |
| day_of_month | TEXT | Day of month | Day of the month | |
| month | TEXT | Month | Number of the month | |
| now | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_month_name | TEXT | Year month name | Year and month with the month name written out, e.g. "Jan 2025". | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |