Blog

python data analysis concept

Python for Marketers: Searching Facebook ad library

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

Read More

Pennsylvania Dutch Meadow Tea recipe

One of my favorite parts of summer is Meadow Tea, a chilled tea brewed with fresh apple mint (mentha suaveolens). This is a fairly common drink in Pennsylvania Dutch areas, particularly among Mennonite and Amish communities. It’s definitely an acquired taste – most people either love it or hate it. I love it, so I’m […]

Read More
python data analysis concept

Python for Marketers: Forecasting future seasonal data

What this is for: Forecasting seasonal data Requirements: Python Anaconda distribution, Understanding of statistics and experience with machine learning Concepts covered: Calucating confidence intervals and forecasting future values with pmdarima library Download the Jupyter notebook One of the more helpful applications of data science to marketing is developing forecasts. You can use forecasts to predict […]

Read More
python data analysis concept

Textual analysis of Facebook comments using Python

What this is for: Collecting comments from a public Facebook page and performing a basic content analysis Requirements: Python Anaconda distribution, basic understanding of HTML structure and Chrome inspector tool Concepts covered: Social listening, word clouds For anyone who works in strategic communications, it’s critical that you have a finger on the pulse of your […]

Read More
analytics

Segmenting pageviews by age and gender

Google Analytics’ Demographics report can provide a wealth of valuable data about the users of your website, including age, gender, interests and affinity categories. One of the cool but lesser known features of Google Analytics is the ability to create pivot tables with your web data. In this quick tutorial, we’ll make a simple pivot […]

Read More
python data analysis concept

Python for Marketers: Making Selenium web scraper click on links

What this is for: Telling a Selenium web scraper to click on link or enter basic information into a form Requirements: Python Anaconda distribution, Basic knowledge of HTML structure and Chrome Inspector tool Concepts covered: Selenium Selenium is an incredibly useful tool for scraping websites with Python, but occasionally your scraper may need to interact […]

Read More
python data analysis concept

Python for Marketers: Using starts-with() and contains() in Selenium web scraper

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

Read More