4.50(2 Ratings)

Automation of Reports using APIs in Python

Students Enrolled:459
Course Duration: 3h

About Course

Do you want a 90% Reduction in Time and Effort that is spent on Campaign Reporting?

Campaign reporting is a boring, mundane activity that has no value add. You just export data from the platform dashboard and create graphs/tables and attach them in a PPT. Moreover, since this is a manual process, it is bound to be error-prone. Why spend time on this mundane, boring task yourself? Let the machines take over.

In this course, we will see how we can extract our campaign performance data from all platforms and convert them into amazing graphs. And that too with just ONE CLICK!

$40

What I will learn?

  • Automation in Python
  • Use of API in Digital Marketing
  • Google Data Studio
  • How to save time in campaign reporting
  • How to reduce errors in campaign reports

Requirements

  • Basics of Digital Marketing

Target Audience

  • Digital Marketing Professionals
  • Account Managers
  • Agency Owners
  • Business Owners
  • Students
  • Python Automation Enthusiasts

Topics for this course

0. Welcome to the Course

1. Introduction to the Course (Free Preview)

2. Building Dashboards in Google Data Studio

  • 2.1 Introduction to Google Data Studio
    03:52
  • 2.2 Google Adwords Reporting Automation
    02:51
  • 2.3 Facebook Ads Reporting Automation
    16:50

3. Introduction to Python and APIs

  • 3.1 Python Introduction & Installation
    06:09
  • 3.2 Python Libraries
    01:25
  • 3.3 Download Python Code Files
    01:35
  • 3.4 Python Practice
    14:25

4. Introduction to Facebook Marketing API

  • 4.1 Making a Facebook App
    10:30
  • 4.2 Facebook Python API Installation
    03:30

5. Extracting Data from Facebook

  • 5.1 Extracting Campaign Data from Facebook
    19:50
  • 5.2 Exporting Data to Excel File
    10:04

6. Connecting Python to Google Sheets

  • 6.1 Getting Access Tokens & Library Installation
    07:47
  • 6.2 Code to Export Data to Google Sheets
    14:46

7. Making Batch File for Automation

  • 7.1 Create Batch File
    04:42
  • 7.2 Automate Batch File
    04:24

8. Scaling the Process

  • 8.1 Tackling Conversions
    07:31
  • 8.2 Customizing the Code
    08:12
  • 8.3 Enhancing Google Data Studio Report
    20:47
  • 8. 4 Checklist & Best Practices
    05:54

9. Way Ahead

  • 9.1 Conclusion
    02:23

Student Ratings & Reviews

4.5
Total 2 Ratings
5
1 Rating
4
1 Rating
3
0 Rating
2
0 Rating
1
0 Rating
A
5 months ago
Good and professional
Nice Course. Gained new knowledge and it simple to learn. Expecting more automation course.
$40

Want to receive push notifications for all major on-site activities?