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 […]
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 […]
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 […]
Converting raw, non-delimited text into usable formats If you’ve spent as much time working with datasets as I have, you’ve probably run into a situation at least once where the data you need does not come in a neat, tidy, or even usable format. In a perfect world, raw data would be delimited in some […]