Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Answered

Marketing Insights data doesn't match CSV files from Azure Blob Storage

(0) ShareShare
ReportReport
Posted on by 40

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

  • Verified answer
    MiltosV Profile Picture
    MiltosV on at
    RE: Marketing Insights data doesn't match CSV files from Azure Blob Storage

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans