LogoLogo
Daton
Daton
  • Daton Defined: From Web App Essentials to Advanced Integrations
  • Platform
    • Essentials
      • Billing
      • Integrate Facebook Ads on Daton
      • Integrate Shopify on Daton
      • Integrate Google Analytics on Daton
      • Access permissions for Daton
      • How to get started with Daton setup
      • Terminology in Daton
        • Source and Source_Table statuses
      • Various pages in Daton
    • Features
      • Navigating the pages in Daton
        • Notifications
        • Logs
        • Dashboard
        • My Account
        • Connectors
        • My Integrations
        • Integration Details
      • Templates
      • Account Management
        • My Account Page
      • Notifications
      • Monitoring
        • Logging and Log Retention
      • Manage Integrations
        • Handling Changes to Schema
        • Modifying an integration
      • Data
        • Handling Nested Data
        • Daton Metadata
        • Inserts, Updates, and Upserts
        • Data Type Mapping
        • Data Replication in Daton
          • Replication Fields
          • Replication Methods
            • Key-based Incremental Replication
      • Knowledge Base
        • What is ELT and how is it different from traditional ETL tools
          • Billing
      • Pipelines
        • Pipeline Jobs
        • Loading Behavior
      • Security
      • Feature Updates
        • Amazon Vendor Central
  • Connectors
    • Data Sources
      • Advertising
        • Adjust v1
        • Adjust v2
          • About Adjust v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Adjust v2 with Daton
          • Schema Information
        • Amazon Ads
          • Release Notes
        • Amazon Attribution
          • Release Notes
        • Amazon Brand Metrics
          • About Amazon Brand Metrics
          • Essential Attributes and Supported Tables
          • How to Integrate Amazon Brand Metrics with Daton
          • Schema Infomation
        • Amazon DSP V1
          • Release Notes
        • Amazon DSP V2
        • Amazon Marketing Cloud (AMC)
        • Amazon Marketing Streams
          • About Amazon Marketing Streams Connector
          • Essential Attributes
          • How to Integrate Amazon Marketing Streams with Daton
          • Release Notes
        • Amazon Sponsored Brand Ads
          • Release Notes
        • Amazon Sponsored Display Ads
          • Release Notes
        • Amazon Sponsored Product Ads
          • Release Notes
        • Amazon Sponsored TV Ads
        • Bing Ads
          • Release Notes
        • Bol Ads
          • Release Notes
        • Facebook Ads
          • Release Notes
        • Google Ads
          • Release Notes
        • Google My Business
        • Google My Business v2
          • About Google My Business v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Google Business Profile Account with Daton
          • Schema Information
        • Gorgias
        • Gorgias V2
        • HelpScout
        • HelpScout v2
          • About HelpScout Platform
          • Essential Attributes and Supported Tables
          • How to Integrate HelpScout with Daton
          • Schema Information
          • Release Notes
        • Outbrain
          • Release Notes
        • Outbrain v2
          • About Outbrain Platform
          • Essential Attributes & Supported Tables
          • How to Integrate Outbrain v2 with Daton
          • Schema Information
        • Pinterest v2
          • About Pinterest v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Pinterest v2 with Daton
          • Schema Information
        • Rakuten
          • About Rakuten Connector
          • Essential Attributes
          • How to Integrate Rakuten with Daton
        • StackAdapt
          • About StackAdapt Platform
          • Essential Attributes and Supported Tables
          • How to Integrate StackAdapt with Daton
          • Schema Information
        • Typeform
          • About Typeform Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Typeform with Daton
          • Schema Information
        • Upscribe
          • Release Notes
        • Upscribe V2
          • About Upscribe Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Upscribe v2 with Daton
          • Schema Information
      • Analytics Platforms
        • Appsflyer
        • GA4
          • About Google Analytics Platform
          • Essential Attributes and Table Selection
          • How to Integrate GA4 with Daton
          • Schema Information
        • Google Analytics
          • Release Notes
        • Jungle Scout
        • Northbeam
          • About Northbeam Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Northbeam with Daton
          • Schema Information
        • Prodco Analytics
          • About Prodco Analytics Platform
          • Essential Attributes and Table Selection
          • How to Integrate Prodco Analytics Account with Daton
          • Schema Information
        • Rainforest
          • About Rainforest Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Rainforest Account with Daton
          • Schema Information
        • Sprout Social
          • About Sprout Social Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Sprout Social with Daton
          • Schema Information
        • Taboola
        • Taboola v2
          • About Taboola v2
          • Essential Attributes and Supported Tables
          • How to Integrate Taboola v2 with Daton
          • Schema Information
        • Edge by Ascential
      • Business
        • ClickUp
          • About ClickUp Connector
          • Essential Attributes and Supported Tables
          • How to Integrate ClickUp with Daton
          • Schema Information
        • Bubble
        • Pipedrive
          • About Pipedrive Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Pipedrive with Daton
          • Schema Information
        • Teamwork
          • About Teamwork Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Teamwork with Daton
          • Schema Information
        • Teamwork v2
          • About Teamwork Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Teamwork v2 with Daton
          • Schema Information
        • TikTok Business
          • About TikTok Business Connector
          • Essential Attributes and Supported Tables
          • How to Integrate TikTok Business with Daton
          • Schema Information
        • Unbounce v2
          • About Unbounce v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Unbounce v2 with Daton
          • Schema Information
      • Call Center
        • Aircall
        • Callpage
        • JustCall
          • About JustCall Connector
          • Essential Attributes and Supported Tables
          • How to Integrate JustCall with Daton
          • Schema Information
      • Databases
        • Amazon Aurora MySQL
          • About Amazon Aurora Platform
          • Essential Attributes
          • How to Integrate Amazon Aurora with Daton
        • Amazon Redshift
          • About Amazon Redshift Platform
          • Essential Attributes
          • How to Integrate Amazon Redshift with Daton
        • GCP MySQL
          • About GCP MySQL Platform
          • Essential Attributes
          • How to Integrate GCP MySQL with Daton
        • GCP PostgreSQL
          • Setup Manual
        • Magento (DB)
          • About Magento Connector
          • Essential Attributes
          • How to Integrate Magento with Daton
        • MySQL
          • Release Notes
        • NetSuite
        • PostgreSQL
          • Release Notes
        • SQLServer
        • WooCommerce SQL
          • About WooCommerce SQL Platform
          • Essential Attributes
          • How to Integrate WooCommerce SQL with Daton
      • Daton Connector
        • Release Notes
      • Ecommerce Platforms
        • Amazon MWS
          • Release Notes
        • Amazon Selling Partner
          • All Report Types and Tables
          • Release Notes
        • Amazon Vendor Central
          • All Report Types and Tables
          • Real Time Reports
          • Daily Reports
          • Weekly Reports
          • Snapshot Reports
          • Monthly Reports
          • Raw Tables
          • Release Notes
        • Bigcommerce
        • BigCommerce v2
          • About BigCommerce Platform
          • Essential Attributes and Supported Tables
          • How to Integrate BigCommerce Account with Daton
          • Schema Information
          • Release Notes
        • Bol Retail v2
          • Release Notes
        • Capillary Martjack
          • Release Notes
        • Kaufland
          • About Kaufland Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Kaufland with Daton
          • Schema Information
        • Keepa
          • About Keepa Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Keepa with Daton
          • Schema Information
        • Lazada
        • Loopreturns
          • Release Notes
        • Magento
          • Release Notes
        • Magento 2 (APIs)
          • Release Notes
        • Mercado Libre
          • About Mercado Libre Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Mercado Libre with Daton
          • Schema Information
        • Shopify
          • Access tokens for Shopify
          • Release Notes
        • Shopify V2
        • Walmart
          • Release Notes
        • Walmart_v2
          • Release Notes
        • WooCommerce
      • Files
        • Amazon S3
          • Release Notes
        • Dropbox
          • Release Notes
        • Email Attachments
          • About Email Attachments Connector
          • Essential Attributes and Connector Guidelines
          • How to Integrate Email Attachments with Daton
        • Google Cloud Storage
          • Release Notes
        • Google Drive
        • Google Sheets
          • Release Notes
        • SFTP (SSH File Transfer Protocol)
      • OMS/WMS
        • Cin7
        • Goflow
          • About Goflow Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Goflow with Daton
          • Schema Information
        • Rippling
          • About Rippling Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Rippling with Daton
          • Schema Information
      • Payments
        • PayPal
          • About PayPal Connector
          • Essential Attributes and Supported Tables
          • How to Integrate PayPal with Daton
          • Schema Information
        • Razorpay
          • About Razorpay Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Razorpay with Daton
          • Schema Information
        • Razorpay v1
        • Stripe
      • Productivity Trackers
        • GitLab
          • Release Notes
        • Time Doctor
          • Release Notes
      • SaaS Integrations
        • Aftership
          • Release Notes
        • Aftership V2
        • Anvyl
        • Ascend
        • Awtomic
          • Release Notes
        • Braintree
          • About Braintree Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Braintree Account with Daton
          • Schema Information Braintree
        • Calendly
          • Release Notes
        • Calendly V2
        • Campaign Monitor
        • Capsule CRM
        • Chargebee
        • Freshworks CRM
        • Loop Subscription
        • Commission Junction
        • Constant Contact
        • Copper CRM
          • About Copper
          • Essential Attributes and Supported Tables
          • How to Integrate Copper Account with Daton
          • Schema Information
          • Release Notes
        • Criteo
        • Criteo Retail Media
        • Customer.io
        • DotDigital
        • dotdigital V2
        • Easyecom
        • EasyEcom V2
          • Release Notes
        • ePallet ERP
        • Etsy
        • Exchange Rates
          • About Exchange Rate Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Exchange Rates with Daton
          • Schema Information
          • Release Notes
        • Fairing (previously EnquireLabs)
          • Release Notes
        • FreshBooks
          • Release Notes
        • Freshdesk
          • Release Notes
        • Freshsales
          • Release Notes
        • Fulfil
        • Gladly
          • Release Notes
        • Google Search Console
          • Release Notes
        • HubSpot
          • Release Notes
        • HubSpot v2
          • About HubSpot v2 Connector
          • Essential Attributes and Supported Tables
          • How to Integrate HubSpot v2 with Daton
          • Schema Information
        • Impact
          • Release Notes
        • Infusionsoft (now Keap Max Classic)
          • About Infusionsoft Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Infusionsoft with Daton
          • Schema Information
        • Insightly
        • Intercom
          • Release Notes
        • Intercom V2
          • Release Notes
        • Outbrain V2 (Old)
          • Release Notes
        • Inventory Planner
        • Jira
        • JudgeMe
          • Release Notes
        • Kibo Commerce
        • Klaviyo
          • Release Notes
        • Klaviyo V2
          • Release Notes
        • Kustomer
        • LeadSquared CRM
        • LeadSquared V2
        • LinkedIn Ads
        • LiveChat
        • LoyaltyLion
        • MailChimp
          • Release Notes
        • MNTN
        • Monday
        • NewRelic
        • Okendo Reviews
          • About Okendo Reviews Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Okendo Reviews with Daton
          • Schema Information
        • Optimove
          • Release Notes
        • Pingdom
        • Pinterest
        • Pipedrive
        • PushEngage
        • Quickbase
        • QuickBooks
        • Quickbooks v2
          • About Quickbooks Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Quickbooks v2 with Daton
          • Schema Information
        • Re:amaze
        • ReCharge Payments
          • Release Notes
        • ReCharge Payments v1
          • Setup Manual
          • Schema Information
        • Recharge Payments V2
          • Setup Manual
          • Schema Information
        • Reviewmonitoring
          • Release Notes
        • Salsify
          • Release Notes
        • SendGrid
          • Release Notes
        • Shiphero
        • Shippo
        • Shiprocket
          • Release Notes
        • Shiprocket v2
          • About Shiprocket Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Shiprocket with Daton
          • Schema Information
        • Shipstation
          • Release Notes
        • Skubana
        • SkuVault
          • About SkuVault Connector
          • Essential Attributes and Supported Tables
          • How to Integrate SkuVault with Daton
          • Schema Information
        • Smartrr
        • Smartrr v2
          • About Smartrr Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Smartrr v2 with Daton
          • Schema Information
        • Stamped.io
          • About Stamped.io Platform
          • Essential Attributes and Supported Tables
          • How to Integrate Stamped.io with Daton
          • Schema Information
        • Stamped.io v1
        • Stay AI
        • Sticky.io
        • SugarCRM
          • Release Notes
        • Survey Monkey
        • Tune
        • Unbounce
        • Unicommerce
        • Unicommerce
          • About Unicommerce Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Unicommerce with Daton
          • Schema Information
          • Release Notes
        • When I Work
        • Xero
        • Xero V2
          • About Xero Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Xero V2 with Daton
          • Schema Information
        • Yahoo Gemini
        • Yotpo
        • Yotpo v2
          • About Yotpo Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Yotpo v2 with Daton
          • Schema Information
        • Zendesk Chat
        • Zendesk ETL
          • Release Notes
        • Zoho CRM
          • Release Notes
        • ZohoDesk
          • Release Notes
      • Surveys
        • Alchemer
          • About Alchemer Platform
          • Essential Attributes and Supported Tables Alchemer
          • How to Integrate Alchemer Account with Daton
          • Schema Information Alchemer
        • Fairing
          • About Fairing Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Fairing with Daton
          • Schema Information
        • Survicate
          • About Survicate Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Survicate with Daton
          • Schema Information
      • Shipping Platforms
        • 3PL Central
        • Byrd
        • Cin7
        • ClickPost
        • Dear
        • Easypost
        • Ohi
          • About Ohi Connector
          • Essential Attributes and Supported Tables
          • How to Integrate Ohi with Daton
          • Schema Information
        • ShipBob
          • About ShipBob Connector
          • Essential Attributes and Supported Tables
          • How to Integrate ShipBob with Daton
          • Schema Information
      • Webhooks
    • Destinations
      • Amazon RDS PostgreSQL
        • Amazon RDS for PostgreSQL Integration with Daton
        • How to Set up RDS PostgreSQL Destination in Daton
      • Amazon RDS MySQL
        • About Integrating Amazon RDS for MySQL database with Daton
        • How to Set up RDS MySQL Destination in Daton
      • Amazon Redshift
        • Querying Daton created tables on RedShift
        • Release Notes
      • Amazon S3
        • Release Notes
      • Azure One Lake
        • About Azure One Lake as a connector in Daton
        • How to Set up an Azure One Lake Database for Integrating with Daton
        • How to Integrate your Azure One Lake Database as a Destination in Daton
      • Azure Data Lake Storage
        • About Azure Data Lake Storage as a connector in Daton
        • How to Set up an Azure Data Lake Storage for Integrating with Daton
        • How to Integrate Your Azure Data Lake Storage Database as a Destination in Daton
      • GCP PostgreSQL
        • About Google Cloud SQL for PostgreSQL Database with Daton
        • How to Set up GCP PostgreSQL Destination in Daton
      • Google BigQuery
        • Release Notes
      • GCS
      • MySQL
        • About Integrating MySQL with Daton
        • How to Set up a MySQL Database for Integrating with Daton
        • How to Set up Your MySQL Database as a Destination in Daton
      • Oracle Autonomous Data Warehouse
      • Snowflake
        • Release Notes
  • FAQs and Troubleshooting
    • Connector permissions and API Keys
      • Access tokens for Shopify
      • Amazon Ads Permissions
      • Where to find my Amazon MWS Merchant Token and Auth Token
      • How to create BigCommerce API Account and generate Client Id, Client Secret and Access tokens
      • How to create Client credentials for Bol Retail
      • How to create Developer application for Mercado Libre
      • How to create API Keys for SendGrid
      • Where to find API Keys for Freshsales
      • Where to find API Keys for Freshdesk
      • How to create REST API Keys for NewRelic
      • How to create API Keys for Chargebee
      • How to generate Access Token for Calendly
      • How to obtain Klaviyo API Key
      • Where to find API Keys for RazorPay
      • How to create API Keys for PushEngage
      • How to create Criteo API User and generate Client Id and Client Secret
      • How to find site-id/domain and create WooCommerce Consumer Key and Secret
    • Authentication Failure while connecting Database using SSH tunnel
    • Common Errors and Resolution
    • FAQs
      • How to get access to FB Ads Business Manager?
      • How to get access to Google Analytics?
      • Querying Daton created child tables for nested data
      • Google Analytics - FAQs
      • How does Lite Plan Work?
      • How do I upgrade my subscription?
      • How does loading behaviour impact billing?
      • What are the tables highlighted with the letter "F"?
      • Amazon Advertising FAQs
      • Amazon Business and Inventory Reports FAQs
      • Why don't I see my data?
      • How exactly do Business Reports work in Daton?
      • Steps to upload your own ASIN and SKU file in Amazon SP connectors
      • What are 'FATAL' and 'CANCELLED' report statuses in Amazon Selling Partner?
      • How to setup Google BigQuery Project
      • Amazon Selling Partner, Vendor Central - Access to resource denied error.
      • VendorSalesReportByManufacturing showing a FATAL report status?
      • How to Enable SSH Tunneling during a Database Source Authentication?
  • New Subscription Plans and Billing
    • Subscription Plans Overview
    • Find Your Perfect Data Integration Fit - Growth and Enterprise Plans Explored
    • Daton's Subscriptions Dashboard: Harness the Power of Your Data
    • How to Select and Subscribe to a Daton Subscription Plan?
    • Subscription Plan Upgrade and Downgrade
    • Changing Billing Cycle
  • Product Insights: Report, Roadmap, and Release Notes
    • Introduction to Product Insights
    • 2023 Recap and 2024 Roadmap
    • Release Notes
