🏁Getting started with the Component Manager
How to get started with the Adobe Analytics Component Manager for Google Sheets. Explains how to generate the JWT API 2.0 Token and more.
Last updated
How to get started with the Adobe Analytics Component Manager for Google Sheets. Explains how to generate the JWT API 2.0 Token and more.
Last updated
You can set the Component Manager up all by yourself with the steps below. Alternatively, we gladly guide you through the setup step-by-step. Just get in touch with us through our contact form or send us an e-mail to contact[at]datacroft.de.
Not new, but simply want to know how to migrate an existing Component Manager from JWT to OAuth V2?
You can install the Component Manager Add-on either
a) directly from the Google Workspace Marketplace, or
b) via the Extensions menu in Google Sheets: In Google Sheets, click on Extensions -> Add-ons -> Get add-ons.
Then search for "AA Component Manager" and install.
If you have trouble installing, try to make sure you are logged in with ONE Google account (only for installing - you can later log in with other accounts again) or try in another browser.
After installing, follow the steps below:
To start, create a new Google Sheet and give it a useful name, e.g. "Component Manager My Company".
Set File -> Settings -> Locale to "United States" so your Google Sheet understands decimal numbers the same way the Component Manager does:
Then follow the video or text guide below:
You need to have System Administrator rights for your Adobe Experience Cloud. The process takes about 15 minutes.
Click on Extensions -> AA Component Manager -> Setup:
This will import all the necessary tabs. So wait a while until you see the "Finished (Re)creating sheet" message below.
After that, you should see an overlay to view the terms & conditions. With the next steps in the setup, you will also create a Component Manager account. This is why you first need to accept the terms & conditions when you run the setup for the first time.
You can now close the overlay.
We will continue with the Component Manager setup later. Now let's first set up the Adobe Analytics credentials.
Option a) Let us do it. Simply give your contact from Datacroft (or write to component-manager@datacroft.de) Experience Cloud Admin rights for a day or arrange a 15-minute call where we walk you through everything.
Option b) Do it yourself:
1. Under https://console.adobe.io/, log in with a user who has Developer rights (can be given via Adobe Admin Console -> Users -> Developers) for Adobe Analytics and is an Adobe Analytics Admin.
2. Create a "project" (ideally called "Component Manager API Access").
3. Click on "Add API", select "Adobe Analytics" -> Next -> select "OAuth Server-to-Server" -> Next
4. Select any Product Profile (technically, it does not matter which profile you choose because we will make this user an Admin soon, but choose one that makes the most sense for your organization), then "Save configured API".
5. On the following page, click on "OAuth Server-to-Server":
6. There, you should see the following credentials.
7. Now copy the Technical Account EMAIL (not the Technical Account ID!).
8. Log into the Adobe Admin Console and click on Products:
9. Go to Analytics:
10. Click on the "Admins" tab and then "Add Admin".
12. Paste the Technical Account Email you copied previously, then click the little arrow to the right and select the entry that appears below.
In the preview, you should now see "Enterprise ID" and an "SSO User Name":
Click Save. Your new Admin should show as "Technical Account" in the list.
You are now ready to check if the Component Manager can connect to the Adobe Analytics API.
1. Go to the config tab, then, select Extensions -> AA Component Manager -> Setup from the main menu again to finish the setup. You can also run this anytime again to update the API credentials.
3. Confirm the terms & conditions.
4. You are now asked to add each of the OAuth V2 Credentials that are required for the connection, in the following order:
Scopes
Client ID
Secret (click on "Retrieve Secret" to get it)
Org ID
Simply copy-paste them from your Adobe Developer project OAuth Credentials page.
Example:
5. Decide whether the Component Manager shall import the names and email addresses of your organization's Adobe Analytics users (see more here).
6. Confirm or change the Base Report Suite ID (see below). For now, you can leave this blank or simply enter your main Report Suite ID.
7. A "Thank you, we're setting up your account" message will appear. Check the config tab's columns G-I for the field "setup_status". After 20-30 seconds, it should show "success" as well as some rows informing you of the duration of your contract. You should then also see a "Setup result" success message.
Well done 👍! Your Component Account is created and the Adobe Analytics connection works!
After creating a new API User and linking it to an Admin account in Adobe Analytics, it can take a couple of minutes until the user can actually use her Admin rights. So if the Component Manager tells you that your user does not have Admin rights, try again after a couple of minutes.
For some features to work, you need to set the Base Report Suite ID. Simply enter your main Report Suite ID into the config tab next to "base_rsid":
You can get all Report Suite IDs directly in the Component Manager by running "AA Component Manager" -> "Report Suites" -> "Refresh Report Suites". Or you can find them under Admin -> Report Suites:
Any Component Manager Google Sheet will always show all Segments, Calculated Metrics and Date Ranges of your entire Adobe Analytics account, as these component types are not Report-Suite-specific. E.g., a segment you created in Report Suite A can be used in any other Report Suite.
However, dimensions (eVars/props & classifications) and metrics (Success Events) are Report-Suite-specifc. For example, eVar2 can mean something different in another Report Suite or it may not even be activated there. Similarly, Virtual Report Suites are built on top of a "Base Report Suite" (officially "Parent Report Suite").
Thus, the "Base Report Suite ID" tells the Component Manager from which Report Suite it shall import dimensions, metrics and Virtual Report Suites.
In other words, the Base Report Suite ID is the Report Suite ID from which...
eVars, props and Success Events are pulled in (segments, calculated metrics and date ranges are report-suite-independent)
Virtual Report Suites will be shown: the VRSs that have the Main Report Suite as their "parent suite"
You can change this ID at any time in the config tab or create a second sheet with another Base Report Suite ID.
You can also do this later, but to enable Virtual Report Suite functionalities, follow the steps here.
After you have all tabs (e.g. "comp_editor" etc.), you can start populating the sheet with data. You can take a shortcut by running "Other -> Populate all tabs":
After starting "Populate all Tabs", take a break and get a coffee, because the Component Manager should not be disturbed until it has finished the last tab to fill, which is the Component Usage tab. Filling the Component Usage tab for the first time can take 15 minutes to an hour, but you can start working in the other tabs once the Component Usage tab update has started. You will know that it has started because you will be moved to that tab and you will see this message popping up on the bottom right:
"Populate all tabs" actually does not populate "all" tabs, but only those that do not require any up-front configuration (like "Compare Report Suites").
Now enjoy the Component Manager! You have now officially become a hyper-efficient Adobe Analytics Admin!
Attention: The video below explains how to set up the API credentials with the deprecated JWT method! We strongly recommend following the OAuth V2 guide above! We will provide a new video for OAuth V2 soon!
