
This course includes our updated coding exercises so you can practice your skills as you learn.
See a demo
In this lecture, you'll learn how to:
Interpret the mechanics of a data pipeline.
Explore the benefits reporting automation can bring to a business.
In this lecture, you'll learn how to:
Evaluate the Supermetrics offering and functionalities.
Distinguish between a data source and a destination.
Create a Supermetrics free trial account.
In this lecture, you'll learn how to:
Access the complete Supermetrics documentation that would answer any specific question you might have about your destination or data source.
In this lecture, you'll learn how to:
Connect a Google Analytics data source to Google Data Studio.
Configure the Supermetrics' Google Analytics connector, including selecting views and segments.
In this lecture, you'll learn how to:
Extract data from Facebook Ads and port it directly into Google Data Studio using the Supermetrics connector.
Explore the Facebook Ads data schema in Google Data Studio.
In this lecture, you'll learn how to:
Create a "Twitter user tweets" query with Supermetrics' Public Data Twitter connector.
Visualize the outcome in Google Data Studio and apply interaction filters.
In this lecture, you'll learn how to:
Use the "Twitter user data" query type in the Public Data Twitter connector.
Explore new dimensions and metrics to enhance your insights-building experience.
In this lecture, you'll learn how to:
Use Supermetrics' Google Analytics 4 connector to deliver better results for your business.
Apply a Google Data Studio template created by Supermetrics.
In this lecture, you'll learn how to:
Create a BigQuery sandbox account within the Google Cloud Console.
Navigate the Google BigQuery interface and create a project.
In this lecture, you'll learn how to:
Create your own marketing data warehouse with Supermetrics for BigQuery.
Connect your LinkedIn Company Pages data to BigQuery.
Setup an automated data transfer in BigQuery.
In this lecture, you'll learn how to:
Explore the newly created LinkedIn tables in BigQuery.
Query a table in BigQuery using SQL.
In this part, you are going to learn how to install the Supermetrics Add-on in Excel and activate it to fetch data from various sources.
In this lecture, you'll learn how to:
Access additional resources related to Supermetrics and the latest data automation trends.
Welcome to "Introduction to Supermetrics for Data Automation"! 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.
Plus, three 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.
Project 3: Using the Google Analytics 4 Connector to analyze your website data
BONUS: Once you complete the course, you get a 20% discount from a Supermetrics subscription via a special promo code (this applies to first-time purchases made from the website ONLY)!
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.
What are the students who took the course saying?
"Great course! This is my second course with the same instructor and I just enrolled with another one of his courses, the third one. Not only do I love his courses, his teaching style is also excellent. I'm getting from his courses just the skills that I need as a Digital Marketing freelancer. Thank you!" - Dame
"Great course to learn about how to automate data reporting and make efficient use of so much data. It has easy to follow practical examples which makes it intriguing and resourceful. Highly recommended for people in digital marketing/social media campaign management" - Emmie
"Great course and content! As a digital marketing practitioner working with Data Studio, I highly recommend this course if you are looking to quickly get up to speed with Supermetrics and understand what it is and what its main functionalities are. I especially liked Lachezar's hands-on approach, presenting the material in a concise and comprehensive way, which is really ideal for practitioners. Looking forward to more high quality content!" - Andrea