Impact

Impact ETL connector for data replication

Snapshot

Features	Details
Release Status	Released
Source API Version	v10.0
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	Impact Client SID Impact Client Token/Secret
Replication Type	Key based Replication Full Replication
Replication Key	DATE NA
Suggested Replication Frequency	24 hrs

Tables/APIs Supported
Ads	Campaigns
Deals	Partners
Invoices	Phonenumbers

Integrate Impact with Daton

1. Signin to Daton

2. Select Impact from Integrations page

3. Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. Provide your impact client sid and impact client secret/token.

5. After providing the details to authorize Daton to periodically extract data from Impact.

6. Post successful authentication you will be prompted to choose from the list of available tables

7. Then select all required fields for each table

8. Submit the integration.

Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

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