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 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 […]