[PDF] Getting data out of Adobe Analytics - Adobe Experience League PDF Summit2018-S904_final

Data Warehouse Live Stream Raw Data Report API Pre-Processing Processing Evaluating Segment/Calculated Metrics Compatibility Reports that display

Previous PDF

Next PDF

[PDF] Adobe Analytics

20 août 2015 · create customised reports that include calculated metrics and If you have Data Warehouse enabled for Analytics, you can generate complex,

[PDF] Getting data out of Adobe Analytics - Adobe Experience League

Data Warehouse Live Stream Raw Data Report API Pre-Processing Processing Evaluating Segment/Calculated Metrics Compatibility Reports that display

by delivering unique and intelligent audience insights for data-driven decision making With the example, use People to define calculated metrics such as time spent per person, revenue per person, organization's own data warehouses

[PDF] Package RSiteCatalyst

5 nov 2019 · Description Functions for interacting with the Adobe Analytics API V1 4 Description Get calculated metrics for the specified report suites Usage with an addional element are supported in data warehouse reports Details

[PDF] AdobeAD0-E202v2020-10-29q24 - FreeCramcom

Which calculated metric represents the average number of times a user has on the site D A data warehouse report with the following metric/dimensions: video

[PDF] Custom Adobe Analytics Training - DMPG

Adobe Analytics Workspace reporting tool and the underlying Analytics data models The 45 mins Adobe Workspace: Pulling together segments, calculated metrics and 20 mins Extraction: Data Warehouse, Data Feeds, APIs

[PDF] Statistical Data Warehouse Design Manual - europaeu

To reach these goals, building a Statistical Data Warehouse (S-DWH) is result of calculating admin data based totals for turnover and employment It may take many forms, including feedback from users, process metadata, system metrics SDMX-based IT tools are developed in different platforms: JAVA, Adobe Flex

[PDF] Analytics Modules: Installation and Porting Guide - MicroStrategy

to use the Analytics Module as your initial data warehouse when you do not have an Experience with MicroStrategy reports and metrics using MicroStrategy technology Adobe Reader installed on your computer, you can download it from For porting to a SQL Server 2000 database, to calculate dates : For the Date

[PDF] AdobeAnalyticsIntegration-DataX low

based reporting) and the Adobe Data Warehouse (offline data export) Calculated metrics are either built using complex calculations and/or use multiple data

[PDF] Adobe Analytics Integration - cloudfrontnet

the property and sent to Adobe Analytics to generate reports/alerts on above will be available in Adobe's data warehouse but ignored in reporting metrics like Carts and Checkouts as well as any custom calculated metrics created Make

Matt Kohl & Aaron Hadley, Customer Care

Customer Care Experience and Perspective

3 ~20%

EXPORT RELATED CASES

What options do I have to

1 | Evaluating Export Options

2 | Data Feeds & Live Stream

3 | Adobe Report Builder & Reporting API

4 | Q&A

Classifications (metadata)

Real-time Reports

(API)

Analytics

Reports

Data Feeds ZIP Data

Warehouse

Live Stream

Raw Data

Report API

Pre-ProcessingProcessing

Evaluating Options / ArchitectureQuestions Definitions © 2018 Adobe Systems Incorporated. All Rights Reserved. Adobe Confidential. 7 The longer you wait for data to be processed, the more context rich it becomes Evaluating Options / Architecture QuestionsDefinitions © 2018 Adobe Systems Incorporated. All Rights Reserved. Adobe Confidential. 8 Evaluating Options / Architecture QuestionsDefinitions Immediacy / iˈmēdēəsē/ The quality of bringing one into direct and instant involvement with something, giving rise to a sense of urgency or excitement © 2018 Adobe Systems Incorporated. All Rights Reserved. Adobe Confidential. 9 Consumability/ kənˈsoଲomˈəˈbilədē/ Possession of the means or skill to use or ingestEvaluating Options /

Architecture

QuestionsDefinitions

Consumability

Immediacy

Consumability

Immediacy

Live Stream

Consumability

Immediacy

Live Stream

RealtimeAPI

Consumability

Immediacy

Live Stream

RealtimeAPI

