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 NeedTo 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)

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.

Configuration

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.

Tabs

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 Variable Rules Regular Expression

All Tools

Evars

List of all defined eVars eVar Settings from Adobe

SDR Builder

Props

List of all defined s.props s.prop settings

SDR Builder

Events

List of all defined events Event settings

SDR Builder

Audit Comparison

URLs for each page in audit Analytics tag data for each URL

Audit Comparison

URL Diff Results

URLs missing from Pre-audit URLs missing from Post-audit

Audit Comparison

Did this answer your question?Thanks for the feedbackThere was a problem submitting your feedback. Please try again later.