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 |
- 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.
- 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
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
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
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:
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 |
Last modified 6mo ago