Evaluating Options / Architecture QuestionsDefinitions

Data Feed

Consumability

Immediacy

Live Stream

RealtimeAPI

Evaluating Options / Architecture QuestionsDefinitions

Data Feed

Data Warehouse

API/ARB

Quick Marketing Response

Monitoring traffic in near real time

Not as good:

Historical Exports

Populating BI Systems

A stream of partially-processed Analytics data within seconds of collection

Live Stream

Frequent/Repeated Requests

Dashboards

Not as good:

Bulk data exports

Historical backfills

Programmatic access to UI reports, including Real-time, standard, and Data Warehouse

Reporting API

Batched delivery of raw, clickstream data.

Data Feed

Good:

Bulk Exports

Integrating into other data sets

Custom processing (attribution)

Validation/Troubleshooting

Not as good:

Dashboards

No "Uniques" Limitations

Multiple Breakdowns

Large Data Sets (Reports)

Not as good:

Speed

Segment/Calculated Metrics Compatibility

Reports that display advanced data relationships from raw, granular-level data.

Data Warehouse

Scheduled Updates

Dashboards

Broad User Base/Ease of use

Not as good:

Bulk data exports

Historical backfills

Excel-Based add-on that integrates Adobe Analytics data directly into workbooks via the reporting API

Report Builder

1 | Evaluating Export Options

2 | Data Feeds & Live Stream

3 | Adobe Report Builder & Reporting API

4 | Q&A

DATA FEED

Search Engines

IDLookup Value

Browsers &

Types

IDLookup Value

Column Headers

IDLookup Value

Plugins

IDLookup Value

Country

IDLookup Value

Resolution

IDLookup Value

Events

IDLookup Value

Referrer Types

IDLookup Value

Hit Data

Data Feed

Columns

2018-02-16

Data Feed / ColumnsCon?gurations Delivery UI

Visitor Identification

2018-02-1616:30:51JS-1.8.1Mysite.com/productInfo10mycustomlink.comMy Custom Link0

2018-02-1616:32:22H.25.4Mysite.com/productDwnld11mydownloadlink.comMy DownloadLink0

Event Types

3/21/2018 13:41WJY123;Shiny Shoes;1;100.00;202=10.001,201,202=100

3/21/2018 15:21WKB456;Comfy Socks;10;15.00;202=5.001,201,202=50

3/21/2018 16:11WKQ789;Nice Shirt;1;25.00;202=5.001,201,202=50

3/21/2018 16:11WKQ789;Nice Shirt;1;25.00;202=5.001

Data Feed / ColumnsConfigurations Delivery UI

Orders

Configurations

3/21/2018 13:41:1211Homewww.mysite.com

3/21/2018 15:21:3421Homewww.mysite.com

3/21/2018 16:11:2531Productwww.mysite.com/p...

3/21/2018 16:11:4332Categorywww.mysite.com/c...

Data Feed / Columns Con?gurationsDelivery UI

Remove Escape Characters

3/21/2018 13:41:1211Homewww.mysite.com

3/21/2018 15:21:3421Homewww.mysite.com

3/21/2018 16:11:2531Productwww.mysite.com/p...

3/21/2018 16:11:4332Categorywww.mysite.com/c...

29
TAB Data Feed / Columns ConfigurationsDelivery UI

Remove Escape Characters

NEWLINE

© 2018 Adobe Systems Incorporated. All Rights Reserved. Adobe Confidential. 30
If z x R d C #7 6 http If z x R d C #7 6 http If z x R d C #7 6 http If z x R d C #7 6 h?p If z R C x d#76 If z x R d C #7 6

3/21/2018 13:41:1211Homewww.mysite.com

3/21/2018 15:21:3421Home

3/21/2018 16:11:2531

Productwww.mysite.com/p...

3/21/2018 16:11:32Categorywww.mysite.com/c...

Offline

Visit

DAY 1DAY 2

User goes online

Buffered hits sent

Data Feed / Columns ConfigurationsDelivery UI

Late Arriving Hits

Data Feed Delivered

Offline

Visit

DAY 1DAY 2

User goes online

Buffered hits sent

