Daasity Knowledge Base
Daasity Knowledge Base
  • Start here
    • Daasity Overview
    • Important Concepts
      • Attribution Overview
      • What is a Daasity Valid Order?
      • Customer Householding
      • Timezones in Daasity
      • Ecommerce Glossary
      • Daasity Data Security Overview
    • Retail Analytics 101
      • Understanding the Basics: POS Data 101
      • How to use Syndicated Data
    • Product Changelog
    • Feature Requests
  • 🔌Extract
    • Extract your data with Daasity
    • All Integrations
      • Alchemer
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Algolia
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Amazon Advertising
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Where to Find Your Data
      • Amazon Seller Central
        • Validating Your Amazon Data in Daasity
          • Comparing Your Amazon Seller Central Orders to Daasity
        • Integration Setup
          • Configure Amazon Reports
          • Monitor Amazon Reports
        • Integration Specifications
          • Orders API
          • FBA Customer Concessions Reports
          • FBA Sales Reports
          • FBA Inventory Reports
          • FBA Removals Reports
          • Inventory Reports
          • Order Tracking Reports
          • Performance Reports
          • Returns Reports
          • Settlement Reports
          • Seller Retail Analytics Reports
        • Workflow Configuration Setup
          • Orders API
          • FBA Customer Concession Reports
          • FBA Inventory Reports
          • Performance Reports
          • FBA Sales Reports
          • FBA Removal Reports
          • Inventory Reports
          • Order Tracking Reports
          • Returns Reports
          • Seller Retail Analytics Reports
          • Settlement Reports
        • Transformation Configuration Setup
          • Orders API
          • FBA Customer Concessions Reports
          • FBA Inventory Reports
          • Performance Reports
          • FBA Sales Reports
          • FBA Removals Reports
          • Inventory Reports
          • Order Tracking Reports
          • Returns Reports
          • Seller Retail Analytics Reports
          • Settlement Reports
      • Amazon Vendor Central
        • Integration Setup
        • Integration Specifications
        • How to use
        • ASIN Mapping Configuration Setup
        • Workflow Configuration Setup
        • Transformation Configuration Setup
          • Vendor Sales & Inventory Report
          • Vendor Traffic Report
      • AppLovin
        • Integration Setup
      • Attentive Mobile
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Azure SQL Database
      • Back In Stock
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Big Commerce
        • Integration Setup
          • Connect Daasity From BigCommerce Marketplace
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • BigQuery Datasource
      • Bing Ads
        • Integration Setup
        • Integration Specifications
      • Circana
        • Integration Setup
        • Integration Specifications
        • Data Release Calendar
        • H-E-B Circana
      • Cordial
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Criteo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • D​ata File (CSV, XLS)
      • Emplifi
        • Integration Specifications
      • Extensiv (Skubana)
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Facebook Ads
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Where to Find Your Data
      • Fairing V2
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Important Notes
      • Google Ads
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Google Analytics 4
        • API vs BigQuery
        • API Integration
          • Integration Setup
          • Integration Specifications
          • Workflow Configuration Setup
          • Transformation Configuration Instructions
          • Custom Reports
          • Validating GA4 Data in Daasity
          • Blending Universal Analytics & GA4 Data
        • BigQuery integration
          • Integration Setup
          • Integration Specifications
          • Workflow Configuration Setup
          • Transformation Configuration Instructions
          • Important Notes
          • Creating a Custom Report
      • Google Sheet
      • Gorgias
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Impact Radius (Beta)
        • Integration Specifications
      • Iterable
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Klaviyo Summary Statistics
        • Integration Setup
        • Integration Specifications
      • Klaviyo V2
        • Integration Setup
        • Integration Specifications
      • KnoCommerce
        • Integration Setup
        • Integration Specifications
      • Loop Returns
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Microsoft SQL Server Database
      • Mongo Database
      • MySQL Database
      • Narvar
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • NetSuite
      • Newstore
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Northbeam
        • Integration Setup
      • Okendo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Ometria
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Order Desk
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Pepperjam
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Pinterest
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Postgres Database
      • Postscript (beta)
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Recharge
        • Integration Setup
        • Integration Specifications
        • Integration Specifications (2021-11 Beta)
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Recharge Data and Known Discrepancies
      • Retail Next
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Rockerbox
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Salesforce Commerce Cloud
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • SFTP
      • ShipBob
        • Integration Setup
        • Integration Specifications
      • Shipstation
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Shopify
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Shopify B2B Data
      • SKIO
        • Integration Setup
        • Integration Specifications
      • Snapchat
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • SPINS
        • Integration Setup
        • Integration Specifications
        • How to Use
        • Data Release Calendar
      • Stay Ai
        • Integration Setup
        • Integration Specifications
      • Target Plus
        • Integration Setup
      • Thankful
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • TikTok
        • Integration Setup
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Walmart Marketplace
        • Integration Setup
        • Integration Specifications
      • Whole Foods Market
        • Integration Setup
        • Integration Specifications
        • How to use
      • Yotpo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Zendesk
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
    • Brand Supplied Data (BSD)
      • BSD Overview
      • Monitoring Your BSD Progress
      • Revenue Plan
      • Marketing Budget
      • Marketing Spend
      • RFM Values
      • Shipping & Fulfillment Cost
      • SKU Hierarchy
      • SKU Mapping
      • SKU Cost
      • Discount Code Mapping
      • Other Order Sources
      • Channel Mapping
        • Overview & Setup
        • Filling out Channel Mapping
        • Missing from GA & Missing from BSD
      • Configuration
  • 📊VISUALIZE
    • Dashboards
      • Dashboard Overview
      • Standard Dashboards
        • Daasity 101 Overview Dashboards
          • Flashes
          • Shopify Sales Report
          • Account Health
        • Digital Product & Revenue
          • Orders and Revenue
          • Amazon Settlement Report
          • Product Repurchase Rate
          • Product
            • Product Dimensions
              • Why is a Product Name NULL?
          • Inventory
          • Operations
            • Fulfilment Status Options
        • Retention Marketing Dashboards
          • Notifications (Email/SMS)
          • Retention
          • Customer Performance (Email/SMS)
          • Site Funnels
        • Acquisition Marketing Dashboards
          • Attribution Deep Dive
            • Marketing Attribution
              • Attribution Overview
              • Survey-Based Attribution
              • Discount Code Attribution
              • First Click, Last Click, and Assisted Attribution
              • Custom Attribution
              • Vendor-Reported Attribution
              • CPO, CPA, and CAC
              • Missing from GA & Missing from BSD
          • LTV & RFM
            • RFM
              • RFM in the Daasity App
              • Understanding RFM
              • Time on Books (TOB)
          • Marketing
          • Vendor-Reported Marketing Performance
          • Site Analytics & Attribution
      • Integration Dashboards
        • Amazon All Orders Report
        • Amazon Seller Central Business Reports
        • Gorgias
        • Klaviyo Campaign & Flow Performance
        • Loop Returns
        • Okendo Reviews
        • ShipBob
        • Shipstation
        • Subscription
        • Walmart Marketplace Account Sales Report
        • Yotpo
    • Explores
      • Explore Overview
      • Order Line Revenue vs. Transactional Sales Report
      • How to Access An Explore
      • Standard Daasity Explores
        • Current Inventory Level Explore
        • Customer Details Explore
        • Daily Company Metrics Explore
        • Daily Marketing Plan To Actual Marketing Performance Explore
        • Daily Plan to Actual Explore
        • Lifetime Value Explore
        • Marketing Attribution Explore
        • Multi-Channel Transaction Explore
        • Order and Order Line Revenue Explore
        • Product Page Explore
        • Shopping Stage Explore
        • SKU Level Repurchase Rates Explore
        • Traffic Explore
        • Transactional Sales Report Explore
        • UA vs G4 Explore
      • Integration Explores
        • Algolia
        • Amazon Settlement Explore
        • Fairing Survey Responses Explore
        • Gorgias Tickets Explore
        • Loop Returns Explore
        • Okendo Reviews Explore
        • Subscribers and Subscription Monthly Churn Rates Explores (Recharge)
        • Shipstation Explore
        • Yotpo
        • Zen Desk
    • Looker Guides
      • Building visualizations
      • Working with date dimensions & filters
      • Schedule a Report or Dashboard
      • Exporting Data
    • Looker Guides (Developer)
      • Daasity Hub & Spoke Introduction
      • Hub & Spoke File Structure
      • Working with LookML Dashboards
      • Customizing Base Daasity Code
    • Visualize using other BI tools
  • 🔀Transform
    • Transforming Data with Daasity
    • Daasity Data Models
      • Daasity Data Model Overview
      • Unified Data Schemas
        • Unified Schema Introduction
        • Unified Order Schema (UOS)
        • Unified Notification Schema (UNS)
        • Unified Subscription Schema (USS)
        • Unified Marketing Schema (UMS)
        • Unified Traffic Schema (UTS)
        • Unified Wholesale Schema (UWS)
      • Data Mart Models
        • Data Mart Introduction
        • Data Reporting Platform (DRP)
        • Channel Attribution Data Mart
        • Marketing Data Mart
      • Transform Code
        • Transform Code Introduction
        • Transform Code Sequence - DRP
        • Initialization Code
        • Householding Code
        • Order Status Code
        • Order Channel and Marketing Code
        • Daily Plan Code
        • Order and Order Line Revenue
        • Plan to Actual Code
        • Customer Code
        • Subscription Code
        • Reviews
        • Life-Time Value Code
        • Returns
        • Product and Inventory Code
        • Email & SMS
        • Transform Code Sequence - Data Mart
        • Unified Order Schema (UOS) Code
        • Unified Marketing Schema (UMS) Code
        • Unified Notification Schema (UNS)
        • Channel Attribution Data Mart Code
        • Marketing Data Mart Code
      • Source to Final Destination
    • Code Repository
      • Code Repository Overview
      • Getting Access to Your Code Repository
      • Code Repository Branches
      • Custom SQL Code
      • Custom Script Manifest Files
    • Script Manifest (YAML) Files
  • 🎵Data Orchestration
    • Workflows
      • Getting Started with Workflows
      • Creating Workflows
      • Managing Workflows
      • Workflow Metrics
    • Notifications
      • Introduction to Notifications
      • Enabling Notification Emails
      • Notifications UI
      • Managing Notifications
      • Authorization List
  • Audiences
    • Audiences Overview
    • Pushing Audience Data to Targets
      • Targets Overview
      • Attentive
        • Events Target
        • Subscribers Target
        • Target Endpoint Documentation
      • Facebook Ads
        • Facebook Target
        • Target Endpoint Documentation
      • Google Ads
        • Google Ads Target
        • Target Endpoint Documentation
      • Klaviyo
        • Events Target
        • Profiles Target
        • Target Endpoint Documentation
      • Sailthru
        • Events Target
        • Users Target
        • Target Endpoint Documentation
      • Tiktok Ads
        • TikTok Target
        • Target Endpoint Documentation
    • Building Audiences
  • warehouse
    • BigQuery
    • Redshift
    • Snowflake
    • Test Data Warehouse
      • Test Data Warehouse Overview
      • Create a Snowflake Test Warehouse
      • Create a Redshift Test Warehouse
  • —
    • Go to Daasity App
    • Contact Support
    • ✍️Feature Requests
