Hello,
I was looking into pulling data on from Marketing Insights programmatically. To do this I pulled from the CSV files in Azure Blob Storage. I got the container location from the Marketing Analytics Configuration file so I know this is the export location for the Marketing data plus I see the CSV files being updated periodically. I see all the folders such as EmailOpened, WebsiteVisited, EventCheckIn, etc. So it seems pretty straightforward to read these files and get data about a particular Contact's Insights data, but I found that the data in these CSV files is incomplete. For example, I open the most recently modified CSV in the EmailOpened folder and filter for a particular Contact ID. It returns 2 rows. Then I go to that Contact's record and it shows that it had 5 Email Opens in the same timeframe. The two rows in the CSV file are there, but there are additional rows missing it seems. Over and over again I saw this. I even checked other files like the WebsiteVisits and saw the same thing. The CSVs only had a subset of the entries from the Contact records. So who is correct here? Are the CSVs correct and the Contact records showing erroneous data or are the CSV files incomplete. If so, where is the other data coming from? I would appreciate any insight into Insights (hehe).
Hi mkubala,
Thanks for reaching out.
You need to load all CSV files, not just the latest one as. As new interactions are generated, files are updated in parallel, therefore multiple files can be modified at the same time.
Please let me know if that helps.
Kind regards
André Arnaud de Cal...
291,979
Super User 2025 Season 1
Martin Dráb
230,848
Most Valuable Professional
nmaenpaa
101,156