So I am exporting data views using the automation studio for each of the data view objects (open, click etc.) to FTP then from there our backend guy takes these csv files and inserts them into another platform.
The problem is that my counts in Marketing Cloud when I use query studio are way higher than our external platform. Is there something I am missing in how MC tabulates data vs our platform? Anything I haven't thought of to look into?
Below is a sample code of one of my queries which exports our data to FTP. Thanks!
SELECT o.AccountID ,o.OYBAccountID ,o.JobID ,o.ListID ,o.BatchID ,o.SubscriberID ,o.SubscriberKey ,o.EventDate ,o.Domain ,o.IsUnique ,o.TriggererSendDefinitionObjectID ,o.TriggeredSendCustomerKey ,cal.uuid__c AS AccountUUID ,cal.User_uuid__c AS UserUUID FROM _Open o with(nolock) inner join [contact_all] cal on o.subscriberKey = cal.id WHERE EventDate > dateadd(hh,-2,getdate())