Data Feed / Columns ConfigurationsDelivery UI

Late Arriving Hits

HISTORICALONGOING

Data Feed / Columns ConfigurationsDelivery UI

File Intervals

HISTORICALONGOING

Data Feed / Columns ConfigurationsDelivery UI

File Intervals

DailyHourly

HISTORICALONGOING

Data Feed / Columns ConfigurationsDelivery UI

File Intervals

Daily

File Consolidation

Hourly

HISTORICALONGOING

Data Feed / Columns ConfigurationsDelivery UI

File Intervals

Daily

File Consolidation

Backfill Hardware

Hourly

HISTORICALONGOING

Data Feed / Columns ConfigurationsDelivery UI

File Intervals

Daily

File Consolidation

Backfill Hardware

Hourly

Faster Processing

HISTORICALONGOING

Daily

File Consolidation

Backfill Hardware

Hourly

Data Feed / Columns ConfigurationsDelivery UI

File Intervals

Faster Processing

Quicker Recovery

Delivery

Setup:

Issues:Static (small)

Capacity related

Setup:

Issues:Static (varies)

Limited Support

Key Exchange

One-Step

Authentication

IP Restrictions

Concurrent Connections

Setup:

Issues:Dynamic

Region Support

User Interface

LIVE STREAM

Solution Access

Adobe ID

PRE-REQUISITES

Live Stream / SetupConnection Comparison

Create Application

Create Stream

Concurrent Connections

Visitor

12345678

Live Stream / Setup ConnectionComparison

Get Token:

curl -i-v "https://api.omniture.com/token" -u '[Application ID]:[Application Secret]' -d "grant_type=client_credentials"

Connect to Stream:

curl "[insert stream urlhere]" --header "Authorization: Bearer [paste token here]" --compressed

[PDF] [PDF] Getting data out of Adobe Analytics - Adobe Experience League

Matt Kohl & Aaron Hadley, Customer Care

Customer Care Experience and Perspective

EXPORT RELATED CASES

What options do I have to

1 | Evaluating Export Options

2 | Data Feeds & Live Stream

3 | Adobe Report Builder & Reporting API

4 | Q&A

Classifications (metadata)

Real-time Reports

Analytics

Reports

Warehouse

Live Stream

Raw Data

Report API

Pre-ProcessingProcessing

Architecture

QuestionsDefinitions

Consumability

Immediacy

Consumability

Immediacy

Live Stream

Consumability

Immediacy

Live Stream

RealtimeAPI

Consumability

Immediacy

Live Stream

RealtimeAPI

Data Feed

Consumability

Immediacy

Live Stream

RealtimeAPI

Data Feed

Data Warehouse

API/ARB

Quick Marketing Response

Monitoring traffic in near real time

Not as good:

Historical Exports

Populating BI Systems

Live Stream

Frequent/Repeated Requests

Dashboards

Not as good:

Bulk data exports

Historical backfills

Reporting API

Batched delivery of raw, clickstream data.

Data Feed

Bulk Exports

Integrating into other data sets

Custom processing (attribution)

Validation/Troubleshooting

Not as good:

Dashboards

No "Uniques" Limitations

Multiple Breakdowns

Large Data Sets (Reports)

Not as good:

Speed

Segment/Calculated Metrics Compatibility

Data Warehouse

Scheduled Updates

Dashboards

Broad User Base/Ease of use

Not as good:

Bulk data exports

Historical backfills

Report Builder

1 | Evaluating Export Options

2 | Data Feeds & Live Stream

3 | Adobe Report Builder & Reporting API

4 | Q&A

DATA FEED

Quick Marketing Response

Monitoring traffic in near real time

Historical Exports

Populating BI Systems

Frequent/Repeated Requests

Dashboards

Bulk data exports

Historical backfills

Bulk Exports

Integrating into other data sets

Custom processing (attribution)

Validation/Troubleshooting

Dashboards

No "Uniques" Limitations

Multiple Breakdowns

Large Data Sets (Reports)

Speed

Segment/Calculated Metrics Compatibility

Scheduled Updates

Dashboards

Broad User Base/Ease of use

Bulk data exports

Historical backfills