Tables #

✍️ DRAFT : IN PROGRESS

The Spotler Connector tries to use as much is possible the exiting tables and columns in Dynamics 365 to store data. In this way, when you remove the Connector from your environment, you don't lose this data.

But for some functionality we added a couple of tables and columns.

Added Tables #

• Spotler Info: Information about the synchronization to Spotler, like the last status and if it is active or inactive.

• Spotler Permission: Permission for which a Customer or Lead can (un)subscribe for.

• Spotler Job (Log): Jobs for executing operations by the Spotler Connector.

• Spotler Automation: Contains the trigger codes of automations and campaigns in Spotler. Used to lookup in a Spotler Job.

• Marketing Interaction: Interactions related to marketing, like Website Visits, Email Opened or Email Clicked.

• Website Visitor: Tracked Website Visitors than can be promoted to leads, accounts or contacts, when they have a high score.

Extended Tables #

• Account

  • Spotler Info (dh_SpotlerInfo)
  • Website Visitor (dh_WebsiteVisitor)
  • Engagement Score (dh_EngagementScore)
  • Recent Engagement Score (dh_EngagementWeightedScore)

• Contact

  • Spotler Info (dh_SpotlerInfo)
  • Engagement Score (dh_EngagementScore)
  • Recent Engagement Score (dh_EngagementWeightedScore)

• Lead

  • Spotler Info (dh_SpotlerInfo)
  • Website Visitor (dh_WebsiteVisitor)
  • Engagement Score (dh_EngagementScore)
  • Recent Engagement Score (dh_EngagementWeightedScore)

• Marketing List

  • Spotler Info (dh_SpotlerInfo)

• Campaign

  • Bounce Rate (%) (dh_BounceRate)
  • Click-Through Rate (%) (dh_ClickThroughRate)
  • Click-To-Open Rate (%) (dh_ClickToOpenRate)
  • Clicks (dh_ClickCount)
  • Conversion Click-To-Open Rate (%) (dh_ConversionClickToOpenRate)
  • Conversion Clicks (dhConversionClickCount)
  • Conversion Rate (%) (dh_ConversionRate)
  • Deliveries (dh_DeliveryCount)
  • Delivery Rate (%) (dh_DeliveryRate)
  • Hard Bounces (dh_HardBounceCount)
  • Not Retained After Bounce (dh_NotRetainedAfterBounceCount)
  • Open Rate (%) (dh_OpenRate)
  • Opens (dh_OpenCount)
  • Rendered Opens (dh_RenderedOpenCount)
  • Sent (dh_SentCount)
  • Soft Bounces (dh_SoftBounceCount)
  • Total Bounces (dh_BounceCount)
  • Unsubscribe Rate (%) (dh_UnsubscribeRate)
  • Unsubscribes (dh_UnsubscribeCount)

• Email

  • Bounced (dh_spotlerbounced)
  • Is Opened (dh_spotlerisopened)
  • Is Clicked (dh_spotlerisclicked)