{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Charting a Marketing Acquisition Funnel\n", "> The motiviation was duplicating some of Looker's bar charts when the data itself was still a bunch of CSV files, MySQL queries, and a bunch of API calls glued together\n", "\n", "- toc: false\n", "- branch: master\n", "- badges: true\n", "- categories: [viz, jupyter]\n", "- hide: false\n", "- search_exclude: false" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "%matplotlib inline\n", "\n", "import pandas as pd\n", "from collections import OrderedDict\n", "import matplotlib.pyplot as plt\n", "import matplotlib.patches as patches\n", "\n", "import seaborn as sns\n", "sns.set_style('whitegrid')" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | date | \n", "website_traffic | \n", "new_accounts | \n", "account_verify | \n", "product_activated | \n", "paid_conversion | \n", "some_other_metric | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "2019-08-01 | \n", "530771 | \n", "15720 | \n", "12670 | \n", "10812 | \n", "654 | \n", "13270 | \n", "
1 | \n", "2019-09-01 | \n", "558652 | \n", "15900 | \n", "13884 | \n", "12909 | \n", "908 | \n", "13678 | \n", "