Introduction to Supermetrics for Data Automation - 2022
What you'll learn
- Pull data directly into your Data Studio report from multiple sources, including Facebook Ads, LinkedIn and etc.
- Eliminate hours of manual work by scheduling data transfers and automating your marketing reporting.
- Get access to 20+ dashboard customizable templates for SEM, paid & organic social media, programmatic advertising, SEO, web analytics, and more.
- Plug into all your BigQuery tables with one data source instance and pulls all that data neatly into Data Studio.
- Get any metrics you need, combine them with any dimensions in Excel. No VBA (Visual Basic for Applications) or coding knowledge required.
- Use the Twitter Public Data connector to fetch metrics and dimensions for any public twitter account and analyze it in Data Studio.
- Google Data Studio Account (free)
- Google BigQuery Account (free)
- Supermetrics Trial Account (free)
- Google Sheets (free)
- Facebook Ads (your account)
- LinkedIn Company Pages (your account)
- Excel (your account)
Welcome to "Introduction to Supermetrics for Data Automation – 2022"! 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
Who this course is for:
- Automation Leads
- Automation Managers
- Data Architects
- Data Analysts
- Digital Marketers
Hey there! I'm Lachezar Arabadzhiev and for the past five years, I have helped companies harness the power of data, visual storytelling, and education in a variety of ways to drive business growth and innovation. I began my career as a digital marketer at Microsoft but soon transitioned to the audience and analytics world, where I had the opportunity to work with major brands including Air Canada, RBC, Walmart, Kimberly-Clark, StackAdapt, LinkedIn, Mazda, and HSBC.
Throughout all that time, I always loved teaching and developing learning programs for my fellow colleagues and friends. That passion materialized in early 2021 in the form of a brand new company that I was luckily enough to start.
I am currently the Founder and CEO of SkildLabs, where I help companies and individuals build better learning experiences through the power of education and technology. With SkildLabs, I believe we have the ability to empower students globally and create more interactive learning experiences. How? By combining the learning tools already available and a better method for organizing learning experiences.
What about Google Data Studio?
I have been working with the Google Data Studio beta since early 2017 and have built a wide variety of visualisations and automation flows. From performance-based dashboards with joined GMP sources (GA360, CM and DV360) to audience-driven segmented views with log-level data. In addition, I am a Display and Video 360 (DV360) expert having ran the audience strategy, inventory selection and programmatic optimisation experiments for the programmatic media buying at Royal Bank of Canada (RBC).
I am also a Certified GMP expert and an official speaker at the Canadian Google Data & Analytics Summit, 2018.
With the rapid switch to virtual workspaces and community meeting places, we’ve watched organizations of all sizes struggle to appropriately and effectively marshal their online learning resources and present them in a comprehensive, easy-to-use format.
SkildLabs aims to solve that problem by providing consulting and implementation that lets organizations build their business using the power of education. Whether the goal is upskilling employees, creating a community around courses, or building a micro-academy to explain the intricacies of a product or service, SkildLabs will take your online learning objectives and ideas and turn them into reality, and the best part is we will be there every step of the way.