Skip to content

Instantly share code, notes, and snippets.

@Saurabh7

Saurabh7/multifull5.ipynb

Created July 4, 2017 13:49
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Saurabh7/a15df8d95eac2e2d35f62537683624a9 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Saurabh7/a15df8d95eac2e2d35f62537683624a9 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
multifull5.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<script>jQuery(function() {if (jQuery(\"body.notebook_app\").length == 0) { jQuery(\".input_area\").toggle(); jQuery(\".prompt\").toggle();}});</script>"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"data": {
"text/html": [
"<button onclick=\"jQuery('.input_area').toggle(); jQuery('.prompt').toggle();\">Toggle code</button>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"import IPython.core.display as di\n",
"\n",
"# This line will hide code by default when the notebook is exported as HTML\n",
"di.display_html('<script>jQuery(function() {if (jQuery(\"body.notebook_app\").length == 0) { jQuery(\".input_area\").toggle(); jQuery(\".prompt\").toggle();}});</script>', raw=True)\n",
"\n",
"# This line will add a button to toggle visibility of code blocks, for use with the HTML export version\n",
"di.display_html('''<button onclick=\"jQuery('.input_area').toggle(); jQuery('.prompt').toggle();\">Toggle code</button>''', raw=True)"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"from IPython.display import display, HTML\n",
"from itertools import combinations, product\n",
"import pandas as pd\n",
"import json\n",
"from jarvis.brain.utility.data_preparation import get_active_ad_accounts\n",
"from jarvis.brain.insights.paths.path_pre_processor import PathPreProcessor\n",
"from jarvis.brain.insights.paths.path_processor import PathProcessor\n",
"from jarvis.brain.insights.paths.path_utility import create_levels_hash\n",
"from flask.json import jsonify\n",
"import pandas as pd\n",
"import numpy as np"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"metrics_dict = {\"ga_cpv\": {\"numerator\": \"fb_spend\", \"denominator\":\"ga_visits\", \"diff\": -1},\n",
" \"ga_cvr\": {\"numerator\": \"ga_transactions\", \"denominator\":\"ga_visits\", \"diff\": 1}}\n",
"goal_metric = [\"ga_cpv\", \"ga_cvr\"]\n",
"\n",
"# metrics_dict = {\"fb_ctr\": {\"numerator\": \"fb_inline_link_clicks\", \"denominator\":\"fb_impressions\", \"diff\": 1}}\n",
"# goal_metric = \"fb_ctr\""
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"TIME USED 8.758716106414795\n",
"['Behaviors', 'Device Platforms', 'Billing Event', 'Daily Report', 'Optimization Goal', 'Product Category', 'Audience Strategy', 'misc', 'Age Range', 'Interests', 'User OS', 'Call To Action', 'Gender', 'Audience Types', 'Channel', 'Image', 'CA Daily Report', 'FabAlley', 'Landing Pages', 'Account', 'AdWyZe', 'Page Types', 'Lookalike Types', 'Custom Audiences', 'App Type', 'Sale Campaign', 'Locations', 'Campaign Objective', 'Ad Type']\n"
]
},
{
"name": "stderr",
"output_type": "stream",
"text": [
"/home/sabby/jarvis/jarvis/brain/insights/paths/path_processor.py:258: RuntimeWarning: invalid value encountered in double_scalars\n",
" other_goal_metric = other_num[goal_metric] / other_deno[goal_metric]\n"
]
}
],
"source": [
"args = {\n",
" \"user_id\":\"0\",\n",
" \"account_ids\":{\"facebook\": [261]},\n",
" \"start_date\":\"2017-06-23\",\n",
" \"end_date\":\"2017-06-29\",\n",
" \"goal_metric\": goal_metric,\n",
" \"metrics\": metrics_dict,\n",
" \"num_results\":1500,\n",
" \"filters\": [{\"metric\": \"fb_spend\", \"operator\": \"$gt\", \"value\": 0}],\n",
" \"num_trees\": 10,\n",
"# \"tag_list\":[\"Sale Campaign\", \"Product Category\",\n",
"# \"Image\"],\n",
" \"dimensions\": None,\n",
" \"goal\": None\n",
"}\n",
"\n",
"ad_account = args['account_ids']\n",
"num_levels = 3\n",
"start_date = args['start_date']\n",
"end_date = args['end_date']\n",
"goal_metric = args['goal_metric']\n",
"metrics_dict = args['metrics']\n",
"dimensions = args['dimensions']\n",
"filters = args['filters']\n",
"# tag_list = args['tag_list']\n",
"\n",
"aggregations = {}\n",
"for gm in goal_metric:\n",
" aggregations[metrics_dict[gm]['numerator']] = pd.np.sum\n",
" aggregations[metrics_dict[gm]['denominator']] = pd.np.sum\n",
"# aggregations = {metrics_dict[goal_metric]['numerator']: pd.np.sum,\n",
"# metrics_dict[goal_metric]['denominator']: pd.np.sum}\n",
"goal = args['goal']\n",
"metrics = list(aggregations.keys())\n",
"num_trees = args['num_trees'] if args['num_trees'] != None else 10\n",
"\n",
"excluded_tags = ['Campaigns', 'ad_id', 'Adsets', 'start_date', 'Ads', '_id', 'internal_id', 'Sale',\n",
" 'Product - algo', 'Carousel Count', 'Ad Format', 'Dominant Color', 'Number of Faces',\n",
" 'end_date', 'Active Ads Count in Adset', 'Active Adsets Count in Campaign',\n",
" 'Labels', 'audience type', 'audience category', 'Product Set', 'Prominent Text',\n",
" 'DominantColor', 'ProminentText', 'NumberofFaces', 'name', 'strategy', 'Current Adsets',\n",
" 'Facebook Positions', 'AdsetStrategy', 'Publisher Platforms']\n",
"\n",
"num_results = args['num_results'] if args['num_results'] != None else 15\n",
"\n",
"path_pre_process = PathPreProcessor(ad_account, start_date, end_date,\n",
" [], metrics, num_levels, aggregations,\n",
" excluded_tags, filters, dimensions)#, tag_list=tag_list)\n",
"\n",
"import time\n",
"t1 = time.time()\n",
"path_pre_process.get_data(cross_channel=False)\n",
"print('TIME USED', time.time() - t1)\n",
"path_pre_process.clean_tags(path_pre_process.df, excluded_tags, metrics)\n",
"path_pre_process.score_tags()\n",
"path_pre_process.cluster_tags()\n",
"spend = path_pre_process.get_channel_spend()\n",
"\n",
"global_tag_list = path_pre_process.tag_list\n",
"\n",
"path_model = PathProcessor(path_pre_process.df, goal_metric, metrics_dict, global_tag_list,\n",
" aggregations, num_trees=num_trees, spend=spend, check_threshold=0.05)\n",
"# overall_goal_metric=goal)\n",
"path_model.set_comparison(True)\n",
"\n",
"paths_df, overall = path_model.execute_paths(num_results)\n",
"\n",
"# paths_df.replace([pd.np.inf, -pd.np.inf], 0, inplace=True)\n",
"# paths_df.fillna(value=0, inplace=True)\n",
"\n",
"output = {}\n",
"# paths_df = paths_df[:num_results]\n",
"overall_df = paths_df\n",
"\n",
"levels = [('level_' + str(idx)) for idx in range(num_levels)]\n",
"overall_df['levels'] = overall_df[levels].values.tolist()\n",
"overall_df['levels'] = overall_df['levels'].apply(create_levels_hash)\n",
"\n",
"overall_goal_metric = path_model.overall_goal_metrics\n",
"avg_spend_prop = overall_df.spend_prop.mean()\n",
"\n",
"output['goal_axis'] = overall_goal_metric\n",
"output['spend_axis'] = avg_spend_prop\n",
"\n",
"dfs = []\n",
"\n",
"# Separate output for different quadrants.\n",
"dfs.append(overall_df[(overall_df[goal_metric[0]] < overall_goal_metric[goal_metric[0]]) & (\n",
" overall_df[goal_metric[1]] > overall_goal_metric[goal_metric[1]])])\n",
"\n",
"dfs.append(overall_df[(overall_df[goal_metric[0]] > overall_goal_metric[goal_metric[0]]) & (\n",
" overall_df[goal_metric[1]] > overall_goal_metric[goal_metric[1]])])\n",
"\n",
"dfs.append(overall_df[(overall_df[goal_metric[0]] > overall_goal_metric[goal_metric[0]]) & (\n",
" overall_df[goal_metric[1]] < overall_goal_metric[goal_metric[1]])])\n",
"\n",
"dfs.append(overall_df[(overall_df[goal_metric[0]] < overall_goal_metric[goal_metric[0]]) & (\n",
" overall_df[goal_metric[1]] < overall_goal_metric[goal_metric[1]])])"
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"{'ga_cpv': 10.138876445278633, 'ga_cvr': 0.006117534571595517}"
]
},
"execution_count": 7,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"overall_goal_metric"
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>index</th>\n",
" <th>level_0</th>\n",
" <th>level_1</th>\n",
" <th>level_2</th>\n",
" <th>imp_factor</th>\n",
" <th>spend_prop</th>\n",
" <th>ga_cpv</th>\n",
" <th>ga_cvr</th>\n",
" <th>levels</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>33</th>\n",
" <td>51</td>\n",
" <td>AdWyZe : campaigns</td>\n",
" <td>misc : AdWyzeCampaigns</td>\n",
" <td>Image : ea1d07cfff104c6a41871cb0f42fd04d</td>\n",
" <td>0.547015</td>\n",
" <td>7.747811</td>\n",
" <td>7.702926</td>\n",
" <td>0.007379</td>\n",
" <td>[{'custom_tags.AdWyZe': 'campaigns'}, {'custom...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>89</th>\n",
" <td>167</td>\n",
" <td>Audience Strategy : Prospecting</td>\n",
" <td>Landing Pages : www.faballey.com/curve</td>\n",
" <td>Age Range : 21-44</td>\n",
" <td>0.100222</td>\n",
" <td>2.593485</td>\n",
" <td>8.020870</td>\n",
" <td>0.006481</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Prospectin...</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" index level_0 \\\n",
"33 51 AdWyZe : campaigns \n",
"89 167 Audience Strategy : Prospecting \n",
"\n",
" level_1 \\\n",
"33 misc : AdWyzeCampaigns \n",
"89 Landing Pages : www.faballey.com/curve \n",
"\n",
" level_2 imp_factor spend_prop \\\n",
"33 Image : ea1d07cfff104c6a41871cb0f42fd04d 0.547015 7.747811 \n",
"89 Age Range : 21-44 0.100222 2.593485 \n",
"\n",
" ga_cpv ga_cvr levels \n",
"33 7.702926 0.007379 [{'custom_tags.AdWyZe': 'campaigns'}, {'custom... \n",
"89 8.020870 0.006481 [{'custom_tags.Audience Strategy': 'Prospectin... "
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"dfs[0]"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>index</th>\n",
" <th>level_0</th>\n",
" <th>level_1</th>\n",
" <th>level_2</th>\n",
" <th>imp_factor</th>\n",
" <th>spend_prop</th>\n",
" <th>ga_cpv</th>\n",
" <th>ga_cvr</th>\n",
" <th>levels</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>30</td>\n",
" <td>Audience Strategy : Retention</td>\n",
" <td>Landing Pages : www.faballey.com/clothing/tops...</td>\n",
" <td>Age Range : 21-44</td>\n",
" <td>0.928579</td>\n",
" <td>1.629191</td>\n",
" <td>25.316052</td>\n",
" <td>0.009498</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Retention'...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>34</td>\n",
" <td>Sale Campaign : sale</td>\n",
" <td>Product Category : Tops</td>\n",
" <td>Custom Audiences : Time Spent Top10% or Top 5%...</td>\n",
" <td>0.782003</td>\n",
" <td>2.898391</td>\n",
" <td>23.524557</td>\n",
" <td>0.012048</td>\n",
" <td>[{'custom_tags.Sale Campaign': 'sale'}, {'cust...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>39</td>\n",
" <td>Image : 3aea93aab486b0ae10931d0d5087b7ef</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>0.696198</td>\n",
" <td>1.126350</td>\n",
" <td>22.551154</td>\n",
" <td>0.008741</td>\n",
" <td>[{'custom_tags.Image': '3aea93aab486b0ae10931d...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td>52</td>\n",
" <td>Custom Audiences : Top 5% time spent users</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>0.530641</td>\n",
" <td>1.052266</td>\n",
" <td>20.459813</td>\n",
" <td>0.010187</td>\n",
" <td>[{'custom_tags.Custom Audiences': 'Top 5% time...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>36</th>\n",
" <td>56</td>\n",
" <td>Custom Audiences : Time Spent Top10% or Top 5%...</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>0.502744</td>\n",
" <td>9.204771</td>\n",
" <td>19.814942</td>\n",
" <td>0.008459</td>\n",
" <td>[{'custom_tags.Custom Audiences': 'Time Spent ...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>38</th>\n",
" <td>58</td>\n",
" <td>Custom Audiences : Lookalike (IN, 1%) - Email ...</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>0.472810</td>\n",
" <td>2.339213</td>\n",
" <td>19.654652</td>\n",
" <td>0.009538</td>\n",
" <td>[{'custom_tags.Custom Audiences': 'Lookalike (...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>39</th>\n",
" <td>61</td>\n",
" <td>Audience Strategy : Prospecting</td>\n",
" <td>FabAlley : Indya</td>\n",
" <td>Age Range : 20-45</td>\n",
" <td>0.446392</td>\n",
" <td>4.081633</td>\n",
" <td>19.244113</td>\n",
" <td>0.007822</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Prospectin...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41</th>\n",
" <td>66</td>\n",
" <td>AdWyZe : Sale campaigns</td>\n",
" <td>Image : cf21f87f6bad6327f262e509aa75fc35</td>\n",
" <td>- : -</td>\n",
" <td>0.405275</td>\n",
" <td>5.793376</td>\n",
" <td>18.631646</td>\n",
" <td>0.008705</td>\n",
" <td>[{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td>68</td>\n",
" <td>Audience Strategy : Retention</td>\n",
" <td>Landing Pages : www.faballey.com/clothing/tops</td>\n",
" <td>- : -</td>\n",
" <td>0.357240</td>\n",
" <td>5.606146</td>\n",
" <td>17.968956</td>\n",
" <td>0.008396</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Retention'...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46</th>\n",
" <td>77</td>\n",
" <td>Ad Type : Carousel</td>\n",
" <td>CA Daily Report : WCA</td>\n",
" <td>- : -</td>\n",
" <td>0.348306</td>\n",
" <td>15.060721</td>\n",
" <td>17.560516</td>\n",
" <td>0.008247</td>\n",
" <td>[{'custom_tags.Ad Type': 'Carousel'}, {'custom...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>47</th>\n",
" <td>78</td>\n",
" <td>Sale Campaign : sale</td>\n",
" <td>Product Category : Dresses</td>\n",
" <td>Custom Audiences : Lookalike (IN, 1%) - All Pu...</td>\n",
" <td>0.338086</td>\n",
" <td>2.091617</td>\n",
" <td>17.796256</td>\n",
" <td>0.006686</td>\n",
" <td>[{'custom_tags.Sale Campaign': 'sale'}, {'cust...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td>79</td>\n",
" <td>Image : cf21f87f6bad6327f262e509aa75fc35</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>0.334839</td>\n",
" <td>6.529283</td>\n",
" <td>17.623165</td>\n",
" <td>0.007306</td>\n",
" <td>[{'custom_tags.Image': 'cf21f87f6bad6327f262e5...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50</th>\n",
" <td>84</td>\n",
" <td>AdWyZe : Sale campaigns</td>\n",
" <td>Image : 7042828aaa7f6635d095dd821d85304d</td>\n",
" <td>- : -</td>\n",
" <td>0.325398</td>\n",
" <td>4.554141</td>\n",
" <td>17.542967</td>\n",
" <td>0.008745</td>\n",
" <td>[{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>52</th>\n",
" <td>87</td>\n",
" <td>Audience Strategy : Prospecting</td>\n",
" <td>FabAlley : tops</td>\n",
" <td>Age Range : 18-44</td>\n",
" <td>0.309188</td>\n",
" <td>1.618308</td>\n",
" <td>17.385826</td>\n",
" <td>0.008443</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Prospectin...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>54</th>\n",
" <td>92</td>\n",
" <td>AdWyZe : Sale campaigns</td>\n",
" <td>Landing Pages : www.faballey.com/clothing/dresses</td>\n",
" <td>- : -</td>\n",
" <td>0.303539</td>\n",
" <td>10.343066</td>\n",
" <td>17.063029</td>\n",
" <td>0.007203</td>\n",
" <td>[{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>56</th>\n",
" <td>95</td>\n",
" <td>Audience Strategy : Retention</td>\n",
" <td>Landing Pages : www.faballey.com/indya, www.fa...</td>\n",
" <td>Age Range : 21-44</td>\n",
" <td>0.287175</td>\n",
" <td>1.043425</td>\n",
" <td>17.070829</td>\n",
" <td>0.010000</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Retention'...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>60</th>\n",
" <td>103</td>\n",
" <td>Audience Strategy : Prospecting</td>\n",
" <td>Landing Pages : www.faballey.com/clothing/dresses</td>\n",
" <td>Age Range : 21-44</td>\n",
" <td>0.270774</td>\n",
" <td>5.594928</td>\n",
" <td>16.703496</td>\n",
" <td>0.006517</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Prospectin...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>62</th>\n",
" <td>106</td>\n",
" <td>AdWyZe : Sale campaigns</td>\n",
" <td>Landing Pages : www.faballey.com/clothing/tops</td>\n",
" <td>- : -</td>\n",
" <td>0.265786</td>\n",
" <td>11.580925</td>\n",
" <td>16.471416</td>\n",
" <td>0.007327</td>\n",
" <td>[{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>64</th>\n",
" <td>111</td>\n",
" <td>Image : 7042828aaa7f6635d095dd821d85304d</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>0.248639</td>\n",
" <td>5.502964</td>\n",
" <td>16.364947</td>\n",
" <td>0.007790</td>\n",
" <td>[{'custom_tags.Image': '7042828aaa7f6635d095dd...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>67</th>\n",
" <td>115</td>\n",
" <td>Campaign Objective : Conversions</td>\n",
" <td>Audience Types : Custom, Lookalike</td>\n",
" <td>- : -</td>\n",
" <td>0.225986</td>\n",
" <td>3.577092</td>\n",
" <td>16.052433</td>\n",
" <td>0.009404</td>\n",
" <td>[{'custom_tags.Campaign Objective': 'Conversio...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>70</th>\n",
" <td>123</td>\n",
" <td>Sale Campaign : non-sale</td>\n",
" <td>Product Category : Multi Category</td>\n",
" <td>Custom Audiences : Time Spent Top10% or Top 5%...</td>\n",
" <td>0.188165</td>\n",
" <td>2.553518</td>\n",
" <td>15.448267</td>\n",
" <td>0.008452</td>\n",
" <td>[{'custom_tags.Sale Campaign': 'non-sale'}, {'...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>71</th>\n",
" <td>124</td>\n",
" <td>Audience Strategy : Mixed</td>\n",
" <td>Landing Pages : www.faballey.com/clothing/tops</td>\n",
" <td>- : -</td>\n",
" <td>0.182222</td>\n",
" <td>2.532693</td>\n",
" <td>15.346598</td>\n",
" <td>0.012698</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Mixed'}, {...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>74</th>\n",
" <td>132</td>\n",
" <td>FabAlley : tops</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>0.167742</td>\n",
" <td>19.343707</td>\n",
" <td>14.736200</td>\n",
" <td>0.007450</td>\n",
" <td>[{'custom_tags.FabAlley': 'tops'}]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>75</th>\n",
" <td>137</td>\n",
" <td>Ad Type : Carousel</td>\n",
" <td>FabAlley : dresses</td>\n",
" <td>Interests : College or Education or Higher edu...</td>\n",
" <td>0.155880</td>\n",
" <td>1.250781</td>\n",
" <td>14.905598</td>\n",
" <td>0.010406</td>\n",
" <td>[{'custom_tags.Ad Type': 'Carousel'}, {'custom...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>76</th>\n",
" <td>142</td>\n",
" <td>Image : 3fe65f1956cff5dc95e64900b02627ba</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>0.152414</td>\n",
" <td>2.561673</td>\n",
" <td>14.816646</td>\n",
" <td>0.011111</td>\n",
" <td>[{'custom_tags.Image': '3fe65f1956cff5dc95e649...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>77</th>\n",
" <td>143</td>\n",
" <td>Audience Strategy : Retention</td>\n",
" <td>Landing Pages : www.faballey.com/indya, www.fa...</td>\n",
" <td>- : -</td>\n",
" <td>0.151087</td>\n",
" <td>1.674642</td>\n",
" <td>14.809614</td>\n",
" <td>0.006950</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Retention'...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>78</th>\n",
" <td>148</td>\n",
" <td>Audience Strategy : Retention</td>\n",
" <td>FabAlley : Curve</td>\n",
" <td>Age Range : 18-44</td>\n",
" <td>0.144363</td>\n",
" <td>1.675940</td>\n",
" <td>14.685011</td>\n",
" <td>0.007651</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Retention'...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>79</th>\n",
" <td>150</td>\n",
" <td>Sale Campaign : non-sale</td>\n",
" <td>Product Category : Tops</td>\n",
" <td>Custom Audiences : Lookalike (IN, 1%) - All Pu...</td>\n",
" <td>0.141817</td>\n",
" <td>2.683145</td>\n",
" <td>14.618501</td>\n",
" <td>0.007136</td>\n",
" <td>[{'custom_tags.Sale Campaign': 'non-sale'}, {'...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>92</th>\n",
" <td>172</td>\n",
" <td>Image : 79c688c4ede3f008b7d9e90215d1a0b6</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>0.097629</td>\n",
" <td>5.291899</td>\n",
" <td>13.698969</td>\n",
" <td>0.008137</td>\n",
" <td>[{'custom_tags.Image': '79c688c4ede3f008b7d9e9...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>94</th>\n",
" <td>174</td>\n",
" <td>AdWyZe : campaigns</td>\n",
" <td>misc : AdWyzeCampaigns</td>\n",
" <td>Image : 3fe65f1956cff5dc95e64900b02627ba</td>\n",
" <td>0.097144</td>\n",
" <td>1.635984</td>\n",
" <td>13.745950</td>\n",
" <td>0.010271</td>\n",
" <td>[{'custom_tags.AdWyZe': 'campaigns'}, {'custom...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>95</th>\n",
" <td>176</td>\n",
" <td>AdWyZe : Sale campaigns</td>\n",
" <td>Landing Pages : faballey.com</td>\n",
" <td>- : -</td>\n",
" <td>0.092913</td>\n",
" <td>13.875059</td>\n",
" <td>13.462753</td>\n",
" <td>0.017284</td>\n",
" <td>[{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96</th>\n",
" <td>178</td>\n",
" <td>Age Range : 21-35</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>0.091414</td>\n",
" <td>4.269501</td>\n",
" <td>13.582072</td>\n",
" <td>0.006944</td>\n",
" <td>[{'custom_tags.Age Range': '21-35'}]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>97</th>\n",
" <td>183</td>\n",
" <td>Sale Campaign : sale</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>0.086172</td>\n",
" <td>59.099572</td>\n",
" <td>12.488681</td>\n",
" <td>0.007971</td>\n",
" <td>[{'custom_tags.Sale Campaign': 'sale'}]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>98</th>\n",
" <td>185</td>\n",
" <td>Audience Strategy : Prospecting</td>\n",
" <td>Landing Pages : www.faballey.com/clothing/dresses</td>\n",
" <td>Age Range : 20-30</td>\n",
" <td>0.085965</td>\n",
" <td>1.460974</td>\n",
" <td>13.504003</td>\n",
" <td>0.008878</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Prospectin...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>99</th>\n",
" <td>189</td>\n",
" <td>Audience Strategy : Retention</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>0.081087</td>\n",
" <td>41.105804</td>\n",
" <td>12.760344</td>\n",
" <td>0.010165</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Retention'}]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>101</th>\n",
" <td>191</td>\n",
" <td>AdWyZe : campaigns</td>\n",
" <td>misc : AdWyzeCampaigns</td>\n",
" <td>Image : 79c688c4ede3f008b7d9e90215d1a0b6</td>\n",
" <td>0.061550</td>\n",
" <td>4.393134</td>\n",
" <td>12.887126</td>\n",
" <td>0.007941</td>\n",
" <td>[{'custom_tags.AdWyZe': 'campaigns'}, {'custom...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>104</th>\n",
" <td>197</td>\n",
" <td>AdWyZe : Sale campaigns</td>\n",
" <td>Image : e7469535eac32dc1a3a7d00596ed558c</td>\n",
" <td>- : -</td>\n",
" <td>0.058518</td>\n",
" <td>1.543335</td>\n",
" <td>12.844971</td>\n",
" <td>0.008721</td>\n",
" <td>[{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>105</th>\n",
" <td>199</td>\n",
" <td>AdWyZe : campaigns</td>\n",
" <td>Landing Pages : www.faballey.com/clothing/tops</td>\n",
" <td>- : -</td>\n",
" <td>0.057185</td>\n",
" <td>7.762782</td>\n",
" <td>12.734773</td>\n",
" <td>0.007592</td>\n",
" <td>[{'custom_tags.AdWyZe': 'campaigns'}, {'custom...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>106</th>\n",
" <td>201</td>\n",
" <td>Audience Strategy : Retention</td>\n",
" <td>Landing Pages : www.faballey.com/clothing/tops...</td>\n",
" <td>- : -</td>\n",
" <td>0.055838</td>\n",
" <td>1.371171</td>\n",
" <td>12.777071</td>\n",
" <td>0.006509</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Retention'...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>112</th>\n",
" <td>212</td>\n",
" <td>Sale Campaign : non-sale</td>\n",
" <td>Product Category : Tops</td>\n",
" <td>Custom Audiences : Lookalike (IN, 1% to 2%) - ...</td>\n",
" <td>0.033514</td>\n",
" <td>1.586356</td>\n",
" <td>12.127750</td>\n",
" <td>0.006676</td>\n",
" <td>[{'custom_tags.Sale Campaign': 'non-sale'}, {'...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>116</th>\n",
" <td>217</td>\n",
" <td>Audience Strategy : Prospecting</td>\n",
" <td>FabAlley : tops</td>\n",
" <td>Age Range : 20-34</td>\n",
" <td>0.021909</td>\n",
" <td>1.041070</td>\n",
" <td>11.723314</td>\n",
" <td>0.006883</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Prospectin...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>119</th>\n",
" <td>226</td>\n",
" <td>Age Range : 21-44</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>0.009047</td>\n",
" <td>55.057197</td>\n",
" <td>10.822686</td>\n",
" <td>0.008033</td>\n",
" <td>[{'custom_tags.Age Range': '21-44'}]</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" index level_0 \\\n",
"19 30 Audience Strategy : Retention \n",
"22 34 Sale Campaign : sale \n",
"25 39 Image : 3aea93aab486b0ae10931d0d5087b7ef \n",
"34 52 Custom Audiences : Top 5% time spent users \n",
"36 56 Custom Audiences : Time Spent Top10% or Top 5%... \n",
"38 58 Custom Audiences : Lookalike (IN, 1%) - Email ... \n",
"39 61 Audience Strategy : Prospecting \n",
"41 66 AdWyZe : Sale campaigns \n",
"42 68 Audience Strategy : Retention \n",
"46 77 Ad Type : Carousel \n",
"47 78 Sale Campaign : sale \n",
"48 79 Image : cf21f87f6bad6327f262e509aa75fc35 \n",
"50 84 AdWyZe : Sale campaigns \n",
"52 87 Audience Strategy : Prospecting \n",
"54 92 AdWyZe : Sale campaigns \n",
"56 95 Audience Strategy : Retention \n",
"60 103 Audience Strategy : Prospecting \n",
"62 106 AdWyZe : Sale campaigns \n",
"64 111 Image : 7042828aaa7f6635d095dd821d85304d \n",
"67 115 Campaign Objective : Conversions \n",
"70 123 Sale Campaign : non-sale \n",
"71 124 Audience Strategy : Mixed \n",
"74 132 FabAlley : tops \n",
"75 137 Ad Type : Carousel \n",
"76 142 Image : 3fe65f1956cff5dc95e64900b02627ba \n",
"77 143 Audience Strategy : Retention \n",
"78 148 Audience Strategy : Retention \n",
"79 150 Sale Campaign : non-sale \n",
"92 172 Image : 79c688c4ede3f008b7d9e90215d1a0b6 \n",
"94 174 AdWyZe : campaigns \n",
"95 176 AdWyZe : Sale campaigns \n",
"96 178 Age Range : 21-35 \n",
"97 183 Sale Campaign : sale \n",
"98 185 Audience Strategy : Prospecting \n",
"99 189 Audience Strategy : Retention \n",
"101 191 AdWyZe : campaigns \n",
"104 197 AdWyZe : Sale campaigns \n",
"105 199 AdWyZe : campaigns \n",
"106 201 Audience Strategy : Retention \n",
"112 212 Sale Campaign : non-sale \n",
"116 217 Audience Strategy : Prospecting \n",
"119 226 Age Range : 21-44 \n",
"\n",
" level_1 \\\n",
"19 Landing Pages : www.faballey.com/clothing/tops... \n",
"22 Product Category : Tops \n",
"25 - : - \n",
"34 - : - \n",
"36 - : - \n",
"38 - : - \n",
"39 FabAlley : Indya \n",
"41 Image : cf21f87f6bad6327f262e509aa75fc35 \n",
"42 Landing Pages : www.faballey.com/clothing/tops \n",
"46 CA Daily Report : WCA \n",
"47 Product Category : Dresses \n",
"48 - : - \n",
"50 Image : 7042828aaa7f6635d095dd821d85304d \n",
"52 FabAlley : tops \n",
"54 Landing Pages : www.faballey.com/clothing/dresses \n",
"56 Landing Pages : www.faballey.com/indya, www.fa... \n",
"60 Landing Pages : www.faballey.com/clothing/dresses \n",
"62 Landing Pages : www.faballey.com/clothing/tops \n",
"64 - : - \n",
"67 Audience Types : Custom, Lookalike \n",
"70 Product Category : Multi Category \n",
"71 Landing Pages : www.faballey.com/clothing/tops \n",
"74 - : - \n",
"75 FabAlley : dresses \n",
"76 - : - \n",
"77 Landing Pages : www.faballey.com/indya, www.fa... \n",
"78 FabAlley : Curve \n",
"79 Product Category : Tops \n",
"92 - : - \n",
"94 misc : AdWyzeCampaigns \n",
"95 Landing Pages : faballey.com \n",
"96 - : - \n",
"97 - : - \n",
"98 Landing Pages : www.faballey.com/clothing/dresses \n",
"99 - : - \n",
"101 misc : AdWyzeCampaigns \n",
"104 Image : e7469535eac32dc1a3a7d00596ed558c \n",
"105 Landing Pages : www.faballey.com/clothing/tops \n",
"106 Landing Pages : www.faballey.com/clothing/tops... \n",
"112 Product Category : Tops \n",
"116 FabAlley : tops \n",
"119 - : - \n",
"\n",
" level_2 imp_factor \\\n",
"19 Age Range : 21-44 0.928579 \n",
"22 Custom Audiences : Time Spent Top10% or Top 5%... 0.782003 \n",
"25 - : - 0.696198 \n",
"34 - : - 0.530641 \n",
"36 - : - 0.502744 \n",
"38 - : - 0.472810 \n",
"39 Age Range : 20-45 0.446392 \n",
"41 - : - 0.405275 \n",
"42 - : - 0.357240 \n",
"46 - : - 0.348306 \n",
"47 Custom Audiences : Lookalike (IN, 1%) - All Pu... 0.338086 \n",
"48 - : - 0.334839 \n",
"50 - : - 0.325398 \n",
"52 Age Range : 18-44 0.309188 \n",
"54 - : - 0.303539 \n",
"56 Age Range : 21-44 0.287175 \n",
"60 Age Range : 21-44 0.270774 \n",
"62 - : - 0.265786 \n",
"64 - : - 0.248639 \n",
"67 - : - 0.225986 \n",
"70 Custom Audiences : Time Spent Top10% or Top 5%... 0.188165 \n",
"71 - : - 0.182222 \n",
"74 - : - 0.167742 \n",
"75 Interests : College or Education or Higher edu... 0.155880 \n",
"76 - : - 0.152414 \n",
"77 - : - 0.151087 \n",
"78 Age Range : 18-44 0.144363 \n",
"79 Custom Audiences : Lookalike (IN, 1%) - All Pu... 0.141817 \n",
"92 - : - 0.097629 \n",
"94 Image : 3fe65f1956cff5dc95e64900b02627ba 0.097144 \n",
"95 - : - 0.092913 \n",
"96 - : - 0.091414 \n",
"97 - : - 0.086172 \n",
"98 Age Range : 20-30 0.085965 \n",
"99 - : - 0.081087 \n",
"101 Image : 79c688c4ede3f008b7d9e90215d1a0b6 0.061550 \n",
"104 - : - 0.058518 \n",
"105 - : - 0.057185 \n",
"106 - : - 0.055838 \n",
"112 Custom Audiences : Lookalike (IN, 1% to 2%) - ... 0.033514 \n",
"116 Age Range : 20-34 0.021909 \n",
"119 - : - 0.009047 \n",
"\n",
" spend_prop ga_cpv ga_cvr \\\n",
"19 1.629191 25.316052 0.009498 \n",
"22 2.898391 23.524557 0.012048 \n",
"25 1.126350 22.551154 0.008741 \n",
"34 1.052266 20.459813 0.010187 \n",
"36 9.204771 19.814942 0.008459 \n",
"38 2.339213 19.654652 0.009538 \n",
"39 4.081633 19.244113 0.007822 \n",
"41 5.793376 18.631646 0.008705 \n",
"42 5.606146 17.968956 0.008396 \n",
"46 15.060721 17.560516 0.008247 \n",
"47 2.091617 17.796256 0.006686 \n",
"48 6.529283 17.623165 0.007306 \n",
"50 4.554141 17.542967 0.008745 \n",
"52 1.618308 17.385826 0.008443 \n",
"54 10.343066 17.063029 0.007203 \n",
"56 1.043425 17.070829 0.010000 \n",
"60 5.594928 16.703496 0.006517 \n",
"62 11.580925 16.471416 0.007327 \n",
"64 5.502964 16.364947 0.007790 \n",
"67 3.577092 16.052433 0.009404 \n",
"70 2.553518 15.448267 0.008452 \n",
"71 2.532693 15.346598 0.012698 \n",
"74 19.343707 14.736200 0.007450 \n",
"75 1.250781 14.905598 0.010406 \n",
"76 2.561673 14.816646 0.011111 \n",
"77 1.674642 14.809614 0.006950 \n",
"78 1.675940 14.685011 0.007651 \n",
"79 2.683145 14.618501 0.007136 \n",
"92 5.291899 13.698969 0.008137 \n",
"94 1.635984 13.745950 0.010271 \n",
"95 13.875059 13.462753 0.017284 \n",
"96 4.269501 13.582072 0.006944 \n",
"97 59.099572 12.488681 0.007971 \n",
"98 1.460974 13.504003 0.008878 \n",
"99 41.105804 12.760344 0.010165 \n",
"101 4.393134 12.887126 0.007941 \n",
"104 1.543335 12.844971 0.008721 \n",
"105 7.762782 12.734773 0.007592 \n",
"106 1.371171 12.777071 0.006509 \n",
"112 1.586356 12.127750 0.006676 \n",
"116 1.041070 11.723314 0.006883 \n",
"119 55.057197 10.822686 0.008033 \n",
"\n",
" levels \n",
"19 [{'custom_tags.Audience Strategy': 'Retention'... \n",
"22 [{'custom_tags.Sale Campaign': 'sale'}, {'cust... \n",
"25 [{'custom_tags.Image': '3aea93aab486b0ae10931d... \n",
"34 [{'custom_tags.Custom Audiences': 'Top 5% time... \n",
"36 [{'custom_tags.Custom Audiences': 'Time Spent ... \n",
"38 [{'custom_tags.Custom Audiences': 'Lookalike (... \n",
"39 [{'custom_tags.Audience Strategy': 'Prospectin... \n",
"41 [{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c... \n",
"42 [{'custom_tags.Audience Strategy': 'Retention'... \n",
"46 [{'custom_tags.Ad Type': 'Carousel'}, {'custom... \n",
"47 [{'custom_tags.Sale Campaign': 'sale'}, {'cust... \n",
"48 [{'custom_tags.Image': 'cf21f87f6bad6327f262e5... \n",
"50 [{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c... \n",
"52 [{'custom_tags.Audience Strategy': 'Prospectin... \n",
"54 [{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c... \n",
"56 [{'custom_tags.Audience Strategy': 'Retention'... \n",
"60 [{'custom_tags.Audience Strategy': 'Prospectin... \n",
"62 [{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c... \n",
"64 [{'custom_tags.Image': '7042828aaa7f6635d095dd... \n",
"67 [{'custom_tags.Campaign Objective': 'Conversio... \n",
"70 [{'custom_tags.Sale Campaign': 'non-sale'}, {'... \n",
"71 [{'custom_tags.Audience Strategy': 'Mixed'}, {... \n",
"74 [{'custom_tags.FabAlley': 'tops'}] \n",
"75 [{'custom_tags.Ad Type': 'Carousel'}, {'custom... \n",
"76 [{'custom_tags.Image': '3fe65f1956cff5dc95e649... \n",
"77 [{'custom_tags.Audience Strategy': 'Retention'... \n",
"78 [{'custom_tags.Audience Strategy': 'Retention'... \n",
"79 [{'custom_tags.Sale Campaign': 'non-sale'}, {'... \n",
"92 [{'custom_tags.Image': '79c688c4ede3f008b7d9e9... \n",
"94 [{'custom_tags.AdWyZe': 'campaigns'}, {'custom... \n",
"95 [{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c... \n",
"96 [{'custom_tags.Age Range': '21-35'}] \n",
"97 [{'custom_tags.Sale Campaign': 'sale'}] \n",
"98 [{'custom_tags.Audience Strategy': 'Prospectin... \n",
"99 [{'custom_tags.Audience Strategy': 'Retention'}] \n",
"101 [{'custom_tags.AdWyZe': 'campaigns'}, {'custom... \n",
"104 [{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c... \n",
"105 [{'custom_tags.AdWyZe': 'campaigns'}, {'custom... \n",
"106 [{'custom_tags.Audience Strategy': 'Retention'... \n",
"112 [{'custom_tags.Sale Campaign': 'non-sale'}, {'... \n",
"116 [{'custom_tags.Audience Strategy': 'Prospectin... \n",
"119 [{'custom_tags.Age Range': '21-44'}] "
]
},
"execution_count": 9,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"dfs[1]"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>index</th>\n",
" <th>level_0</th>\n",
" <th>level_1</th>\n",
" <th>level_2</th>\n",
" <th>imp_factor</th>\n",
" <th>spend_prop</th>\n",
" <th>ga_cpv</th>\n",
" <th>ga_cvr</th>\n",
" <th>levels</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>25</td>\n",
" <td>Sale Campaign : sale</td>\n",
" <td>Product Category : Dresses</td>\n",
" <td>Custom Audiences : Time Spent Top10% or Top 5%...</td>\n",
" <td>1.189560</td>\n",
" <td>1.370140</td>\n",
" <td>28.323484</td>\n",
" <td>0.005415</td>\n",
" <td>[{'custom_tags.Sale Campaign': 'sale'}, {'cust...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>41</td>\n",
" <td>AdWyZe : Sale campaigns</td>\n",
" <td>Image : a1272cba13b15daab9b85c5c3b316fc7</td>\n",
" <td>- : -</td>\n",
" <td>0.669494</td>\n",
" <td>1.398309</td>\n",
" <td>22.210555</td>\n",
" <td>0.002774</td>\n",
" <td>[{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44</th>\n",
" <td>72</td>\n",
" <td>Audience Strategy : Mixed</td>\n",
" <td>FabAlley : dresses</td>\n",
" <td>- : -</td>\n",
" <td>0.354852</td>\n",
" <td>1.044399</td>\n",
" <td>18.067583</td>\n",
" <td>0.000000</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Mixed'}, {...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45</th>\n",
" <td>75</td>\n",
" <td>AdWyZe : Sale campaigns</td>\n",
" <td>Image : f7fe99a0277b16356551860627aa32a6</td>\n",
" <td>- : -</td>\n",
" <td>0.349361</td>\n",
" <td>2.518287</td>\n",
" <td>17.946540</td>\n",
" <td>0.003111</td>\n",
" <td>[{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>58</th>\n",
" <td>98</td>\n",
" <td>Audience Strategy : Retention</td>\n",
" <td>Landing Pages : www.faballey.com/clothing/tops...</td>\n",
" <td>- : -</td>\n",
" <td>0.276452</td>\n",
" <td>4.909180</td>\n",
" <td>16.807546</td>\n",
" <td>0.004783</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Retention'...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>61</th>\n",
" <td>105</td>\n",
" <td>Image : f7fe99a0277b16356551860627aa32a6</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>0.266433</td>\n",
" <td>2.984236</td>\n",
" <td>16.703944</td>\n",
" <td>0.002444</td>\n",
" <td>[{'custom_tags.Image': 'f7fe99a0277b1635655186...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>68</th>\n",
" <td>120</td>\n",
" <td>Audience Strategy : Retention</td>\n",
" <td>FabAlley : Curve</td>\n",
" <td>- : -</td>\n",
" <td>0.208345</td>\n",
" <td>2.639650</td>\n",
" <td>15.785885</td>\n",
" <td>0.005744</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Retention'...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>69</th>\n",
" <td>122</td>\n",
" <td>Sale Campaign : sale</td>\n",
" <td>Product Category : Dresses</td>\n",
" <td>Custom Audiences : Lookalike (IN, 1% to 2%) - ...</td>\n",
" <td>0.206824</td>\n",
" <td>1.799472</td>\n",
" <td>15.779502</td>\n",
" <td>0.005360</td>\n",
" <td>[{'custom_tags.Sale Campaign': 'sale'}, {'cust...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>72</th>\n",
" <td>127</td>\n",
" <td>AdWyZe : Sale campaigns</td>\n",
" <td>Image : b2815b2ba2f10ed8b3070dbf37820e58</td>\n",
" <td>- : -</td>\n",
" <td>0.182053</td>\n",
" <td>3.510871</td>\n",
" <td>15.322954</td>\n",
" <td>0.005335</td>\n",
" <td>[{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>73</th>\n",
" <td>130</td>\n",
" <td>AdWyZe : Sale campaigns</td>\n",
" <td>Landing Pages : www.faballey.com/clothing/tops</td>\n",
" <td>Image : ee5720b3ca6f6b3b0c2226cab36921da</td>\n",
" <td>0.172033</td>\n",
" <td>5.202330</td>\n",
" <td>15.113767</td>\n",
" <td>0.005074</td>\n",
" <td>[{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>80</th>\n",
" <td>152</td>\n",
" <td>Audience Strategy : Retention</td>\n",
" <td>Landing Pages : www.faballey.com/clothing/tops...</td>\n",
" <td>Age Range : 18-54</td>\n",
" <td>0.131027</td>\n",
" <td>3.279989</td>\n",
" <td>14.403110</td>\n",
" <td>0.003451</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Retention'...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>81</th>\n",
" <td>154</td>\n",
" <td>Image : ee5720b3ca6f6b3b0c2226cab36921da</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>0.130856</td>\n",
" <td>5.987171</td>\n",
" <td>14.350498</td>\n",
" <td>0.005023</td>\n",
" <td>[{'custom_tags.Image': 'ee5720b3ca6f6b3b0c2226...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>88</th>\n",
" <td>162</td>\n",
" <td>FabAlley : dresses</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>0.103239</td>\n",
" <td>15.582926</td>\n",
" <td>13.643717</td>\n",
" <td>0.005428</td>\n",
" <td>[{'custom_tags.FabAlley': 'dresses'}]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>107</th>\n",
" <td>205</td>\n",
" <td>Audience Strategy : Retention</td>\n",
" <td>FabAlley : Multi Category</td>\n",
" <td>Age Range : 18-54</td>\n",
" <td>0.053932</td>\n",
" <td>4.909068</td>\n",
" <td>12.685007</td>\n",
" <td>0.003384</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Retention'...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>109</th>\n",
" <td>209</td>\n",
" <td>Custom Audiences : Retargeting 7 days</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>0.040453</td>\n",
" <td>5.532741</td>\n",
" <td>12.303384</td>\n",
" <td>0.003689</td>\n",
" <td>[{'custom_tags.Custom Audiences': 'Retargeting...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>113</th>\n",
" <td>213</td>\n",
" <td>Sale Campaign : sale</td>\n",
" <td>Lookalike Types : 1%</td>\n",
" <td>Custom Audiences : Lookalike (IN, 1%) - Email_...</td>\n",
" <td>0.028681</td>\n",
" <td>1.459837</td>\n",
" <td>11.967387</td>\n",
" <td>0.003579</td>\n",
" <td>[{'custom_tags.Sale Campaign': 'sale'}, {'cust...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>114</th>\n",
" <td>214</td>\n",
" <td>Sale Campaign : non-sale</td>\n",
" <td>Product Category : Dresses</td>\n",
" <td>Custom Audiences : Lookalike (IN, 1%) - All Pu...</td>\n",
" <td>0.024737</td>\n",
" <td>1.164098</td>\n",
" <td>11.829246</td>\n",
" <td>0.002662</td>\n",
" <td>[{'custom_tags.Sale Campaign': 'non-sale'}, {'...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>118</th>\n",
" <td>221</td>\n",
" <td>Audience Strategy : Prospecting</td>\n",
" <td>FabAlley : dresses</td>\n",
" <td>Age Range : 18-44</td>\n",
" <td>0.013160</td>\n",
" <td>3.135474</td>\n",
" <td>11.334684</td>\n",
" <td>0.004104</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Prospectin...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>121</th>\n",
" <td>230</td>\n",
" <td>AdWyZe : campaigns</td>\n",
" <td>misc : AdWyzeCampaigns</td>\n",
" <td>Image : a2809a569c180c23d7ff073d92905d4c</td>\n",
" <td>0.007047</td>\n",
" <td>1.704966</td>\n",
" <td>11.006607</td>\n",
" <td>0.002255</td>\n",
" <td>[{'custom_tags.AdWyZe': 'campaigns'}, {'custom...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>122</th>\n",
" <td>232</td>\n",
" <td>AdWyZe : Sale campaigns</td>\n",
" <td>Landing Pages : www.faballey.com/indya</td>\n",
" <td>Image : 47595dd72f8a3a57d09092906e6474cf</td>\n",
" <td>0.005635</td>\n",
" <td>2.355675</td>\n",
" <td>10.908945</td>\n",
" <td>0.003639</td>\n",
" <td>[{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>123</th>\n",
" <td>234</td>\n",
" <td>Image : 85b8e25839d93bf2308dde89f62e3c62</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>0.005622</td>\n",
" <td>1.136783</td>\n",
" <td>10.912607</td>\n",
" <td>0.004191</td>\n",
" <td>[{'custom_tags.Image': '85b8e25839d93bf2308dde...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>124</th>\n",
" <td>239</td>\n",
" <td>Image : 4d85b8a014e4e1c27ba990e0ff9be8f3</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>0.003515</td>\n",
" <td>2.413454</td>\n",
" <td>10.742138</td>\n",
" <td>0.002721</td>\n",
" <td>[{'custom_tags.Image': '4d85b8a014e4e1c27ba990...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>125</th>\n",
" <td>240</td>\n",
" <td>Lookalike Types : 1%</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>0.003091</td>\n",
" <td>19.451299</td>\n",
" <td>10.653346</td>\n",
" <td>0.005069</td>\n",
" <td>[{'custom_tags.Lookalike Types': '1%'}]</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" index level_0 \\\n",
"16 25 Sale Campaign : sale \n",
"27 41 AdWyZe : Sale campaigns \n",
"44 72 Audience Strategy : Mixed \n",
"45 75 AdWyZe : Sale campaigns \n",
"58 98 Audience Strategy : Retention \n",
"61 105 Image : f7fe99a0277b16356551860627aa32a6 \n",
"68 120 Audience Strategy : Retention \n",
"69 122 Sale Campaign : sale \n",
"72 127 AdWyZe : Sale campaigns \n",
"73 130 AdWyZe : Sale campaigns \n",
"80 152 Audience Strategy : Retention \n",
"81 154 Image : ee5720b3ca6f6b3b0c2226cab36921da \n",
"88 162 FabAlley : dresses \n",
"107 205 Audience Strategy : Retention \n",
"109 209 Custom Audiences : Retargeting 7 days \n",
"113 213 Sale Campaign : sale \n",
"114 214 Sale Campaign : non-sale \n",
"118 221 Audience Strategy : Prospecting \n",
"121 230 AdWyZe : campaigns \n",
"122 232 AdWyZe : Sale campaigns \n",
"123 234 Image : 85b8e25839d93bf2308dde89f62e3c62 \n",
"124 239 Image : 4d85b8a014e4e1c27ba990e0ff9be8f3 \n",
"125 240 Lookalike Types : 1% \n",
"\n",
" level_1 \\\n",
"16 Product Category : Dresses \n",
"27 Image : a1272cba13b15daab9b85c5c3b316fc7 \n",
"44 FabAlley : dresses \n",
"45 Image : f7fe99a0277b16356551860627aa32a6 \n",
"58 Landing Pages : www.faballey.com/clothing/tops... \n",
"61 - : - \n",
"68 FabAlley : Curve \n",
"69 Product Category : Dresses \n",
"72 Image : b2815b2ba2f10ed8b3070dbf37820e58 \n",
"73 Landing Pages : www.faballey.com/clothing/tops \n",
"80 Landing Pages : www.faballey.com/clothing/tops... \n",
"81 - : - \n",
"88 - : - \n",
"107 FabAlley : Multi Category \n",
"109 - : - \n",
"113 Lookalike Types : 1% \n",
"114 Product Category : Dresses \n",
"118 FabAlley : dresses \n",
"121 misc : AdWyzeCampaigns \n",
"122 Landing Pages : www.faballey.com/indya \n",
"123 - : - \n",
"124 - : - \n",
"125 - : - \n",
"\n",
" level_2 imp_factor \\\n",
"16 Custom Audiences : Time Spent Top10% or Top 5%... 1.189560 \n",
"27 - : - 0.669494 \n",
"44 - : - 0.354852 \n",
"45 - : - 0.349361 \n",
"58 - : - 0.276452 \n",
"61 - : - 0.266433 \n",
"68 - : - 0.208345 \n",
"69 Custom Audiences : Lookalike (IN, 1% to 2%) - ... 0.206824 \n",
"72 - : - 0.182053 \n",
"73 Image : ee5720b3ca6f6b3b0c2226cab36921da 0.172033 \n",
"80 Age Range : 18-54 0.131027 \n",
"81 - : - 0.130856 \n",
"88 - : - 0.103239 \n",
"107 Age Range : 18-54 0.053932 \n",
"109 - : - 0.040453 \n",
"113 Custom Audiences : Lookalike (IN, 1%) - Email_... 0.028681 \n",
"114 Custom Audiences : Lookalike (IN, 1%) - All Pu... 0.024737 \n",
"118 Age Range : 18-44 0.013160 \n",
"121 Image : a2809a569c180c23d7ff073d92905d4c 0.007047 \n",
"122 Image : 47595dd72f8a3a57d09092906e6474cf 0.005635 \n",
"123 - : - 0.005622 \n",
"124 - : - 0.003515 \n",
"125 - : - 0.003091 \n",
"\n",
" spend_prop ga_cpv ga_cvr \\\n",
"16 1.370140 28.323484 0.005415 \n",
"27 1.398309 22.210555 0.002774 \n",
"44 1.044399 18.067583 0.000000 \n",
"45 2.518287 17.946540 0.003111 \n",
"58 4.909180 16.807546 0.004783 \n",
"61 2.984236 16.703944 0.002444 \n",
"68 2.639650 15.785885 0.005744 \n",
"69 1.799472 15.779502 0.005360 \n",
"72 3.510871 15.322954 0.005335 \n",
"73 5.202330 15.113767 0.005074 \n",
"80 3.279989 14.403110 0.003451 \n",
"81 5.987171 14.350498 0.005023 \n",
"88 15.582926 13.643717 0.005428 \n",
"107 4.909068 12.685007 0.003384 \n",
"109 5.532741 12.303384 0.003689 \n",
"113 1.459837 11.967387 0.003579 \n",
"114 1.164098 11.829246 0.002662 \n",
"118 3.135474 11.334684 0.004104 \n",
"121 1.704966 11.006607 0.002255 \n",
"122 2.355675 10.908945 0.003639 \n",
"123 1.136783 10.912607 0.004191 \n",
"124 2.413454 10.742138 0.002721 \n",
"125 19.451299 10.653346 0.005069 \n",
"\n",
" levels \n",
"16 [{'custom_tags.Sale Campaign': 'sale'}, {'cust... \n",
"27 [{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c... \n",
"44 [{'custom_tags.Audience Strategy': 'Mixed'}, {... \n",
"45 [{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c... \n",
"58 [{'custom_tags.Audience Strategy': 'Retention'... \n",
"61 [{'custom_tags.Image': 'f7fe99a0277b1635655186... \n",
"68 [{'custom_tags.Audience Strategy': 'Retention'... \n",
"69 [{'custom_tags.Sale Campaign': 'sale'}, {'cust... \n",
"72 [{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c... \n",
"73 [{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c... \n",
"80 [{'custom_tags.Audience Strategy': 'Retention'... \n",
"81 [{'custom_tags.Image': 'ee5720b3ca6f6b3b0c2226... \n",
"88 [{'custom_tags.FabAlley': 'dresses'}] \n",
"107 [{'custom_tags.Audience Strategy': 'Retention'... \n",
"109 [{'custom_tags.Custom Audiences': 'Retargeting... \n",
"113 [{'custom_tags.Sale Campaign': 'sale'}, {'cust... \n",
"114 [{'custom_tags.Sale Campaign': 'non-sale'}, {'... \n",
"118 [{'custom_tags.Audience Strategy': 'Prospectin... \n",
"121 [{'custom_tags.AdWyZe': 'campaigns'}, {'custom... \n",
"122 [{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c... \n",
"123 [{'custom_tags.Image': '85b8e25839d93bf2308dde... \n",
"124 [{'custom_tags.Image': '4d85b8a014e4e1c27ba990... \n",
"125 [{'custom_tags.Lookalike Types': '1%'}] "
]
},
"execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"dfs[2]"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {
"scrolled": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>index</th>\n",
" <th>level_0</th>\n",
" <th>level_1</th>\n",
" <th>level_2</th>\n",
" <th>imp_factor</th>\n",
" <th>spend_prop</th>\n",
" <th>ga_cpv</th>\n",
" <th>ga_cvr</th>\n",
" <th>levels</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>0</td>\n",
" <td>AdWyZe : campaigns</td>\n",
" <td>misc : AdWyzeCampaigns</td>\n",
" <td>Image : 47595dd72f8a3a57d09092906e6474cf</td>\n",
" <td>6.247269e+00</td>\n",
" <td>1.192298</td>\n",
" <td>7.002313</td>\n",
" <td>0.001026</td>\n",
" <td>[{'custom_tags.AdWyZe': 'campaigns'}, {'custom...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>1</td>\n",
" <td>Age Range : 20-34</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>5.518040e+00</td>\n",
" <td>4.027281</td>\n",
" <td>5.424781</td>\n",
" <td>0.003176</td>\n",
" <td>[{'custom_tags.Age Range': '20-34'}]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>2</td>\n",
" <td>Audience Strategy : Prospecting</td>\n",
" <td>FabAlley : Indya</td>\n",
" <td>Age Range : 18-44</td>\n",
" <td>5.422265e+00</td>\n",
" <td>1.556255</td>\n",
" <td>5.529832</td>\n",
" <td>0.002792</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Prospectin...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>4</td>\n",
" <td>Image : 1bc1d582bef8ce4a664f59431a974b18</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>4.769262e+00</td>\n",
" <td>2.889459</td>\n",
" <td>6.426656</td>\n",
" <td>0.002136</td>\n",
" <td>[{'custom_tags.Image': '1bc1d582bef8ce4a664f59...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>5</td>\n",
" <td>Audience Strategy : Prospecting</td>\n",
" <td>Landing Pages : www.faballey.com/indya</td>\n",
" <td>Age Range : 20-34</td>\n",
" <td>4.341206e+00</td>\n",
" <td>2.098992</td>\n",
" <td>3.943278</td>\n",
" <td>0.002789</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Prospectin...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>8</td>\n",
" <td>Audience Strategy : Prospecting</td>\n",
" <td>FabAlley : Indya</td>\n",
" <td>Age Range : 22-38</td>\n",
" <td>3.823647e+00</td>\n",
" <td>1.130809</td>\n",
" <td>8.003912</td>\n",
" <td>0.004326</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Prospectin...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>10</td>\n",
" <td>Audience Strategy : Prospecting</td>\n",
" <td>Landing Pages : www.faballey.com/indya</td>\n",
" <td>Age Range : 20-30</td>\n",
" <td>3.687110e+00</td>\n",
" <td>1.699265</td>\n",
" <td>6.866775</td>\n",
" <td>0.002117</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Prospectin...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>12</td>\n",
" <td>Image : e715ddbac9df21eeae6546df8ce0af83</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>3.596714e+00</td>\n",
" <td>8.241338</td>\n",
" <td>4.694454</td>\n",
" <td>0.003084</td>\n",
" <td>[{'custom_tags.Image': 'e715ddbac9df21eeae6546...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>13</td>\n",
" <td>Audience Strategy : Prospecting</td>\n",
" <td>Landing Pages : www.faballey.com/indya</td>\n",
" <td>Age Range : 22-35</td>\n",
" <td>3.528863e+00</td>\n",
" <td>1.127772</td>\n",
" <td>8.179569</td>\n",
" <td>0.001900</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Prospectin...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>15</td>\n",
" <td>AdWyZe : campaigns</td>\n",
" <td>misc : AdWyzeCampaigns</td>\n",
" <td>Image : 1bc1d582bef8ce4a664f59431a974b18</td>\n",
" <td>3.419016e+00</td>\n",
" <td>2.477162</td>\n",
" <td>6.037268</td>\n",
" <td>0.001915</td>\n",
" <td>[{'custom_tags.AdWyZe': 'campaigns'}, {'custom...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>16</td>\n",
" <td>AdWyZe : Sale campaigns</td>\n",
" <td>Image : e715ddbac9df21eeae6546df8ce0af83</td>\n",
" <td>- : -</td>\n",
" <td>3.099256e+00</td>\n",
" <td>1.559732</td>\n",
" <td>7.910748</td>\n",
" <td>0.005314</td>\n",
" <td>[{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>18</td>\n",
" <td>AdWyZe : campaigns</td>\n",
" <td>misc : AdWyzeCampaigns</td>\n",
" <td>Image : e7469535eac32dc1a3a7d00596ed558c</td>\n",
" <td>1.819736e+00</td>\n",
" <td>2.112618</td>\n",
" <td>8.513110</td>\n",
" <td>0.005630</td>\n",
" <td>[{'custom_tags.AdWyZe': 'campaigns'}, {'custom...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>19</td>\n",
" <td>Age Range : 22-38</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>1.817801e+00</td>\n",
" <td>1.650880</td>\n",
" <td>8.406545</td>\n",
" <td>0.004002</td>\n",
" <td>[{'custom_tags.Age Range': '22-38'}]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>20</td>\n",
" <td>Audience Strategy : Prospecting</td>\n",
" <td>FabAlley : Indya</td>\n",
" <td>Age Range : 18-35</td>\n",
" <td>1.657500e+00</td>\n",
" <td>3.843495</td>\n",
" <td>6.009110</td>\n",
" <td>0.003140</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Prospectin...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>22</td>\n",
" <td>Interests : Education or Higher education or H...</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>1.490510e+00</td>\n",
" <td>1.396902</td>\n",
" <td>7.164214</td>\n",
" <td>0.001343</td>\n",
" <td>[{'custom_tags.Interests': 'Education or Highe...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>23</td>\n",
" <td>Ad Type : Carousel</td>\n",
" <td>FabAlley : Indya</td>\n",
" <td>Interests : CTS or Cognizant or Curvy Magazine...</td>\n",
" <td>1.378099e+00</td>\n",
" <td>1.679854</td>\n",
" <td>3.559321</td>\n",
" <td>0.002775</td>\n",
" <td>[{'custom_tags.Ad Type': 'Carousel'}, {'custom...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>28</td>\n",
" <td>Image : 7507128d21e379e8b189c753ef2fc0b9</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>1.047426e+00</td>\n",
" <td>6.940722</td>\n",
" <td>7.442603</td>\n",
" <td>0.003277</td>\n",
" <td>[{'custom_tags.Image': '7507128d21e379e8b189c7...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>29</td>\n",
" <td>Ad Type : Carousel</td>\n",
" <td>CA Daily Report : Intrest</td>\n",
" <td>- : -</td>\n",
" <td>1.045628e+00</td>\n",
" <td>3.719975</td>\n",
" <td>4.905255</td>\n",
" <td>0.002188</td>\n",
" <td>[{'custom_tags.Ad Type': 'Carousel'}, {'custom...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>32</td>\n",
" <td>Interests : CTS or Cognizant or Curvy Magazine...</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>8.646711e-01</td>\n",
" <td>2.323073</td>\n",
" <td>4.123442</td>\n",
" <td>0.002480</td>\n",
" <td>[{'custom_tags.Interests': 'CTS or Cognizant o...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>33</td>\n",
" <td>AdWyZe : Sale campaigns</td>\n",
" <td>Image : 7507128d21e379e8b189c753ef2fc0b9</td>\n",
" <td>- : -</td>\n",
" <td>8.304274e-01</td>\n",
" <td>6.072591</td>\n",
" <td>7.831636</td>\n",
" <td>0.003716</td>\n",
" <td>[{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>37</td>\n",
" <td>Sale Campaign : non-sale</td>\n",
" <td>Product Category : Indya</td>\n",
" <td>Custom Audiences : Lookalike (IN, 1%) - All Pu...</td>\n",
" <td>7.377625e-01</td>\n",
" <td>2.844118</td>\n",
" <td>5.422274</td>\n",
" <td>0.003496</td>\n",
" <td>[{'custom_tags.Sale Campaign': 'non-sale'}, {'...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>38</td>\n",
" <td>Ad Type : Carousel</td>\n",
" <td>FabAlley : Indya</td>\n",
" <td>Interests : Action movies or Animated movies o...</td>\n",
" <td>7.349946e-01</td>\n",
" <td>2.740437</td>\n",
" <td>6.054053</td>\n",
" <td>0.003279</td>\n",
" <td>[{'custom_tags.Ad Type': 'Carousel'}, {'custom...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>40</td>\n",
" <td>Age Range : 18-35</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>6.919871e-01</td>\n",
" <td>8.455855</td>\n",
" <td>7.719922</td>\n",
" <td>0.003747</td>\n",
" <td>[{'custom_tags.Age Range': '18-35'}]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>44</td>\n",
" <td>Audience Types : Interests</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>6.265166e-01</td>\n",
" <td>14.572893</td>\n",
" <td>7.117261</td>\n",
" <td>0.003412</td>\n",
" <td>[{'custom_tags.Audience Types': 'Interests'}]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>45</td>\n",
" <td>Audience Strategy : Prospecting</td>\n",
" <td>Landing Pages : www.faballey.com/clothing/tops</td>\n",
" <td>Age Range : 18-35</td>\n",
" <td>6.176336e-01</td>\n",
" <td>1.045796</td>\n",
" <td>8.158542</td>\n",
" <td>0.003406</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Prospectin...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td>47</td>\n",
" <td>Sale Campaign : non-sale</td>\n",
" <td>Product Category : Indya</td>\n",
" <td>Custom Audiences : Lookalike (IN, 1% to 2%) - ...</td>\n",
" <td>5.986324e-01</td>\n",
" <td>2.848397</td>\n",
" <td>4.334387</td>\n",
" <td>0.001329</td>\n",
" <td>[{'custom_tags.Sale Campaign': 'non-sale'}, {'...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td>48</td>\n",
" <td>Audience Strategy : Prospecting</td>\n",
" <td>Landing Pages : www.faballey.com/indya</td>\n",
" <td>Age Range : 21-44</td>\n",
" <td>5.840144e-01</td>\n",
" <td>7.246749</td>\n",
" <td>5.283740</td>\n",
" <td>0.002419</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Prospectin...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td>50</td>\n",
" <td>Landing Pages : www.faballey.com/indya</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>5.507294e-01</td>\n",
" <td>23.560192</td>\n",
" <td>6.536754</td>\n",
" <td>0.003053</td>\n",
" <td>[{'custom_tags.Landing Pages': 'www.faballey.c...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>35</th>\n",
" <td>55</td>\n",
" <td>AdWyZe : campaigns</td>\n",
" <td>misc : AdWyzeCampaigns</td>\n",
" <td>Image : e715ddbac9df21eeae6546df8ce0af83</td>\n",
" <td>5.257057e-01</td>\n",
" <td>6.681606</td>\n",
" <td>4.287529</td>\n",
" <td>0.002802</td>\n",
" <td>[{'custom_tags.AdWyZe': 'campaigns'}, {'custom...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>37</th>\n",
" <td>57</td>\n",
" <td>AdWyZe : Sale campaigns</td>\n",
" <td>Image : a2809a569c180c23d7ff073d92905d4c</td>\n",
" <td>- : -</td>\n",
" <td>4.845407e-01</td>\n",
" <td>5.734127</td>\n",
" <td>8.799243</td>\n",
" <td>0.005092</td>\n",
" <td>[{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40</th>\n",
" <td>64</td>\n",
" <td>Audience Strategy : Prospecting</td>\n",
" <td>FabAlley : Curve</td>\n",
" <td>- : -</td>\n",
" <td>4.057853e-01</td>\n",
" <td>8.158878</td>\n",
" <td>8.294510</td>\n",
" <td>0.003906</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Prospectin...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>49</th>\n",
" <td>80</td>\n",
" <td>AdWyZe : Sale campaigns</td>\n",
" <td>Landing Pages : www.faballey.com/indya</td>\n",
" <td>- : -</td>\n",
" <td>3.321612e-01</td>\n",
" <td>10.400295</td>\n",
" <td>8.470731</td>\n",
" <td>0.003983</td>\n",
" <td>[{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>51</th>\n",
" <td>86</td>\n",
" <td>Custom Audiences : Lookalike (IN, 1% to 2%) - ...</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>3.104761e-01</td>\n",
" <td>11.872287</td>\n",
" <td>7.626464</td>\n",
" <td>0.002748</td>\n",
" <td>[{'custom_tags.Custom Audiences': 'Lookalike (...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>55</th>\n",
" <td>94</td>\n",
" <td>Interests : Action movies or Animated movies o...</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>2.977350e-01</td>\n",
" <td>4.835514</td>\n",
" <td>7.312505</td>\n",
" <td>0.003301</td>\n",
" <td>[{'custom_tags.Interests': 'Action movies or A...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>57</th>\n",
" <td>97</td>\n",
" <td>Age Range : 20-30</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>2.810979e-01</td>\n",
" <td>4.059218</td>\n",
" <td>9.070683</td>\n",
" <td>0.003707</td>\n",
" <td>[{'custom_tags.Age Range': '20-30'}]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>59</th>\n",
" <td>102</td>\n",
" <td>Interests : Curvy Girl Clothing or Curvy Magaz...</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>2.757823e-01</td>\n",
" <td>1.704208</td>\n",
" <td>9.520507</td>\n",
" <td>0.005366</td>\n",
" <td>[{'custom_tags.Interests': 'Curvy Girl Clothin...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>63</th>\n",
" <td>110</td>\n",
" <td>Image : 47595dd72f8a3a57d09092906e6474cf</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>2.555915e-01</td>\n",
" <td>3.547973</td>\n",
" <td>9.186600</td>\n",
" <td>0.002487</td>\n",
" <td>[{'custom_tags.Image': '47595dd72f8a3a57d09092...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>66</th>\n",
" <td>114</td>\n",
" <td>AdWyZe : Sale campaigns</td>\n",
" <td>Landing Pages : www.faballey.com/curve</td>\n",
" <td>- : -</td>\n",
" <td>2.446256e-01</td>\n",
" <td>7.991047</td>\n",
" <td>9.158887</td>\n",
" <td>0.004704</td>\n",
" <td>[{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>82</th>\n",
" <td>155</td>\n",
" <td>Sale Campaign : non-sale</td>\n",
" <td>Lookalike Types : 1-2%</td>\n",
" <td>- : -</td>\n",
" <td>1.302416e-01</td>\n",
" <td>6.055255</td>\n",
" <td>6.189984</td>\n",
" <td>0.002321</td>\n",
" <td>[{'custom_tags.Sale Campaign': 'non-sale'}, {'...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>83</th>\n",
" <td>156</td>\n",
" <td>Daily Report : Open targeting</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>1.291378e-01</td>\n",
" <td>9.347453</td>\n",
" <td>5.775222</td>\n",
" <td>0.002913</td>\n",
" <td>[{'custom_tags.Daily Report': 'Open targeting'}]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>85</th>\n",
" <td>159</td>\n",
" <td>Sale Campaign : non-sale</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>1.148432e-01</td>\n",
" <td>40.900428</td>\n",
" <td>7.971589</td>\n",
" <td>0.004408</td>\n",
" <td>[{'custom_tags.Sale Campaign': 'non-sale'}]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>86</th>\n",
" <td>160</td>\n",
" <td>Image : a2809a569c180c23d7ff073d92905d4c</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>1.127166e-01</td>\n",
" <td>7.439093</td>\n",
" <td>9.223175</td>\n",
" <td>0.004547</td>\n",
" <td>[{'custom_tags.Image': 'a2809a569c180c23d7ff07...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>87</th>\n",
" <td>161</td>\n",
" <td>Sale Campaign : non-sale</td>\n",
" <td>Lookalike Types : 1%</td>\n",
" <td>- : -</td>\n",
" <td>1.080536e-01</td>\n",
" <td>7.684288</td>\n",
" <td>8.229148</td>\n",
" <td>0.003834</td>\n",
" <td>[{'custom_tags.Sale Campaign': 'non-sale'}, {'...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>90</th>\n",
" <td>169</td>\n",
" <td>Sale Campaign : non-sale</td>\n",
" <td>Product Category : Dresses</td>\n",
" <td>Custom Audiences : Lookalike (IN, 1% to 2%) - ...</td>\n",
" <td>9.920654e-02</td>\n",
" <td>1.136600</td>\n",
" <td>8.365456</td>\n",
" <td>0.001928</td>\n",
" <td>[{'custom_tags.Sale Campaign': 'non-sale'}, {'...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>91</th>\n",
" <td>170</td>\n",
" <td>Audience Strategy : Prospecting</td>\n",
" <td>FabAlley : Curve</td>\n",
" <td>Age Range : 18-44</td>\n",
" <td>9.859321e-02</td>\n",
" <td>2.566727</td>\n",
" <td>8.231543</td>\n",
" <td>0.003080</td>\n",
" <td>[{'custom_tags.Audience Strategy': 'Prospectin...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>93</th>\n",
" <td>173</td>\n",
" <td>Sale Campaign : non-sale</td>\n",
" <td>Product Category : Indya</td>\n",
" <td>- : -</td>\n",
" <td>9.760268e-02</td>\n",
" <td>13.159897</td>\n",
" <td>5.537575</td>\n",
" <td>0.002572</td>\n",
" <td>[{'custom_tags.Sale Campaign': 'non-sale'}, {'...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>103</th>\n",
" <td>194</td>\n",
" <td>Ad Type : Carousel</td>\n",
" <td>CA Daily Report : Open Targeting</td>\n",
" <td>- : -</td>\n",
" <td>6.021106e-02</td>\n",
" <td>7.070576</td>\n",
" <td>8.788161</td>\n",
" <td>0.004992</td>\n",
" <td>[{'custom_tags.Ad Type': 'Carousel'}, {'custom...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>108</th>\n",
" <td>207</td>\n",
" <td>Landing Pages : www.faballey.com/curve</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>5.291336e-02</td>\n",
" <td>10.798528</td>\n",
" <td>9.382976</td>\n",
" <td>0.004173</td>\n",
" <td>[{'custom_tags.Landing Pages': 'www.faballey.c...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>110</th>\n",
" <td>210</td>\n",
" <td>Audience Types : Open Targeting</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>3.958964e-02</td>\n",
" <td>9.420624</td>\n",
" <td>9.528173</td>\n",
" <td>0.005034</td>\n",
" <td>[{'custom_tags.Audience Types': 'Open Targetin...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>115</th>\n",
" <td>216</td>\n",
" <td>Audience Types : Lookalike</td>\n",
" <td>- : -</td>\n",
" <td>- : -</td>\n",
" <td>2.464193e-02</td>\n",
" <td>31.323586</td>\n",
" <td>9.260314</td>\n",
" <td>0.004001</td>\n",
" <td>[{'custom_tags.Audience Types': 'Lookalike'}]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>117</th>\n",
" <td>219</td>\n",
" <td>Sale Campaign : sale</td>\n",
" <td>Product Category : Curve</td>\n",
" <td>Custom Audiences : Lookalike (IN, 1% to 2%) - ...</td>\n",
" <td>1.755675e-02</td>\n",
" <td>2.254897</td>\n",
" <td>7.972732</td>\n",
" <td>0.003087</td>\n",
" <td>[{'custom_tags.Sale Campaign': 'sale'}, {'cust...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>120</th>\n",
" <td>229</td>\n",
" <td>Sale Campaign : non-sale</td>\n",
" <td>Lookalike Types : 1%</td>\n",
" <td>Custom Audiences : Lookalike (IN, 1%) - All Pu...</td>\n",
" <td>7.128733e-03</td>\n",
" <td>7.085810</td>\n",
" <td>8.362386</td>\n",
" <td>0.004122</td>\n",
" <td>[{'custom_tags.Sale Campaign': 'non-sale'}, {'...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>127</th>\n",
" <td>249</td>\n",
" <td>Campaign Objective : Conversions</td>\n",
" <td>Product Category : Indya</td>\n",
" <td>Daily Report : Open targeting</td>\n",
" <td>3.004299e-07</td>\n",
" <td>5.526682</td>\n",
" <td>4.959103</td>\n",
" <td>0.002507</td>\n",
" <td>[{'custom_tags.Campaign Objective': 'Conversio...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>128</th>\n",
" <td>250</td>\n",
" <td>Campaign Objective : Conversions</td>\n",
" <td>Audience Types : Interests</td>\n",
" <td>Daily Report : Open targeting</td>\n",
" <td>2.569125e-07</td>\n",
" <td>6.114036</td>\n",
" <td>5.417794</td>\n",
" <td>0.002631</td>\n",
" <td>[{'custom_tags.Campaign Objective': 'Conversio...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>138</th>\n",
" <td>266</td>\n",
" <td>Campaign Objective : Conversions</td>\n",
" <td>Audience Types : Open Targeting</td>\n",
" <td>Daily Report : Open targeting</td>\n",
" <td>6.520688e-08</td>\n",
" <td>2.634940</td>\n",
" <td>6.528782</td>\n",
" <td>0.004111</td>\n",
" <td>[{'custom_tags.Campaign Objective': 'Conversio...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>143</th>\n",
" <td>274</td>\n",
" <td>Campaign Objective : Conversions</td>\n",
" <td>Product Category : Dresses</td>\n",
" <td>Daily Report : Open targeting</td>\n",
" <td>7.466021e-09</td>\n",
" <td>1.894762</td>\n",
" <td>7.769180</td>\n",
" <td>0.005371</td>\n",
" <td>[{'custom_tags.Campaign Objective': 'Conversio...</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" index level_0 \\\n",
"0 0 AdWyZe : campaigns \n",
"1 1 Age Range : 20-34 \n",
"2 2 Audience Strategy : Prospecting \n",
"3 4 Image : 1bc1d582bef8ce4a664f59431a974b18 \n",
"4 5 Audience Strategy : Prospecting \n",
"5 8 Audience Strategy : Prospecting \n",
"6 10 Audience Strategy : Prospecting \n",
"7 12 Image : e715ddbac9df21eeae6546df8ce0af83 \n",
"8 13 Audience Strategy : Prospecting \n",
"9 15 AdWyZe : campaigns \n",
"10 16 AdWyZe : Sale campaigns \n",
"11 18 AdWyZe : campaigns \n",
"12 19 Age Range : 22-38 \n",
"13 20 Audience Strategy : Prospecting \n",
"14 22 Interests : Education or Higher education or H... \n",
"15 23 Ad Type : Carousel \n",
"17 28 Image : 7507128d21e379e8b189c753ef2fc0b9 \n",
"18 29 Ad Type : Carousel \n",
"20 32 Interests : CTS or Cognizant or Curvy Magazine... \n",
"21 33 AdWyZe : Sale campaigns \n",
"23 37 Sale Campaign : non-sale \n",
"24 38 Ad Type : Carousel \n",
"26 40 Age Range : 18-35 \n",
"28 44 Audience Types : Interests \n",
"29 45 Audience Strategy : Prospecting \n",
"30 47 Sale Campaign : non-sale \n",
"31 48 Audience Strategy : Prospecting \n",
"32 50 Landing Pages : www.faballey.com/indya \n",
"35 55 AdWyZe : campaigns \n",
"37 57 AdWyZe : Sale campaigns \n",
"40 64 Audience Strategy : Prospecting \n",
"49 80 AdWyZe : Sale campaigns \n",
"51 86 Custom Audiences : Lookalike (IN, 1% to 2%) - ... \n",
"55 94 Interests : Action movies or Animated movies o... \n",
"57 97 Age Range : 20-30 \n",
"59 102 Interests : Curvy Girl Clothing or Curvy Magaz... \n",
"63 110 Image : 47595dd72f8a3a57d09092906e6474cf \n",
"66 114 AdWyZe : Sale campaigns \n",
"82 155 Sale Campaign : non-sale \n",
"83 156 Daily Report : Open targeting \n",
"85 159 Sale Campaign : non-sale \n",
"86 160 Image : a2809a569c180c23d7ff073d92905d4c \n",
"87 161 Sale Campaign : non-sale \n",
"90 169 Sale Campaign : non-sale \n",
"91 170 Audience Strategy : Prospecting \n",
"93 173 Sale Campaign : non-sale \n",
"103 194 Ad Type : Carousel \n",
"108 207 Landing Pages : www.faballey.com/curve \n",
"110 210 Audience Types : Open Targeting \n",
"115 216 Audience Types : Lookalike \n",
"117 219 Sale Campaign : sale \n",
"120 229 Sale Campaign : non-sale \n",
"127 249 Campaign Objective : Conversions \n",
"128 250 Campaign Objective : Conversions \n",
"138 266 Campaign Objective : Conversions \n",
"143 274 Campaign Objective : Conversions \n",
"\n",
" level_1 \\\n",
"0 misc : AdWyzeCampaigns \n",
"1 - : - \n",
"2 FabAlley : Indya \n",
"3 - : - \n",
"4 Landing Pages : www.faballey.com/indya \n",
"5 FabAlley : Indya \n",
"6 Landing Pages : www.faballey.com/indya \n",
"7 - : - \n",
"8 Landing Pages : www.faballey.com/indya \n",
"9 misc : AdWyzeCampaigns \n",
"10 Image : e715ddbac9df21eeae6546df8ce0af83 \n",
"11 misc : AdWyzeCampaigns \n",
"12 - : - \n",
"13 FabAlley : Indya \n",
"14 - : - \n",
"15 FabAlley : Indya \n",
"17 - : - \n",
"18 CA Daily Report : Intrest \n",
"20 - : - \n",
"21 Image : 7507128d21e379e8b189c753ef2fc0b9 \n",
"23 Product Category : Indya \n",
"24 FabAlley : Indya \n",
"26 - : - \n",
"28 - : - \n",
"29 Landing Pages : www.faballey.com/clothing/tops \n",
"30 Product Category : Indya \n",
"31 Landing Pages : www.faballey.com/indya \n",
"32 - : - \n",
"35 misc : AdWyzeCampaigns \n",
"37 Image : a2809a569c180c23d7ff073d92905d4c \n",
"40 FabAlley : Curve \n",
"49 Landing Pages : www.faballey.com/indya \n",
"51 - : - \n",
"55 - : - \n",
"57 - : - \n",
"59 - : - \n",
"63 - : - \n",
"66 Landing Pages : www.faballey.com/curve \n",
"82 Lookalike Types : 1-2% \n",
"83 - : - \n",
"85 - : - \n",
"86 - : - \n",
"87 Lookalike Types : 1% \n",
"90 Product Category : Dresses \n",
"91 FabAlley : Curve \n",
"93 Product Category : Indya \n",
"103 CA Daily Report : Open Targeting \n",
"108 - : - \n",
"110 - : - \n",
"115 - : - \n",
"117 Product Category : Curve \n",
"120 Lookalike Types : 1% \n",
"127 Product Category : Indya \n",
"128 Audience Types : Interests \n",
"138 Audience Types : Open Targeting \n",
"143 Product Category : Dresses \n",
"\n",
" level_2 imp_factor \\\n",
"0 Image : 47595dd72f8a3a57d09092906e6474cf 6.247269e+00 \n",
"1 - : - 5.518040e+00 \n",
"2 Age Range : 18-44 5.422265e+00 \n",
"3 - : - 4.769262e+00 \n",
"4 Age Range : 20-34 4.341206e+00 \n",
"5 Age Range : 22-38 3.823647e+00 \n",
"6 Age Range : 20-30 3.687110e+00 \n",
"7 - : - 3.596714e+00 \n",
"8 Age Range : 22-35 3.528863e+00 \n",
"9 Image : 1bc1d582bef8ce4a664f59431a974b18 3.419016e+00 \n",
"10 - : - 3.099256e+00 \n",
"11 Image : e7469535eac32dc1a3a7d00596ed558c 1.819736e+00 \n",
"12 - : - 1.817801e+00 \n",
"13 Age Range : 18-35 1.657500e+00 \n",
"14 - : - 1.490510e+00 \n",
"15 Interests : CTS or Cognizant or Curvy Magazine... 1.378099e+00 \n",
"17 - : - 1.047426e+00 \n",
"18 - : - 1.045628e+00 \n",
"20 - : - 8.646711e-01 \n",
"21 - : - 8.304274e-01 \n",
"23 Custom Audiences : Lookalike (IN, 1%) - All Pu... 7.377625e-01 \n",
"24 Interests : Action movies or Animated movies o... 7.349946e-01 \n",
"26 - : - 6.919871e-01 \n",
"28 - : - 6.265166e-01 \n",
"29 Age Range : 18-35 6.176336e-01 \n",
"30 Custom Audiences : Lookalike (IN, 1% to 2%) - ... 5.986324e-01 \n",
"31 Age Range : 21-44 5.840144e-01 \n",
"32 - : - 5.507294e-01 \n",
"35 Image : e715ddbac9df21eeae6546df8ce0af83 5.257057e-01 \n",
"37 - : - 4.845407e-01 \n",
"40 - : - 4.057853e-01 \n",
"49 - : - 3.321612e-01 \n",
"51 - : - 3.104761e-01 \n",
"55 - : - 2.977350e-01 \n",
"57 - : - 2.810979e-01 \n",
"59 - : - 2.757823e-01 \n",
"63 - : - 2.555915e-01 \n",
"66 - : - 2.446256e-01 \n",
"82 - : - 1.302416e-01 \n",
"83 - : - 1.291378e-01 \n",
"85 - : - 1.148432e-01 \n",
"86 - : - 1.127166e-01 \n",
"87 - : - 1.080536e-01 \n",
"90 Custom Audiences : Lookalike (IN, 1% to 2%) - ... 9.920654e-02 \n",
"91 Age Range : 18-44 9.859321e-02 \n",
"93 - : - 9.760268e-02 \n",
"103 - : - 6.021106e-02 \n",
"108 - : - 5.291336e-02 \n",
"110 - : - 3.958964e-02 \n",
"115 - : - 2.464193e-02 \n",
"117 Custom Audiences : Lookalike (IN, 1% to 2%) - ... 1.755675e-02 \n",
"120 Custom Audiences : Lookalike (IN, 1%) - All Pu... 7.128733e-03 \n",
"127 Daily Report : Open targeting 3.004299e-07 \n",
"128 Daily Report : Open targeting 2.569125e-07 \n",
"138 Daily Report : Open targeting 6.520688e-08 \n",
"143 Daily Report : Open targeting 7.466021e-09 \n",
"\n",
" spend_prop ga_cpv ga_cvr \\\n",
"0 1.192298 7.002313 0.001026 \n",
"1 4.027281 5.424781 0.003176 \n",
"2 1.556255 5.529832 0.002792 \n",
"3 2.889459 6.426656 0.002136 \n",
"4 2.098992 3.943278 0.002789 \n",
"5 1.130809 8.003912 0.004326 \n",
"6 1.699265 6.866775 0.002117 \n",
"7 8.241338 4.694454 0.003084 \n",
"8 1.127772 8.179569 0.001900 \n",
"9 2.477162 6.037268 0.001915 \n",
"10 1.559732 7.910748 0.005314 \n",
"11 2.112618 8.513110 0.005630 \n",
"12 1.650880 8.406545 0.004002 \n",
"13 3.843495 6.009110 0.003140 \n",
"14 1.396902 7.164214 0.001343 \n",
"15 1.679854 3.559321 0.002775 \n",
"17 6.940722 7.442603 0.003277 \n",
"18 3.719975 4.905255 0.002188 \n",
"20 2.323073 4.123442 0.002480 \n",
"21 6.072591 7.831636 0.003716 \n",
"23 2.844118 5.422274 0.003496 \n",
"24 2.740437 6.054053 0.003279 \n",
"26 8.455855 7.719922 0.003747 \n",
"28 14.572893 7.117261 0.003412 \n",
"29 1.045796 8.158542 0.003406 \n",
"30 2.848397 4.334387 0.001329 \n",
"31 7.246749 5.283740 0.002419 \n",
"32 23.560192 6.536754 0.003053 \n",
"35 6.681606 4.287529 0.002802 \n",
"37 5.734127 8.799243 0.005092 \n",
"40 8.158878 8.294510 0.003906 \n",
"49 10.400295 8.470731 0.003983 \n",
"51 11.872287 7.626464 0.002748 \n",
"55 4.835514 7.312505 0.003301 \n",
"57 4.059218 9.070683 0.003707 \n",
"59 1.704208 9.520507 0.005366 \n",
"63 3.547973 9.186600 0.002487 \n",
"66 7.991047 9.158887 0.004704 \n",
"82 6.055255 6.189984 0.002321 \n",
"83 9.347453 5.775222 0.002913 \n",
"85 40.900428 7.971589 0.004408 \n",
"86 7.439093 9.223175 0.004547 \n",
"87 7.684288 8.229148 0.003834 \n",
"90 1.136600 8.365456 0.001928 \n",
"91 2.566727 8.231543 0.003080 \n",
"93 13.159897 5.537575 0.002572 \n",
"103 7.070576 8.788161 0.004992 \n",
"108 10.798528 9.382976 0.004173 \n",
"110 9.420624 9.528173 0.005034 \n",
"115 31.323586 9.260314 0.004001 \n",
"117 2.254897 7.972732 0.003087 \n",
"120 7.085810 8.362386 0.004122 \n",
"127 5.526682 4.959103 0.002507 \n",
"128 6.114036 5.417794 0.002631 \n",
"138 2.634940 6.528782 0.004111 \n",
"143 1.894762 7.769180 0.005371 \n",
"\n",
" levels \n",
"0 [{'custom_tags.AdWyZe': 'campaigns'}, {'custom... \n",
"1 [{'custom_tags.Age Range': '20-34'}] \n",
"2 [{'custom_tags.Audience Strategy': 'Prospectin... \n",
"3 [{'custom_tags.Image': '1bc1d582bef8ce4a664f59... \n",
"4 [{'custom_tags.Audience Strategy': 'Prospectin... \n",
"5 [{'custom_tags.Audience Strategy': 'Prospectin... \n",
"6 [{'custom_tags.Audience Strategy': 'Prospectin... \n",
"7 [{'custom_tags.Image': 'e715ddbac9df21eeae6546... \n",
"8 [{'custom_tags.Audience Strategy': 'Prospectin... \n",
"9 [{'custom_tags.AdWyZe': 'campaigns'}, {'custom... \n",
"10 [{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c... \n",
"11 [{'custom_tags.AdWyZe': 'campaigns'}, {'custom... \n",
"12 [{'custom_tags.Age Range': '22-38'}] \n",
"13 [{'custom_tags.Audience Strategy': 'Prospectin... \n",
"14 [{'custom_tags.Interests': 'Education or Highe... \n",
"15 [{'custom_tags.Ad Type': 'Carousel'}, {'custom... \n",
"17 [{'custom_tags.Image': '7507128d21e379e8b189c7... \n",
"18 [{'custom_tags.Ad Type': 'Carousel'}, {'custom... \n",
"20 [{'custom_tags.Interests': 'CTS or Cognizant o... \n",
"21 [{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c... \n",
"23 [{'custom_tags.Sale Campaign': 'non-sale'}, {'... \n",
"24 [{'custom_tags.Ad Type': 'Carousel'}, {'custom... \n",
"26 [{'custom_tags.Age Range': '18-35'}] \n",
"28 [{'custom_tags.Audience Types': 'Interests'}] \n",
"29 [{'custom_tags.Audience Strategy': 'Prospectin... \n",
"30 [{'custom_tags.Sale Campaign': 'non-sale'}, {'... \n",
"31 [{'custom_tags.Audience Strategy': 'Prospectin... \n",
"32 [{'custom_tags.Landing Pages': 'www.faballey.c... \n",
"35 [{'custom_tags.AdWyZe': 'campaigns'}, {'custom... \n",
"37 [{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c... \n",
"40 [{'custom_tags.Audience Strategy': 'Prospectin... \n",
"49 [{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c... \n",
"51 [{'custom_tags.Custom Audiences': 'Lookalike (... \n",
"55 [{'custom_tags.Interests': 'Action movies or A... \n",
"57 [{'custom_tags.Age Range': '20-30'}] \n",
"59 [{'custom_tags.Interests': 'Curvy Girl Clothin... \n",
"63 [{'custom_tags.Image': '47595dd72f8a3a57d09092... \n",
"66 [{'custom_tags.AdWyZe': 'Sale campaigns'}, {'c... \n",
"82 [{'custom_tags.Sale Campaign': 'non-sale'}, {'... \n",
"83 [{'custom_tags.Daily Report': 'Open targeting'}] \n",
"85 [{'custom_tags.Sale Campaign': 'non-sale'}] \n",
"86 [{'custom_tags.Image': 'a2809a569c180c23d7ff07... \n",
"87 [{'custom_tags.Sale Campaign': 'non-sale'}, {'... \n",
"90 [{'custom_tags.Sale Campaign': 'non-sale'}, {'... \n",
"91 [{'custom_tags.Audience Strategy': 'Prospectin... \n",
"93 [{'custom_tags.Sale Campaign': 'non-sale'}, {'... \n",
"103 [{'custom_tags.Ad Type': 'Carousel'}, {'custom... \n",
"108 [{'custom_tags.Landing Pages': 'www.faballey.c... \n",
"110 [{'custom_tags.Audience Types': 'Open Targetin... \n",
"115 [{'custom_tags.Audience Types': 'Lookalike'}] \n",
"117 [{'custom_tags.Sale Campaign': 'sale'}, {'cust... \n",
"120 [{'custom_tags.Sale Campaign': 'non-sale'}, {'... \n",
"127 [{'custom_tags.Campaign Objective': 'Conversio... \n",
"128 [{'custom_tags.Campaign Objective': 'Conversio... \n",
"138 [{'custom_tags.Campaign Objective': 'Conversio... \n",
"143 [{'custom_tags.Campaign Objective': 'Conversio... "
]
},
"execution_count": 11,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"dfs[3]"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"# df_1 = dfs[0]\n",
"# df_2 = dfs[1]\n",
"# df_3 = dfs[2]\n",
"# df_4 = dfs[3]\n",
"\n",
"# # Change quadrants based on property of goal metric.\n",
"# # (e.g. quadrants are exchanged for roas <-> cpt)\n",
"# # if metrics_dict[goal_metric]['diff'] == -1:\n",
"# # df_2, df_3 = df_3, df_2\n",
"# # df_4, df_1 = df_1, df_4"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"# from bokeh.charts import Scatter, output_file, show\n",
"# from bokeh.io import output_notebook, push_notebook\n",
"# from bokeh.plotting import figure, ColumnDataSource\n",
"# from bokeh.models import HoverTool\n",
"# from bokeh.models.widgets.tables import DataTable, TableColumn\n",
"# from bokeh.models import Span\n"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"# output_notebook()"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true,
"scrolled": false
},
"outputs": [],
"source": [
"# all_df = df_1.append(df_2, ignore_index=True)\n",
"# all_df = all_df.append(df_3, ignore_index=True)\n",
"# all_df = all_df.append(df_4, ignore_index=True)\n",
"\n",
"# def round_float(s):\n",
"# if s.dtype == 'float64':\n",
"# s = s.round(7)\n",
"# return s\n",
"# data = output\n",
"# input_json = args\n",
"# avg_spend_prop = float(data['spend_axis'])\n",
"\n",
"# tooltips=[\n",
"# ('lvl 0:', '@level_0'),\n",
"# ('lvl 1:', '@level_1'),\n",
"# ('lvl 2:', '@level_2'),\n",
"# ('lvl 3:', '@level_3'),\n",
"# (input_json['goal_metric'], '@'+input_json['goal_metric']),\n",
"# ('Projected % cpt change', '@Projected_change'),\n",
"# ('Spend Prop', '@spend_prop')\n",
"# ]\n",
"\n",
"# hover = HoverTool(tooltips=tooltips)\n",
"# hover1 = HoverTool(tooltips=tooltips)\n",
"\n",
"# def build_bokeh_trace(df_obj, num):\n",
"# df_obj = df_obj.copy()\n",
"# if len(df_obj):\n",
"# df_obj = df_obj.sort_values(by='imp_factor', ascending=False)\n",
"# df_plotly = df_obj.iloc[0:num].copy()\n",
"# df_plotly['idx'] = df_plotly.index\n",
"# df_plotly['size'] = df_plotly['imp_factor']\n",
"# # range r1 to r2\n",
"# r1=8\n",
"# r2=30\n",
"# min_r = df_plotly['size'].min()\n",
"# max_r = df_plotly['size'].max()\n",
"# df_plotly['size'] = ((df_plotly['size'] - min_r )*(r2-r1) / (max_r - min_r)) + r1\n",
"# df_plotly['overall'] = data['goal_axis']\n",
"# df_plotly['overall_spend_prop'] = avg_spend_prop\n",
"# else:\n",
"# return ColumnDataSource(df_obj)\n",
"\n",
"# source = ColumnDataSource(df_plotly)\n",
"# return source\n",
"\n",
"# spend_source_1 = build_bokeh_trace(df_1, 10)\n",
"# spend_source_2 = build_bokeh_trace(df_2, 10)\n",
"# spend_source_3 = build_bokeh_trace(df_3, 10)\n",
"# spend_source_4 = build_bokeh_trace(df_4, 10)\n",
"# if metrics_dict[goal_metric]['diff'] == -1:\n",
"# df_2, df_3 = df_3, df_2\n",
"# df_4, df_1 = df_1, df_4\n",
"# table_source_1 = ColumnDataSource(df_1.apply(round_float))\n",
"# table_source_2 = ColumnDataSource(df_2.apply(round_float))\n",
"# table_source_3 = ColumnDataSource(df_3.apply(round_float))\n",
"# table_source_4 = ColumnDataSource(df_4.apply(round_float))\n",
"\n",
"# columns = [\n",
"# TableColumn(field=\"level_0\", title=\"level 0\"),\n",
"# TableColumn(field=\"level_1\", title=\"level 1\"),\n",
"# TableColumn(field=\"level_2\", title=\"level 2\"),\n",
"# TableColumn(field=\"level_3\", title=\"level 3\"),\n",
"# TableColumn(field=\"other_{0}\".format(input_json['goal_metric']), title=\"Other {0}\".format(input_json['goal_metric'])),\n",
"# TableColumn(field=input_json['goal_metric'], title=input_json['goal_metric'],),\n",
"# TableColumn(field=\"spend_prop\", title=\"Spend %\"),\n",
"# TableColumn(field=\"imp_factor\", title=\"Impact factor\"),\n",
"# ]\n",
"\n",
"\n",
"# # Spend sorted.\n",
"# p1 = figure(plot_width=800, plot_height=500, tools=[hover1],\n",
"# title=\"Performance by paths.\")\n",
"# p1.xaxis.axis_label = 'Spend Proportion'\n",
"# p1.yaxis.axis_label = input_json['goal_metric']\n",
"\n",
"# if len(df_1):\n",
"# prop_plot_1 = p1.circle('spend_prop', input_json['goal_metric'], fill_color='orange', source=spend_source_1, size='size')\n",
"# if len(df_2):\n",
"# prop_plot_2 = p1.circle('spend_prop', input_json['goal_metric'], fill_color='red', source=spend_source_2, size='size')\n",
"# if len(df_3):\n",
"# prop_plot_3 = p1.circle('spend_prop', input_json['goal_metric'], fill_color='green', source=spend_source_3, size='size')\n",
"# if len(df_4):\n",
"# prop_plot_4 = p1.circle('spend_prop', input_json['goal_metric'], fill_color='blue', source=spend_source_4, size='size')\n",
"\n",
"# # overall_line = p1.line('spend_prop', 'overall', source=bad_spend_source)\n",
"# avg_spend = Span(location=avg_spend_prop, dimension='height', line_color='black', line_width=3)\n",
"# avg_cpt = Span(location=data['goal_axis'], dimension='width', line_color='black', line_width=3)\n",
"\n",
"# p1.add_layout(avg_spend)\n",
"# p1.add_layout(avg_cpt)\n",
"# # overall_spend_prop = p1.line('overall_spend_prop', goal_metric, source=bad_spend_source)\n",
"# # overall_spend_prop = p1.line('overall_spend_prop', goal_metric, source=good_spend_source)\n",
"\n",
"# prop_plot = show(p1, notebook_handle=True)\n",
"\n",
"# # Tables.\n",
"# print('Q1')\n",
"# if len(df_1):\n",
"# data_table_1 = DataTable(source=table_source_1, columns=columns, width=1000)\n",
"# table_1 = show(data_table_1, notebook_handle=True)\n",
"\n",
"# print('Q2')\n",
"# if len(df_2):\n",
"# data_table_2 = DataTable(source=table_source_2, columns=columns, width=1000)\n",
"# table_2 = show(data_table_2, notebook_handle=True)\n",
"\n",
"# print('Q3')\n",
"# if len(df_3):\n",
"# data_table_3 = DataTable(source=table_source_3, columns=columns, width=1000)\n",
"# table_3 = show(data_table_3, notebook_handle=True)\n",
"\n",
"# print('Q4')\n",
"# if len(df_4):\n",
"# data_table_4 = DataTable(source=table_source_4, columns=columns, width=1000)\n",
"# table_4 = show(data_table_4, notebook_handle=True)\n"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"# from jarvis.brain.utility.data_preparation import (get_metrics_date_range, get_channel_metrics_date_range)\n",
"\n",
"# def extract_custom_tags(df, custom_tag_column=True):\n",
"# \"\"\"Extracting custom tags as individual features.\"\"\"\n",
"# if custom_tag_column:\n",
"# df = pd.concat([df, pd.DataFrame((d for idx, d in df['custom_tags'].iteritems()))], axis=1)\n",
"# del df['custom_tags']\n",
"\n",
"# selected_columns = [col for col in df.columns\n",
"# if (type(df[col].iloc[0]) != dict or df[col][:1].iloc[0]['source'] in ['AUTO', 'USER'])]\n",
"# selected_columns.remove('Campaigns') \n",
"# selected_columns.remove('Adsets')\n",
"# selected_columns.remove('Ads') \n",
"\n",
"# df_ = df[selected_columns]\n",
"# df_ = df_.applymap(lambda x: x['name'] if (type(x) == dict and 'name' in x) else x)\n",
"# df__ = df[['Campaigns', 'Adsets', 'Ads']]\n",
"# df__=df__.applymap(lambda x: x['metadata']['name'] if (type(x) == dict and 'metadata' in x and 'name' in x['metadata']) else x)\n",
"# return df_.join(df__)\n",
"\n",
"# df = get_metrics_date_range(args['account_ids']['facebook'], 'ad', args['start_date'], args['end_date'],\n",
"# metrics + [path_pre_process.get_channel_spend()], dimensions=['custom_tags'], custom_tags=False,\n",
"# active=False, rails_api=True, page_size=4000, rename_id=False,\n",
"# filters=args['filters'], ad_channel='facebook')\n",
"\n",
"# df = extract_custom_tags(df)"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"# from colorama import Fore, Back, Style\n",
"# def path_to_dict(df1,df,good=True):\n",
"# ads=[]\n",
"# tot_imp=0\n",
"# df2=df1.copy()\n",
"# for index,row in df2.iterrows():\n",
"# key_list=[]\n",
"# value_list=()\n",
"# df_=df.copy()\n",
"# path_dict=dict()\n",
"# path_dict[index]=dict()\n",
"# for i in range(0, num_levels):\n",
"# if(row['level_' +str(i)] != '- : -'):\n",
"# level = row['level_' + str(i)]\n",
"# level = level.split(':')\n",
"# key = level[0]\n",
"# key=key.strip()\n",
"# level = level[1]\n",
"# level = level.strip()\n",
"# path_dict[index][key]=level\n",
"# for key, value in path_dict[index].items():\n",
"# key_list.append(key)\n",
"# value_list=value_list+(value ,)\n",
"# df_=df_[df_[key]==value]\n",
"# df_ = df_.applymap(lambda x: round(x,6) if type(x)==np.float64 else x)\n",
"# total_spend = df_.fb_spend.sum()\n",
"# total_spend=round(total_spend,5)\n",
"# total_num = df_[metrics_dict[goal_metric]['numerator']].sum()\n",
"# total_num =round(total_num,5)\n",
"# total_deno = df_[metrics_dict[goal_metric]['denominator']].sum()\n",
"# total_deno = round(total_deno,5)\n",
"# try:\n",
"# goal_metric_path=total_num/total_deno\n",
"# goal_metric_path=round(goal_metric_path,5)\n",
"# except:\n",
"# goal_metric_path=0\n",
"# df_=df_.groupby(['Campaigns','Adsets','Ads'],as_index=False).agg(aggregations)\n",
"# df_=df_.sort('fb_spend',ascending=False)\n",
"# df_=df_.reset_index(drop=True)\n",
"# df_[goal_metric+' : \\n'+str(goal_metric_path)]=round(df_[metrics_dict[goal_metric]['numerator']]/df_[metrics_dict[goal_metric]['denominator']],5)\n",
"# df_.replace([pd.np.inf, -pd.np.inf], 0, inplace=True)\n",
"# # df_=df_.rename(columns = {metrics_dict[goal_metric]['numerator']:column_names['numerator']+' : \\n'+str(total_num),metrics_dict[goal_metric]['denominator']:column_names['denominator']+' : \\n'+str(total_deno)})\n",
"# # df_=df_.drop(['index'], axis = 1, inplace = True)\n",
"# print('Path :'+str(index))\n",
"# print(\"---------\")\n",
"# path_df=df2.loc[[index]]\n",
" \n",
"# str_path = Fore.BLUE + path_df['level_0'][index] +'\\n'+ path_df['level_1'][index] + '\\n'+path_df['level_2'][index] #+'\\n'+ path_df['level_3'][index]\n",
"# str_path=str_path.replace('- : -','')\n",
"# str_path=str_path.strip()\n",
"# print(str_path)\n",
"# print('\\n')\n",
"# print('Spend Proportion here is '+ str(round(row['spend_prop'],5))+' %')\n",
" \n",
"# if good:\n",
"# bg_color='lightgreen'\n",
"# else:\n",
"# bg_color='pink'\n",
"# df_=df_.style.set_table_styles(\n",
"# [{'selector': 'th',\n",
"# 'props': [('background-color', bg_color)]}] )\n",
"# display(df_)"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": [
"column_names=metrics_dict[goal_metric]"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true,
"scrolled": false
},
"outputs": [],
"source": [
"path_to_dict(df_1,df)"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true,
"scrolled": false
},
"outputs": [],
"source": [
"path_to_dict(df_2,df)"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true,
"scrolled": false
},
"outputs": [],
"source": [
"path_to_dict(df_3,df,False)"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true,
"scrolled": false
},
"outputs": [],
"source": [
"path_to_dict(df_4,df,False)"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": []
}
],
"metadata": {
"anaconda-cloud": {},
"kernelspec": {
"display_name": "Python [jarvis1]",
"language": "python",
"name": "Python [jarvis1]"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.5.2"
}
},
"nbformat": 4,
"nbformat_minor": 1
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment