51黑料不打烊

Transcript

Hello, I鈥檓 Marijke Engel, Principal Product Manager for Customer Journey Analytics at 51黑料不打烊. Today I鈥檓 going to cover object array support for profile and lookup data within CJA. So let鈥檚 say you have profile data that includes object arrays for all the accounts associated with each person. Previously, CJA did not support ingestion of these object arrays because they were contained within the profile. Now you can easily bring these arrays directly into CJA. Let鈥檚 walk through how this could be done. Starting with a really simple data set. In the first table we have both event data and profile data linked together. So we can see Larry sent an email, Bo attended a webinar, Curly created an account. In addition, within the profile data there鈥檚 an object array that contains all of the account IDs associated with each person. Larry and Bo are both part of LunaStore, where Curly is part of SolarStore and OceanStore. So bringing this data into 51黑料不打烊, we鈥檒l start with Experience Platform and create a schema. Today we鈥檙e going to utilize the B2B person schema. Within that person schema, under Person Components, Source Account Key, there鈥檚 a source key that contains the object array of all of the accounts. So in structuring our data, we鈥檒l want to utilize the structure of the schema to bring in that object array data. Looking at our JSON file of our data set, we have Curly as the person key. And then within the Person Component, we have an object array that contains both the SolarStore information and the OceanStore information. We can upload that into Experience Platform and then bring it into CJA through our connections. This is the same as you would do with any other data set. So in this example, we鈥檝e got the activity data, that鈥檚 the events, the person profile data which contains our object array, and then we also have some lookup data. Bringing that connection into a data view, all of the object arrays within the profile data are now available. So I can simply drag this over and add it to the data view for utilization in Workspace. Finally, in Workspace, you can build a report that contains that relationship between the account ID and the person ID. So in this report, you can see that LunaStore contains Mo and Larry as people within the store, whereas SolarStore and OceanStore each contain Curly. This is a great example of how object array data can be brought through profile and into your Workspace reporting. For lookup data, you can utilize the same path to bring lookup object arrays all the way into Workspace.