Powered by GitBook
On this page
  • Snapshot
  • Integrate Optimove with Daton
  • Workflow
  • Optimove Data

Was this helpful?

  1. Connectors
  2. Data Sources
  3. SaaS Integrations

Optimove

Optimove ETL connector for data replication

Snapshot

Features

Details

Release Status

Released

Source API Version

Table Selection

Yes

Column Selection

Yes

Edit Integration

Yes

Replication Type Selection

No

Authentication Parameters

Optimove Base URI Optimove Username Optimove Password

Replication Type

Full Replication Key Based Incremental

Replication Key

Date

Suggested Replication Frequency

24 hrs

Tables/APIs Supported

CustomerAttribute

LifecycleStageList

MicroSegmentList

MicroSegmentChangers

AllActions

ActionsByTargetGroup

Promocodes

PromocodesByCampaign

PromocodesByTargetGroup

ActionDetailsByTargetGroup

ExecutedCampaignDetails

CampaignDetails

ExecutionChannels

ExecutedCampaignChannelDetails

ExecutedCampaignsByChannel

TargetGroupByDate

TargetGroupDetails

CustomerActionsByTargetGroup

CustomerOnetimeActionsByDate

CustomerOnetimeActionsByCampaign

CustomerFutureValues

CustomerLastActionExecuted

CustomerActionDetailsByDate

CustomersActionEndedByDate

CustomersSendFDetailsByCampaign

CustomerExecutionDetailsByCampaign

ProcessedCampaignCustomers

CurrentlyTargetedCustomers

CanceledCampaignCustomers

CustomerProductDetailsByCampaign

CustomerProductDetailsByDate

CustomerProductRecommendations

CampaignInteractionCustomers

CustomerChannelInteractions

ExternalRealtimeCampaignCustomers

ValueSegments

CustomersByValueSegment

ValueSegmentChangers

Promotions

ChannelTemplates

ChannelTemplateDetails

ExternalRealtimeTriggers

ActivityEventList

TransactionalTemplateMetrics

Integrate Optimove with Daton

  1. Signin to Daton

  2. Select Optimove 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 Optimove Base URI, Username, Password for authentication and authorize Daton to periodically extract data from Optimove

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

  6. Then select all required fields for each table

  7. 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

Optimove Data

CustomerAttribute

Purpose: Fetch the customer details like name, age address

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

RealFieldName

STRING

Description

STRING

LifecycleStageList

Purpose: Fetch the details of all life cycles stages pertain to a customer

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

StageId

INTEGER

StageName

STRING

MicroSegmentList

Purpose: Fetch the all details of microsement pertaint to a customer

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

MicrosegmentID

INTEGER

MicrosegmentName

STRING

LifecycleStageID

STRING

FutureValue

FLOAT

ChurnRate

NUMERIC

ReactivationRate

NUMERIC

ConversionProbability

NUMERIC

MicroSegmentChangers

Purpose: Fetch the details of customers who changed their microsegment, along with previous microsegment details and last date for fetched data.

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

CustomerID

STRING

InitialMicroSegmentID

INTEGER

FinalMicroSegmentID

INTEGER

AllActions

Purpose: Fetch the details of actions names and their IDs

Replication: Full Replication Replication Key: NA

Fields

Name

Target Datatype

ActionID

INTEGER

ActionName

STRING

ActionsByTargetGroup

Purpose: Fetch the details of recipent group and actions associated with particular target group of a particular date

Replication: Key-Based Replication

Replication Key: date

Fields

Name

Target Datatype

RecipientGroupID

INTEGER

ActionID

INTEGER

Date

STRING

Promocodes

Purpose: Fetch the details of target group’s , action’s and their promocodes of a particular date

Replication: Key-Based Replication

Replication Key: date

Fields

Name

Target Datatype

TargetGroupID

INTEGER

RecipientGroupID

INTEGER

ActionID

INTEGER

PromoCode

STRING

Date

STRING

PromocodesByCampaign

Purpose: Fetch the details of recipient group’s , action’s and their promocodes of a particular campaign

Replication: Key-Based Replication

Replication Key: campaignid

Fields

Name

Target Datatype

RecipientGroupID

INTEGER

ActionID

INTEGER

PromoCode

STRING

CampaignId

INTEGER

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

Replication: Key-Based Replication

Replication Key: date

Fields

Name

Target Datatype

RecipientGroupID

INTEGER

ActionID

INTEGER

PromoCode

STRING

Date

STRING

TargetGroupId

INTEGER

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

Replication: Key-Based Replication

Replication Key: date

Fields

Name

Target Datatype

RecipientGroupID

INTEGER

ActionID

INTEGER

Duration

INTEGER

LeadTime

INTEGER

ChannelID

INTEGER

Date

STRING

TargetGroupId

INTEGER

ExecutedCampaignDetails

Purpose: Fetch the details of all campaign that were executed in a particular date.

Replication: Key-Based Replication

Replication Key: date

Fields

Name

Target Datatype

CampaignID

INTEGER

TargetGroupID

INTEGER

CampaignType

STRING

Duration

INTEGER

LeadTime

INTEGER

Notes

STRING

IsMultiChannel

BOOLEAN

IsRecurrence