Powered by GitBook
On this page
  • Integration Overview
  • Integration Availability
  • API Endpoints
  • Impact Radius Schema
  • Accounts
  • Action Inquiries
  • Action Inquiry Comments
  • Action Items
  • Action Updates
  • Actions
  • Ads
  • Campaign Company Contacts
  • Campaigns
  • Contact Accounts
  • Contacts
  • Contracts
  • Deals
  • Exception List Action Trackers
  • Exception List Items
  • Exception Lists
  • Invoice Line Items
  • Invoices
  • Partner Contacts
  • Partner Group Media Partners
  • Partner Groups
  • Partner Phones
  • Partner Programs
  • Partner Promotional Methods
  • Partner Properties
  • Partners
  • Promo Codes
  • Users

Was this helpful?

  1. Extract
  2. All Integrations
  3. Impact Radius (Beta)

Integration Specifications

PreviousImpact Radius (Beta)NextIterable

Last updated 1 year ago

Was this helpful?

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 . 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

  • Update Method: UPSERT

  • Table Name: [impact_radius.accounts]

JSON Element
Database 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

  • Update Method: UPSERT

  • Table Name: [impact_radius.action_inquiries]

JSON Element
Database 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

  • Update Method: UPSERT

  • Table Name: [impact_radius.action_inquiry_comments]

JSON Element
Database 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

  • Update Method: UPSERT

  • Table Name: [impact_radius.action_items]

JSON Element
Database 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

  • Update Method: UPSERT

  • Table Name: [impact_radius.action_updates]

JSON Element
Database 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 Element
Database 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

  • Update Method: UPSERT

  • Table Name: [impact_radius.ads]

JSON Element
Database 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 Element
Database 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

  • Update Method: UPSERT

  • Table Name: [impact_radius.campaigns]

JSON Element
Database 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 Element
Database 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

  • Update Method: UPSERT

  • Table Name: [impact_radius.contacts]

JSON Element
Database 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

  • Update Method: UPSERT

  • Table Name: [impact_radius.contracts]

JSON Element
Database 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

  • Update Method: UPSERT

  • Table Name: [impact_radius.deals]

JSON Element
Database 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

  • Update Method: UPSERT

  • Table Name: [impact_radius.exception_list_action_trackers]

JSON Element
Database 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

  • Update Method: UPSERT

  • Table Name: [impact_radius.exception_list_items]

JSON Element
Database 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

  • Update Method: UPSERT

  • Table Name: [impact_radius.exception_lists]

JSON Element
Database 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 Element
Database 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

  • Update Method: UPSERT

  • Table Name: [impact_radius.invoices]

JSON Element
Database 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 Element
Database 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

  • Update Method: UPSERT

  • Table Name: [impact_radius.partner_group_media_partners]

JSON Element
Database 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

  • Update Method: UPSERT

  • Table Name: [impact_radius.partner_groups]

JSON Element
Database 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 Element
Database 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 Element
Database 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 Element
Database 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 Element
Database 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

__synced_at

Daasity-generated

__shop_id

__sync_key

Partners

  • Update Method: UPSERT

  • Table Name: [impact_radius.partners]

JSON Element
Database Column

Id

id

Name

name

Description

description

Website

website

State

state

Address.Country

address_country

Address.Address1

address_address1

Address.Address2

address_address2

Address.City

address_city

Address.State

address_state

Address.PostalCode

address_postal_code

Phone.Country

phone_country

Phone.Number

phone_number

Currency

currency

Timezone

timezone

IndirectTax.Country

indirect_tax_country

IndirectTax.Number

indirect_tax_number

PartnerType

partner_type

PromotionalCountries

promotional_countries

PromotionalCategories

promotional_categories

LinkedAccounts

linked_accounts

PartnerValues.Value1

partner_values_value1

PartnerValues.Value2

partner_values_value2

PartnerValues.Value3

partner_values_value3

AccountManager

account_manager

DateCreated

date_created

DateLastUpdated

date_last_updated

CreatedBy

created_by

LastUpdatedBy

last_updated_by

Uri

uri

Daasity-generated

_account_id

Daasity-generated

__integration_id

Daasity-generated

__synced_at

Daasity-generated

__shop_id

__sync_key

Promo Codes

  • Update Method: UPSERT

  • Table Name: [impact_radius.promo_codes]

JSON Element
Database Column

Id

id

Code

code

Type

type

CreditPolicy

credit_policy

CampaignId

campaign_id

CampaignName

campaign_name

AssignedPartnerId

assigned_partner_id

AssignedPartnerName

assigned_partner_name

CreatedDate

created_date

StartDate

start_date

EndDate

end_date

State

state

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

Users

  • Update Method: UPSERT

  • Table Name: [impact_radius.users]

JSON Element
Database Column

Id

id

FirstName

first_name

LastName

last_name

Username

username

Type

type

State

state

Language

language

ProductRoles.Product

product

ProductRoles.AccessibleCampaigns

accessible_campaigns

ProductRoles.Role

role

JoinedDate

joined_date

DateLastUpdated

date_last_updated

LastUpdatedBy

last_updated_by

CreatedBy

created_by

Uri

uri

Daasity-generated

_account_id

Daasity-generated

__integration_id

Daasity-generated

__synced_at

Daasity-generated

__shop_id

__sync_key

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

🔌
this API documentation
Retrieve an account
List all actions
List all action inquiries
List all action items
List all action updates
List all ads
List all campaigns
List all contacts
List all deals
List all exception lists
List all exception list items
List all invoices
List all partners
List all partner groups
List all promo codes
List all users
Retrieve an account
List all action inquiries
List all action inquiries
List all action items
List all action updates
List all actions
List all ads
List all campaigns
List all campaigns
List all contacts
List all contacts
List all contracts
List all deals
List all exception lists
List all exception list items
List all exception lists
List all invoices
List all invoices
List all partners
List all partner groups
List all partner groups
List all partners
List all partners
List all partners
List all partners
List all partners
List all promo codes
List all users
Accounts
Account Inquiries
Account Inquiry Comments
Action Items
Action Updates
Actions
Ads
Campaign Company Contacts
Campaigns
Contact Accounts
Contacts
Contracts
Deals
Exception List Action Trackers
Exception List Items
Exception Lists
Invoice Line Items
Invoices
Partner Contacts
Partner Group Media Partners
Partner Groups
Partner Phones
Partner Programs
Partner Promotional Methods
Partner Properties
Partners
Promo Codes
Users