Data Blending Techniques & Scripts for eCommerce Measurement

Discover the art of blending data in Google Data Studio and learn the opportunities of how to join up your online channels and ads data into a single view. Become a data pro with a few blending techniques and handy scripts to showcase your eCommerce activity.

Transcript

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