README.md

Models / Collections

[x] Note: must handle campaign.excludeUrls urlId and sendId together in one process.

ad-creative-trackers (done)

• no ddt data

ad-creatives (done)

• no ddt data

behavior-entities (done)

• no ddt data

behavior-views (done)

• no ddt data

campaigns (done)

• 314 ddt records
• relationships
  • customerId
    • 64 distinct customerIds
  • email.tagIds
    • 0 distinct tagIds
  • email.excludeUrls.urlId
    • 6 campaigns with this field set
  • email.excludeUrls.sendId
    • 6 campaigns with this field set
  • forms.excludeFormIds
    • 0 distinct formIds
  • ads.tagIds
    • 0 distinct tagIds
  • ads.excludeTrackerIds
    • 0 distinct tracker ids
• models that reference this
  • identity (can be ignored, no data)

click-requests (done)

• can likely ignore

content-query-results (done)

• can ignore

customers (done)

• 239 ddt records
• unique index on key field (when not deleted)
• when a duplicate key is found, merge with IEN customer
• relationships
  • parentId
    • 0 records
• models that reference this
  • campaign
  • extracted-host
  • extracted-url
  • form (can be ignored, no data)
  • identity (can be ignored, no data)
  • order

email-categories (done)

• 22 ddt records
• externalSource.identifier values will need to be handled for DDT BU
• relationships
  • parentId
    • 21 categories with this field set
    • 6 distinct categoryIds
• models that reference this
  • email-category
  • email-deployment
  • email-send-url
  • line-item (can be ignored, no data)

email-deployments (done)

• 721 ddt records
• externalSource.identifier values will need to be handled for DDT BU
• relationships
  • categoryId
    • 721 deployments with this field set
    • 20 distinct categoryIds
• models that reference this
  • email-send-url
  • email-send

email-send-urls (done)

• 31,230 ddt records
• unique key on sendId, urlId
• relationships
  • deploymentId
    • 721 distinct deploymentIds
  • sendId
    • 1,307 distinct sendIds
  • categoryId
    • 9 distinct categoryIds
  • urlId
    • 5,114 distinct urlIds

email-sends (done)

• 1,308 ddt records
• externalSource.identifier values will need to be handled for DDT BU
• relationships
  • deploymentId
    • 721 distinct deploymentIds
• models that reference this
  • campaign
  • email-send-url
  • event-email-click
  • line-item (can be ignored, no data)

errors (done)

• can likely ignore

event-ad-creatives (done)

• no ddt data

event-email-clicks (done)

• 458,689 ddt records
• unique index on day, job, url, usr
• relationships
  • url (extractedUrlId)
  • usr (identityId)
  • job (sendId)

excluded-email-domains (done)

• no ddt data

extracted-hosts (done)

• 129 ddt records
• unique index on value
• relationships
  • customerId
    • 14 hosts with this field set
    • 14 distinct customerIds
  • tagIds
    • 0 hosts with this field set
• models that reference this
  • extracted-url

extracted-urls (done)

• 6,137 ddt records
• unique index on shortId
• unique index on values.original
• relationships
  • resolvedHostId
    • all urls have this field set
    • 113 distinct hostIds
  • customerId
    • 904 urls with this field set
    • 234 distinct customerIds
  • tagIds
    • 4,649 urls with this field set
• models that reference this
  • campaign
  • email-send-url
  • event-email-click
  • line-item (can ignore, no data)
  • url-acknowledgment

form-entries (done)

• no ddt data

forms (done)

• no ddt data

honey-pots (done)

• can likely ignore

identities (done)

• 21,871 ddt records
• externalSource.identifier values will need to be handled for DDT BU
• need to determine how to handle "duplicate" email addresses
• relationships
  • inactiveCustomerIds
    • 0 records
  • inactiveCampaignIds
    • 0 records
  • inactiveLineItemIds
    • 0 records
• models that reference this
  • event-email-click
• api verification
  • 672 transferrable records were not found in the IEN API
  • all of these were also not found in the DDT API
  • conclusion: these were removed from ET entirely

line-items (done)

• 3 ddt records
• relationships
  • orderId
    • 3 records
    • 3 distinct orderIds
  • categoryIds
    • 0 records
  • tagIds
    • 0 records
  • excludedUrls.urlId
    • 0 records
  • excludedUrls.sendId
    • 0 records
• models that reference this
  • identity (can ignore, no data)

orders (done)

• 3 ddt records
• relationships
  • customerId
    • 3 records
    • 3 distinct customerIds
  • salesRepId (userId)
    • 3 records
    • 2 distinct userIds
• models that reference this
  • line-item

pings (done)

• can ignore

tags (done)

• 5 ddt records
• unique index on name (when not deleted)
• models that reference this
  • campaign (can ignore, no data)
  • extracted-host (can ignore, no data)
  • extracted-url
  • line-item (can ignore, no data)

tracked-campaigns (done)

• no ddt data

url-acknowledgments (done)

• 757 ddt records
• unique index on shortId
• relationships
  • urlIds

users (done)

• 18 ddt records
• unique index on email (when not deleted)
• merge with ien records
• models that reference this
  • order

videos (done)

• no ddt data