web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Answered

Measure Attributes on Customer Profile Export

(0) ShareShare
ReportReport
Posted on by 8

I have created a few measures that I need on the customer profile. I also need the Customer LifeTime Value score on it.  I know if I export the customer profiles I can connect to the fields in the entities stored in the lake, but that's a lot of custom work.  Is there something I'm missing with regard to Customer Attributes?  What I mean is, I was under the impression they were added to the profile by default but on Export they don't seem to.  Is there anything I can do to make them appear in Exports?

I have the same question (0)
  • Verified answer
    Brian Stubelt Profile Picture
    2 on at

    By default, measures are not added to the 'Customer' table. Measures that are of type 'Customer Attribute' are in a separate 'Customer_Measure' table. However, if the measure is of type 'Customer Measure' it will have an individual table. So if I'm understanding your question right, you will seemingly need to export a couple tables and merge them.

  • Bill Ryan Profile Picture
    8 on at

    Thanks Brian - that's what I was asking - I was able to find them after the export and joining them but someone had told me when a measure was added as a customer attribute, it would be joined to the profile.  I was a little suspicious and it sounds like they were wrong. You confirmed what I was hoping to confirm, appreciate it.

  • Suggested answer
    Wayne Wang Profile Picture
    Microsoft Employee on at

    Thanks Brian for the answer!  Yes, 'Customer Attribute' type measures are all saved as columns in the system-generated table named Customer_Measure, while 'Customer measure' type measures are saved as individual tables.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 166 Super User 2026 Season 1

#2
Jimmy Passeti Profile Picture

Jimmy Passeti 51 Most Valuable Professional

#2
NeerajPawar Profile Picture

NeerajPawar 51

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans