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.

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

Source API Documentation: https://integrations.impact.com/impact-brand/reference/list-all-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

Source API Documentation: https://integrations.impact.com/impact-brand/reference/list-all-campaigns

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

Source API Documentation: https://integrations.impact.com/impact-brand/reference/list-all-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

Source API Documentation: https://integrations.impact.com/impact-brand/reference/list-all-invoices

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

Source API Documentation: https://integrations.impact.com/impact-brand/reference/list-all-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:

Source API Documentation: https://integrations.impact.com/impact-brand/reference/list-all-phone-numbers

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

Table of Contents

Tables/APIs Impact Data

Schema Information of Impact Connector

Saras Pulse

Saras Daton