Integration Specifications

Integration Overview

Impact Radius is an affiliate marketing platform to help you promote your ecommerce business.

This document provides context on what kind of data is being gathered through this extractor, which endpoints that data is coming from, and how the extracted tables relate to each other.

Integration Availability

This integration is currently available for:

  • Enterprise

API Endpoints

The Daasity Impact Radius extractor is built based on this API documentation. The following endpoints are used by Daasity to replicate data from Impact Radius:

Impact Radius Schema

The Daasity Impact Radius extractor creates these tables using the endpoints and replication methods listed. The data is mapped from source API endpoint to the table based on the mapping logic outlined in each table.

Accounts

JSON ElementDatabase Column

CompanyName

company_name

Industry.IndustryId

industry_id

Industry.IndustryName

industry_name

Website

website

PrimaryPhoneNumber

primary_phone_number

PrimaryPhoneNumberCountry

primary_phone_number_country

SecondaryPhoneNumber

secondary_phone_number

SecondaryPhoneNumberCountry

secondary_phone_number_country

MinimumContactRating

minimum_contact_rating

Timezone

timezone

Currency

currency

RegisteredForIndirectTax

registered_for_indirect_tax

IndirectTaxNumber

indirect_tax_number

OrganizationType

organization_type

EinSsnForeignTaxId

ein_ssn_foreign_tax_id

CorporateAddress.AddressLine1

corporate_address_line1

CorporateAddress.AddressLine2

corporate_address_line2

CorporateAddress.City

corporate_address_city

CorporateAddress.State

corporate_address_state

CorporateAddress.PostalCode

corporate_address_postal_code

CorporateAddress.Country

corporate_address_country

BillingAddress.AddressLine1

billing_address_line1

BillingAddress.AddressLine2

billing_address_line2

BillingAddress.City

billing_address_city

BillingAddress.State

billing_address_state

BillingAddress.PostalCode

billing_address_postal_code

BillingAddress.Country

billing_address_country

FinancialContact.UserId

financial_contact_user_id

FinancialContact.Name

financial_contact_name

FinancialContact.Email

financial_contact_email

FinancialContact.WorkPhoneNumber

financial_contact_work_phone_number

FinancialContact.WorkPhoneNumberCountry

financial_contact_work_phone_number_country

FinancialContact.CellPhoneNumber

financial_contact_cell_phone_number

FinancialContact.CellPhoneNumberCountry

financial_contact_cell_phone_number_country

TechnicalContact.UserId

technical_contact_user_id

TechnicalContact.Name

technical_contact_name

TechnicalContact.Email

technical_contact_email

TechnicalContact.WorkPhoneNumber

technical_contact_work_phone_number

TechnicalContact.WorkPhoneNumberCountry

technical_contact_work_phone_number_country

TechnicalContact.CellPhoneNumber

technical_contact_cell_phone_number

TechnicalContact.CellPhoneNumberCountry

technical_contact_cell_phone_number_country

SecurityContact.UserId

security_contact_user_id

SecurityContact.Name

security_contact_name

SecurityContact.Email

security_contact_email

SecurityContact.WorkPhoneNumber

security_contact_work_phone_number

SecurityContact.WorkPhoneNumberCountry

security_contact_work_phone_number_country

SecurityContact.CellPhoneNumber

security_contact_cell_phone_number

SecurityContact.CellPhoneNumberCountry

security_contact_cell_phone_number_country

CommercialContact.UserId

commercial_contact_user_id

CommercialContact.Name

commercial_contact_name

CommercialContact.Email

commercial_contact_email

CommercialContact.WorkPhoneNumber

commercial_contact_work_phone_number

CommercialContact.WorkPhoneNumberCountry

commercial_contact_work_phone_number_country

CommercialContact.CellPhoneNumber

commercial_contact_cell_phone_number

CommercialContact.CellPhoneNumberCountry

commercial_contact_cell_phone_number_country

Uri

uri

Daasity-generated

_account_id

Daasity-generated

__integration_id

Daasity-generated

__synced_at

Daasity-generated

__shop_id

__sync_key

Action Inquiries

JSON ElementDatabase Column

Id

id

CampaignId

campaign_id

CampaignName

campaign_name

MediaPartnerId