BOOLEAN

Status

STRING

Error

STRING

Date

STRING

CampaignDetails

Purpose: Fetch the details of particular campaign details

Replication: Key-Based Replication

Replication Key: campaignid

Fields

Name

Target Datatype

TargetGroupID

INTEGER

CampaignType

STRING

Duration

INTEGER

LeadTime

INTEGER

Notes

STRING

IsMultiChannel

BOOLEAN

IsRecurrence

BOOLEAN

Status

STRING

Error

STRING

Tags

STRING

CampaignID

INTEGER

ExecutionChannels

Purpose: Fetch the details of all executable channels.

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

ChannelId

INTEGER

ChannelName

STRING

ExecutedCampaignChannelDetails

Purpose: Fetch the details of a particular campaign exceuted on particular channel

Replication: Key-Based Replication

Replication Key: campaignid, channelid

Fields

Name

Target Datatype

SendID

STRING

TemplateID

INTEGER

ScheduledTime

STRING

CampaignID

INTEGER

ChannelID

INTEGER

ExecutedCampaignsByChannel

Purpose: Fetch the details of campaigns executed for a particular channel on particular date.

Replication: Key-Based Replication

Replication Key: date

Fields

Name

Target Datatype

CampaignID

INTEGER

ChannelID

INTEGER

Date

STRING

TargetGroupByDate

Purpose: Fetch the details of a group for which the actions were performed on particular date.

Replication: Key-Based Replication

Replication Key: date

Fields

Name

Target Datatype

TargetGroupID

INTEGER

Date

STRING

TargetGroupDetails

Purpose: Fetch the details of all target groups

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

TargetGroupID

INTEGER

TargetGroupName

STRING

TargetGroupPriority

INTEGER

CustomerActionsByTargetGroup

Purpose: Fetch the details of customers and their marketing actions on a particular group on a particular date.

Replication: Key-Based Replication

Replication Key: date

Fields

Name

Target Datatype

CustomerID

STRING

ActionID

INTEGER

ChannelID

INTEGER

RecipientGroupID

INTEGER

CustomerAttributes

STRING

Date

STRING

TargetGroupID

INTEGER

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.

Replication: Key-Based Replication

Replication Key: date

Fields

Name

Target Datatype

CustomerID

STRING

ActionID

INTEGER

ChannelID

INTEGER

Date

STRING

CustomerOnetimeActionsByCampaign

Purpose: Fetch the details of customers and the details associated with a particular one-time campaign.

Replication: Key-Based Replication

Replication Key: campaignid

Fields

Name

Target Datatype

CustomerID

STRING

RecipientGroupID

INTEGER

ActionID

INTEGER

ChannelID

INTEGER

CustomerAttributes

STRING

CampaignID

INTEGER

CustomerFutureValues

Purpose: Fetch the details of future customers and their future values.

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

CustomerID

STRING

FutureValue

FLOAT

CustomerLastActionExecuted

Purpose: Fetch the details of last action executed for a particular customer.

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

Date

STRING

ActionID

INTEGER

Duration

INTEGER

TargetGroupID

INTEGER

CustomerID

STRING

CustomerActionDetailsByDate

Purpose: Fetch the details of customer IDs and details of the campaigns sent to them on a particular date.

Replication: Key-Based Replication

Replication Key: date

Fields

Name

Target Datatype

CustomerID

STRING

RecipientGroupID

INTEGER

ActionID

INTEGER

ChannelID

INTEGER

Date

STRING

CustomersActionEndedByDate

Purpose: Fetch the details of customer IDs and details of the campaigns they received, for action durations which ended on a particular date.

Replication: Key-Based Replication

Replication Key: date

Fields

Name

Target Datatype

CustomerID

STRING

ActionID

INTEGER

ChannelID

INTEGER

Date

STRING

Duration

INTEGER

TargetGroupID

INTEGER

CustomersSendFDetailsByCampaign

Purpose: Fetch the details of all customers and channels and their send times and channel send details for a particular campaign.

Replication: Key-Based Replication

Replication Key: campaignid

Fields

Name

Target Datatype

CustomerID

STRING

ChannelID

INTEGER

ScheduledTime

STRING

SendID

STRING

CampaignID

INTEGER

CustomerExecutionDetailsByCampaign

Purpose: Fetch the details of all customers and the details associated with each customer for a particular campaign.

Replication: Key-Based Replication

Replication Key: campaignid

