I have user’s monthly activities in this format:
{
"2022": {
"5": {
"Likes": 2,
"Comments": 1
}
}
}If I sync this as user attributes, how would I be able to get answers to questions like:
Is this possible in Amplitude?
Best answer by Saish Redkar
Hey
There are many approaches to this depending on your use case.
IMO, the nested JSON approach is always be a tricky one for extracting the right datapoint. You can refer to this post for added context.
If you do use a nested json object property, you can try leveraging the EXTRACT_FROM_DICT function in the derived properties feature to create properties on the fly based on a specific key value if that appears useful. Assuming the ‘5’ is the month of May in your format, you can breakdown this as user_likes_May
Let me know if I have interpreted your use case correctly. Hope this helps.
+10Hey
There are many approaches to this depending on your use case.
IMO, the nested JSON approach is always be a tricky one for extracting the right datapoint. You can refer to this post for added context.
If you do use a nested json object property, you can try leveraging the EXTRACT_FROM_DICT function in the derived properties feature to create properties on the fly based on a specific key value if that appears useful. Assuming the ‘5’ is the month of May in your format, you can breakdown this as user_likes_May
Let me know if I have interpreted your use case correctly. Hope this helps.
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
