Building a Data Pipeline: a Single Source of Truth for Marketing Analysis | Online
About this event
Is your marketing data currently under the control of multiple vendors and platforms? Do you have to cobble together siloed data and reporting tools to answer questions about marketing ROI and your customer’s journey? It’s time to take control! Cloud databases and low-code/no-code data management tools have made it possible for marketers to build data pipelines without a big investment in hardware, software, and custom development. In this workshop, we will walk through each of the steps from gathering Facebook, Google Ads, Google Search Console and Analytics data to populating a Google BigQuery database. The session will be packed with tips and tools, and there will be time, in the end, to dive into your specific data needs and challenges.
Takeaways
- Learn how to plan and design your own pipeline, tailored to your business
- Learn the basics of nimble data wrangling with Google Apps, Supermetrics, CIFL, and other tools
- Learn how to get all of your data in one place and in a consistent format, enabling holistic, cross-channel analysis
Prereqs & Preparation
Prerequisites: you don’t need to be a developer, but you will get more out of this workshop if you have a basic knowledge of JavaScript. It is also intended for people who are at least moderately proficient with data analysis in spreadsheets and Google Analytics. We will have sample data available, but you will be able to work with your own data if you have read access to Facebook, Google Ads and Analytics. Preparation: Please bring a laptop. If you have any real-world data challenges, please bring those too.
