Slide 1

Slide 1 text

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

Slide 51

Slide 51 text

Thank You