Introduction
  • Introduction
  • Download Python
Let's get started
  • Marketing KPIs
  • Create accounts
  • Install libraries with PIP
Access Google Analytics data
  • Simple GA data access
  • GA data access with active GA account
  • Data access on Jupyter Notebook
  • Add ISO-week function
  • Add extract unsegmented data function
  • Add extract segmented data function
  • Checking for errors in the first part of the code
  • Get the correct date for your function
  • Checking for errors in the extracting data functions
  • Transform extracted totals data to Pandas DataFrame
  • Transform extracted details data to Pandas DataFrame
  • Add initialise Google Drive function
  • Add download worksheet function
  • Add loop function for totals data
  • Authenticate Google Drive API
  • Check for errors in the loop totals function
  • Add loop function for details data
  • Load data to Google Spreadsheet
  • More checks for errors in the loop totals function
  • Add sort index function
  • Make a Python file with complete code
Access Facebook data
  • Create a Facebook app and get the code template
  • Simple Facebook data access
  • Move code to Jupyter Notebook
  • Copy functions from GA Jupyter Notebook and add extract data function
  • Check for errors by printing the extracted data
  • Transform extracted totals data to Pandas DataFrame
  • Transform extracted details data to Pandas DataFrame
  • Add sorting function and loop totals function
  • Add loop function for details data
  • Add sleep to API query function
  • Make a Python file with complete code
  • Test the Python file
Finish assigning data and automate scripts
  • Assignment worksheet totals
  • Assignment worksheet details
  • Crontab automation
Final code
  • Google Analytics code
  • Facebook code
  • JSON template