autoSDR for SiteCatalyst

• • People often forget to update SDR.

  • Manual copy-and-paste is error-prone.

  • Switching RSID/eVars/props/events is time-consuming.

So I created this autoSDR that can be automatically updated with a single click.

Features

• • Create or update SDRs for all Report Suites with a single click

  • Settings for eVar, Props and Events are aggregated on one sheet per RSID

  • RSID can be filtered by a term (partial match)

  • Functions built in Google Docs are also available:

    • PDF/Excel/CSV Export

    • See revision history

    • Sharing and publishing

How to get started

• 1. Make sure you are a member of "Web Service Access" Group. You are NOT by default.

  2. Get your "Shared Secret" which you can get from the Web Services section of the SiteCatalyst Admin Console.

• 1. Click here to open the spreadsheet on Google Docs. It is being shared as a read-only doc, so you need to "Make a copy" for yourself to use it.

• 1. Click "autoSDR" menu and select "Sign In & Update".

• 1. Sign In using your Web Service Credentials.

• • 1. Company: the same company name you use to sign in SiteCatalyst

    2. Username : the same user name you use to sign in SiteCatalyst

    3. Shared Secret: You can get this from the Web Services section of the SiteCatalyst Admin Console.

    4. Data Center: Ask your admin or account manager if you don't know where your data resides.

    5. Remember me: Five items on this dialog can be saved in your personal profile.

• 1. Wait until all the sheets are created with settings filled-in.

Notes

• • If you have too many report suites, you can filter RSID.

    • If the simple filter (partial match) doesn't work for you, create another user and grant access to a subset of report suites.

  • Each update consumes four API tokens (number of RSID is irrelevant here).

  • This is my personal project. No support is provided by Adobe Systems.

This is what I needed when I was a customer with 100+ report suites. I believe every admin can enjoy this, so I am making this available to all. Enjoy!

Mak Shimizu