Welcome to "Introduction to Supermetrics for Data Studio and BigQuery"! In this quick crash course, you are going to learn how to automate data reporting by using Supermetrics and its wide range of connectors. Often, when faced with multiple data sources, from platforms like Facebook Ads, Twitter and Campaign Manager (CM360), it becomes difficult to ensure they are always up-to-date, error-free and follow consistent formatting. Therefore, to automate your reporting, you need a tool like Supermetrics to connect the pipes and allow your data sources to get to their destinations in the most efficient way possible.
The course is aimed at beginners and those who are starting their journey in reporting automation. If you are a marketing data automation expert already or an advanced Supermetrics user, this course is probably not suitable for you.
By the end of the course, you will be able to:
Pull data directly into your Data Studio report from multiple sources, including Facebook Ads, LinkedIn Company pages and etc.
Eliminate hours of manual work by scheduling data transfers and automating your marketing reporting.
Plug into all your BigQuery tables with one data source instance and pulls all that data neatly into Data Studio.
Get access to 20+ dashboard customizable templates for SEM, paid & organic social media, programmatic advertising, SEO, web analytics, and more.
Plus, two quick hands-on projects:
Project 1: Use the Twitter Public Data connector to fetch metrics and dimensions for any public twitter account and analyze it in Data Studio.
Project 2: Use the Pinterest Public Connector to fetch data for any account and use a Data Studio parameter to search and add new accounts dynamically.
BONUS: Once you complete the course, you get a 20% discount from any Supermetrics subscription via a special promo code!
What is Supermetrics?
Supermetrics tools automatically fetch data from multiple platforms (e.g. Twitter Ads, Facebook Ads, Google Analytics...) and pull it into any destination (Data Studio, Google Sheets, Excel). It also allows you to set up automatic data refreshes and scheduled emails. This eliminates the need to copy-paste marketing data into a reporting or data visualization platform.
Who is the instructor?
Lachezar Arabadzhiev is a digital markitech with 4+ years of experience in performance analytics and data visualization. Lachezar began his career as a digital marketer at Microsoft, but soon transitioned to the measurement and analytics world, where he has had the opportunity to work with major brands such as Air Canada, RBC, Kimberly-Clark, Mazda and HSBC.
Lachezar has been working with Data Studio and BigQuery since early 2017 and has built a wide variety of visualizations and automation flows. From performance-based dashboards with joined GMP sources (Google Analytics 360, Campaign Manager and Display & Video 360) to audience-driven segmentation views with user-level eCommerce data.
Lachezar is a certified GMP expert and an official speaker at the Canadian Google Data & Analytics Summit, 2018.