media_partner_id

MediaPartnerName

media_partner_name

OrderId

order_id

TransactionDate

transaction_date

TransactionAmount

transaction_amount

InquiryType

inquiry_type

ExpectedPayout

expected_payout

ResolutionDeadlineDate

resolution_deadline_date

TrackingLink

tracking_link

ActionId

action_id

ActionUri

action_uri

AutoApprovalDate

auto_approval_date

ResolutionStatus

resolution_status

RejectReason

reject_reason

FinalPayout

final_payout

ResolutionDate

resolution_date

CreationDate

creation_date

Uri

uri

Daasity-generated

_account_id

Daasity-generated

__integration_id

Daasity-generated

__synced_at

Daasity-generated

__shop_id

__sync_key

Action Inquiry Comments

JSON ElementDatabase Column

Comments.User

user

Comments.Comment

comment

Comments.Date

date

Daasity-generated

_account_id

Daasity-generated

__integration_id

Daasity-generated

__synced_at

Daasity-generated

__shop_id

__sync_key

Action Items

JSON ElementDatabase Column

Sku

sku

ItemName

item_name

Category

category

Quantity

quantity

SaleAmount

sale_amount

SaleAmountCurrency

sale_amount_currency

Payout

payout

PayoutCurrency

payout_currency

Rebate

rebate

RebateCurrency

rebate_currency

AdjustmentDate

adjustment_date

AdjustmentReason

adjustment_reason

Uri

uri

Daasity-generated

_account_id

Daasity-generated

__integration_id

Daasity-generated

__synced_at

Daasity-generated

__shop_id

__sync_key

Action Updates

JSON ElementDatabase Column

Id

id

ActionId

action_id

CampaignId

campaign_id

ActionTrackerId

action_tracker_id

EventCode

event_code

MediaPartnerId

media_partner_id

State

state

StateDetail

state_detail

StateDetailDescription

state_detail_description

AdId

ad_id

Disposition

disposition

DeltaPayout

delta_payout

DeltaAmount

delta_amount

Currency

currency

Category

category

SubCategory

sub_category

Sku

sku

Quantity

quantity

CatalogName

catalog_name

CatalogCategory

catalog_category

CatalogDescription

catalog_description

CatalogManufacturer

catalog_manufacturer

CatalogOriginalFormatCategory

catalog_original_format_category

CatalogSubCategory

catalog_sub_category

UpdateDate

update_date

LockingDate

locking_date

ClearingDate

clearing_date

ActionDate

action_date

Oid

oid

CustomerId

customer_id

CustomerStatus

customer_status

Text1

text1

Text2

text2

Text3

text3

CallerId

caller_id

ContractId

contract_id

EventTypeId

event_type_id

EventTypeName

event_type_name

PayoutLevel

payout_level

DefaultPayoutRate

default_payout_rate

PayoutGroup.Id

payout_group_id

PayoutGroup.Rank

payout_group_rank

PayoutGroup.PayoutRate

payout_group_payout_rate

PayoutGroup.Rules

payout_group_rules

SharedId

shared_id

ActionUri

action_uri

Uri

uri

Daasity-generated

_account_id

Daasity-generated

__integration_id

Daasity-generated

__synced_at

Daasity-generated

__shop_id

__sync_key

Actions

  • Update Method: UPSERT

  • Table Name: [impact_radius.actions]

JSON ElementDatabase Column

Id

id

CampaignId

campaign_id

CampaignName

campaign_name

ActionTrackerName

action_tracker_name

ActionTrackerId

action_tracker_id

EventCode

event_code

MediaPartnerId

media_partner_id

MediaPartnerName

media_partner_name

State

state

AdId

ad_id

ClientCost

client_cost

Payout

payout

DeltaPayout

delta_payout

IntendedPayout

intended_payout

Amount

amount

DeltaAmount

delta_amount

IntendedAmount

intended_amount

Currency

currency

ReferringDate

referring_date

EventDate

event_date

CreationDate

creation_date

LockingDate

locking_date

ClearedDate

cleared_date

ReferringType

referring_type

ReferringDomain

referring_domain

IpAddress

ip_address

PromoCode

promo_code

Oid

oid

CustomerId

customer_id

CustomerPostCode

customer_post_code

CustomerStatus

customer_status

Note

note

CallerId

caller_id

CustomerArea

customer_area

CustomerCity

customer_city

CustomerRegion

customer_region

CustomerCountry

customer_country

SharedId

shared_id

Uri

uri

Daasity-generated

_account_id

Daasity-generated

__integration_id

Daasity-generated

__synced_at

Daasity-generated

__shop_id

__sync_key

Ads

  • Endpoint: List all ads

  • Update Method: UPSERT

  • Table Name: [impact_radius.ads]

JSON ElementDatabase Column

Id

id

Name

name

Description

description

CampaignId

campaign_id

CampaignName

campaign_name

AdType

ad_type

LandingPage

landing_page

MobileFallbacks

mobile_fallbacks

CustomAdServingUrl

custom_ad_serving_url

AdCodeTemplate

ad_code_template

IabAdUnit

iab_ad_unit

ThirdPartyServableAdCreativeHeight

third_party_servable_ad_creative_height

ThirdPartyServableAdCreativeWidth

third_party_servable_ad_creative_width

BannerAlternativeTag

banner_alternative_tag

LinkText

link_text

CouponLinkName

coupon_link_name

CouponAllowCustomPromoCode

coupon_allow_custom_promo_code

GetHtmlCodeType

get_html_code_type

CustomisationCharge

customisation_charge

Labels

labels

AllowDeepLinking

allow_deep_linking

MobileReady

mobile_ready

PhoneTracking

phone_tracking

PromoCodeTracking

promo_code_tracking

Language

language

LimitedTimeStartDate

limited_time_start_date

LimitedTimeEndDate

limited_time_end_date

RestrictedMediaPartners

restricted_media_partners

RestrictedMediaPartnerGroups

restricted_media_partner_groups

Season

season

TopSeller

top_seller

DealId

deal_id

DealName

deal_name

DealDescription

deal_description

DealState

deal_state

DealType

deal_type

DealScope

deal_scope

DealProducts

deal_products

DealCategories

deal_categories

DiscountType

discount_type

DiscountAmount

discount_amount

DiscountCurrency

discount_currency

DiscountPercent

discount_percent

DiscountMaximumPercent

discount_maximum_percent

DiscountPercentRangeStart

discount_percent_range_start

DiscountPercentRangeEnd

discount_percent_range_end

Gift

gift

RebateAmount

rebate_amount

RebateCurrency

rebate_currency

DealDefaultPromoCode

deal_default_promo_code

MinimumPurchaseAmount

minimum_purchase_amount

MinimumPurchaseAmountCurrency

minimum_purchase_amount_currency

MaximumSavingsAmount

maximum_savings_amount

MaximumSavingsCurrency

maximum_savings_currency

BogoBuyQuantity

bogo_buy_quantity

BogoBuyScope

bogo_buy_scope

BogoBuyName

bogo_buy_name

BogoBuyImageUrl

bogo_buy_image_url

BogoGetQuantity

bogo_get_quantity

BogoGetScope

bogo_get_scope

BogoGetDiscountType

bogo_get_discount_type

BogoGetName

bogo_get_name

BogoGetImageUrl

bogo_get_image_url

BogoGetDiscountAmount

bogo_get_discount_amount

BogoGetDiscountCurrency

bogo_get_discount_currency

BogoGetDiscountPercent

bogo_get_discount_percent

PurchaseLimitQuantity

purchase_limit_quantity

DealStartDate

deal_start_date

DealEndDate

deal_end_date

SynchAdsPromoCodes

synch_ads_promo_codes

DealRestrictedMediaPartners

deal_restricted_media_partners

DealRestrictedMediaPartnerGroups

deal_restricted_media_partner_groups

Uri

uri

Daasity-generated

_account_id

Daasity-generated

__integration_id

Daasity-generated

__synced_at

Daasity-generated

__shop_id

__sync_key

Campaign Company Contacts

  • Update Method: UPSERT

  • Table Name: [impact_radius.campaign_company_contacts]

JSON ElementDatabase Column

CompanyContacts.FirstName

first_name

CompanyContacts.LastName

last_name

CompanyContacts.EmailAddress

email_address

CompanyContacts.PhoneNumber

