What this is for: Querying Facebook’s ad library for political or issue ads and downloading results to .CSV Requirements: Verified Facebook ID, Facebook developer account, Basic understanding of APIs and Pandas dataframes In 2019, Facebook launched its Ad Library to improve transparency in advertising, allowing anyone to easily search ads that pages are running. While […]
What this is for: Analyzing and visualizing CTR and search position for organic search terms Requirements: Google Analytics data connected to Google Search Console, Python Anaconda Distribution Concepts covered: Simple data cleaning, Pandas dataframe, Matplotlib, search engine result position, click through rates Complete python file available for download We all know search rankings matter. Users […]
What this is for: Scraping web pages to collect review data and storing the data into a CSV Requirements: Python Anaconda distribution, Basic knowledge of HTML structure and Chrome Inspector tool Concepts covered: Selenium, Error exception handling Download the entire Python file In an earlier blog post, I wrote a brief tutorial on web scraping […]
Update: Since writing this post, Google has removed documentation for Python for this API. My code still works for me, but as this is not a supported language, I’d recommend building in a different language. Read more here. What this is for: Getting reviews from multiple Google My Business locations and converting data into a […]
What this is for: Exploring correlations between multiple variables Requirements: Python Anaconda distribution, Google My Business or comparable data with multiple variables you want to test, Basic understanding of Pandas dataframe & statistics Concepts covered: Creating a correlation matrix, basic dataframe calculations, scatter plots, exporting charts as PNG Download the entire Python file I’ve always […]
What this is for: Identifying basic data trends, Creating future goals based on trends Requirements: Python Anaconda distribution, Google Analytics or comparable data, Basic understanding of Pandas dataframes and Matplotlib Concepts covered: Basic cleaning of data, linear regression, Scatter plot Complete Python file available for download One of the most basic forms of data analysis […]
What this does: Scrapes pages to get alt tags and page titles, and saves as CSV Requires: Python Anaconda distribution, basic knowledge of Pandas and HTML structure Concepts covered: Basic scraper with BeautifulSoup, Scrape multiple pages, Loops, Export to CSV Download the entire Python file Python has a lot of great uses for marketers, and […]