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 […]
In 2017, researchers at the American Cancer Society reported a “curious” finding in their study of colorectal cancer in the U.S. While overall rates have fallen, colon cancer rates have been increasing among young adults ages 20-54. Researchers said young adults are more likely to be diagnosed with distant stage colorectal cancer “largely due to […]
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 […]