phone_number

Id

campaign_id

Daasity-generated

_account_id

Daasity-generated

__integration_id

Daasity-generated

__synced_at

Daasity-generated

__shop_id

__sync_key

Campaigns

JSON ElementDatabase Column

Id

id

Name

name

State

state

Categories.PrimaryCategory

categories_primary_category

Categories.PrimarySubCategories

categories_primary_sub

Categories.AdditionalCategory

categories_additional_category

Categories.AdditionalSubCategories

categories_additional_sub

ShortDescription

short_description

LongDescription

long_description

ListInMarketplace

list_in_marketplace

DisplayServicingAgency

display_servicing_agency

Rating

rating

SearchKeywords

search_keywords

ShippingRegions

shipping_regions

Resources.CompanyHomepage

resources_company_homepage

Resources.ExampleLandingPage

resources_example_landing_page

Resources.InformationPage

resources_information_page

Resources.AdditionalRelatedLinks

resources_additional_related_links

GiftCardPayouts

gift_card_payouts

TrademarkBidding

trademark_bidding

ThirdPartyImpressionPixel

third_party_impression_pixel

MobileReadyAds

mobile_ready_ads

DisplayFutureAds

display_future_ads

PromoCodeTracking

promo_code_tracking

TrackingDomain

tracking_domain

SiteDefinition

site_definition

ImpressionTracking

impression_tracking

ViewThroughCrediting

view_through_crediting

IdentityMatching

identity_matching

GatewayTrackingSettings.DefaultLandingPage

gateway_tracking_settings_default_landing_page

GatewayTrackingSettings.MediaPartnerTrackingTemplate

gateway_tracking_settings_media_partner_template

GatewayTrackingSettings.CampaignTrackingTemplate

gateway_tracking_settings_campaign_template

GatewayTrackingSettings.SSLSupport

gateway_tracking_settings_ssl_support

GatewayTrackingSettings.DeepLinking

gateway_tracking_settings_deep_linking

GatewayTrackingSettings.DeepLinkDomains

gateway_tracking_settings_deep_link_domains

GatewayTrackingSettings.ThirdPartyGatewayUrl

gateway_tracking_settings_third_party_url

GatewayTrackingSettings.ThirdPartyGatewayQueryStringParameters

gateway_tracking_settings_third_party_query_string_parameters

GatewayTrackingSettings.UniqueClickWindowLength

gateway_tracking_settings_unique_click_window_length

GatewayTrackingSettings.UniqueClickWindowType

gateway_tracking_settings_unique_click_window_type

DirectTrackingSettings.UnidentifiedName

direct_tracking_settings_unidentified_name

DirectTrackingSettings.SessionWindowLength

direct_tracking_settings_session_window_length

Uri

uri

Daasity-generated

_account_id

Daasity-generated

__integration_id

Daasity-generated

__synced_at

Daasity-generated

__shop_id

__sync_key

Contact Accounts

  • Update Method: UPSERT

  • Table Name: [impact_radius.contact_accounts]

JSON ElementDatabase Column

Accounts.Id

id

Accounts.Name

name

Id

contact_id

Daasity-generated

_account_id

Daasity-generated

__integration_id

Daasity-generated

__synced_at

Daasity-generated

__shop_id

__sync_key

Contacts

JSON ElementDatabase Column

Id

id

FirstName

first_name

LastName

last_name

EmailAddress

email_address

Title

title

ProfileImage

profile_image

WorkPhoneNumberCountry

work_phone_number_country

WorkPhoneNumber

work_phone_number

CellphoneNumberCountry

cellphone_number_country

CellphoneNumber

cellphone_number

Editable

editable

Labels

labels

Uri

uri

Daasity-generated

_account_id

Daasity-generated

__integration_id

Daasity-generated

__synced_at

Daasity-generated

__shop_id

__sync_key

Contracts

JSON ElementDatabase Column

Id

id

PartnerId

partner_id

PartnerValue1

partner_value1

Status

status

StartDate

start_date

EndDate

end_date

BrandSignatory

brand_signatory

BrandSignatoryDate

brand_signatory_date

PartnerSignatory

partner_signatory

PartnerSignatoryDate

partner_signatory_date

DateCreated

date_created

