Measure Attributes on Customer Profile Export

(0) Share

Report

Posted on by Bill Ryan

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?

All responses (3)

Answers (1)

Suggested answer

Wayne Wang on at

Like (0)

Report

RE: Measure Attributes on Customer Profile Export

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.
Bill Ryan 8 on at

Like (1)

Report

RE: Measure Attributes on Customer Profile Export

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.
Verified answer

Brian Stubelt 2 on at

Like (3)

Report

RE: Measure Attributes on Customer Profile Export

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.