Expand my Community achievements bar.

Webinar: Adobe Customer Journey Analytics Product Innovations: A Quarterly Overview. Come learn for the Adobe Analytics Product team who will be covering AJO reporting, Graph-based Stitching, guided analysis for CJA, and more!
SOLVED

Adobe Analytics Product Profile users cleanup

Avatar

Level 2

Hi everyone,

We're looking to clean up our Product Profiles by removing inactive users. This includes:

  • Users who haven't interacted with the product. E.g. - for more than 6 months (considered inactive).
  • Users with inactive email addresses (likely due to them leaving the organization).

Ideally, we'd like to automate this process. Is there a way or API in Adobe Analytics that allows us to:

  1. Identify these inactive users based on the criteria mentioned above.
  2. Remove them from the respective Product Profiles.

Any insights or suggestions on achieving this cleanup would be greatly appreciated.

Thanks

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Not quite exactly. Adobe Analytics is relying on Adobe Experience Cloud to manage user accounts and profiles. There is no direct API on Adobe Analytics to query the last access of users, but there is a deeper Usage API, Usage API (adobe.com), to get more details usage and access logs. This is an interesting API and I am looking for some use cases on that as well. If using the API, you will need to iterate months back to get the full picture and better store them locally to build your inventory so there is no need to look back into history using API every time.

However, back to your request that API could be a bit overkilled and too complicated. You can manually get the list of Adobe Analytics user and their last access timestamp from the "Admin" menu then "Analytics users & assets", where you can select all to down as CSV. Of course, there is no way from either the API or downloaded CSV to tell if those email addresses are still valid or not, you need to implement your logic and cross-check with some other data sources to determine who should be deleted.

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Not quite exactly. Adobe Analytics is relying on Adobe Experience Cloud to manage user accounts and profiles. There is no direct API on Adobe Analytics to query the last access of users, but there is a deeper Usage API, Usage API (adobe.com), to get more details usage and access logs. This is an interesting API and I am looking for some use cases on that as well. If using the API, you will need to iterate months back to get the full picture and better store them locally to build your inventory so there is no need to look back into history using API every time.

However, back to your request that API could be a bit overkilled and too complicated. You can manually get the list of Adobe Analytics user and their last access timestamp from the "Admin" menu then "Analytics users & assets", where you can select all to down as CSV. Of course, there is no way from either the API or downloaded CSV to tell if those email addresses are still valid or not, you need to implement your logic and cross-check with some other data sources to determine who should be deleted.