DateLastUpdated

date_last_updated

TemplateTerms.TemplateId

template_terms_id

TemplateTerms.VersionId

template_terms_version_id

TemplateTerms.Name

template_terms_name

TemplateTerms.Labels

template_terms_labels

TemplateTerms.Currency

template_terms_currency

EventPayouts.EventPayouts

event_payouts

TemplateTerms.ChangeNotificationPeriod

template_terms_change_notification_period

TemplateTerms.ReturnPolicy

template_terms_return_policy

TemplateTerms.MaxReturnPercentage

template_terms_max_return_percentage

TemplateTerms.CustomCreativePayer

template_terms_custom_creative_payer

PdfUri

pdf_uri

Uri

uri

Daasity-generated

_account_id

Daasity-generated

__integration_id

Daasity-generated

__synced_at

Daasity-generated

__shop_id

__sync_key

Deals

  • Endpoint: List all deals

  • Update Method: UPSERT

  • Table Name: [impact_radius.deals]

JSON ElementDatabase Column

Id

id

Name

name

Description

description

CampaignId

campaign_id

State

state

Type

type

Scope

scope

Products.ProductName

product_name

Products.ProductImageUrl

product_image_url

Products.ProductBeforePriceAmount

product_before_price_amount

Products.ProductBeforePriceCurrency

product_before_price_currency

Products.ProductAfterPriceAmount

product_after_price_amount

Products.ProductAfterPriceCurrency

product_after_price_currency

Categories

categories

DiscountType

discount_type

DiscountAmount

discount_amount

DiscountCurrency

discount_currency

DiscountPercent

discount_percent

DiscountMaximumPercent

discount_maximum_percent

DiscountPercentRangeStart

discount_percent_range_start

DiscountPercentRangeEnd

discount_percent_range_end

Gift

gift

RebateAmount

rebate_amount

RebateCurrency

rebate_currency

DefaultPromoCode

default_promo_code

MinimumPurchaseAmount

minimum_purchase_amount

MinimumPurchaseAmountCurrency

minimum_purchase_amount_currency

MaximumSavingsAmount

maximum_savings_amount

MaximumSavingsCurrency

maximum_savings_currency

BogoBuyQuantity

bogo_buy_quantity

BogoBuyScope

bogo_buy_scope

BogoBuyName

bogo_buy_name

BogoBuyImageUrl

bogo_buy_image_url

BogoGetQuantity

bogo_get_quantity

BogoGetScope

bogo_get_scope

BogoGetDiscountType

bogo_get_discount_type

BogoGetName

bogo_get_name

BogoGetImageUrl

bogo_get_image_url

BogoGetDiscountAmount

bogo_get_discount_amount

BogoGetDiscountCurrency

bogo_get_discount_currency

BogoGetDiscountPercent

bogo_get_discount_percent

PurchaseLimitQuantity

purchase_limit_quantity

StartDate

start_date

EndDate

end_date

SynchAdsPromoCodes

synch_ads_promo_codes

RestrictedMediaPartners

restricted_media_partners

RestrictedMediaPartnerGroups

restricted_media_partner_groups

Uri

uri

Daasity-generated

_account_id

Daasity-generated

__integration_id

Daasity-generated

__synced_at

Daasity-generated

__shop_id

__sync_key

Exception List Action Trackers

JSON ElementDatabase Column

ActionTrackers.Id

action_trackers_id

ActionTrackers.Name

action_trackers_name

Id

exception_list_id

Daasity-generated

_account_id

Daasity-generated

__integration_id

Daasity-generated

__synced_at

Daasity-generated

__shop_id

__sync_key

Exception List Items

JSON ElementDatabase Column

Id

id

Value

value

Name

name

MatchMode

match_mode

ListId

list_id

CreatedDate

created_date

Uri

uri

Daasity-generated

_account_id

Daasity-generated

__integration_id

Daasity-generated

__synced_at

Daasity-generated

__shop_id

__sync_key

Exception Lists

JSON ElementDatabase Column

Id

id

Name

name

State

state

CampaignId

campaign_id

Type

type

CreatedDate

created_date

DeactivationDate

deactivation_date

NumberOfItems

number_of_items

ItemsUri

items_uri

Uri

uri

