If you work with large volumes of data in Google Analytics, you have likely encountered sampled data at some point. Seeing that your data has been sampled might make you suspicious – can I really trust the data if it is sampled at 50%? What about only 5%? To get to the bottom of this, […]
What this is for: Extracting bulk data from the NPI registry and downloading as CSV Requirements: Knowledge of JSON, Pandas dataframes Concepts covered: Making an API request, flattening JSON, combining dataframes Download: Download the Jupyter notebook If you work with health care provider data, you are no doubt familiar with NPI (National Provider Identifier) data. […]
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 […]
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 […]