7 Steps to Clean up Adobe Analytics in a Data-Driven Way

Merge duplicate segments and calculated metrics, delete unused components, and get rid of those thousands of old workspaces

Thanks to the Adobe Analytics API, you can finally get your Analytics setup back under control and put an end to user (and admin) frustration because of seemingly endless lists of components with similar names, duplicates etc.

A good data engineer can write the queries needed for the steps below herself with the Adobe Analytics API 2.0, e.g. via Julien Piccini’s Python Wrapper. Or you can go the easy way and use the Adobe Analytics Bulk Component Manager for Google Sheets by Datacroft (see previous articles on the Component Manager as a driver for efficient Virtual Report Suite Components Curation, or how you can easily find 100’s of unused segments with it).

Step 1: Identify unused Workspaces

  • have not been viewed in the last 90 days
  • have no active email schedules (regular PDF/CSV exports)
  • have not been modified in the last 6 months.

In the Component Manager, go to the “Workspaces” tab. Update it via the menu “Adobe Component Manager > Workspaces > Update Workspaces list”, then filter …

  • the “modified” column by “Date is before” -> “exact date” -> your date in format “2020–07–01”
  • the “viewsLast90Days” and “activeScheduledJobs” columns by “0”
Filter unused workspaces

Step 2: Tell owners to mark the Workspaces they still need

In the email to the owners, send the link to the sheet, explain the benefits (cleaner, faster Analytics with less interpretation errors, misunderstandings and frustration) and explain that they need to mark all Workspaces they still need with “x”.

Give owners a bit of time to mark what they still need.

Step 3: Delete all unused Workspaces with one command

Deleting Workspaces in bulk: mark with x, run “Delete Workspaces”

When the deletion is done, the “Workspaces” tab refills, with now hopefully hundreds of Workspaces less (at 2 clients, we recently deleted 700 and 1'230 Workspaces respectively this way). Moreover, in the “update_log” tab, you can download an Excel file that shows you which workspaces were deleted (un)successfully (unsuccessfully e.g. because the Workspaces had been deleted before already).

The “update_log” documents almost all changes to components and workspaces initiated by the Adobe Analytics Component Manager for GoogleSheets.

Step 4: Identify unused components

The Component Usage Tab shows all Components, their usage (in which Workspaces, Segments, and Calculated Metrics) and even shows you each segment’s and calculated metric’s duplicates. Update it to see how many components are now “orphans” after you have deleted all those workspaces.

The Component Usage tab is probably the most useful of all (see this video to see it in action). It shows all components by their usage, i.e.: In how many and in which Workspaces, Segments, and Calculated Metrics is each component used? See e.g. the Calculated Metric “Avg. Order Value (Product Revenue)” marked in green below: It is quite popular, as it is used in 146 Projects (Workspaces), 0 Segments and 0 Calculated Metrics (which is no surprise because Calculated Metrics cannot be used in Segments or other Calculated Metrics).

Some components are hugely popular among your users, others aren’t.

This is super useful, because we can now simply filter like this:

  • componentType “calculatedMetric”, “dateRange”, or “segment”
  • includeType: “all” or “shared” (because “template” components refer to out-of-the-box stuff like “Visits” or “PageName” which cannot be changed)
  • matches_total: 0

This gives us a list of only the components that are not used anywhere and can likely be deleted. This list should now be longer — because we have just deleted a lot of workspaces where a certain component may have been used before.

With the filters we can detect components that are not used anywhere (matches_total = 0).

Step 5: Delete all unused Components with one click

Paste the IDs into the “id” column, the rest of the columns will fill automatically.

Now choose method “delete” in one of the drop-down menus in the “method” column and copy it down to the last row.

Now, choose “Component Editor -> Send Updates to AA”.

You are taken to the “update_export” tab and can review the changes before finally confirming.

Do a final check on the “update preview” tab and confirm.

Update: Do all this with one click

Need I mention that the update_log tab logs all these deletions as well? No, I don’t. The status area on the component_editor tab shows you the progress and reloads all components after the deletion is finished. You can now verify in the left blue area that the deleted components are indeed gone (Select “All Components” and then search for the deleted IDs — or go into Adobe Analytics and see for yourself! :))

Select “All Components” to get a list of all components, or if you use Curated Components-enabled Virtual Report Suites, you can select any of them to see only their components as well.

Step 6: Identify duplicates

Now you can help your users by automatically replacing duplicate components by their “default” version:

  1. Identify the duplicates by filtering out blanks from the column “duplicate_calcmetrics_names”
  2. Sort the table by the same column so you have the duplicates on top of each other.
  3. Determine the “survivor” for each duplicate.
    Example: In the first 2 rows below, we see 146 usages for “Avg. Order Value”, but only 3 usages for its duplicate “Product Revenue / Orders”. Here it is clear that “Avg. Order Value” deserves to survive the cleanup. You can use the “remarks” column on the left (not in screenshot) to mark the survivors with S and the losers with L.
Determine who will survive the “great purging of the duplicates”.

Step 7: Merge duplicates by automatically replacing them everywhere

Copy-paste the IDs of the “losers” (the components that will perish) on the left side and the “survivors” on the right side.

In the example below, “% Bot Traffic” will e.g. be replaced by “% Visits by Bots”. Now run Component Usage > Run Component Replacer and wait a bit.

Easily replace the components on the left by those on the right in any Workspace, Segment, or Calculated Metric.

After the cleanup, we can delete the components on the left (the losers). Once again, we simply copy their IDs over to the “component_editor” tab and follow “Step 5: Delete all unused Components with one click” to delete them.

(optional) Last Step: Now tackle your technical implementation (eVars, props, Success Events)

Too many Success Events = too many get used sparingly or not at all.

Tedious manual sifting-through is in the past

To learn more, schedule a free demo and get a free trial, contact me on LinkedIn (with a message, please, too much contact spam), or request a demo on the official Datacroft Component Manager website.

Digital Analytics Expert. Owner of dim28.ch. Creator of the Adobe Analytics Component Manager for Google Sheets: https://bit.ly/component-manager