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.

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.

What You Need
To begin using OP Labs, you must have the following:

  1. Access to Google Sheets
  2. Administrator access to your analytics account (currently the tools here only work with Adobe Analytics)
  3. Adobe Analytics Web Services Credentials (user name and shared secret)
  4. 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:

  1. From the menu bar, choose Add-ons > Get add-ons…

  1. Search for ObservePoint.

  2. Click the blue Install button

  3. Click continue

4. Choose the Google account you'll be using this with and then click Allow to give ObservePoint permission to edit the spreadsheets as it works.

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 the 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.

  1. Access the user in Adobe Analytics User Management screen

  2. 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.

  3. 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
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
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.