Data Blending Techniques & Scripts
For Ecommerce Measurement
Stephen McAllister
Absolute Digital Media
Data Blending Techniques &
Scripts For Ecommerce
Measurement
Stephen McAllister
Absolute Digital
@AbsoluteDMedia
Slide 2
Slide 2 text
In A World Of Data - Ever Feel
Like Missing The Woods For The
Trees
Slide 3
Slide 3 text
If Your Old Hat Like Me - You Can Do
Anything With An Excel Sheet
Slide 4
Slide 4 text
4
Imagine Taking That Flexibility To
Create A Live Reporting Platform Of
Your Data
Slide 5
Slide 5 text
5
Your One Stop Shop For Putting Data
Together
Slide 6
Slide 6 text
6
Getting Going
1. Ask Yourself What Do
You Want To Measure?
Slide 7
Slide 7 text
7
2. Map Out All Your
Fields & What You
Want To Join
Slide 8
Slide 8 text
8
3. Connect Your Data Sources
Slide 9
Slide 9 text
9
4. Lets Blend &
Get Creative
Slide 10
Slide 10 text
Remember: What
Gets Measured,
Gets Done
Slide 11
Slide 11 text
11
Blend 1. Want To See Multiple Websites In A
Single View
Slide 12
Slide 12 text
12
The Setup & Points
DataStuio You Can Blend Up To 6 Sources
Together
Example: x4 Google Analytics Views Together
Slide 13
Slide 13 text
13
DataSetup
Use Month As The Join.
Hostname As The Dimension.
Revenue As The Metric.
Slide 14
Slide 14 text
14
Results
A Month On Month View Showing My Sites
Performance Back To Back.
Slide 15
Slide 15 text
15
Blend 2. - Want To Join All Your Costs Per
Channel Into A Single View
Slide 16
Slide 16 text
16
The Setup & Points
Data Into G-Sheets Or Use Connectors From
Supermetrics
Slide 17
Slide 17 text
17
DataSetup
Cost Or Total Spend As The Metric.
Slide 18
Slide 18 text
18
Results
A Table With Each Channel Spend Set Out
Slide 19
Slide 19 text
19
Blend 3. - Blending Up Goals From Multiple GA
Data Views
Slide 20
Slide 20 text
20
The Setup & Points
Say You Have Multiple GA Views Tracking
Different Goal Points, You Wanted To Join Them In
A View & Look At Total Sessions.
Slide 21
Slide 21 text
21
DataSetup
Join Using Default Channel Group
Dimension Month Date Range
Goal Completions As Your Metric + Sessions
Slide 22
Slide 22 text
22
Results
You Can Pull Goals From
Multiple Views To Calculate The
Total & Completion Rates.
Slide 23
Slide 23 text
23
Blend 4.(My Favourite ) - Want To See The True
Value Of Your Google Shopping
Slide 24
Slide 24 text
24
The Setup & Points
Google Ads – Shopping
Script to G-Sheet
Google Analytics
Slide 25
Slide 25 text
25
Results
A View That Shows Shopping Data
Vs Sales Vs Checkout Behaviour
Vs Conversion Value.
Slide 26
Slide 26 text
26
Discover How To Join Up Gads/Product
Feed/GA Data in a single view
Slide 27
Slide 27 text
27
Use Scripts To
Harness The
Power Of Data
Slide 28
Slide 28 text
28
Google API Reporting - Explore
What You Can Extract
Slide 29
Slide 29 text
29
My Go To Script
For Getting
Data To A G-Sheet
Slide 30
Slide 30 text
30
1. Export Out All Your Relevant
Google Shopping Data Into A G-Sheet
(On An ItemID Level)
Slide 31
Slide 31 text
31
2. Repeat The Same Process But This
Time Pulling Out ItemID + Product Title
Slide 32
Slide 32 text
32
3. Now You Have A DataSet - Treat It
Like Excel. Customise Your View.
ItemId + Title + Sales Data + Whatever
Slide 33
Slide 33 text
33
4. Get Your Data Into DataStudio
Slide 34
Slide 34 text
34
5. Blend Your
Sources Together
Slide 35
Slide 35 text
35
What Can We Now See
That Was Hidden Before
Slide 36
Slide 36 text
36
Specific Items
(Do They Sell) On Their Own
Slide 37
Slide 37 text
37
Specific Items
(Do They Support Other Products)
Slide 38
Slide 38 text
38
Specific Items
(Where Are My Opportunities)
Slide 39
Slide 39 text
39
Specific Items
(Where Are My
Dogs) - The
Wastage
Slide 40
Slide 40 text
40
Now You Have A Live Funnel Of Data
Slide 41
Slide 41 text
41
Want To Add More Connectors
or Touch Points?
Slide 42
Slide 42 text
42
Start Having Fun & Take
It Step By Step
Slide 43
Slide 43 text
43
Simply find your anchor
and join up data
Slide 44
Slide 44 text
@SophieBrannon 44
Slide 45
Slide 45 text
45
1. Don't be scared
of data - It's your
friend
Slide 46
Slide 46 text
46
2. Start simple as you
learn how to connect data.
Slide 47
Slide 47 text
47
3. Get as much data into
DataStudio
Slide 48
Slide 48 text
48
4. Have An Application In
Mind That You Can Action
Slide 49
Slide 49 text
49
5. Be Prepared
To Impress Your
Boss
Slide 50
Slide 50 text
50
6. Finally With A Bit Of
Creativity You Can Blend Your
Data To Whatever You Need