Fields

Name

Target Datatype

CustomerID

STRING

ActionID

INTEGER

ChannelID

INTEGER

TemplateID

STRING

ScheduleTime

STRING

PromoCode

STRING

CampaignID

INTEGER

ProcessedCampaignCustomers

Purpose: Fetch the details od all customers and associated promotion codes for a particular campaign

Replication: Key-Based Replication

Replication Key: campaignid

Fields

Name

Target Datatype

CustomerID

STRING

PromoCode

STRING

CampaignID

INTEGER

CurrentlyTargetedCustomers

Purpose: Fetch the details of customers and who are currently included in one or more campaigns

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

CustomerID

STRING

ActionID

INTEGER

CampaignID

INTEGER

StartDate

STRING

EndDate

STRING

CanceledCampaignCustomers

Purpose: Fetch the details of customers who’s campaignes were cancelled along with the associated actions and promo codes.

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

CustomerID

STRING

ActionID

INTEGER

PromoCode

STRING

CampaignID

INTEGER

CustomerProductDetailsByCampaign

Purpose: Fetch the details of customers and recommended products for each customer targeted by a particular product recommendation campaign

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

CustomerID

STRING

ProductID

STRING

ProductAttributes

STRING

CampaignID

INTEGER

CustomerProductDetailsByDate

Purpose: Fetch the details of customers and recommended products for each customer targeted by any product recommendation campaign on a particular date.

Replication: Key-Based Replication

Replication Key: date

Fields

Name

Target Datatype

CustomerID

STRING

ProductID

STRING

ProductAttributes

STRING

Date

STRING

CustomerProductRecommendations

Purpose: Fetch the details of product recommendations generated for customers by Optimove

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

CustomerID

STRING

ProductId

STRING

RecommendationType

INTEGER

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.

Replication: Key-Based Replication

Replication Key: date

Fields

Name

Target Datatype

CampaignID

INTEGER

Date

STRING

ChannelID

INTEGER

TemplateID

INTEGER

EventID

INTEGER

CustomerID

STRING

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.

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

CampaignID

INTEGER

Date

STRING

RecipientGroupID

INTEGER

ActionID

INTEGER

ChannelID

INTEGER

TemplateID

INTEGER

EventID

INTEGER

CustomerID

STRING

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

Replication: Key-Based Replication

Replication Key: execution_date

Fields

Name

Target Datatype

CampaignID

INTEGER

CustomerID

STRING

PromoCode

STRING

TriggerID

INTEGER

ActionID

INTEGER

TargetGroupID

INTEGER

RecipientGroupID

INTEGER

CustomerAttributes

STRING

Date

STRING

ValueSegments

Purpose: Fetch the details of value segment details.

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

ValueSegmentName

STRING

ValueSegmentID

INTEGER

CustomersByValueSegment

Purpose: Fetch the details of customers and their particular value segment at current time.

Replication: Key-Based Replication

Replication Key: valuesegmentid

Fields

Name

Target Datatype

CustomerID

STRING

ValueSegmentID

INTEGER

ValueSegmentChangers

Purpose: Fetch the details of customers in the database which changed value segments, along with their before and after value segment

Replication: Key-Based Replication

Replication Key: startdate

Fields

Name

Target Datatype

CustomerID

INTEGER

InitialValueSegmentID

INTEGER

FinalValueSegmentID

INTEGER

Promotions

Purpose: Fetch the details of promo codes and associated names and their updations and deletions

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

PromoCode

STRING

PromotionName

STRING

ChannelTemplates

Purpose: Fetch the details of template and associated names that will be associated with a specified channel

Replication: Key-Based Replication

Replication Key: channelid

Fields

Name

Target Datatype

TemplateID

INTEGER

TemplateName

STRING

ChannelID

INTEGER

ChannelTemplateDetails

Purpose: Fetch the details of content and attributes of a specific template for a specific channel

Replication: Key-Based Replication

Replication Key: channelid

Fields

Name

Target Datatype

TemplateID

INTEGER

TemplateContent

STRING

ChannelID

INTEGER

ExternalRealtimeTriggers

Purpose: Fetch the details of realtime triggers handled by an external system

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

TriggerID

STRING

TriggerName

STRING

ActivityEventList

Purpose: Fetch the details of all available custom SDK events with each event parameter's name and type.

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

id

INTEGER

name

STRING

Event_Parameters

RECORD

TransactionalTemplateMetrics

Purpose: Fetch the details of post-execution metrics for a specific transactional mail template over time.

Replication: Key-Based Replication

Replication Key: templateid

Fields

Name | Target Datatype --- | ---