Daasity-generated

_account_id

Daasity-generated

__integration_id

Daasity-generated

__synced_at

Daasity-generated

__shop_id

__sync_key

Invoice Line Items

  • Update Method: UPSERT

  • Table Name: [impact_radius.invoice_line_items]

JSON ElementDatabase Column

LineItems.CampaignId

campaign_id

LineItems.CampaignName

campaign_name

LineItems.Description

description

LineItems.EventMonthYear

event_month_year

LineItems.Actions

actions

LineItems.NetItemAmount

net_item_amount

LineItems.VatItemAmount

vat_item_amount

LineItems.TotalItemAmount

total_item_amount

LineItems.Status

status

LineItems.DueDate

due_date

LineItems.PaidDate

paid_date

Id

invoice_id

Daasity-generated

_account_id

Daasity-generated

__integration_id

Daasity-generated

__synced_at

Daasity-generated

__shop_id

__sync_key

Invoices

JSON ElementDatabase Column

Id

id

CreatedDate

created_date

MediaId

media_id

MediaName

media_name

Currency

currency

TotalAmount

total_amount

TotalVatAmount

total_vat_amount

PDF

pdf

Uri

uri

Daasity-generated

_account_id

Daasity-generated

__integration_id

Daasity-generated

__synced_at

Daasity-generated

__shop_id

__sync_key

Partner Contacts

  • Update Method: UPSERT

  • Table Name: [impact_radius.partner_contacts]

JSON ElementDatabase Column

Contacts.FirstName

first_name

Contacts.LastName

last_name

Contacts.Labels

labels

Contacts.Email

email

Contacts.IsPrimary

is_primary

Id

partner_id

Daasity-generated

_account_id

Daasity-generated

__integration_id

Daasity-generated

__synced_at

Daasity-generated

__shop_id

__sync_key

Partner Group Media Partners

JSON ElementDatabase Column

MediaPartners.PartnerId

partner_id

MediaPartners.PartnerName

partner_name

MediaPartners.PartnerUri

partner_uri

GroupId

partner_group_id

Daasity-generated

_account_id

Daasity-generated

__integration_id

Daasity-generated

__synced_at

Daasity-generated

__shop_id

__sync_key

Partner Groups

JSON ElementDatabase Column

Groups.GroupId

group_id

Groups.GroupName

group_name

Id

partner_id

Daasity-generated

_account_id

Daasity-generated

__integration_id

Daasity-generated

__synced_at

Daasity-generated

__shop_id

__sync_key

Partner Phones

  • Update Method: UPSERT

  • Table Name: [impact_radius.partner_phones]

JSON ElementDatabase Column

Phones.Type

type

Phones.Country

country

Phones.Number

number

Id

partner_id

Daasity-generated

_account_id

Daasity-generated

__integration_id

Daasity-generated

__synced_at

Daasity-generated

__shop_id

__sync_key

Partner Programs

  • Update Method: UPSERT

  • Table Name: [impact_radius.partner_programs]

JSON ElementDatabase Column

Programs.Id

id

Programs.Name

name

Programs.ContractId

contract_id

Programs.ContractName

contract_name

Programs.JoinDate

join_date

Programs.ExpirationDate

expiration_date

Id

parnter_id

Daasity-generated

_account_id

Daasity-generated

__integration_id

Daasity-generated

__synced_at

Daasity-generated

__shop_id

__sync_key

Partner Promotional Methods

  • Update Method: UPSERT

  • Table Name: [impact_radius.partner_promotional_methods]

JSON ElementDatabase Column

PromotionalMethods.Type

type

PromotionalMethods.IsPrimary

is_primary

Id

partner_id

Daasity-generated

_account_id

Daasity-generated

__integration_id

Daasity-generated

__synced_at

Daasity-generated

__shop_id

__sync_key

Partner Properties

  • Update Method: UPSERT

  • Table Name: [impact_radius.partner_properties]

JSON ElementDatabase Column

Properties.Id

id

Properties.Name

name

Properties.Type

type

Properties.Platform

platform

Properties.Url

url

Properties.Doe

doe

Properties.Dlu

dlu

Id

partner_id

Daasity-generated

_account_id

Daasity-generated

__integration_id

Daasity-generated