Optimove
Optimove ETL connector for data replication
Last updated
Optimove ETL connector for data replication
Last updated
Signin to Daton
Select Optimove from Integrations page
Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later
Provide Optimove Base URI, Username, Password for authentication and authorize Daton to periodically extract data from Optimove
Post successful authentication, you will be prompted to choose from the list of available tables
Then select all required fields for each table
Submit the integration
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
Users would be able to edit/pause/re-activate/delete integration anytime
Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
CustomerAttribute
Purpose: Fetch the customer details like name, age address
Source API Documentation https://docs.optimove.com/api-usage-guide/#Model-related_Functions_GetCustomerAttributeList
Replication: Full Replication
Replication Key: NA
Fields
LifecycleStageList
Purpose: Fetch the details of all life cycles stages pertain to a customer
Source API Documentation https://docs.optimove.com/api-usage-guide/#Model-related_Functions_GetLifecycleStageList
Replication: Full Replication
Replication Key: NA
Fields
MicroSegmentList
Purpose: Fetch the all details of microsement pertaint to a customer
Source API Documentation https://docs.optimove.com/api-usage-guide/#Model-related_Functions_GetMicrosegmentList
Replication: Full Replication
Replication Key: NA
Fields
MicroSegmentChangers
Purpose: Fetch the details of customers who changed their microsegment, along with previous microsegment details and last date for fetched data.
Source API Documentation https://docs.optimove.com/api-usage-guide/#Model-related_Functions_GetMicrosegmentChangers
Replication: Full Replication
Replication Key: NA
Fields
AllActions
Purpose: Fetch the details of actions names and their IDs
Source API Documentation https://docs.optimove.com/api-usage-guide/#GetAllActions
Replication: Full Replication Replication Key: NA
Fields
ActionsByTargetGroup
Purpose: Fetch the details of recipent group and actions associated with particular target group of a particular date
Source API Documentation https://docs.optimove.com/api-usage-guide/#GetActionsByTargetGroup
Replication: Key-Based Replication
Replication Key: date
Fields
Promocodes
Purpose: Fetch the details of target group’s , action’s and their promocodes of a particular date
Source API Documentation https://docs.optimove.com/api-usage-guide/#Action-related_Functions_GetPromoCodes
Replication: Key-Based Replication
Replication Key: date
Fields
PromocodesByCampaign
Purpose: Fetch the details of recipient group’s , action’s and their promocodes of a particular campaign
Source API Documentation https://docs.optimove.com/api-usage-guide/#Action-related_Functions_GetPromoCodesByCampaign
Replication: Key-Based Replication
Replication Key: campaignid
Fields
PromocodesByTargetGroup
Purpose: Fetch the details of all recipient group IDs, action IDs and promo codes associated with a given target group on a particular date
Source API Documentation https://docs.optimove.com/api-usage-guide/#Action-related_Functions_GetPromoCodesByTargetGroup
Replication: Key-Based Replication
Replication Key: date
Fields
ActionDetailsByTargetGroup
Purpose: Fetch the details of action and their duration(in days & in days) and the execution channels associated with a given target group on a particular date
Source API Documentation https://docs.optimove.com/api-usage-guide/#Action-related_Functions_GetActionDetailsByTargetGroup
Replication: Key-Based Replication
Replication Key: date
Fields
ExecutedCampaignDetails
Purpose: Fetch the details of all campaign that were executed in a particular date.
Source API Documentation https://docs.optimove.com/api-usage-guide/#Action-related_Functions_GetExecutedCampaignDetails
Replication: Key-Based Replication
Replication Key: date
Fields
CampaignDetails
Purpose: Fetch the details of particular campaign details
Source API Documentation https://docs.optimove.com/api-usage-guide/#Action-related_Functions_GetCampaignDetails
Replication: Key-Based Replication
Replication Key: campaignid
Fields
ExecutionChannels
Purpose: Fetch the details of all executable channels.
Source API Documentation https://docs.optimove.com/api-usage-guide/#Action-related_Functions_GetExecutionChannels
Replication: Full Replication
Replication Key: NA
Fields
ExecutedCampaignChannelDetails
Purpose: Fetch the details of a particular campaign exceuted on particular channel
Source API Documentation https://docs.optimove.com/api-usage-guide/#Action-related_Functions_GetExecutedCampaignChannelDetails
Replication: Key-Based Replication
Replication Key: campaignid, channelid
Fields
ExecutedCampaignsByChannel
Purpose: Fetch the details of campaigns executed for a particular channel on particular date.
Source API Documentation https://docs.optimove.com/api-usage-guide/#Action-related_Functions_GetExecutedCampaignsByChannel
Replication: Key-Based Replication
Replication Key: date
Fields
TargetGroupByDate
Purpose: Fetch the details of a group for which the actions were performed on particular date.
Source API Documentation https://docs.optimove.com/api-usage-guide/#Target_Group-related_Functions_GetTargetGroupsByDate
Replication: Key-Based Replication
Replication Key: date
Fields
TargetGroupDetails
Purpose: Fetch the details of all target groups
Source API Documentation https://docs.optimove.com/api-usage-guide/#Target_Group-related_Functions_GetTargetGroupDetails
Replication: Full Replication
Replication Key: NA
Fields
CustomerActionsByTargetGroup
Purpose: Fetch the details of customers and their marketing actions on a particular group on a particular date.
Source API Documentation https://docs.optimove.com/api-usage-guide/#GetCustomerActionsByTargetGroup
Replication: Key-Based Replication
Replication Key: date
Fields
CustomerOnetimeActionsByDate
Purpose: Fetch the details of customers and their marketing actions as a part of one time campaign on a particular group on a particular date.
Source API Documentation https://docs.optimove.com/api-usage-guide/#GetCustomerOneTimeActionsByDate
Replication: Key-Based Replication
Replication Key: date
Fields
CustomerOnetimeActionsByCampaign
Purpose: Fetch the details of customers and the details associated with a particular one-time campaign.
Source API Documentation https://docs.optimove.com/api-usage-guide/#GetCustomerOneTimeActionsByCampaign
Replication: Key-Based Replication
Replication Key: campaignid
Fields
CustomerFutureValues
Purpose: Fetch the details of future customers and their future values.
Source API Documentation https://docs.optimove.com/api-usage-guide/#GetCustomerFutureValues
Replication: Full Replication
Replication Key: NA
Fields
CustomerLastActionExecuted
Purpose: Fetch the details of last action executed for a particular customer.
Source API Documentation https://docs.optimove.com/api-usage-guide/#GetCustomerLastActionExecuted
Replication: Full Replication
Replication Key: NA
Fields
CustomerActionDetailsByDate
Purpose: Fetch the details of customer IDs and details of the campaigns sent to them on a particular date.
Source API Documentation https://docs.optimove.com/api-usage-guide/#GetCustomerActionDetailsByDate
Replication: Key-Based Replication
Replication Key: date
Fields
CustomersActionEndedByDate
Purpose: Fetch the details of customer IDs and details of the campaigns they received, for action durations which ended on a particular date.
Source API Documentation https://docs.optimove.com/api-usage-guide/#GetCustomersActionEndedByDate
Replication: Key-Based Replication
Replication Key: date
Fields
CustomersSendFDetailsByCampaign
Purpose: Fetch the details of all customers and channels and their send times and channel send details for a particular campaign.
Source API Documentation https://docs.optimove.com/api-usage-guide/#Customer-related_Functions_GetCustomerSendDetailsByCampaign
Replication: Key-Based Replication
Replication Key: campaignid
Fields
CustomerExecutionDetailsByCampaign
Purpose: Fetch the details of all customers and the details associated with each customer for a particular campaign.
Source API Documentation https://docs.optimove.com/api-usage-guide/#Customer-related_Functions_GetCustomerExecutionDetailsByCampaign
Replication: Key-Based Replication
Replication Key: campaignid
Fields
ProcessedCampaignCustomers
Purpose: Fetch the details od all customers and associated promotion codes for a particular campaign
Source API Documentation https://docs.optimove.com/api-usage-guide/#Customer-related_Functions_GetProcessedCampaignCustomers
Replication: Key-Based Replication
Replication Key: campaignid
Fields
CurrentlyTargetedCustomers
Purpose: Fetch the details of customers and who are currently included in one or more campaigns
Source API Documentation https://docs.optimove.com/api-usage-guide/#Customer-related_Functions_GetCurrentlyTargetedCustomers
Replication: Full Replication
Replication Key: NA
Fields
CanceledCampaignCustomers
Purpose: Fetch the details of customers who’s campaignes were cancelled along with the associated actions and promo codes.
Source API Documentation https://docs.optimove.com/api-usage-guide/#Customer-related_Functions_GetCanceledCampaignCustomers
Replication: Full Replication
Replication Key: NA
Fields
CustomerProductDetailsByCampaign
Purpose: Fetch the details of customers and recommended products for each customer targeted by a particular product recommendation campaign
Source API Documentation https://docs.optimove.com/api-usage-guide/#Customer-related_Functions_GetCustomerProductDetailsByCampaign
Replication: Full Replication
Replication Key: NA
Fields
CustomerProductDetailsByDate
Purpose: Fetch the details of customers and recommended products for each customer targeted by any product recommendation campaign on a particular date.
Source API Documentation https://docs.optimove.com/api-usage-guide/#Customer-related_Functions_GetCustomerProductDetailsByDate
Replication: Key-Based Replication
Replication Key: date
Fields
CustomerProductRecommendations
Purpose: Fetch the details of product recommendations generated for customers by Optimove
Source API Documentation https://docs.optimove.com/api-usage-guide/#Customer-related_Functions_GetCustomerProductRecommendations
Replication: Full Replication
Replication Key: NA
Fields
CampaignInteractionCustomers
Purpose: Fetch the details of customers and their marketing actions as a part of one time campaign on a particular group on a particular date.
Source API Documentation https://docs.optimove.com/api-usage-guide/#Customer-related_Functions_GetCampaignInteractionCustomers
Replication: Key-Based Replication
Replication Key: date
Fields
CustomerChannelInteractions
Purpose: Fetch the details of customers and their templates , campaigns. For each customer who performed a particular interaction with a campaign that was delivered on a particular date via a particular channel.
Source API Documentation https://docs.optimove.com/api-usage-guide/#Customer-related_Functions_GetCustomerChannelInteractions
Replication: Full Replication
Replication Key: NA
Fields
ExternalRealtimeCampaignCustomers
Purpose: Fetch the details of customers who scheduled to receive a realtime campaign by an external system on a particular date, along with associated details
Source API Documentation https://docs.optimove.com/api-usage-guide/#Customer-related_Functions_GetExternalRealtimeCampaignCustomers
Replication: Key-Based Replication
Replication Key: execution_date
Fields
ValueSegments
Purpose: Fetch the details of value segment details.
Source API Documentation https://docs.optimove.com/api-usage-guide/#GetValueSegments
Replication: Full Replication
Replication Key: NA