📌 Topics Covered

• Creating a Google Analytics account
• Account summary, home page, admin panel, and dashboard overview
• Report types: suggested, custom, e-commerce, event, page/screen, revenue, session, user
• Reports snapshot: acquisition, traffic, leads, campaigns
• Customer behavior analysis using UNIQUE() and COUNT_DISTINCT()
• Financial calculations: SUM(SALES) – COST
• Conversion rate calculation: SUM(ORDERS) / SUM(SESSIONS)
• Data cleaning in Excel: SORT(), UNIQUE()
• Data export and processing from GA to Excel
• Power Query and Google Sheets connection for dynamic analysis

📝 Class Summary
In this class, we combine Google Analytics and Excel skills to collect, export, process, and analyze website and business data. We start by setting up a Google Analytics account and exploring dashboards, key metrics, and report types. Then, we dive into Excel to clean, transform, and calculate insights such as customer behavior, financial performance, and conversion rates. Power Query and Google Sheets connections are introduced to automate workflows and enable dynamic, real-time analysis.

✅ What You Will Learn

• Set up and navigate Google Analytics dashboards and reports
• Understand metrics for acquisition, traffic, leads, campaigns, and revenue
• Export and clean GA data in Excel for analysis
• Analyze customer behavior, calculate conversion rates, and perform financial planning
• Use Power Query and Google Sheets to automate data processing and reporting

Watch the Video

Download the Practice File

Click “Mark as Complete” button.

Thanks and Good Luck