What this is for: Isolating elements you want to scrape with Selenium Requirements: Python Anaconda distribution, Basic knowledge of HTML structure and Chrome Inspector tool Concepts covered: Selenium, XPath Occasionally when you’re testing or scraping a web page with Selenium, you may need to select an element or group of elements where you may only […]
Taking a quick glance at your content marketing data, you can usually glean a couple of insights and major themes. While this anecdotal evidence can be beneficial, sometimes we need a deeper dive – the insights might not always be clear, or perhaps you have a theory that you want to test. Are certain topics […]
Working with nested JSON data in Excel If you’ve ever needed a quick way to do statistical analysis of JSON data or convert it to a delimited format like CSV, Microsoft Excel’s power query gives you that ability. However, if you’re used to only working with traditional delimited data like CSVs, there will likely be […]
We’ve all done it at one time or another. You’re trying to scroll on your smart phone and you click on a digital ad by accident. And advertisers can be pretty sure that others are accidentally clicking on their ads. “Fat fingers” can be fairly common problem, but exactly how often this happens is a […]
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 […]