Real-Life Online and Offline Data Integration

85 

Full text

(1)

Real-Life Online and

Offline Data Integration

BenjaminMangold BenjaminMangold LovesData

(2)

‣ Merging offline and online data

‣ Measuring 3rd party payments

‣ QR codes for in-store sales

‣ Measuring email opens and clicks

(3)
(4)

ga('create', 'UA-3457234-1',

{ 'userId': '394822' });

(5)
(6)
(7)

Cross-device reporting

Customer-centric analysis

Optimize for customers

(8)
(9)

analytics.js

for websites

SDKs

for Android

and iOS apps

Tag Manager

for websites,

iOS and Android apps

(10)
(11)

Measurement Protocol

for

custom data integrations

Data Import

to include

(12)
(13)
(14)

2248

Bronze

4814

Gold

9472

Silver

2248

Desktop

4814

Mobile

9472

Desktop

(15)
(16)

‣ Filter hundreds of thousands of rows

‣ Visualize your data

‣ Chart, map, network or custom layout

‣ Merge data

‣ Combine with public data

(17)
(18)
(19)
(20)
(21)

Merge based on

order number

(22)
(23)
(24)
(25)
(26)

Channels driving

event registrations

Channels driving

actual attendance

(27)

Channel that is not

driving attendance

(28)

Channel that is driving

better attendance

(29)
(30)
(31)

107 914 1,067 94 PayPal Details PalPal Confirm example.com/thanks example.com/pay

(32)

?

?

1,067 94 PayPal Details PalPal Confirm example.com/thanks example.com/pay

(33)
(34)

PayPal Confirm PayPal Details PayPal IPN Analytics example.com/thanks example.com/pay

(35)
(36)

‣ Connect different apps

‣ 300+ apps supported

‣ Easy to use

(37)
(38)
(39)
(40)
(41)
(42)

Twitter mentions

New Salesforce contacts

Eventbrite attendees

(43)
(44)

POS

Website

(45)
(46)
(47)
(48)

Coupon

Website

POS

Scan Coupon

Marketing

Analytics

(49)
(50)

<img src="https://chart.googleapis.com/ chart?chs=250x250&cht=qr&chl=http://

(51)

<img src="https://chart.googleapis.com/ chart?chs=250x250&cht=qr&chl=http://

www.example.com/page.html?cid=1234.9876"/>

(52)

<img src="https://chart.googleapis.com/

chart?chs=250x250&cht=qr&chl=http://

www.example.com/page.html?cid=1234.9876"/>

(53)

Tag Manager

Dynamic QR Code

Landing Page

(54)
(55)
(56)

Coupon “B”

Coupon “A”

(57)

Coupon downloads

(58)
(59)

Channel

In-Store

Conversions

(60)
(61)

Redeemed

Didn’t

(62)

Save  with  your  coupon! Limited  5me  only.

Didn’t Redeem

(63)
(64)

Measure

email opens

Measure

users

as they click

through to your website

Create

remarketing ads

(65)
(66)

ID in URL

Email

Analytics

Get ID

(67)

<a href="http://www.company.com?

utm_source=newsletter&utm_medium=email&ut m_campaign=newsletter%20october

(68)

<a href="http://www.company.com?

utm_source=newsletter&utm_medium=email&ut m_campaign=newsletter%20october

%202014">View more details</a>

(69)

<a href="http://www.company.com?

utm_source=newsletter&utm_medium=email&ut m_campaign=newsletter%20october

%202014">View more details</a>

(70)
(71)

<a href="http://www.company.com?

utm_source=newsletter&utm_medium=email&ut m_campaign=newsletter%20october

%202014&user=*|MMERGE3|*">View more

details</a>

(72)
(73)
(74)

<script> (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) })(window,document,'script','//www.google-analytics.com/analytics.js','ga'); <?php $userId = htmlspecialchars($_GET["user"]) ; if ($userId != NULL) {

$gacode = "ga('create', 'UA-123456-1', { 'userId': '%s' });"; echo sprintf($gacode, $userId);

} else {

! $gacode = "ga('create', 'UA-123456-1');"; echo sprintf($gacode); } ?> ga('send', 'pageview'); </script>

Read User ID

Track

ing Code or

Tag Manager

(75)
(76)

1 Pixel HIT

Email

(77)

<img height="1" src=" https://ssl.google-analytics.com/collect? v=1&tid=UA-123456-1&cid=*|MMERGE3|* &t=pageview&dp=%2FEmailOpen%2F*|MMERGE3|* &dt=Email%20Open&uid=*|MMERGE3|*" width="1" />

Measurement Protocol

(78)

<img height="1" src="https://ssl.google-analytics.com/collect? v=1&tid=UA-123456-1&cid=*|MMERGE3|* &t=pageview&dp=%2FEmailOpen%2F*|MMERGE3|* &dt=Email%20Open&uid=*|MMERGE3|*" width="1" />

Merge

(79)
(80)
(81)

Opened

Clicked

Email

Opened,

(82)

View  latest  deals. Don’t  miss  out!

MY

company

View  Deals

Opened Email,

Didn’t Click

(83)
(84)

‣ Identify opportunities fo

r your organization

‣ Merging

‣ Measuring

‣ Small steps can provide rich insights

‣ Inform your marketing strategy

‣ Experiment with user-based remarketing

(85)

Stay connected...

benjamin@lovesdata.com

BenjaminMangold

Figure

Updating...

Related subjects :