Component Usage
How to interpret the Component Usage tab (all_comp_usage).
Last updated
How to interpret the Component Usage tab (all_comp_usage).
Last updated
The Component Usage tab is a "gold mine" for Adobe Analytics admins trying to optimize their setup. It shows, for example:
all components and how often they are used, and where, i.e.
in how many and which Workspaces ("Projects")
in how many and which Segment or Calculated Metric definitions
in how many and which Alert definitions
duplicate Segments and Calculated Metrics (same definition, but different name/description)
to which Virtual Report Suites's "Curated Components" a component belongs
After setting up your Component Manager, click "Component Usage -> Updated Component Usage tab" to update.
You can follow the progress in the status bar:
When done, it will show "FINISHED!".
Be patient! The first update of the Component Usage tab can take a while. It takes roughly ...
15 min to 45 hour for a small account (< 2'000 Workspaces and 7'500 Components)
up to 2 hours for a medium account (< 5'000 Workspaces and 30'000 Components)
It is recommended not to run other tasks during the update to avoid 429 "too many requests" API errors. The Component Manager can work around them, but anytime it encounters this error, it will take a little break, so the execution will take longer.
If you have a really huge account and cannot get all results within 2 hours, scroll down to the chapter on "Limiting the data".
Scroll down to that chapter as well if you have more than the maximum Components or Workspaces for an individual run.
The next time you run the Component Usage update, it is generated by calculating the delta to the previous update. So unless you have changed a huge number of workspaces since then, it should not take more than 5-15 minutes.
owner name: Name of the owner (if personal data is enabled).
modifiedById: User ID of the user who last modified the component
definition: The technical definition in JSON format
rsid: The "Parent" Report Suite ID in which this component was created.
componentType: The type (segment, calculated metric, dimension, metric or date range)
includeType:
shared = "shared with all"
all = "all components" (no matter if shared)
templates = out-of-the-box component (e.g. "Visit") visible to anyone
matching_projects_count: In how many Workspace projects is this component used (= the workspace contains at least one panel in which this component is used in whatever form (e.g. in a table, a graph, a dropzone filter, etc...)
matching_calc_metrics_count: In how many Calculated Metrics definition does this component figure?
matching_segments_count: In how many Segment definitions does this component figure?
matching_alerts_count: In how many Alert definitions does this component figure?
matches_total: Previous 4 columns summed up. A zero here means a component is an "orphan", i.e. it exists, but it is not used anywhere --> a deletion candidate
matching_projects_ids: The matching Workspace Project's IDs
matching_projects_names: The matching Workspace Project's names
matching_segments_ids: The matching Segments' IDs
matching_segments_names: The matching Segments' names
matching_calc_metrics_ids: The matching Calculated Metrics' IDs
matching_calc_metrics_names: The matching Calculated Metrics' names
matching_alerts_names: The matching Alerts' names
matching_alerts_ids: The matching Alerts' IDs
duplicate_segments_count: For segments, shows number of duplicates, i.e. segments which are the same by their definition, but may have a different name or description
duplicate_segments_ids: The IDs of all segments that are duplicates to this one (including this one)
duplicate_segments_names: The names of those segments
duplicate_calcmetrics_count: For Calculated Metrics, shows number of duplicates, i.e. Calculated Metrics which are the same by their definition, but may have a different name or description
duplicate_calcmetrics_ids: The IDs of all Calculated Metrics that are duplicates to this one (including this one)
duplicate_calcmetrics_names: The names of those Calculated Metrics
write_timestamp: When was this row generated (UTC)
VRS columns: show if the component is among the curated Components of the VRSs and the Curated Name used in that VRS (if any). See "Configuring Virtual Report Suites".
either the Adobe API does not provide this info (e.g., there is no data on the last modification date of an eVar)
or some fields simply make no sense for all components (e.g. you simply cannot modify the built-in "Visits" metric, so there is no modification date either)
In such cases, you see not supported by this component.
Very long values are cut off
Columns like "description", "definition", or the "matching names" can get very long and are thus truncated after a certain number of characters. Otherwise they could break Google Sheet's max cell limits or make writing to GoogleSheets via the API impossible. The calculations, e.g. of the number of matches, are made before truncation. Truncation is only applied shortly before the data is written to the Google Sheet.
With "Component Usage -> Suggest Components for deletion", you can have the Component Manager weed through the Components in the Component Usage tab, find the thousands of unused components that are deletable and suggest them for deletion. If you do not want to delete them directly, you can also automatically append a "warning" text to component names, e.g. "- WILL BE DELETED SOON".
See this video on how to:
Together with the Component Replacer, the Component Manager can also be used to harmonize duplicate segments or calculated metrics.
If you think you need to use any of the filters below, it is best to contact your Datacroft support for the best strategy. The following is not an exhaustive explanation.
If you have a huge account that goes beyond the maximum allowed components per Component Usage run (7500 workspaces and 35000 components), or if you want to gain speed by just concentrating on certain component types (e.g. "only segments and calculated metrics"), you can limit the data via the "Component Usage Tab Filter" settings in the "config" tab (it is not required to fill in all fields):
In this example, we are telling the Component Usage generator ...
to look for component matches only in Workspaces with changes since Dec 31, 2020 and Sep 30, 2021
to limit the components types to check to Segments and Calculated Metrics
to check only components of the type "all" and "shared" (since we cannot change template components anyway)
to check a maximum 20k of those components matching the other filters
and a maximum of 5k workspaces matching the other filters
furthermore we limit the workspaces scan to Workspaces created in RSIDs "reportsuite1", "reportsuite2" and "reportsuite3"
The maximum applies per run. So you could do the first run for 5'000 Workspaces with modification dates in this year, and then change those dates to last year for the second run and thus get matches in all your 8'000 Workspaces.
