Introduction

Datasources and destinations

Fields listing for Impact

EXPLORE YOUR DATA

Metrics & dimensions

Find the fields you need for your next report.

0 metrics165 dimensions

165 fields

All fields
FieldDetails
Account Sid
impact.com account SID used for the advertiser account. Example: 1234567
Field IDcompany_information/id
DimensionTEXT
Ad Description
Additional ad description for partners. Example: Our best deals this summer creative.
Field IDad/description
DimensionTEXT
Ad Id
Unique impact.com ad identifier. Example: 892081
Field IDad/id
DimensionTEXT
Ad Name
Ad name. Example: Summer Sale 2020 250x250
Field IDad/name
DimensionTEXT
Ad Program Name
Program name associated with the ad. Example: Acme Campaign
Field IDad/campaign_name
DimensionTEXT
Ad Promo Code Tracking
Whether promo code tracking is enabled for the ad. Example: false
Field IDad/promo_code_tracking
DimensionBOOLEAN
Ad Type
Kind of ad provided to partners. Example: BANNER
Field IDad/ad_type
DimensionTEXT
Ad Uri
impact.com API URI for the ad resource. Example: /Advertisers/1234567/Ads/892081
Field IDad/uri
DimensionTEXT
Additional Category
Additional marketplace category for the program. Example: Travel
Field IDcampaign/additional_category
DimensionTEXT
Address 1
First line of the partner address. Example: 1640 Riverside Dr.
Field IDpartner/address_1
DimensionTEXT
Address 2
Second line of the partner address. Example: Suite 20
Field IDpartner/address_2
DimensionTEXT
Address City
City of the partner address. Example: Hill Valley
Field IDpartner/address_city
DimensionTEXT
Address Country
Country code for the partner address. Example: US
Field IDpartner/address_country
DimensionCOUNTRY_CODE
Address Postal Code
Postal code of the partner address. Example: 90210
Field IDpartner/address_postal_code
DimensionTEXT
Address State
State or region of the partner address. Example: CA
Field IDpartner/address_state
DimensionTEXT
Allow Deep Linking
Whether the ad allows deep linking. Example: true
Field IDad/allow_deep_linking
DimensionBOOLEAN
Banner Alternative Tag
Alternative tracking tag for the banner. Example: summersale
Field IDad/banner_alternative_tag
DimensionTEXT
Billing Address City
Billing address city. Example: Boston
Field IDcompany_information/billing_address_city
DimensionTEXT
Billing Address Country
Billing address country code. Example: US
Field IDcompany_information/billing_address_country
DimensionCOUNTRY_CODE
Billing Address Line 1
First line of the billing address. Example: 112 1/2 Beacon St.
Field IDcompany_information/billing_address_line_1
DimensionTEXT
Billing Address Line 2
Second line of the billing address. Example: Floor 3
Field IDcompany_information/billing_address_line_2
DimensionTEXT
Billing Address Postal Code
Billing address postal code. Example: 02116
Field IDcompany_information/billing_address_postal_code
DimensionTEXT
Billing Address State
Billing address state or region. Example: MASSACHUSETTS
Field IDcompany_information/billing_address_state
DimensionTEXT
Commercial Contact Email
Email address of the commercial contact. Example: sales@example.com
Field IDcompany_information/commercial_contact_email
DimensionTEXT
Commercial Contact Name
Name of the primary commercial contact. Example: John Doe
Field IDcompany_information/commercial_contact_name
DimensionTEXT
Company Currency
Primary account currency. Example: USD
Field IDcompany_information/currency
DimensionTEXT
Company Homepage
Homepage URL referenced in program resources. Example: https://www.acme.com
Field IDcampaign/company_homepage
DimensionURL
Company Indirect Tax Number
Indirect tax number when the advertiser is registered. Example: GB123456789
Field IDcompany_information/indirect_tax_number
DimensionTEXT
Company Name
Advertiser company name. Example: Acme Corporation
Field IDcompany_information/company_name
DimensionTEXT
Company Timezone
Account timezone label. Example: (GMT -08:00) Pacific Time (US & Canada); Tijuana
Field IDcompany_information/timezone
DimensionTEXT
Company Uri
impact.com API URI for the company information resource. Example: /Advertisers/1234567/CompanyInformation
Field IDcompany_information/uri
DimensionTEXT
Company Website
Advertiser website URL. Example: https://www.example.com
Field IDcompany_information/website
DimensionURL
Contract Id
Contract identifier for the partner-program relationship. Example: 12345
Field IDpartner_program/contract_id
DimensionTEXT
Contract Name
Contract name for the partner-program relationship. Example: Acme Public Terms
Field IDpartner_program/contract_name
DimensionTEXT
Corporate Address City
Corporate address city. Example: Hill Valley
Field IDcompany_information/corporate_address_city
DimensionTEXT
Corporate Address Country
Corporate address country code. Example: US
Field IDcompany_information/corporate_address_country
DimensionCOUNTRY_CODE
Corporate Address Line 1
First line of the corporate address. Example: 1640 Riverside Dr.
Field IDcompany_information/corporate_address_line_1
DimensionTEXT
Corporate Address Line 2
Second line of the corporate address. Example: Suite 200
Field IDcompany_information/corporate_address_line_2
DimensionTEXT
Corporate Address Postal Code
Corporate address postal code. Example: 90210
Field IDcompany_information/corporate_address_postal_code
DimensionTEXT
Corporate Address State
Corporate address state or region. Example: CALIFORNIA
Field IDcompany_information/corporate_address_state
DimensionTEXT
Country
Country enum targeted by the partner. Example: US
Field IDpartner_promotional_country/country
DimensionTEXT
Coupon Link Name
Name shown for coupon-link ads. Example: Summer Sale 20% Off
Field IDad/coupon_link_name
DimensionTEXT
Custom Ad Serving Url
Third-party hosted creative URL when impact.com hosting is bypassed. Example: https://cdn.example.com/banner.png
Field IDad/custom_ad_serving_url
DimensionURL
Customisation Charge
Charge applied when the ad is customized. Example: 0.00
Field IDad/customisation_charge
DimensionNUMBER
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
DimensionYEAR_MONTH_DAY
Date Created
Date the ad was created in impact.com. Example: 2024-02-29T22:03:35-08:00
Field IDad/date_created
DimensionYEAR_MONTH_DAY
Date Last Updated
Date of the most recent ad update. Example: 2024-02-29T22:03:35-08:00
Field IDad/date_last_updated
DimensionYEAR_MONTH_DAY
Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
DimensionDAY
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
DimensionDAY_OF_WEEK
Deal Categories
Categories targeted by the associated deal. Example: Legos,Dolls
Field IDad/deal_categories
DimensionTEXT
Deal Default Promo Code
Default promo code attached to the deal. Example: SUMMERSALE20
Field IDad/deal_default_promo_code
DimensionTEXT
Deal Description
Description of the associated deal. Example: The end of summer sale with great discounts and the best items
Field IDad/deal_description
DimensionTEXT
Deal End Date
End date of the associated deal. Example: 2020-09-30T00:00:00-07:00
Field IDad/deal_end_date
DimensionYEAR_MONTH_DAY
Deal Id
Associated impact.com deal identifier. Example: 85433
Field IDad/deal_id
DimensionTEXT
Deal Name
Associated deal name. Example: Summer Sale 2020
Field IDad/deal_name
DimensionTEXT
Deal Scope
Scope of the associated deal. Example: CATEGORY
Field IDad/deal_scope
DimensionTEXT
Deal Start Date
Start date of the associated deal. Example: 2020-09-17T00:00:00-07:00
Field IDad/deal_start_date
DimensionYEAR_MONTH_DAY
Deal State
Current state of the associated deal. Example: PENDING
Field IDad/deal_state
DimensionTEXT
Deal Type
Type of the associated deal. Example: GENERAL_SALE
Field IDad/deal_type
DimensionTEXT
Direct Tracking Session Window Length
Session window length for direct tracking. Example: 30m
Field IDcampaign/direct_tracking_session_window_length
DimensionTEXT
Direct Tracking Unidentified Name
Fallback name used by direct tracking when the partner is unidentified. Example: Unknown Partner
Field IDcampaign/direct_tracking_unidentified_name
DimensionTEXT
Discount Amount
Discount amount when the deal uses an absolute value. Example: 10.00
Field IDad/discount_amount
DimensionNUMBER
Discount Currency
Currency used for the discount amount. Example: USD
Field IDad/discount_currency
DimensionTEXT
Discount Percent
Percent discount for the deal. Example: 10
Field IDad/discount_percent
DimensionPERCENT
Discount Type
Discount type for the associated deal. Example: PERCENT
Field IDad/discount_type
DimensionTEXT
Display Future Ads
Whether future ads should be visible to partners. Example: false
Field IDcampaign/display_future_ads
DimensionBOOLEAN
Display Servicing Agency
Whether the servicing agency is displayed to partners. Example: false
Field IDcampaign/display_servicing_agency
DimensionBOOLEAN
Dlu
Date the property was last updated. Example: 2020-03-05T11:57:20-05:00
Field IDpartner_property/dlu
DimensionYEAR_MONTH_DAY
Doe
Date of entry for the property. Example: 2010-05-24T13:58:57-04:00
Field IDpartner_property/doe
DimensionYEAR_MONTH_DAY
Ein Ssn Foreign Tax Id
Tax identifier stored on the advertiser account. Example: XXX-XX-678
Field IDcompany_information/ein_ssn_foreign_tax_id
DimensionTEXT
Example Landing Page
Sample landing page used in program resources. Example: https://www.acme.com/store
Field IDcampaign/example_landing_page
DimensionURL
Financial Contact Email
Email address of the financial contact. Example: finance@example.com
Field IDcompany_information/financial_contact_email
DimensionTEXT
Financial Contact Name
Name of the primary financial contact. Example: Road Runner
Field IDcompany_information/financial_contact_name
DimensionTEXT
Financial Contact Work Phone Number
Work phone number for the financial contact. Example: 2065550100
Field IDcompany_information/financial_contact_work_phone_number
DimensionTEXT
Gateway Campaign Tracking Template
Template used to inject campaign tracking tokens. Example: campaign={CampaignId}
Field IDcampaign/gateway_campaign_tracking_template
DimensionTEXT
Gateway Deep Link Domains
Configured deep link domain list. Example: acme.com/store/forge/anvils/anvil2
Field IDcampaign/gateway_deep_link_domains
DimensionTEXT
Gateway Deep Linking
Whether deep linking is enabled in gateway settings. Example: true
Field IDcampaign/gateway_deep_linking
DimensionBOOLEAN
Gateway Default Landing Page
Default landing page used by gateway tracking. Example: http://www.acme.com
Field IDcampaign/gateway_default_landing_page
DimensionURL
Gateway Media Partner Tracking Template
Template used to inject media partner tracking tokens. Example: subid={MediaPartnerId}
Field IDcampaign/gateway_media_partner_tracking_template
DimensionTEXT
Gateway Ssl Support
Whether SSL support is enabled for gateway links. Example: true
Field IDcampaign/gateway_ssl_support
DimensionBOOLEAN
Gateway Unique Click Window Length
Unique click window length configured for gateway tracking. Example: 30m
Field IDcampaign/gateway_unique_click_window_length
DimensionTEXT
Gateway Unique Click Window Type
Unique click window type configured for gateway tracking. Example: ROLLING
Field IDcampaign/gateway_unique_click_window_type
DimensionTEXT
Get Html Code Type
HTML code format generated for the ad. Example: HTML_AND_IFRAME
Field IDad/get_html_code_type
DimensionTEXT
Gift Card Payouts
Whether gift card payouts are enabled. Example: false
Field IDcampaign/gift_card_payouts
DimensionBOOLEAN
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
DimensionHOUR
Iab Ad Unit
IAB ad unit classification for the creative. Example: CUSTOM
Field IDad/iab_ad_unit
DimensionTEXT
Identity Matching
Identity matching mode configured for the program. Example: IR_CONSORTIUM
Field IDcampaign/identity_matching
DimensionTEXT
Impression Tracking
Whether impression tracking is enabled. Example: false
Field IDcampaign/impression_tracking
DimensionBOOLEAN
Indirect Tax Country
Country code used for the partner indirect tax record. Example: US
Field IDpartner/indirect_tax_country
DimensionCOUNTRY_CODE
Information Page
Information page URL referenced by the program. Example: https://www.acme.com/program-info
Field IDcampaign/information_page
DimensionURL
Is Primary
Whether this promotional method is marked as primary. Example: true
Field IDpartner_promotional_method/is_primary
DimensionBOOLEAN
Join Date
Date the partner joined the program. Example: 2019-06-19T08:41:09-04:00
Field IDpartner_program/join_date
DimensionYEAR_MONTH_DAY
Labels
Comma-separated ad labels. Example: sale,US
Field IDad/labels
DimensionTEXT
Landing Page
Landing page URL for the ad. Example: http://www.test.com/6234652
Field IDad/landing_page
DimensionURL
Language
Language of the ad creative. Example: ENGLISH
Field IDad/language
DimensionTEXT
Limited Time End Date
End date for the limited-time ad window. Example: 2020-09-30T00:00:00-07:00
Field IDad/limited_time_end_date
DimensionYEAR_MONTH_DAY
Limited Time Start Date
Start date for the limited-time ad window. Example: 2020-09-16T17:01:28-07:00
Field IDad/limited_time_start_date
DimensionYEAR_MONTH_DAY
Link Text
Visible text used for text-link ads. Example: Shop the summer sale
Field IDad/link_text
DimensionTEXT
Link Type
Primary link type assigned to the partner. Example: TRACKING_LINK
Field IDpartner/link_type
DimensionTEXT
List In Marketplace
Whether the program is listed in the impact.com marketplace. Example: true
Field IDcampaign/list_in_marketplace
DimensionBOOLEAN
Long Description
Long program description shown to partners. Example: This is a long description. Find more words here.
Field IDcampaign/long_description
DimensionTEXT
Maximum Savings Amount
Maximum savings allowed by the deal. Example: 100.00
Field IDad/maximum_savings_amount
DimensionNUMBER
Maximum Savings Currency
Currency for the maximum savings amount. Example: USD
Field IDad/maximum_savings_currency
DimensionTEXT
Minimum Contact Rating
Minimum allowed contact rating for the advertiser account. Example: 1
Field IDcompany_information/minimum_contact_rating
DimensionNUMBER
Minimum Purchase Amount
Minimum purchase amount required by the deal. Example: 10.00
Field IDad/minimum_purchase_amount
DimensionNUMBER
Minimum Purchase Amount Currency
Currency for the minimum purchase amount. Example: USD
Field IDad/minimum_purchase_amount_currency
DimensionTEXT
Mobile Fallback Android
Android fallback app identifier. Example: 12345
Field IDad/mobile_fallback_android
DimensionTEXT
Mobile Fallback Ios
iOS fallback app identifier. Example: 67890
Field IDad/mobile_fallback_ios
DimensionTEXT
Mobile Ready
Whether the ad is optimized for mobile. Example: true
Field IDad/mobile_ready
DimensionBOOLEAN
Mobile Ready Ads
Whether the program exposes mobile-ready ads. Example: false
Field IDcampaign/mobile_ready_ads
DimensionBOOLEAN
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
DimensionMONTH_DAY
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
DimensionMONTH
Organization Type
Legal organization type. Example: CORP
Field IDcompany_information/organization_type
DimensionTEXT
Partner Currency
Preferred partner currency. Example: USD
Field IDpartner/currency
DimensionTEXT
Partner Description
Partner-provided business description. Example: Wile E. Coyote is the top influencer for Acme products!
Field IDpartner/description
DimensionTEXT
Partner Id
Unique impact.com partner identifier. Example: 10000
Field IDpartner/id
DimensionTEXT
Partner Indirect Tax Number
Indirect tax number recorded for the partner. Example: GB123456789
Field IDpartner/indirect_tax_number
DimensionTEXT
Partner Name
Partner display name. Example: Wile E. Coyote Partner
Field IDpartner/name
DimensionTEXT
Partner Program Name
Program display name. Example: Acme Brands
Field IDpartner_program/campaign_name
DimensionTEXT
Partner Promotional Method Type
Promotional method type. Example: SHOPPING
Field IDpartner_promotional_method/type
DimensionTEXT
Partner Property Name
Property display name. Example: Wile E. Coyote Facebook
Field IDpartner_property/name
DimensionTEXT
Partner Property Type
Property type. Example: SOCIAL
Field IDpartner_property/type
DimensionTEXT
Partner State
Current impact.com partner account state. Example: ACTIVE
Field IDpartner/state
DimensionTEXT
Partner Timezone
Partner timezone identifier. Example: America/Los_Angeles
Field IDpartner/timezone
DimensionTEXT
Partner Type
impact.com partner classification. Example: MARKETPLACE
Field IDpartner/partner_type
DimensionTEXT
Partner Uri
impact.com API URI for the partner resource. Example: /Advertisers/1234567/MediaPartners/10000
Field IDpartner/uri
DimensionTEXT
Partner Website
Partner website domain or URL. Example: https://www.example.com
Field IDpartner/website
DimensionURL
Phone Country
Country code for the partner phone number. Example: US
Field IDpartner/phone_country
DimensionCOUNTRY_CODE
Phone Number
Partner phone number. Example: 18055550100
Field IDpartner/phone_number
DimensionTEXT
Phone Tracking
Whether phone tracking is enabled for the ad. Example: false
Field IDad/phone_tracking
DimensionBOOLEAN
Platform
Platform name when the property belongs to a known network. Example: FACEBOOK
Field IDpartner_property/platform
DimensionTEXT
Primary Category
Primary marketplace category for the program. Example: B2B, Services & Office Supplies
Field IDcampaign/primary_category
DimensionTEXT
Primary Phone Number
Primary business phone number. Example: 1235550100
Field IDcompany_information/primary_phone_number
DimensionTEXT
Primary Phone Number Country
Country code for the primary phone number. Example: US
Field IDcompany_information/primary_phone_number_country
DimensionCOUNTRY_CODE
Program Id
Unique impact.com program identifier. Example: 1000
Field IDcampaign/id
DimensionTEXT
Program Name
Program name. Example: Acme Campaign
Field IDcampaign/name
DimensionTEXT
Program Promo Code Tracking
Whether promo code tracking is enabled. Example: true
Field IDcampaign/promo_code_tracking
DimensionBOOLEAN
Program State
Current program state. Example: ACTIVE
Field IDcampaign/state
DimensionTEXT
Program Uri
impact.com API URI for the program resource. Example: /Advertisers/1234567/Campaigns/1000
Field IDcampaign/uri
DimensionTEXT
Property Id
Unique partner property identifier. Example: 271
Field IDpartner_property/property_id
DimensionTEXT
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
DimensionQUARTER
Rating
Program rating shown to partners. Example: 3
Field IDcampaign/rating
DimensionNUMBER
Registered For Indirect Tax
Whether the advertiser is registered for indirect tax. Example: false
Field IDcompany_information/registered_for_indirect_tax
DimensionBOOLEAN
Search Keywords
Keywords associated with the program. Example: Anvils
Field IDcampaign/search_keywords
DimensionTEXT
Season
Season tag assigned to the ad. Example: SUMMER
Field IDad/season
DimensionTEXT
Secondary Phone Number
Secondary business phone number. Example: 3215550100
Field IDcompany_information/secondary_phone_number
DimensionTEXT
Secondary Phone Number Country
Country code for the secondary phone number. Example: US
Field IDcompany_information/secondary_phone_number_country
DimensionCOUNTRY_CODE
Short Description
Short program description shown to partners. Example: This is a short description.
Field IDcampaign/short_description
DimensionTEXT
Site Definition
Primary site definition for the program. Example: www.acme.com
Field IDcampaign/site_definition
DimensionTEXT
Technical Contact Email
Email address of the technical contact. Example: tech@example.com
Field IDcompany_information/technical_contact_email
DimensionTEXT
Technical Contact Name
Name of the primary technical contact. Example: Jane Smith
Field IDcompany_information/technical_contact_name
DimensionTEXT
Third Party Servable Ad Creative Height
Servable creative height in pixels. Example: 250
Field IDad/third_party_servable_ad_creative_height
DimensionNUMBER
Third Party Servable Ad Creative Width
Servable creative width in pixels. Example: 250
Field IDad/third_party_servable_ad_creative_width
DimensionNUMBER
Top Seller
Whether the ad is marked as a top seller. Example: true
Field IDad/top_seller
DimensionBOOLEAN
Tracking Domain
Tracking domain used for program links. Example: acme.sjv.io
Field IDcampaign/tracking_domain
DimensionTEXT
Trademark Bidding
Whether trademark bidding is allowed. Example: false
Field IDcampaign/trademark_bidding
DimensionBOOLEAN
Url
Property URL. Example: https://www.facebook.com/example
Field IDpartner_property/url
DimensionURL
View Through Crediting
Whether view-through crediting is enabled. Example: false
Field IDcampaign/view_through_crediting
DimensionBOOLEAN
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
DimensionWEEK
Week of the year (start Sunday)
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY
DimensionWEEK
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
DimensionYEAR
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
DimensionYEAR_MONTH
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
DimensionYEAR_MONTH_DAY_HOUR
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
DimensionYEAR_QUARTER
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
DimensionYEAR_WEEK

Explore destinations for your data

AI

Claude

Ask Claude about your Marketing data.
AI

ChatGPT

Ask ChatGPT about your Marketing data.
Spreadsheet

Excel

Easily track, report, and analyze your marketing KPIs in Excel.‍
Data lake

Azure Blob Storage

Quickly export your marketing data to Azure Blob Storage for secure storage and analysis, streamlining workflows and enhancing insights.
Data lake

Google Cloud Storage

Effortlessly export marketing data to Google Cloud Storage for secure, scalable storage and streamlined insights.
Data lake

Amazon S3

Unlock effortless data storage and management for your marketing team with seamless transfers to Amazon S3, simplifying workflows and accelerating insights.
Data warehousing

Snowflake

Effortlessly integrates your data in Snowflake, providing a seamless solution for storage, analysis, and real-time insights.
Data warehousing

Amazon Redshift

Access advanced analytics and insights by effortlessly connecting your marketing data to Amazon Redshift.
Data warehousing

Azure SQL

Effortlessly connect your marketing data to Azure SQL for immediate access to valuable insights.
Data warehousing

PostgreSQL

Effortlessly send data from multiple Marketing platforms to your PostgreSQL database with Catchr for seamless integration, storage, and management.
Data warehousing

MySQL

Seamlessly integrate your marketing data with MySQL to access valuable analytics and insights.
Visualization

Tableau

Empower your marketing teams with seamless data transfer to Tableau.
Visualization

Power BI

Whether it's social media analytics, email marketing results, or PPC campaign data, Catchr bridges the gap. Export your data to Power BI.
Data warehousing

Big Query

Unlock advanced analytics and insights by easily connecting your marketing data to BigQuery.
Visualization

Data Studio (formerly Looker Studio)

Catchr makes it super easy to visualize your marketing data into Data Studio (formerly Looker Studio).
Spreadsheet

Google Sheets

Effortlessly report, monitor, and analyze your marketing KPIs in Google Sheets.