PreviousSchema InformationNextRelease Notes

Last updated 5 years ago

Was this helpful?

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

Source API Documentation

https://docs.optimove.com/api-usage-guide/#Model-related_Functions_GetCustomerAttributeList
https://docs.optimove.com/api-usage-guide/#Model-related_Functions_GetLifecycleStageList
https://docs.optimove.com/api-usage-guide/#Model-related_Functions_GetMicrosegmentList
https://docs.optimove.com/api-usage-guide/#Model-related_Functions_GetMicrosegmentChangers
https://docs.optimove.com/api-usage-guide/#GetAllActions
https://docs.optimove.com/api-usage-guide/#GetActionsByTargetGroup
https://docs.optimove.com/api-usage-guide/#Action-related_Functions_GetPromoCodes
https://docs.optimove.com/api-usage-guide/#Action-related_Functions_GetPromoCodesByCampaign
https://docs.optimove.com/api-usage-guide/#Action-related_Functions_GetPromoCodesByTargetGroup
https://docs.optimove.com/api-usage-guide/#Action-related_Functions_GetActionDetailsByTargetGroup
https://docs.optimove.com/api-usage-guide/#Action-related_Functions_GetExecutedCampaignDetails
https://docs.optimove.com/api-usage-guide/#Action-related_Functions_GetCampaignDetails
https://docs.optimove.com/api-usage-guide/#Action-related_Functions_GetExecutionChannels
https://docs.optimove.com/api-usage-guide/#Action-related_Functions_GetExecutedCampaignChannelDetails
https://docs.optimove.com/api-usage-guide/#Action-related_Functions_GetExecutedCampaignsByChannel
https://docs.optimove.com/api-usage-guide/#Target_Group-related_Functions_GetTargetGroupsByDate
https://docs.optimove.com/api-usage-guide/#Target_Group-related_Functions_GetTargetGroupDetails
https://docs.optimove.com/api-usage-guide/#GetCustomerActionsByTargetGroup
https://docs.optimove.com/api-usage-guide/#GetCustomerOneTimeActionsByDate
https://docs.optimove.com/api-usage-guide/#GetCustomerOneTimeActionsByCampaign
https://docs.optimove.com/api-usage-guide/#GetCustomerFutureValues
https://docs.optimove.com/api-usage-guide/#GetCustomerLastActionExecuted
https://docs.optimove.com/api-usage-guide/#GetCustomerActionDetailsByDate
https://docs.optimove.com/api-usage-guide/#GetCustomersActionEndedByDate
https://docs.optimove.com/api-usage-guide/#Customer-related_Functions_GetCustomerSendDetailsByCampaign
https://docs.optimove.com/api-usage-guide/#Customer-related_Functions_GetCustomerExecutionDetailsByCampaign
https://docs.optimove.com/api-usage-guide/#Customer-related_Functions_GetProcessedCampaignCustomers
https://docs.optimove.com/api-usage-guide/#Customer-related_Functions_GetCurrentlyTargetedCustomers
https://docs.optimove.com/api-usage-guide/#Customer-related_Functions_GetCanceledCampaignCustomers
https://docs.optimove.com/api-usage-guide/#Customer-related_Functions_GetCustomerProductDetailsByCampaign
https://docs.optimove.com/api-usage-guide/#Customer-related_Functions_GetCustomerProductDetailsByDate
https://docs.optimove.com/api-usage-guide/#Customer-related_Functions_GetCustomerProductRecommendations
https://docs.optimove.com/api-usage-guide/#Customer-related_Functions_GetCampaignInteractionCustomers
https://docs.optimove.com/api-usage-guide/#Customer-related_Functions_GetCustomerChannelInteractions
https://docs.optimove.com/api-usage-guide/#Customer-related_Functions_GetExternalRealtimeCampaignCustomers
https://docs.optimove.com/api-usage-guide/#GetValueSegments
https://docs.optimove.com/api-usage-guide/#GetCustomersByValueSegment
https://docs.optimove.com/api-usage-guide/#GetValueSegmentChangers
https://docs.optimove.com/api-usage-guide/#GetPromotions
https://docs.optimove.com/api-usage-guide/#External_System_Integration_Functions_GetChannelTemplates
https://docs.optimove.com/api-usage-guide/#External_System_Integration_Functions_GetChannelTemplateDetails
https://docs.optimove.com/api-usage-guide/#External_System_Integration_Functions_GetExternalRealtimeTriggers
https://docs.optimove.com/api-usage-guide/#External_System_Integration_Functions_GetActivityEventList
https://docs.optimove.com/api-usage-guide/#GetTransactionalTemplateMetrics