ObservePoint Labs Introduction
The ObservePoint Labs is a Google Sheets plugin with experimental tools under development. Customers are welcome to use these tools with the understanding that they are not supported, and in some cases, they may not even be documented. There is no guarantee that these will even work as expected. If you are willing to take that risk, then welcome, and enjoy the journey!
We hope you will give us your comments on the tools as you use them. Please email your feedback to Patrick Hillery.
The ObservePoint Labs currently has several tools. Click the buttons on the Main Menu to access each tool and return to the Main Menu by clicking the yellow ObservePoint logo in the upper left screen.
SDR Builder: The main tool is the SDR Builder. With this you can generate sheets that show all the variable settings of any of your report suites and allow you to create and manage an SDR. Use this to set the Adobe report suite variables and generate custom validation rules in ObservePoint.
Approved Tags: Use this to identify all the tags that are allowed on your site and verify that any unapproved tags are not found in any audits.
Audit Comparison: Use this to check two separate audits to see what has changed between the two. This is particularly helpful to quickly spot if any variables have stopped populating or if any pages are missing from either of them.
What You Need
To begin using OP Labs, you must have the following:
- Access to Google Sheets
- Administrator access to your analytics account (currently the tools here only work with Adobe Analytics)
- Adobe Analytics Web Services Credentials (user name and shared secret)
- Your ObservePoint API Key
Installing the Tool
OP Labs is an Add-on for Google Sheets. Create a new blank document in Google Sheets and follow these steps:
- From the menu bar, choose Add-ons > Get add-ons…
Search for ObservePoint.
Click the blue Free button
- Scroll to the bottom of the pop-up and click the button to allow the permissions
The Add-on is now installed and you can use it in any Google Sheet. Click the Add-ons menu to begin using it.
Note: Disable Web Journey Manager in the extensions screen or it may impede ObservePoint Labs from loading in Google Sheets.
ObservePoint Labs tools require credentials from both ObservePoint and Adobe Analytics in order to communicate between the two platforms. When you first open it, the Labs presents the Settings screen. Enter and save your credentials here.
Finding the API Keys
The ObservePoint API key is only available from your Customer Success Manager. Depending upon your user level, you may request either an admin or user key. An admin key will have access to all the properties in your account, while a user key will only be able to access the properties to which that user is assigned.
The Adobe credentials include both a combination of the user name and company as well as the web services key.
Access the user in Adobe Analytics User Management screen
Scroll down the page and find the Web Service Credentials box. If you do not see this, it is likely because you don’t have Web Services Access enabled on your user--your administrator will need to grant you this permission.
Copy the User Name and Shared Secret fields and paste them into the Adobe User:Company and Key fields in the SDR Builder Settings.
If your ObservePoint or Adobe keys change, you must update them in the SDR Builder settings.
Once you save your settings, the builder creates a new configuration sheet. You can always return to the Settings page by clicking the gear icon in the upper right corner of the builder.
Your keys are not shown in the Settings after saving them. If you delete the Config tab, you will need to return to the Settings and re-enter and save your credentials.
Each tool in OP Labs creates its own set of tabs or sheets. The following chart describes these and lists the tool that uses it:
|Tab Name||Content||Used By|
|Config|| Setup Information
Report Suite IDs
|Evars|| List of all defined eVars
eVar Settings from Adobe
|Props|| List of all defined s.props
|Events|| List of all defined events
|Audit Comparison|| URLs for each page in audit
Analytics tag data for each URL
|URL Diff Results|| URLs missing from Pre-audit
URLs missing from Post-audit