Querying Adobe Sitecatalyst using ShufflePoint
Summary
Adobe Sitecatalyst, now marketed as Adobe Analytics, is marketing anaytics and customer intelligence platform.
Setup
Visit Manage Datasources and enter your Sitecatalyst username and key, which you can get from your Adobe account administrator.
Available Report Suites, Dimensions, and Metrics
Unlike Google Analytics, which has a static set of metrics and dimensions across all accounts, Sitecatalyst can have different dimensions and metrics for each report suite. You can download a spreadsheet with the metrics and dimension available for a report suite as follows.
In the "Adobe Sitecatalyst" section of the "Manage Datasources" page is a link View available report suites. Open that page and you are presented with a table of the available report suites associated with the API credential you provided.
Click on a row of the table and then click "Download". This will download an Excel spreadsheet which contains tabs for EVars, Calculated Metrics, Events, Classifications, Segments, Metrics, and Elements. With these in hand, you can construct your AQL queries against SiteCatalyst.
Sample metadata queries
In addition to downloading a spreadsheet with metadata for a report suite, you can use AQL to retrieve the same information. Samples queries are shown below
eVars
SELECT
METRICS xx:identity ON COLUMNS
DIMENSIONS sc:evarName, sc:type, sc:enabled, sc:expirationType, sc:expirationCustomDays, sc:allocationType ON ROWS
FROM [SUITE]
Calculated Metrics
SELECT
METRICS xx:identity ON COLUMNS
DIMENSIONS sc:calculatedMetricName, sc:type, sc:formula, sc:friendlyFormula, sc:decimalPlace, sc:formulaId, sc:visibility ON ROWS
FROM [SUITE]
Events
SELECT
METRICS xx:identity ON COLUMNS
DIMENSIONS sc:eventName, sc:eventId, sc:type, sc:defaultMetric, sc:participation,sc:serialization ON ROWS
FROM [SUITE]
Classifications
SELECT
METRICS xx:identity ON COLUMNS
DIMENSIONS sc:elementName, sc:elementId, sc:type, sc:classificationName, sc:classificationDateEnabled ON ROWS
FROM [SUITE]
Metrics
SELECT
METRICS xx:identity ON COLUMNS
DIMENSIONS sc:metricName, sc:type, sc:metricId, sc:decimals, sc:metricFormula ON ROWS
FROM [SUITE]
Elements
SELECT
METRICS xx:identity ON COLUMNS
DIMENSIONS sc:elementName, sc:elementId ON ROWS
FROM [SUITE]
Segments
SELECT
METRICS xx:identity ON COLUMNS
DIMENSIONS sc:segmentId,sc:segmentName ON ROWS
FROM [SUITE]
Sample analytics queries
In the queries below, replace SUITE with one of the report suites listed for your account, and replace SEGMENT with a segment available in the specified SUITE.
Pageviews for segment
SELECT
METRICS sc:pageviews ON COLUMNS
DIMENSIONS sc:page ON ROWS TOP 20 by sc:pageviews
FROM [SUITE]
SEGMENT "SEGMENT"
WHERE TIMEFRAME lastMonth,lastMonth2