Schema Information of Impact Connector

This topic provides a structured reference to assist you in working with Daton's Impact connector and the associated fields and tables.

Need help with something?

Talk to data expert

Schema Information of Impact Connector

This topic provides a structured reference to assist you in working with Daton's Impact connector and the associated fields and tables.

Tables/APIs

The following is the list of tables or APIs associated with the Impact connector:
  • Ads
  • Campaigns
  • Deals
  • Partners
  • Invoices
  • Phonenumbers

Impact Data

Ads
 
Purpose: Lists all existing Ads
 
Replication: Full-Based Replication
 
Replication Key: NA
 
Fields
NAME
TARGET DATATYPE
Id
STRING
Name
STRING
Description
STRING
CampaignId
STRING
CampaignName
STRING
Type
STRING
TrackingLink
STRING
LandingPageUrl
STRING
AdvertiserId
STRING
AdvertiserName
STRING
Code
STRING
IFrameCode
STRING
Width
STRING
Height
STRING
CreativeUrl
STRING
Labels
STRING
AllowDeepLinking
STRING
MobileReady
STRING
Language
STRING
StartDate
TIMESTAMP
EndDate
STRING
Season
STRING
TopSeller
STRING
SubjectLines
STRING
FromAddresses
STRING
UnsubscribeLink
STRING
DealId
STRING
DealName
STRING
DealDescription
STRING
DealState
STRING
DealType
STRING
DealScope
STRING
DealCategories
STRING
DiscountType
STRING
DiscountAmount
STRING
DiscountCurrency
STRING
DiscountPercent
STRING
DiscountMaximumPercent
STRING
DiscountPercentRangeStart
STRING
DiscountPercentRangeEnd
STRING
Gift
STRING
RebateAmount
STRING
RebateCurrency
STRING
DealDefaultPromoCode
STRING
MinimumPurchaseAmount
STRING
MinimumPurchaseAmountCurrency
STRING
MaximumSavingsAmount
STRING
MaximumSavingsCurrency
STRING
BogoBuyQuantity
STRING
BogoBuyScope
STRING
BogoBuyName
STRING
BogoBuyImageUrl
STRING
BogoGetQuantity
STRING
BogoGetScope
STRING
BogoGetDiscountType
STRING
BogoGetName
STRING
BogoGetImageUrl
STRING
BogoGetDiscountAmount
STRING
BogoGetDiscountCurrency
STRING
BogoGetDiscountPercent
STRING
PurchaseLimitQuantity
STRING
DealStartDate
STRING
DealEndDate
STRING
Uri
STRING
AdType
STRING
LandingPage
STRING
CustomAdServingUrl
STRING
AdCodeTemplate
STRING
IabAdUnit
STRING
ThirdPartyServableAdCreativeHeight
STRING
ThirdPartyServableAdCreativeWidth
STRING
BannerAlternativeTag
STRING
LinkText
STRING
CouponLinkName
STRING
CouponAllowCustomPromoCode
STRING
GetHtmlCodeType
STRING
CustomisationCharge
STRING
PhoneTracking
STRING
PromoCodeTracking
STRING
LimitedTimeStartDate
TIMESTAMP
LimitedTimeEndDate
STRING
SynchAdsPromoCodes
STRING
Campaigns
 
Purpose: List of the campagins for your account
 
Replication: Full-Based Replication
 
Replication Key: NA
 
Fields
NAME
TARGET DATATYPE
Id
STRING
Name
STRING
State
STRING
Categories
RECORD
ShortDescription
STRING
LongDescription
STRING
ListInMarketplace
STRING
DisplayServicingAgency
STRING
Rating
STRING
SearchKeywords
STRING
ShippingRegions
STRING
Resources
RECORD
CompanyContacts
RECORD
GiftCardPayouts
STRING
TrademarkBidding
STRING
ThirdPartyImpressionPixel
STRING
MobileReadyAds
STRING
DisplayFutureAds
STRING
PromoCodeTracking
STRING
TrackingDomain
STRING
SiteDefinition
STRING
ImpressionTracking
STRING
ViewThroughCrediting
STRING
IdentityMatching
STRING
GatewayTrackingSettings
RECORD
DirectTrackingSettings
RECORD
Uri
STRING
Deals
 
Purpose: Use this endpoint to get a complete list of all your deals
 
Replication: Full-Based Replication
 
Replication Key: NA
 
Fields
NAME
TARGET DATATYPE
Id
STRING
Name
STRING
Description
STRING
CampaignId
STRING
State
STRING
Type
STRING
Scope
STRING
Products
RECORD
Categories
STRING
DiscountType
STRING
DiscountAmount
STRING
DiscountCurrency
STRING
DiscountPercent
STRING
DiscountMaximumPercent
STRING
DiscountPercentRangeStart
STRING
DiscountPercentRangeEnd
STRING
Gift
STRING
RebateAmount
STRING
RebateCurrency
STRING
DefaultPromoCode
STRING
MinimumPurchaseAmount
STRING
MinimumPurchaseAmountCurrency
STRING
MaximumSavingsAmount
STRING
MaximumSavingsCurrency
STRING
BogoBuyQuantity
STRING
BogoBuyScope
STRING
BogoBuyName
STRING
BogoBuyImageUrl
STRING
BogoGetQuantity
STRING
BogoGetScope
STRING
BogoGetDiscountType
STRING
BogoGetName
STRING
BogoGetImageUrl
STRING
BogoGetDiscountAmount
STRING
BogoGetDiscountCurrency
STRING
BogoGetDiscountPercent
STRING
PurchaseLimitQuantity
STRING
StartDate
STRING
EndDate
STRING
SynchAdsPromoCodes
STRING
Uri
STRING
Invoices
 
Purpose: Returns the invoices of all the transactions
 
Replication: Key-based Replication
 
Replication Key: LastDateRun
 
Fields
NAME
TARGET DATATYPE
Id
STRING
CreatedDate
TIMESTAMP
RecipientId
STRING
RecipientName
STRING
Currency
STRING
TotalAmount
STRING
LineItems
RECORD
PDF
STRING
Uri
STRING
MediaId
STRING
MediaName
STRING
TotalVatAmount
STRING
Partners
 
Purpose: List of all your partners
 
Replication: Full Based Replication
 
Replication Key: NA
 
Fields
NAME
DATATYPE
Id
STRING
Name
STRING
Description
STRING
Website
STRING
State
STRING
Address
RECORD
Phone
RECORD
Currency
STRING
Timezone
STRING
IndirectTax
RECORD
PartnerType
STRING
PromotionalMethods
RECORD
Properties
RECORD
PromotionalCategories
STRING
Programs
RECORD
Contacts
RECORD
PartnerValues
RECORD
AccountManager
STRING
DateCreated
TIMESTAMP
DateLastUpdated
TIMESTAMP
CreatedBy
STRING
LastUpdatedBy
STRING
Uri
STRING
PromotionalCountries
STRING
Phonenumbers
 
Purpose:
 
Replication: Full Based Replication
 
Replication Key: NA
 
Fields
fullname
type
Id
STRING
Country
STRING
Number
STRING
InternationalNumber
STRING
DateCreated
STRING
LastDateAssigned
TIMESTAMP
LastDateReleased
TIMESTAMP
Uri
STRING
 
connector info impact schema

Related Articles

Table of Contents

Tables/APIs Impact Data