Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Suggested answer

CI Only Picking Up 1 Activity

(0) ShareShare
ReportReport
Posted on by 80

I have a customer insights profile for customers. I added a new entity for spending transactions.This entity has an ID field that is linked to an ID field in the customer profile (but not the CustomerID field).

I have Run the activities.

When I look up a Customer Profile, I see only 1 single transaction. The transactions are correctly linked to each of the Customer Profiles, however, each CP should show at least 5 or more transactions over time. 

The relationships are correct, i.e. Many to 1 from the transaction source to CI based on the custom id field. 

If I import the data into Power BI I can then create the link between the two tables and the data shows up correctly there (meaning each customer has multiple transactions).

Any suggestions on what could be happening here?

  • MichelleD  Profile Picture
    MichelleD on at
    RE: CI Only Picking Up 1 Activity

    Thanks Halen for your reply on this and your comments. This is indeed very helpful. We had a few deep dives with Mike and were able to resolve the issue.

  • Suggested answer
    MichelleD  Profile Picture
    MichelleD on at
    RE: CI Only Picking Up 1 Activity

    Glad we were able to resolve your issue Mike. Please reach out if you have further issues.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CI Only Picking Up 1 Activity

    Hi Mike,

    It's difficult to say off the cuff what the issue could be.

    I have experienced similar issues before and a combination of thorough data checks and re-configuring the activities have usually solved the problems.

    Using Power BI, I would connect to your CI environment and pull in the Customer and UnifiedActivity entities. Once you have mapped these using the customerid field, I would then do some analysis to determine whether the missing activities are for certain customer profiles only or for all of them.

    Aside from making sure your relationships are sound, I would also check your date time fields for your activities as well as the unique id for each activity record. These are important and sometimes they can influence what ultimately shows up in the profiles.

    If you can afford to, remove the activities and relationships and then re-add them.

    Hope this helps.

    Halen

  • MikeHamm Profile Picture
    MikeHamm 80 on at
    RE: CI Only Picking Up 1 Activity

    Hi Michelle,

    When I sent my email to cihlelp@microsoft.com it got rejected.

    I think this is due to our corporate email server is based out of Europe. We have been seeing our US emails get bounced regularly.

    Here is the bounce message. My direct email is mha mm ons @ h s o dot com  (remove spaces).

    emailbounce.png

  • MichelleD  Profile Picture
    MichelleD on at
    RE: CI Only Picking Up 1 Activity

    Mike we believe we have found the issue. Can you reach out to us at CIhelp@microsoft.com so we can share more details to help you mitigate this.

  • MichelleD  Profile Picture
    MichelleD on at
    RE: CI Only Picking Up 1 Activity

    thanks Mike for the update and sharing. Will take a look and come back to you.

  • MikeHamm Profile Picture
    MikeHamm 80 on at
    RE: CI Only Picking Up 1 Activity

    Hello Michelle,

    Yes I can see the multiple activities per Customer in the UnifiedActivity download file.

    [View:https://crm293620.sharepoint.com/:x:/s/CI/ESxZVWlr2adLvPYa1fUUXAYBpbp7Vk-zOvEytm7WVM6dXA?e=I3BRgX:161:130]

    Mike

    Tenant ID: 308085a9-1ee4-4ba6-abcd-5f7400da5bdd

    Environment ID:5af356a5-de74-4ee5-9605-7ca617a46714

  • MichelleD  Profile Picture
    MichelleD on at
    RE: CI Only Picking Up 1 Activity

    Hello Mike, thanks for reaching out. Can you let me know if you see 5 transaction in the UnifiedActivity entity? You can check this by downloading the activities and searching. If the download is too big, please send me you instanceID and I will look into it and come back to you.

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,969 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,842 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans