NFL Adobe Analytics (Omniture)

Overview

Adobe Experience Cloud (formerly called Omniture) provides a variety of marketing and analytics products. NFL clubs can use Adobe Analytics to understand usage patterns across their websites and mobile apps. To set up this integration, contact your KORE Success Manager for instructions.

NFL clubs must provide Adobe Analytics data to KORE via a daily email. KORE does not have access to Adobe Analytics itself, but only the specific data provided by each club.

• TEAM: Notify KORE of your intention to enable this integration

• Success: Send TEAM user guide and instructions on how to setup the data access for KORE
  Below are the steps to identify them in customers' Adobe developer console.

  • Login in to Adobe developer console

  • Navigate to projects -> credentials tab or Service account tab

  • Click on the credentials tab or Service account tab(which is on the left hand side), then it will show client ID and Client Secret.

  We also need the scope. Scope Information can be found on the tab that should be right beside the credentials tab in the developer console

• Success: Save credentials in KORE Secret, create and prioritize a work item in the DWA backlog

• DWA Developer: Setup integration and confirm data is loaded correctly

• KORE: Notify the TEAM the integration has been configured, provide the user guide and a walk through of the integration

Setup

Your KORE Success Manager can enable this integration for you.

Each day, you should receive three emails from the NFL league office with these subject lines:

• Excel Workbook (KPIs Report Builder - Desktop.xlsx)
• Excel Workbook (KPIs Report Builder - MW.xlsx)
• Excel Workbook (KPIs Report Builder - App.xlsx)

Forward these emails with the attachments, being sure that the subject lines are exactly as specified above, to dwa-nflomniture@koreinteractive.com.

ERD and data dictionary

(This information is provided on a best-effort basis without guarantees.)

Schema name: nfl_adobe_omniture

Download data dictionary (Excel file)

Example queries

List the top 5 videos viewed on the mobile web (MW) during the past month:

SELECT TOP 5 "source", video_friendly_name, shr_clubs_minutes_watched
FROM nfl_adobe_omniture.videos
WHERE CAST(date_range AS DATE) > DATEADD(MONTH, -1, CURRENT_DATE)
  AND "source" = 'MW'
GROUP BY "source", video_friendly_name, shr_clubs_minutes_watched
ORDER BY shr_clubs_minutes_watched DESC;

Show a summary of traffic from a particular geographic area during the past week:

SELECT geosegmentation_us_dma, date_range, "source", shr_clubs_visits,
  shr_clubs_video_begins, shr_clubs_photo_views, shr_clubs_article_views
FROM nfl_adobe_omniture.usdma
WHERE geosegmentation_us_dma = 'Atlanta (524)'
  AND CAST(date_range AS DATE) > DATEADD(WEEK, -1, CURRENT_DATE)
GROUP BY "source", date_range, shr_clubs_visits, shr_clubs_video_begins,
  shr_clubs_photo_views, shr_clubs_article_views, geosegmentation_us_dma 
ORDER BY date_range DESC, "source" ASC