Ad_report.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Start Date</th>\n",
       "      <th>End Date</th>\n",
       "      <th>Campaign Name</th>\n",
       "      <th>Ad Group Name</th>\n",
       "      <th>Targeting</th>\n",
       "      <th>Match Type</th>\n",
       "      <th>Customer Search Term</th>\n",
       "      <th>Impressions</th>\n",
       "      <th>Clicks</th>\n",
       "      <th>Click-Thru Rate (CTR)</th>\n",
       "      <th>Cost Per Click (CPC)</th>\n",
       "      <th>7 Day Total Sales</th>\n",
       "      <th>Spend</th>\n",
       "      <th>Total Advertising Cost of Sales (ACoS)</th>\n",
       "      <th>Total Return on Advertising Spend (RoAS)</th>\n",
       "      <th>Number of Days</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>29-May-21</td>\n",
       "      <td>29-May-21</td>\n",
       "      <td>Rainforest - Manual</td>\n",
       "      <td>Broad Ad Group</td>\n",
       "      <td>bamboo kids plates</td>\n",
       "      <td>BROAD</td>\n",
       "      <td>bamboo kids plate set</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>50.00%</td>\n",
       "      <td>1.15</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>31-May-21</td>\n",
       "      <td>9-Jun-21</td>\n",
       "      <td>Rainforest - Manual</td>\n",
       "      <td>Broad Ad Group</td>\n",
       "      <td>bamboo kids plates</td>\n",
       "      <td>BROAD</td>\n",
       "      <td>bamboo kids plates and bowl sets</td>\n",
       "      <td>222</td>\n",
       "      <td>10</td>\n",
       "      <td>4.50%</td>\n",
       "      <td>1.50</td>\n",
       "      <td>49.98</td>\n",
       "      <td>15.01</td>\n",
       "      <td>30.03%</td>\n",
       "      <td>3.33</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>26-May-21</td>\n",
       "      <td>26-May-21</td>\n",
       "      <td>Rainforest - Manual</td>\n",
       "      <td>Broad Ad Group</td>\n",
       "      <td>bamboo kids plates</td>\n",
       "      <td>BROAD</td>\n",
       "      <td>bamboo plate set kids</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>14.29%</td>\n",
       "      <td>2.47</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2.47</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>29-May-21</td>\n",
       "      <td>29-May-21</td>\n",
       "      <td>Rainforest - Manual</td>\n",
       "      <td>Broad Ad Group</td>\n",
       "      <td>bamboo kids plates</td>\n",
       "      <td>BROAD</td>\n",
       "      <td>grow forward kids bamboo plates and bowl sets</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>12.50%</td>\n",
       "      <td>1.98</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.98</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>11-Jun-21</td>\n",
       "      <td>11-Jun-21</td>\n",
       "      <td>Rainforest - Manual</td>\n",
       "      <td>Broad Ad Group</td>\n",
       "      <td>bamboo kids plates</td>\n",
       "      <td>BROAD</td>\n",
       "      <td>kids 10 inch dinner plate bamboo</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>100.00%</td>\n",
       "      <td>1.61</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.61</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Start Date   End Date        Campaign Name   Ad Group Name  \\\n",
       "0  29-May-21  29-May-21  Rainforest - Manual  Broad Ad Group   \n",
       "1  31-May-21   9-Jun-21  Rainforest - Manual  Broad Ad Group   \n",
       "2  26-May-21  26-May-21  Rainforest - Manual  Broad Ad Group   \n",
       "3  29-May-21  29-May-21  Rainforest - Manual  Broad Ad Group   \n",
       "4  11-Jun-21  11-Jun-21  Rainforest - Manual  Broad Ad Group   \n",
       "\n",
       "            Targeting Match Type  \\\n",
       "0  bamboo kids plates      BROAD   \n",
       "1  bamboo kids plates      BROAD   \n",
       "2  bamboo kids plates      BROAD   \n",
       "3  bamboo kids plates      BROAD   \n",
       "4  bamboo kids plates      BROAD   \n",
       "\n",
       "                            Customer Search Term  Impressions  Clicks  \\\n",
       "0                          bamboo kids plate set            2       1   \n",
       "1               bamboo kids plates and bowl sets          222      10   \n",
       "2                          bamboo plate set kids            7       1   \n",
       "3  grow forward kids bamboo plates and bowl sets            8       1   \n",
       "4               kids 10 inch dinner plate bamboo            1       1   \n",
       "\n",
       "  Click-Thru Rate (CTR)  Cost Per Click (CPC)  7 Day Total Sales   Spend  \\\n",
       "0                50.00%                  1.15                0.00   1.15   \n",
       "1                 4.50%                  1.50               49.98  15.01   \n",
       "2                14.29%                  2.47                0.00   2.47   \n",
       "3                12.50%                  1.98                0.00   1.98   \n",
       "4               100.00%                  1.61                0.00   1.61   \n",
       "\n",
       "  Total Advertising Cost of Sales (ACoS)   \\\n",
       "0                                     NaN   \n",
       "1                                  30.03%   \n",
       "2                                     NaN   \n",
       "3                                     NaN   \n",
       "4                                     NaN   \n",
       "\n",
       "   Total Return on Advertising Spend (RoAS)  Number of Days  \n",
       "0                                      0.00               0  \n",
       "1                                      3.33               9  \n",
       "2                                      0.00               0  \n",
       "3                                      0.00               0  \n",
       "4                                      0.00               0  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"data/search_cleaned.csv\")\n",
    "df.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.loc[df['Campaign Name'].str.contains('Rainforest'), 'Campaign Name'] = \"Rainforest\"\n",
    "df.loc[df['Campaign Name'].str.contains('Floral'), 'Campaign Name'] = \"Floral\"\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Key'] = df['Customer Search Term'] + ' ' + df['Campaign Name']+ ' ' + df['Ad Group Name']+ ' ' + df['Targeting']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Short Key'] = df['Customer Search Term'] + ' ' + df['Campaign Name']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Number of Days'].replace({0: 1}, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Start Date', 'End Date', 'Campaign Name', 'Ad Group Name', 'Targeting',\n",
       "       'Match Type', 'Customer Search Term', 'Impressions', 'Clicks',\n",
       "       'Click-Thru Rate (CTR)', 'Cost Per Click (CPC)', '7 Day Total Sales ',\n",
       "       'Spend', 'Total Advertising Cost of Sales (ACoS) ',\n",
       "       'Total Return on Advertising Spend (RoAS)', 'Number of Days', 'Key',\n",
       "       'Short Key'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Start Date</th>\n",
       "      <th>End Date</th>\n",
       "      <th>Campaign Name</th>\n",
       "      <th>Ad Group Name</th>\n",
       "      <th>Targeting</th>\n",
       "      <th>Match Type</th>\n",
       "      <th>Customer Search Term</th>\n",
       "      <th>Impressions</th>\n",
       "      <th>Clicks</th>\n",
       "      <th>Click-Thru Rate (CTR)</th>\n",
       "      <th>Cost Per Click (CPC)</th>\n",
       "      <th>7 Day Total Sales</th>\n",
       "      <th>Spend</th>\n",
       "      <th>Total Advertising Cost of Sales (ACoS)</th>\n",
       "      <th>Total Return on Advertising Spend (RoAS)</th>\n",
       "      <th>Number of Days</th>\n",
       "      <th>Key</th>\n",
       "      <th>Short Key</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>29-May-21</td>\n",
       "      <td>29-May-21</td>\n",
       "      <td>Rainforest</td>\n",
       "      <td>Broad Ad Group</td>\n",
       "      <td>bamboo kids plates</td>\n",
       "      <td>BROAD</td>\n",
       "      <td>bamboo kids plate set</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>50.00%</td>\n",
       "      <td>1.15</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1</td>\n",
       "      <td>bamboo kids plate set Rainforest Broad Ad Grou...</td>\n",
       "      <td>bamboo kids plate set Rainforest</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>31-May-21</td>\n",
       "      <td>9-Jun-21</td>\n",
       "      <td>Rainforest</td>\n",
       "      <td>Broad Ad Group</td>\n",
       "      <td>bamboo kids plates</td>\n",
       "      <td>BROAD</td>\n",
       "      <td>bamboo kids plates and bowl sets</td>\n",
       "      <td>222</td>\n",
       "      <td>10</td>\n",
       "      <td>4.50%</td>\n",
       "      <td>1.50</td>\n",
       "      <td>49.98</td>\n",
       "      <td>15.01</td>\n",
       "      <td>30.03%</td>\n",
       "      <td>3.33</td>\n",
       "      <td>9</td>\n",
       "      <td>bamboo kids plates and bowl sets Rainforest Br...</td>\n",
       "      <td>bamboo kids plates and bowl sets Rainforest</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>26-May-21</td>\n",
       "      <td>26-May-21</td>\n",
       "      <td>Rainforest</td>\n",
       "      <td>Broad Ad Group</td>\n",
       "      <td>bamboo kids plates</td>\n",
       "      <td>BROAD</td>\n",
       "      <td>bamboo plate set kids</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>14.29%</td>\n",
       "      <td>2.47</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2.47</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1</td>\n",
       "      <td>bamboo plate set kids Rainforest Broad Ad Grou...</td>\n",
       "      <td>bamboo plate set kids Rainforest</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>29-May-21</td>\n",
       "      <td>29-May-21</td>\n",
       "      <td>Rainforest</td>\n",
       "      <td>Broad Ad Group</td>\n",
       "      <td>bamboo kids plates</td>\n",
       "      <td>BROAD</td>\n",
       "      <td>grow forward kids bamboo plates and bowl sets</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>12.50%</td>\n",
       "      <td>1.98</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.98</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1</td>\n",
       "      <td>grow forward kids bamboo plates and bowl sets ...</td>\n",
       "      <td>grow forward kids bamboo plates and bowl sets ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>11-Jun-21</td>\n",
       "      <td>11-Jun-21</td>\n",
       "      <td>Rainforest</td>\n",
       "      <td>Broad Ad Group</td>\n",
       "      <td>bamboo kids plates</td>\n",
       "      <td>BROAD</td>\n",
       "      <td>kids 10 inch dinner plate bamboo</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>100.00%</td>\n",
       "      <td>1.61</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.61</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1</td>\n",
       "      <td>kids 10 inch dinner plate bamboo Rainforest Br...</td>\n",
       "      <td>kids 10 inch dinner plate bamboo Rainforest</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>561</th>\n",
       "      <td>19-Jun-21</td>\n",
       "      <td>19-Jun-21</td>\n",
       "      <td>Floral</td>\n",
       "      <td>Ultimate</td>\n",
       "      <td>*</td>\n",
       "      <td>0</td>\n",
       "      <td>b08njz1xy9</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>100.00%</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1</td>\n",
       "      <td>b08njz1xy9 Floral Ultimate *</td>\n",
       "      <td>b08njz1xy9 Floral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>562</th>\n",
       "      <td>3-Jun-21</td>\n",
       "      <td>3-Jun-21</td>\n",
       "      <td>Floral</td>\n",
       "      <td>Ultimate</td>\n",
       "      <td>*</td>\n",
       "      <td>0</td>\n",
       "      <td>b08x653v74</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>100.00%</td>\n",
       "      <td>0.15</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1</td>\n",
       "      <td>b08x653v74 Floral Ultimate *</td>\n",
       "      <td>b08x653v74 Floral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>563</th>\n",
       "      <td>30-May-21</td>\n",
       "      <td>15-Jun-21</td>\n",
       "      <td>Floral</td>\n",
       "      <td>Ultimate</td>\n",
       "      <td>*</td>\n",
       "      <td>0</td>\n",
       "      <td>grow forward</td>\n",
       "      <td>21</td>\n",
       "      <td>5</td>\n",
       "      <td>23.81%</td>\n",
       "      <td>0.12</td>\n",
       "      <td>24.99</td>\n",
       "      <td>0.62</td>\n",
       "      <td>2.48%</td>\n",
       "      <td>40.31</td>\n",
       "      <td>16</td>\n",
       "      <td>grow forward Floral Ultimate *</td>\n",
       "      <td>grow forward Floral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>564</th>\n",
       "      <td>3-Jun-21</td>\n",
       "      <td>3-Jun-21</td>\n",
       "      <td>Floral</td>\n",
       "      <td>Ultimate</td>\n",
       "      <td>*</td>\n",
       "      <td>0</td>\n",
       "      <td>grow+forward</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>100.00%</td>\n",
       "      <td>0.24</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1</td>\n",
       "      <td>grow+forward Floral Ultimate *</td>\n",
       "      <td>grow+forward Floral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>565</th>\n",
       "      <td>9-Jun-21</td>\n",
       "      <td>9-Jun-21</td>\n",
       "      <td>Floral</td>\n",
       "      <td>Ultimate</td>\n",
       "      <td>*</td>\n",
       "      <td>0</td>\n",
       "      <td>wheat straw dinnerware sets</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>100.00%</td>\n",
       "      <td>0.06</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1</td>\n",
       "      <td>wheat straw dinnerware sets Floral Ultimate *</td>\n",
       "      <td>wheat straw dinnerware sets Floral</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>566 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Start Date   End Date Campaign Name   Ad Group Name           Targeting  \\\n",
       "0    29-May-21  29-May-21    Rainforest  Broad Ad Group  bamboo kids plates   \n",
       "1    31-May-21   9-Jun-21    Rainforest  Broad Ad Group  bamboo kids plates   \n",
       "2    26-May-21  26-May-21    Rainforest  Broad Ad Group  bamboo kids plates   \n",
       "3    29-May-21  29-May-21    Rainforest  Broad Ad Group  bamboo kids plates   \n",
       "4    11-Jun-21  11-Jun-21    Rainforest  Broad Ad Group  bamboo kids plates   \n",
       "..         ...        ...           ...             ...                 ...   \n",
       "561  19-Jun-21  19-Jun-21        Floral        Ultimate                   *   \n",
       "562   3-Jun-21   3-Jun-21        Floral        Ultimate                   *   \n",
       "563  30-May-21  15-Jun-21        Floral        Ultimate                   *   \n",
       "564   3-Jun-21   3-Jun-21        Floral        Ultimate                   *   \n",
       "565   9-Jun-21   9-Jun-21        Floral        Ultimate                   *   \n",
       "\n",
       "    Match Type                           Customer Search Term  Impressions  \\\n",
       "0        BROAD                          bamboo kids plate set            2   \n",
       "1        BROAD               bamboo kids plates and bowl sets          222   \n",
       "2        BROAD                          bamboo plate set kids            7   \n",
       "3        BROAD  grow forward kids bamboo plates and bowl sets            8   \n",
       "4        BROAD               kids 10 inch dinner plate bamboo            1   \n",
       "..         ...                                            ...          ...   \n",
       "561          0                                     b08njz1xy9            1   \n",
       "562          0                                     b08x653v74            1   \n",
       "563          0                                   grow forward           21   \n",
       "564          0                                   grow+forward            1   \n",
       "565          0                    wheat straw dinnerware sets            1   \n",
       "\n",
       "     Clicks Click-Thru Rate (CTR)  Cost Per Click (CPC)  7 Day Total Sales   \\\n",
       "0         1                50.00%                  1.15                0.00   \n",
       "1        10                 4.50%                  1.50               49.98   \n",
       "2         1                14.29%                  2.47                0.00   \n",
       "3         1                12.50%                  1.98                0.00   \n",
       "4         1               100.00%                  1.61                0.00   \n",
       "..      ...                   ...                   ...                 ...   \n",
       "561       1               100.00%                  0.04                0.00   \n",
       "562       1               100.00%                  0.15                0.00   \n",
       "563       5                23.81%                  0.12               24.99   \n",
       "564       1               100.00%                  0.24                0.00   \n",
       "565       1               100.00%                  0.06                0.00   \n",
       "\n",
       "     Spend Total Advertising Cost of Sales (ACoS)   \\\n",
       "0     1.15                                     NaN   \n",
       "1    15.01                                  30.03%   \n",
       "2     2.47                                     NaN   \n",
       "3     1.98                                     NaN   \n",
       "4     1.61                                     NaN   \n",
       "..     ...                                     ...   \n",
       "561   0.04                                     NaN   \n",
       "562   0.15                                     NaN   \n",
       "563   0.62                                   2.48%   \n",
       "564   0.24                                     NaN   \n",
       "565   0.06                                     NaN   \n",
       "\n",
       "     Total Return on Advertising Spend (RoAS)  Number of Days  \\\n",
       "0                                        0.00               1   \n",
       "1                                        3.33               9   \n",
       "2                                        0.00               1   \n",
       "3                                        0.00               1   \n",
       "4                                        0.00               1   \n",
       "..                                        ...             ...   \n",
       "561                                      0.00               1   \n",
       "562                                      0.00               1   \n",
       "563                                     40.31              16   \n",
       "564                                      0.00               1   \n",
       "565                                      0.00               1   \n",
       "\n",
       "                                                   Key  \\\n",
       "0    bamboo kids plate set Rainforest Broad Ad Grou...   \n",
       "1    bamboo kids plates and bowl sets Rainforest Br...   \n",
       "2    bamboo plate set kids Rainforest Broad Ad Grou...   \n",
       "3    grow forward kids bamboo plates and bowl sets ...   \n",
       "4    kids 10 inch dinner plate bamboo Rainforest Br...   \n",
       "..                                                 ...   \n",
       "561                       b08njz1xy9 Floral Ultimate *   \n",
       "562                       b08x653v74 Floral Ultimate *   \n",
       "563                     grow forward Floral Ultimate *   \n",
       "564                     grow+forward Floral Ultimate *   \n",
       "565      wheat straw dinnerware sets Floral Ultimate *   \n",
       "\n",
       "                                             Short Key  \n",
       "0                     bamboo kids plate set Rainforest  \n",
       "1          bamboo kids plates and bowl sets Rainforest  \n",
       "2                     bamboo plate set kids Rainforest  \n",
       "3    grow forward kids bamboo plates and bowl sets ...  \n",
       "4          kids 10 inch dinner plate bamboo Rainforest  \n",
       "..                                                 ...  \n",
       "561                                  b08njz1xy9 Floral  \n",
       "562                                  b08x653v74 Floral  \n",
       "563                                grow forward Floral  \n",
       "564                                grow+forward Floral  \n",
       "565                 wheat straw dinnerware sets Floral  \n",
       "\n",
       "[566 rows x 18 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.replace('-', 0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Start Date</th>\n",
       "      <th>End Date</th>\n",
       "      <th>Campaign Name</th>\n",
       "      <th>Ad Group Name</th>\n",
       "      <th>Targeting</th>\n",
       "      <th>Match Type</th>\n",
       "      <th>Customer Search Term</th>\n",
       "      <th>Impressions</th>\n",
       "      <th>Clicks</th>\n",
       "      <th>Click-Thru Rate (CTR)</th>\n",
       "      <th>...</th>\n",
       "      <th>7 Day Total Sales</th>\n",
       "      <th>Spend</th>\n",
       "      <th>Total Advertising Cost of Sales (ACoS)</th>\n",
       "      <th>Total Return on Advertising Spend (RoAS)</th>\n",
       "      <th>Number of Days</th>\n",
       "      <th>Key</th>\n",
       "      <th>Short Key</th>\n",
       "      <th>Impressions Per Day</th>\n",
       "      <th>Spend Per Day</th>\n",
       "      <th>Sales Per Day</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>29-May-21</td>\n",
       "      <td>29-May-21</td>\n",
       "      <td>Rainforest</td>\n",
       "      <td>Broad Ad Group</td>\n",
       "      <td>bamboo kids plates</td>\n",
       "      <td>BROAD</td>\n",
       "      <td>bamboo kids plate set</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>50.00%</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1</td>\n",
       "      <td>bamboo kids plate set Rainforest Broad Ad Grou...</td>\n",
       "      <td>bamboo kids plate set Rainforest</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>1.150000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>31-May-21</td>\n",
       "      <td>9-Jun-21</td>\n",
       "      <td>Rainforest</td>\n",
       "      <td>Broad Ad Group</td>\n",
       "      <td>bamboo kids plates</td>\n",
       "      <td>BROAD</td>\n",
       "      <td>bamboo kids plates and bowl sets</td>\n",
       "      <td>222</td>\n",
       "      <td>10</td>\n",
       "      <td>4.50%</td>\n",
       "      <td>...</td>\n",
       "      <td>49.98</td>\n",
       "      <td>15.01</td>\n",
       "      <td>30.03%</td>\n",
       "      <td>3.33</td>\n",
       "      <td>9</td>\n",
       "      <td>bamboo kids plates and bowl sets Rainforest Br...</td>\n",
       "      <td>bamboo kids plates and bowl sets Rainforest</td>\n",
       "      <td>24.666667</td>\n",
       "      <td>1.667778</td>\n",
       "      <td>5.553333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>26-May-21</td>\n",
       "      <td>26-May-21</td>\n",
       "      <td>Rainforest</td>\n",
       "      <td>Broad Ad Group</td>\n",
       "      <td>bamboo kids plates</td>\n",
       "      <td>BROAD</td>\n",
       "      <td>bamboo plate set kids</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>14.29%</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2.47</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1</td>\n",
       "      <td>bamboo plate set kids Rainforest Broad Ad Grou...</td>\n",
       "      <td>bamboo plate set kids Rainforest</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>2.470000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>29-May-21</td>\n",
       "      <td>29-May-21</td>\n",
       "      <td>Rainforest</td>\n",
       "      <td>Broad Ad Group</td>\n",
       "      <td>bamboo kids plates</td>\n",
       "      <td>BROAD</td>\n",
       "      <td>grow forward kids bamboo plates and bowl sets</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>12.50%</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.98</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1</td>\n",
       "      <td>grow forward kids bamboo plates and bowl sets ...</td>\n",
       "      <td>grow forward kids bamboo plates and bowl sets ...</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>1.980000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>11-Jun-21</td>\n",
       "      <td>11-Jun-21</td>\n",
       "      <td>Rainforest</td>\n",
       "      <td>Broad Ad Group</td>\n",
       "      <td>bamboo kids plates</td>\n",
       "      <td>BROAD</td>\n",
       "      <td>kids 10 inch dinner plate bamboo</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>100.00%</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.61</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1</td>\n",
       "      <td>kids 10 inch dinner plate bamboo Rainforest Br...</td>\n",
       "      <td>kids 10 inch dinner plate bamboo Rainforest</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.610000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>561</th>\n",
       "      <td>19-Jun-21</td>\n",
       "      <td>19-Jun-21</td>\n",
       "      <td>Floral</td>\n",
       "      <td>Ultimate</td>\n",
       "      <td>*</td>\n",
       "      <td>-</td>\n",
       "      <td>b08njz1xy9</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>100.00%</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1</td>\n",
       "      <td>b08njz1xy9 Floral Ultimate *</td>\n",
       "      <td>b08njz1xy9 Floral</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.040000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>562</th>\n",
       "      <td>3-Jun-21</td>\n",
       "      <td>3-Jun-21</td>\n",
       "      <td>Floral</td>\n",
       "      <td>Ultimate</td>\n",
       "      <td>*</td>\n",
       "      <td>-</td>\n",
       "      <td>b08x653v74</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>100.00%</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1</td>\n",
       "      <td>b08x653v74 Floral Ultimate *</td>\n",
       "      <td>b08x653v74 Floral</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.150000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>563</th>\n",
       "      <td>30-May-21</td>\n",
       "      <td>15-Jun-21</td>\n",
       "      <td>Floral</td>\n",
       "      <td>Ultimate</td>\n",
       "      <td>*</td>\n",
       "      <td>-</td>\n",
       "      <td>grow forward</td>\n",
       "      <td>21</td>\n",
       "      <td>5</td>\n",
       "      <td>23.81%</td>\n",
       "      <td>...</td>\n",
       "      <td>24.99</td>\n",
       "      <td>0.62</td>\n",
       "      <td>2.48%</td>\n",
       "      <td>40.31</td>\n",
       "      <td>16</td>\n",
       "      <td>grow forward Floral Ultimate *</td>\n",
       "      <td>grow forward Floral</td>\n",
       "      <td>1.312500</td>\n",
       "      <td>0.038750</td>\n",
       "      <td>1.561875</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>564</th>\n",
       "      <td>3-Jun-21</td>\n",
       "      <td>3-Jun-21</td>\n",
       "      <td>Floral</td>\n",
       "      <td>Ultimate</td>\n",
       "      <td>*</td>\n",
       "      <td>-</td>\n",
       "      <td>grow+forward</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>100.00%</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1</td>\n",
       "      <td>grow+forward Floral Ultimate *</td>\n",
       "      <td>grow+forward Floral</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.240000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>565</th>\n",
       "      <td>9-Jun-21</td>\n",
       "      <td>9-Jun-21</td>\n",
       "      <td>Floral</td>\n",
       "      <td>Ultimate</td>\n",
       "      <td>*</td>\n",
       "      <td>-</td>\n",
       "      <td>wheat straw dinnerware sets</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>100.00%</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1</td>\n",
       "      <td>wheat straw dinnerware sets Floral Ultimate *</td>\n",
       "      <td>wheat straw dinnerware sets Floral</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.060000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>566 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Start Date   End Date Campaign Name   Ad Group Name           Targeting  \\\n",
       "0    29-May-21  29-May-21    Rainforest  Broad Ad Group  bamboo kids plates   \n",
       "1    31-May-21   9-Jun-21    Rainforest  Broad Ad Group  bamboo kids plates   \n",
       "2    26-May-21  26-May-21    Rainforest  Broad Ad Group  bamboo kids plates   \n",
       "3    29-May-21  29-May-21    Rainforest  Broad Ad Group  bamboo kids plates   \n",
       "4    11-Jun-21  11-Jun-21    Rainforest  Broad Ad Group  bamboo kids plates   \n",
       "..         ...        ...           ...             ...                 ...   \n",
       "561  19-Jun-21  19-Jun-21        Floral        Ultimate                   *   \n",
       "562   3-Jun-21   3-Jun-21        Floral        Ultimate                   *   \n",
       "563  30-May-21  15-Jun-21        Floral        Ultimate                   *   \n",
       "564   3-Jun-21   3-Jun-21        Floral        Ultimate                   *   \n",
       "565   9-Jun-21   9-Jun-21        Floral        Ultimate                   *   \n",
       "\n",
       "    Match Type                           Customer Search Term  Impressions  \\\n",
       "0        BROAD                          bamboo kids plate set            2   \n",
       "1        BROAD               bamboo kids plates and bowl sets          222   \n",
       "2        BROAD                          bamboo plate set kids            7   \n",
       "3        BROAD  grow forward kids bamboo plates and bowl sets            8   \n",
       "4        BROAD               kids 10 inch dinner plate bamboo            1   \n",
       "..         ...                                            ...          ...   \n",
       "561          -                                     b08njz1xy9            1   \n",
       "562          -                                     b08x653v74            1   \n",
       "563          -                                   grow forward           21   \n",
       "564          -                                   grow+forward            1   \n",
       "565          -                    wheat straw dinnerware sets            1   \n",
       "\n",
       "     Clicks Click-Thru Rate (CTR)  ...  7 Day Total Sales   Spend  \\\n",
       "0         1                50.00%  ...                0.00   1.15   \n",
       "1        10                 4.50%  ...               49.98  15.01   \n",
       "2         1                14.29%  ...                0.00   2.47   \n",
       "3         1                12.50%  ...                0.00   1.98   \n",
       "4         1               100.00%  ...                0.00   1.61   \n",
       "..      ...                   ...  ...                 ...    ...   \n",
       "561       1               100.00%  ...                0.00   0.04   \n",
       "562       1               100.00%  ...                0.00   0.15   \n",
       "563       5                23.81%  ...               24.99   0.62   \n",
       "564       1               100.00%  ...                0.00   0.24   \n",
       "565       1               100.00%  ...                0.00   0.06   \n",
       "\n",
       "     Total Advertising Cost of Sales (ACoS)   \\\n",
       "0                                        NaN   \n",
       "1                                     30.03%   \n",
       "2                                        NaN   \n",
       "3                                        NaN   \n",
       "4                                        NaN   \n",
       "..                                       ...   \n",
       "561                                      NaN   \n",
       "562                                      NaN   \n",
       "563                                    2.48%   \n",
       "564                                      NaN   \n",
       "565                                      NaN   \n",
       "\n",
       "    Total Return on Advertising Spend (RoAS)  Number of Days  \\\n",
       "0                                       0.00               1   \n",
       "1                                       3.33               9   \n",
       "2                                       0.00               1   \n",
       "3                                       0.00               1   \n",
       "4                                       0.00               1   \n",
       "..                                       ...             ...   \n",
       "561                                     0.00               1   \n",
       "562                                     0.00               1   \n",
       "563                                    40.31              16   \n",
       "564                                     0.00               1   \n",
       "565                                     0.00               1   \n",
       "\n",
       "                                                   Key  \\\n",
       "0    bamboo kids plate set Rainforest Broad Ad Grou...   \n",
       "1    bamboo kids plates and bowl sets Rainforest Br...   \n",
       "2    bamboo plate set kids Rainforest Broad Ad Grou...   \n",
       "3    grow forward kids bamboo plates and bowl sets ...   \n",
       "4    kids 10 inch dinner plate bamboo Rainforest Br...   \n",
       "..                                                 ...   \n",
       "561                       b08njz1xy9 Floral Ultimate *   \n",
       "562                       b08x653v74 Floral Ultimate *   \n",
       "563                     grow forward Floral Ultimate *   \n",
       "564                     grow+forward Floral Ultimate *   \n",
       "565      wheat straw dinnerware sets Floral Ultimate *   \n",
       "\n",
       "                                             Short Key Impressions Per Day  \\\n",
       "0                     bamboo kids plate set Rainforest            2.000000   \n",
       "1          bamboo kids plates and bowl sets Rainforest           24.666667   \n",
       "2                     bamboo plate set kids Rainforest            7.000000   \n",
       "3    grow forward kids bamboo plates and bowl sets ...            8.000000   \n",
       "4          kids 10 inch dinner plate bamboo Rainforest            1.000000   \n",
       "..                                                 ...                 ...   \n",
       "561                                  b08njz1xy9 Floral            1.000000   \n",
       "562                                  b08x653v74 Floral            1.000000   \n",
       "563                                grow forward Floral            1.312500   \n",
       "564                                grow+forward Floral            1.000000   \n",
       "565                 wheat straw dinnerware sets Floral            1.000000   \n",
       "\n",
       "     Spend Per Day  Sales Per Day  \n",
       "0         1.150000       0.000000  \n",
       "1         1.667778       5.553333  \n",
       "2         2.470000       0.000000  \n",
       "3         1.980000       0.000000  \n",
       "4         1.610000       0.000000  \n",
       "..             ...            ...  \n",
       "561       0.040000       0.000000  \n",
       "562       0.150000       0.000000  \n",
       "563       0.038750       1.561875  \n",
       "564       0.240000       0.000000  \n",
       "565       0.060000       0.000000  \n",
       "\n",
       "[566 rows x 21 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Impressions Per Day'] = df['Impressions']/df['Number of Days']\n",
    "df['Spend Per Day'] = df['Spend']/df['Number of Days']\n",
    "df['Sales Per Day'] = df['7 Day Total Sales ']/df['Number of Days']\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "sort_df = df.sort_values(by='Sales Per Day', ascending=False).head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Start Date</th>\n",
       "      <th>End Date</th>\n",
       "      <th>Campaign Name</th>\n",
       "      <th>Ad Group Name</th>\n",
       "      <th>Targeting</th>\n",
       "      <th>Match Type</th>\n",
       "      <th>Customer Search Term</th>\n",
       "      <th>Impressions</th>\n",
       "      <th>Clicks</th>\n",
       "      <th>Click-Thru Rate (CTR)</th>\n",
       "      <th>...</th>\n",
       "      <th>7 Day Total Sales</th>\n",
       "      <th>Spend</th>\n",
       "      <th>Total Advertising Cost of Sales (ACoS)</th>\n",
       "      <th>Total Return on Advertising Spend (RoAS)</th>\n",
       "      <th>Number of Days</th>\n",
       "      <th>Key</th>\n",
       "      <th>Short Key</th>\n",
       "      <th>Impressions Per Day</th>\n",
       "      <th>Spend Per Day</th>\n",
       "      <th>Sales Per Day</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>400</th>\n",
       "      <td>1-Jun-21</td>\n",
       "      <td>1-Jun-21</td>\n",
       "      <td>Floral</td>\n",
       "      <td>Broad Ad Group</td>\n",
       "      <td>kids plates</td>\n",
       "      <td>BROAD</td>\n",
       "      <td>kids dinner plates eco</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>50.00%</td>\n",
       "      <td>...</td>\n",
       "      <td>74.97</td>\n",
       "      <td>0.91</td>\n",
       "      <td>1.21%</td>\n",
       "      <td>82.38</td>\n",
       "      <td>1</td>\n",
       "      <td>kids dinner plates eco Floral Broad Ad Group k...</td>\n",
       "      <td>kids dinner plates eco Floral</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>0.910000</td>\n",
       "      <td>74.970000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>265</th>\n",
       "      <td>25-May-21</td>\n",
       "      <td>12-Jun-21</td>\n",
       "      <td>Rainforest</td>\n",
       "      <td>Exact Ad Group</td>\n",
       "      <td>bamboo plates for kids</td>\n",
       "      <td>EXACT</td>\n",
       "      <td>bamboo plates for kids</td>\n",
       "      <td>12864</td>\n",
       "      <td>188</td>\n",
       "      <td>1.46%</td>\n",
       "      <td>...</td>\n",
       "      <td>1234.51</td>\n",
       "      <td>252.10</td>\n",
       "      <td>20.42%</td>\n",
       "      <td>4.90</td>\n",
       "      <td>18</td>\n",
       "      <td>bamboo plates for kids Rainforest Exact Ad Gro...</td>\n",
       "      <td>bamboo plates for kids Rainforest</td>\n",
       "      <td>714.666667</td>\n",
       "      <td>14.005556</td>\n",
       "      <td>68.583889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>275</th>\n",
       "      <td>25-May-21</td>\n",
       "      <td>12-Jun-21</td>\n",
       "      <td>Rainforest</td>\n",
       "      <td>Exact Ad Group</td>\n",
       "      <td>kids plates</td>\n",
       "      <td>EXACT</td>\n",
       "      <td>kids plates</td>\n",
       "      <td>16269</td>\n",
       "      <td>211</td>\n",
       "      <td>1.30%</td>\n",
       "      <td>...</td>\n",
       "      <td>1074.57</td>\n",
       "      <td>463.94</td>\n",
       "      <td>43.17%</td>\n",
       "      <td>2.32</td>\n",
       "      <td>18</td>\n",
       "      <td>kids plates Rainforest Exact Ad Group kids plates</td>\n",
       "      <td>kids plates Rainforest</td>\n",
       "      <td>903.833333</td>\n",
       "      <td>25.774444</td>\n",
       "      <td>59.698333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>352</th>\n",
       "      <td>25-May-21</td>\n",
       "      <td>19-Jun-21</td>\n",
       "      <td>Floral</td>\n",
       "      <td>Exact Ad Group</td>\n",
       "      <td>bamboo plates for kids</td>\n",
       "      <td>EXACT</td>\n",
       "      <td>bamboo plates for kids</td>\n",
       "      <td>22006</td>\n",
       "      <td>160</td>\n",
       "      <td>0.73%</td>\n",
       "      <td>...</td>\n",
       "      <td>1314.48</td>\n",
       "      <td>221.29</td>\n",
       "      <td>16.83%</td>\n",
       "      <td>5.94</td>\n",
       "      <td>25</td>\n",
       "      <td>bamboo plates for kids Floral Exact Ad Group b...</td>\n",
       "      <td>bamboo plates for kids Floral</td>\n",
       "      <td>880.240000</td>\n",
       "      <td>8.851600</td>\n",
       "      <td>52.579200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>462</th>\n",
       "      <td>13-Jun-21</td>\n",
       "      <td>14-Jun-21</td>\n",
       "      <td>Floral</td>\n",
       "      <td>Broad Ad Group</td>\n",
       "      <td>plates for toddlers</td>\n",
       "      <td>BROAD</td>\n",
       "      <td>dishwasher safe toddler plates</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>50.00%</td>\n",
       "      <td>...</td>\n",
       "      <td>49.98</td>\n",
       "      <td>2.38</td>\n",
       "      <td>4.76%</td>\n",
       "      <td>21.00</td>\n",
       "      <td>1</td>\n",
       "      <td>dishwasher safe toddler plates Floral Broad Ad...</td>\n",
       "      <td>dishwasher safe toddler plates Floral</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>2.380000</td>\n",
       "      <td>49.980000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>435</th>\n",
       "      <td>14-Jun-21</td>\n",
       "      <td>14-Jun-21</td>\n",
       "      <td>Floral</td>\n",
       "      <td>Broad Ad Group</td>\n",
       "      <td>kids bowls</td>\n",
       "      <td>BROAD</td>\n",
       "      <td>kids stackable bowls</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>33.33%</td>\n",
       "      <td>...</td>\n",
       "      <td>49.98</td>\n",
       "      <td>1.38</td>\n",
       "      <td>2.76%</td>\n",
       "      <td>36.22</td>\n",
       "      <td>1</td>\n",
       "      <td>kids stackable bowls Floral Broad Ad Group kid...</td>\n",
       "      <td>kids stackable bowls Floral</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>1.380000</td>\n",
       "      <td>49.980000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>547</th>\n",
       "      <td>1-Jun-21</td>\n",
       "      <td>3-Jun-21</td>\n",
       "      <td>Rainforest</td>\n",
       "      <td>Ultimate</td>\n",
       "      <td>*</td>\n",
       "      <td>-</td>\n",
       "      <td>grow forward</td>\n",
       "      <td>64</td>\n",
       "      <td>6</td>\n",
       "      <td>9.38%</td>\n",
       "      <td>...</td>\n",
       "      <td>99.96</td>\n",
       "      <td>0.74</td>\n",
       "      <td>0.74%</td>\n",
       "      <td>135.08</td>\n",
       "      <td>2</td>\n",
       "      <td>grow forward Rainforest Ultimate *</td>\n",
       "      <td>grow forward Rainforest</td>\n",
       "      <td>32.000000</td>\n",
       "      <td>0.370000</td>\n",
       "      <td>49.980000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>304</th>\n",
       "      <td>18-Jun-21</td>\n",
       "      <td>18-Jun-21</td>\n",
       "      <td>Floral</td>\n",
       "      <td>ASIN</td>\n",
       "      <td>asin=\"B07K2MXK18\"</td>\n",
       "      <td>-</td>\n",
       "      <td>b07k2mxk18</td>\n",
       "      <td>66</td>\n",
       "      <td>1</td>\n",
       "      <td>1.52%</td>\n",
       "      <td>...</td>\n",
       "      <td>49.98</td>\n",
       "      <td>0.93</td>\n",
       "      <td>1.86%</td>\n",
       "      <td>53.74</td>\n",
       "      <td>1</td>\n",
       "      <td>b07k2mxk18 Floral ASIN asin=\"B07K2MXK18\"</td>\n",
       "      <td>b07k2mxk18 Floral</td>\n",
       "      <td>66.000000</td>\n",
       "      <td>0.930000</td>\n",
       "      <td>49.980000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>206</th>\n",
       "      <td>26-May-21</td>\n",
       "      <td>12-Jun-21</td>\n",
       "      <td>Rainforest</td>\n",
       "      <td>ASIN</td>\n",
       "      <td>asin=\"B07KYXRLSN\"</td>\n",
       "      <td>-</td>\n",
       "      <td>b07kyxrlsn</td>\n",
       "      <td>17258</td>\n",
       "      <td>219</td>\n",
       "      <td>1.27%</td>\n",
       "      <td>...</td>\n",
       "      <td>624.75</td>\n",
       "      <td>235.82</td>\n",
       "      <td>37.75%</td>\n",
       "      <td>2.65</td>\n",
       "      <td>17</td>\n",
       "      <td>b07kyxrlsn Rainforest ASIN asin=\"B07KYXRLSN\"</td>\n",
       "      <td>b07kyxrlsn Rainforest</td>\n",
       "      <td>1015.176471</td>\n",
       "      <td>13.871765</td>\n",
       "      <td>36.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>362</th>\n",
       "      <td>25-May-21</td>\n",
       "      <td>19-Jun-21</td>\n",
       "      <td>Floral</td>\n",
       "      <td>Exact Ad Group</td>\n",
       "      <td>kids plates</td>\n",
       "      <td>EXACT</td>\n",
       "      <td>kids plates</td>\n",
       "      <td>18524</td>\n",
       "      <td>208</td>\n",
       "      <td>1.12%</td>\n",
       "      <td>...</td>\n",
       "      <td>874.65</td>\n",
       "      <td>433.96</td>\n",
       "      <td>49.62%</td>\n",
       "      <td>2.02</td>\n",
       "      <td>25</td>\n",
       "      <td>kids plates Floral Exact Ad Group kids plates</td>\n",
       "      <td>kids plates Floral</td>\n",
       "      <td>740.960000</td>\n",
       "      <td>17.358400</td>\n",
       "      <td>34.986000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Start Date   End Date Campaign Name   Ad Group Name  \\\n",
       "400   1-Jun-21   1-Jun-21        Floral  Broad Ad Group   \n",
       "265  25-May-21  12-Jun-21    Rainforest  Exact Ad Group   \n",
       "275  25-May-21  12-Jun-21    Rainforest  Exact Ad Group   \n",
       "352  25-May-21  19-Jun-21        Floral  Exact Ad Group   \n",
       "462  13-Jun-21  14-Jun-21        Floral  Broad Ad Group   \n",
       "435  14-Jun-21  14-Jun-21        Floral  Broad Ad Group   \n",
       "547   1-Jun-21   3-Jun-21    Rainforest        Ultimate   \n",
       "304  18-Jun-21  18-Jun-21        Floral            ASIN   \n",
       "206  26-May-21  12-Jun-21    Rainforest            ASIN   \n",
       "362  25-May-21  19-Jun-21        Floral  Exact Ad Group   \n",
       "\n",
       "                  Targeting Match Type            Customer Search Term  \\\n",
       "400             kids plates      BROAD          kids dinner plates eco   \n",
       "265  bamboo plates for kids      EXACT          bamboo plates for kids   \n",
       "275             kids plates      EXACT                     kids plates   \n",
       "352  bamboo plates for kids      EXACT          bamboo plates for kids   \n",
       "462     plates for toddlers      BROAD  dishwasher safe toddler plates   \n",
       "435              kids bowls      BROAD            kids stackable bowls   \n",
       "547                       *          -                    grow forward   \n",
       "304       asin=\"B07K2MXK18\"          -                      b07k2mxk18   \n",
       "206       asin=\"B07KYXRLSN\"          -                      b07kyxrlsn   \n",
       "362             kids plates      EXACT                     kids plates   \n",
       "\n",
       "     Impressions  Clicks Click-Thru Rate (CTR)  ...  7 Day Total Sales   \\\n",
       "400            2       1                50.00%  ...               74.97   \n",
       "265        12864     188                 1.46%  ...             1234.51   \n",
       "275        16269     211                 1.30%  ...             1074.57   \n",
       "352        22006     160                 0.73%  ...             1314.48   \n",
       "462            4       2                50.00%  ...               49.98   \n",
       "435            3       1                33.33%  ...               49.98   \n",
       "547           64       6                 9.38%  ...               99.96   \n",
       "304           66       1                 1.52%  ...               49.98   \n",
       "206        17258     219                 1.27%  ...              624.75   \n",
       "362        18524     208                 1.12%  ...              874.65   \n",
       "\n",
       "      Spend  Total Advertising Cost of Sales (ACoS)   \\\n",
       "400    0.91                                    1.21%   \n",
       "265  252.10                                   20.42%   \n",
       "275  463.94                                   43.17%   \n",
       "352  221.29                                   16.83%   \n",
       "462    2.38                                    4.76%   \n",
       "435    1.38                                    2.76%   \n",
       "547    0.74                                    0.74%   \n",
       "304    0.93                                    1.86%   \n",
       "206  235.82                                   37.75%   \n",
       "362  433.96                                   49.62%   \n",
       "\n",
       "    Total Return on Advertising Spend (RoAS)  Number of Days  \\\n",
       "400                                    82.38               1   \n",
       "265                                     4.90              18   \n",
       "275                                     2.32              18   \n",
       "352                                     5.94              25   \n",
       "462                                    21.00               1   \n",
       "435                                    36.22               1   \n",
       "547                                   135.08               2   \n",
       "304                                    53.74               1   \n",
       "206                                     2.65              17   \n",
       "362                                     2.02              25   \n",
       "\n",
       "                                                   Key  \\\n",
       "400  kids dinner plates eco Floral Broad Ad Group k...   \n",
       "265  bamboo plates for kids Rainforest Exact Ad Gro...   \n",
       "275  kids plates Rainforest Exact Ad Group kids plates   \n",
       "352  bamboo plates for kids Floral Exact Ad Group b...   \n",
       "462  dishwasher safe toddler plates Floral Broad Ad...   \n",
       "435  kids stackable bowls Floral Broad Ad Group kid...   \n",
       "547                 grow forward Rainforest Ultimate *   \n",
       "304           b07k2mxk18 Floral ASIN asin=\"B07K2MXK18\"   \n",
       "206       b07kyxrlsn Rainforest ASIN asin=\"B07KYXRLSN\"   \n",
       "362      kids plates Floral Exact Ad Group kids plates   \n",
       "\n",
       "                                 Short Key Impressions Per Day  Spend Per Day  \\\n",
       "400          kids dinner plates eco Floral            2.000000       0.910000   \n",
       "265      bamboo plates for kids Rainforest          714.666667      14.005556   \n",
       "275                 kids plates Rainforest          903.833333      25.774444   \n",
       "352          bamboo plates for kids Floral          880.240000       8.851600   \n",
       "462  dishwasher safe toddler plates Floral            4.000000       2.380000   \n",
       "435            kids stackable bowls Floral            3.000000       1.380000   \n",
       "547                grow forward Rainforest           32.000000       0.370000   \n",
       "304                      b07k2mxk18 Floral           66.000000       0.930000   \n",
       "206                  b07kyxrlsn Rainforest         1015.176471      13.871765   \n",
       "362                     kids plates Floral          740.960000      17.358400   \n",
       "\n",
       "     Sales Per Day  \n",
       "400      74.970000  \n",
       "265      68.583889  \n",
       "275      59.698333  \n",
       "352      52.579200  \n",
       "462      49.980000  \n",
       "435      49.980000  \n",
       "547      49.980000  \n",
       "304      49.980000  \n",
       "206      36.750000  \n",
       "362      34.986000  \n",
       "\n",
       "[10 rows x 21 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sort_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Total Advertising Cost of Sales (ACoS) '] = df['Total Advertising Cost of Sales (ACoS) '].fillna(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Start Date</th>\n",
       "      <th>End Date</th>\n",
       "      <th>Campaign Name</th>\n",
       "      <th>Ad Group Name</th>\n",
       "      <th>Targeting</th>\n",
       "      <th>Match Type</th>\n",
       "      <th>Customer Search Term</th>\n",
       "      <th>Impressions</th>\n",
       "      <th>Clicks</th>\n",
       "      <th>Click-Thru Rate (CTR)</th>\n",
       "      <th>...</th>\n",
       "      <th>7 Day Total Sales</th>\n",
       "      <th>Spend</th>\n",
       "      <th>Total Advertising Cost of Sales (ACoS)</th>\n",
       "      <th>Total Return on Advertising Spend (RoAS)</th>\n",
       "      <th>Number of Days</th>\n",
       "      <th>Key</th>\n",
       "      <th>Short Key</th>\n",
       "      <th>Impressions Per Day</th>\n",
       "      <th>Spend Per Day</th>\n",
       "      <th>Sales Per Day</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>29-May-21</td>\n",
       "      <td>29-May-21</td>\n",
       "      <td>Rainforest</td>\n",
       "      <td>Broad Ad Group</td>\n",
       "      <td>bamboo kids plates</td>\n",
       "      <td>BROAD</td>\n",
       "      <td>bamboo kids plate set</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>50.00%</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.15</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>bamboo kids plate set Rainforest Broad Ad Grou...</td>\n",
       "      <td>bamboo kids plate set Rainforest</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.15</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>26-May-21</td>\n",
       "      <td>26-May-21</td>\n",
       "      <td>Rainforest</td>\n",
       "      <td>Broad Ad Group</td>\n",
       "      <td>bamboo kids plates</td>\n",
       "      <td>BROAD</td>\n",
       "      <td>bamboo plate set kids</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>14.29%</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.47</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>bamboo plate set kids Rainforest Broad Ad Grou...</td>\n",
       "      <td>bamboo plate set kids Rainforest</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.47</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>29-May-21</td>\n",
       "      <td>29-May-21</td>\n",
       "      <td>Rainforest</td>\n",
       "      <td>Broad Ad Group</td>\n",
       "      <td>bamboo kids plates</td>\n",
       "      <td>BROAD</td>\n",
       "      <td>grow forward kids bamboo plates and bowl sets</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>12.50%</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.98</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>grow forward kids bamboo plates and bowl sets ...</td>\n",
       "      <td>grow forward kids bamboo plates and bowl sets ...</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.98</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>11-Jun-21</td>\n",
       "      <td>11-Jun-21</td>\n",
       "      <td>Rainforest</td>\n",
       "      <td>Broad Ad Group</td>\n",
       "      <td>bamboo kids plates</td>\n",
       "      <td>BROAD</td>\n",
       "      <td>kids 10 inch dinner plate bamboo</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>100.00%</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.61</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>kids 10 inch dinner plate bamboo Rainforest Br...</td>\n",
       "      <td>kids 10 inch dinner plate bamboo Rainforest</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.61</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5-Jun-21</td>\n",
       "      <td>5-Jun-21</td>\n",
       "      <td>Rainforest</td>\n",
       "      <td>Broad Ad Group</td>\n",
       "      <td>bamboo kids plates</td>\n",
       "      <td>BROAD</td>\n",
       "      <td>kids bamboo plates and bowl sets</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>20.00%</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.78</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>kids bamboo plates and bowl sets Rainforest Br...</td>\n",
       "      <td>kids bamboo plates and bowl sets Rainforest</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.78</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>560</th>\n",
       "      <td>16-Jun-21</td>\n",
       "      <td>16-Jun-21</td>\n",
       "      <td>Floral</td>\n",
       "      <td>Ultimate</td>\n",
       "      <td>*</td>\n",
       "      <td>-</td>\n",
       "      <td>b08gp3b6hb</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>100.00%</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.07</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>b08gp3b6hb Floral Ultimate *</td>\n",
       "      <td>b08gp3b6hb Floral</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.07</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>561</th>\n",
       "      <td>19-Jun-21</td>\n",
       "      <td>19-Jun-21</td>\n",
       "      <td>Floral</td>\n",
       "      <td>Ultimate</td>\n",
       "      <td>*</td>\n",
       "      <td>-</td>\n",
       "      <td>b08njz1xy9</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>100.00%</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>b08njz1xy9 Floral Ultimate *</td>\n",
       "      <td>b08njz1xy9 Floral</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>562</th>\n",
       "      <td>3-Jun-21</td>\n",
       "      <td>3-Jun-21</td>\n",
       "      <td>Floral</td>\n",
       "      <td>Ultimate</td>\n",
       "      <td>*</td>\n",
       "      <td>-</td>\n",
       "      <td>b08x653v74</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>100.00%</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.15</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>b08x653v74 Floral Ultimate *</td>\n",
       "      <td>b08x653v74 Floral</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.15</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>564</th>\n",
       "      <td>3-Jun-21</td>\n",
       "      <td>3-Jun-21</td>\n",
       "      <td>Floral</td>\n",
       "      <td>Ultimate</td>\n",
       "      <td>*</td>\n",
       "      <td>-</td>\n",
       "      <td>grow+forward</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>100.00%</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.24</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>grow+forward Floral Ultimate *</td>\n",
       "      <td>grow+forward Floral</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.24</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>565</th>\n",
       "      <td>9-Jun-21</td>\n",
       "      <td>9-Jun-21</td>\n",
       "      <td>Floral</td>\n",
       "      <td>Ultimate</td>\n",
       "      <td>*</td>\n",
       "      <td>-</td>\n",
       "      <td>wheat straw dinnerware sets</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>100.00%</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.06</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>wheat straw dinnerware sets Floral Ultimate *</td>\n",
       "      <td>wheat straw dinnerware sets Floral</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.06</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>403 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Start Date   End Date Campaign Name   Ad Group Name           Targeting  \\\n",
       "0    29-May-21  29-May-21    Rainforest  Broad Ad Group  bamboo kids plates   \n",
       "2    26-May-21  26-May-21    Rainforest  Broad Ad Group  bamboo kids plates   \n",
       "3    29-May-21  29-May-21    Rainforest  Broad Ad Group  bamboo kids plates   \n",
       "4    11-Jun-21  11-Jun-21    Rainforest  Broad Ad Group  bamboo kids plates   \n",
       "5     5-Jun-21   5-Jun-21    Rainforest  Broad Ad Group  bamboo kids plates   \n",
       "..         ...        ...           ...             ...                 ...   \n",
       "560  16-Jun-21  16-Jun-21        Floral        Ultimate                   *   \n",
       "561  19-Jun-21  19-Jun-21        Floral        Ultimate                   *   \n",
       "562   3-Jun-21   3-Jun-21        Floral        Ultimate                   *   \n",
       "564   3-Jun-21   3-Jun-21        Floral        Ultimate                   *   \n",
       "565   9-Jun-21   9-Jun-21        Floral        Ultimate                   *   \n",
       "\n",
       "    Match Type                           Customer Search Term  Impressions  \\\n",
       "0        BROAD                          bamboo kids plate set            2   \n",
       "2        BROAD                          bamboo plate set kids            7   \n",
       "3        BROAD  grow forward kids bamboo plates and bowl sets            8   \n",
       "4        BROAD               kids 10 inch dinner plate bamboo            1   \n",
       "5        BROAD               kids bamboo plates and bowl sets            5   \n",
       "..         ...                                            ...          ...   \n",
       "560          -                                     b08gp3b6hb            1   \n",
       "561          -                                     b08njz1xy9            1   \n",
       "562          -                                     b08x653v74            1   \n",
       "564          -                                   grow+forward            1   \n",
       "565          -                    wheat straw dinnerware sets            1   \n",
       "\n",
       "     Clicks Click-Thru Rate (CTR)  ...  7 Day Total Sales   Spend  \\\n",
       "0         1                50.00%  ...                 0.0   1.15   \n",
       "2         1                14.29%  ...                 0.0   2.47   \n",
       "3         1                12.50%  ...                 0.0   1.98   \n",
       "4         1               100.00%  ...                 0.0   1.61   \n",
       "5         1                20.00%  ...                 0.0   1.78   \n",
       "..      ...                   ...  ...                 ...    ...   \n",
       "560       1               100.00%  ...                 0.0   0.07   \n",
       "561       1               100.00%  ...                 0.0   0.04   \n",
       "562       1               100.00%  ...                 0.0   0.15   \n",
       "564       1               100.00%  ...                 0.0   0.24   \n",
       "565       1               100.00%  ...                 0.0   0.06   \n",
       "\n",
       "     Total Advertising Cost of Sales (ACoS)   \\\n",
       "0                                          0   \n",
       "2                                          0   \n",
       "3                                          0   \n",
       "4                                          0   \n",
       "5                                          0   \n",
       "..                                       ...   \n",
       "560                                        0   \n",
       "561                                        0   \n",
       "562                                        0   \n",
       "564                                        0   \n",
       "565                                        0   \n",
       "\n",
       "    Total Return on Advertising Spend (RoAS)  Number of Days  \\\n",
       "0                                        0.0               1   \n",
       "2                                        0.0               1   \n",
       "3                                        0.0               1   \n",
       "4                                        0.0               1   \n",
       "5                                        0.0               1   \n",
       "..                                       ...             ...   \n",
       "560                                      0.0               1   \n",
       "561                                      0.0               1   \n",
       "562                                      0.0               1   \n",
       "564                                      0.0               1   \n",
       "565                                      0.0               1   \n",
       "\n",
       "                                                   Key  \\\n",
       "0    bamboo kids plate set Rainforest Broad Ad Grou...   \n",
       "2    bamboo plate set kids Rainforest Broad Ad Grou...   \n",
       "3    grow forward kids bamboo plates and bowl sets ...   \n",
       "4    kids 10 inch dinner plate bamboo Rainforest Br...   \n",
       "5    kids bamboo plates and bowl sets Rainforest Br...   \n",
       "..                                                 ...   \n",
       "560                       b08gp3b6hb Floral Ultimate *   \n",
       "561                       b08njz1xy9 Floral Ultimate *   \n",
       "562                       b08x653v74 Floral Ultimate *   \n",
       "564                     grow+forward Floral Ultimate *   \n",
       "565      wheat straw dinnerware sets Floral Ultimate *   \n",
       "\n",
       "                                             Short Key Impressions Per Day  \\\n",
       "0                     bamboo kids plate set Rainforest                 2.0   \n",
       "2                     bamboo plate set kids Rainforest                 7.0   \n",
       "3    grow forward kids bamboo plates and bowl sets ...                 8.0   \n",
       "4          kids 10 inch dinner plate bamboo Rainforest                 1.0   \n",
       "5          kids bamboo plates and bowl sets Rainforest                 5.0   \n",
       "..                                                 ...                 ...   \n",
       "560                                  b08gp3b6hb Floral                 1.0   \n",
       "561                                  b08njz1xy9 Floral                 1.0   \n",
       "562                                  b08x653v74 Floral                 1.0   \n",
       "564                                grow+forward Floral                 1.0   \n",
       "565                 wheat straw dinnerware sets Floral                 1.0   \n",
       "\n",
       "     Spend Per Day  Sales Per Day  \n",
       "0             1.15            0.0  \n",
       "2             2.47            0.0  \n",
       "3             1.98            0.0  \n",
       "4             1.61            0.0  \n",
       "5             1.78            0.0  \n",
       "..             ...            ...  \n",
       "560           0.07            0.0  \n",
       "561           0.04            0.0  \n",
       "562           0.15            0.0  \n",
       "564           0.24            0.0  \n",
       "565           0.06            0.0  \n",
       "\n",
       "[403 rows x 21 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Top search terms to reasess\n",
    "Zero = df.loc[df['Total Advertising Cost of Sales (ACoS) '] == 0]\n",
    "Zero"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Start Date</th>\n",
       "      <th>End Date</th>\n",
       "      <th>Campaign Name</th>\n",
       "      <th>Ad Group Name</th>\n",
       "      <th>Targeting</th>\n",
       "      <th>Match Type</th>\n",
       "      <th>Customer Search Term</th>\n",
       "      <th>Impressions</th>\n",
       "      <th>Clicks</th>\n",
       "      <th>Click-Thru Rate (CTR)</th>\n",
       "      <th>...</th>\n",
       "      <th>7 Day Total Sales</th>\n",
       "      <th>Spend</th>\n",
       "      <th>Total Advertising Cost of Sales (ACoS)</th>\n",
       "      <th>Total Return on Advertising Spend (RoAS)</th>\n",
       "      <th>Number of Days</th>\n",
       "      <th>Key</th>\n",
       "      <th>Short Key</th>\n",
       "      <th>Impressions Per Day</th>\n",
       "      <th>Spend Per Day</th>\n",
       "      <th>Sales Per Day</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>376</th>\n",
       "      <td>26-May-21</td>\n",
       "      <td>19-Jun-21</td>\n",
       "      <td>Floral</td>\n",
       "      <td>Exact Ad Group</td>\n",
       "      <td>bamboo toddler plates</td>\n",
       "      <td>EXACT</td>\n",
       "      <td>bamboo toddler plates</td>\n",
       "      <td>757</td>\n",
       "      <td>33</td>\n",
       "      <td>4.36%</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>70.82</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24</td>\n",
       "      <td>bamboo toddler plates Floral Exact Ad Group ba...</td>\n",
       "      <td>bamboo toddler plates Floral</td>\n",
       "      <td>31.541667</td>\n",
       "      <td>2.950833</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>328</th>\n",
       "      <td>5-Jun-21</td>\n",
       "      <td>19-Jun-21</td>\n",
       "      <td>Floral</td>\n",
       "      <td>ASIN</td>\n",
       "      <td>asin=\"B08F2PR7JS\"</td>\n",
       "      <td>-</td>\n",
       "      <td>b08f2pr7js</td>\n",
       "      <td>5157</td>\n",
       "      <td>40</td>\n",
       "      <td>0.78%</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.31</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14</td>\n",
       "      <td>b08f2pr7js Floral ASIN asin=\"B08F2PR7JS\"</td>\n",
       "      <td>b08f2pr7js Floral</td>\n",
       "      <td>368.357143</td>\n",
       "      <td>2.165000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357</th>\n",
       "      <td>27-May-21</td>\n",
       "      <td>17-Jun-21</td>\n",
       "      <td>Floral</td>\n",
       "      <td>Exact Ad Group</td>\n",
       "      <td>plates for kids</td>\n",
       "      <td>EXACT</td>\n",
       "      <td>plates for kids</td>\n",
       "      <td>713</td>\n",
       "      <td>17</td>\n",
       "      <td>2.38%</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>29.47</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>21</td>\n",
       "      <td>plates for kids Floral Exact Ad Group plates f...</td>\n",
       "      <td>plates for kids Floral</td>\n",
       "      <td>33.952381</td>\n",
       "      <td>1.403333</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270</th>\n",
       "      <td>25-May-21</td>\n",
       "      <td>12-Jun-21</td>\n",
       "      <td>Rainforest</td>\n",
       "      <td>Exact Ad Group</td>\n",
       "      <td>plates for kids</td>\n",
       "      <td>EXACT</td>\n",
       "      <td>plates for kids</td>\n",
       "      <td>664</td>\n",
       "      <td>15</td>\n",
       "      <td>2.26%</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>27.42</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18</td>\n",
       "      <td>plates for kids Rainforest Exact Ad Group plat...</td>\n",
       "      <td>plates for kids Rainforest</td>\n",
       "      <td>36.888889</td>\n",
       "      <td>1.523333</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>342</th>\n",
       "      <td>25-May-21</td>\n",
       "      <td>16-Jun-21</td>\n",
       "      <td>Floral</td>\n",
       "      <td>ASIN</td>\n",
       "      <td>asin=\"B07KYWP2MT\"</td>\n",
       "      <td>-</td>\n",
       "      <td>b07kywp2mt</td>\n",
       "      <td>3552</td>\n",
       "      <td>24</td>\n",
       "      <td>0.68%</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>23.48</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>22</td>\n",
       "      <td>b07kywp2mt Floral ASIN asin=\"B07KYWP2MT\"</td>\n",
       "      <td>b07kywp2mt Floral</td>\n",
       "      <td>161.454545</td>\n",
       "      <td>1.067273</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314</th>\n",
       "      <td>27-May-21</td>\n",
       "      <td>17-Jun-21</td>\n",
       "      <td>Floral</td>\n",
       "      <td>ASIN</td>\n",
       "      <td>asin=\"B01MG7OE9X\"</td>\n",
       "      <td>-</td>\n",
       "      <td>b01mg7oe9x</td>\n",
       "      <td>2136</td>\n",
       "      <td>28</td>\n",
       "      <td>1.31%</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>23.08</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>21</td>\n",
       "      <td>b01mg7oe9x Floral ASIN asin=\"B01MG7OE9X\"</td>\n",
       "      <td>b01mg7oe9x Floral</td>\n",
       "      <td>101.714286</td>\n",
       "      <td>1.099048</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>257</th>\n",
       "      <td>26-May-21</td>\n",
       "      <td>12-Jun-21</td>\n",
       "      <td>Rainforest</td>\n",
       "      <td>ASIN</td>\n",
       "      <td>asin=\"B07DD9WBZW\"</td>\n",
       "      <td>-</td>\n",
       "      <td>b07dd9wbzw</td>\n",
       "      <td>1011</td>\n",
       "      <td>18</td>\n",
       "      <td>1.78%</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20.19</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17</td>\n",
       "      <td>b07dd9wbzw Rainforest ASIN asin=\"B07DD9WBZW\"</td>\n",
       "      <td>b07dd9wbzw Rainforest</td>\n",
       "      <td>59.470588</td>\n",
       "      <td>1.187647</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>25-May-21</td>\n",
       "      <td>27-May-21</td>\n",
       "      <td>Rainforest</td>\n",
       "      <td>Broad Ad Group</td>\n",
       "      <td>kids plates and bowls</td>\n",
       "      <td>BROAD</td>\n",
       "      <td>kids plates and bowls sets</td>\n",
       "      <td>4271</td>\n",
       "      <td>15</td>\n",
       "      <td>0.35%</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19.69</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2</td>\n",
       "      <td>kids plates and bowls sets Rainforest Broad Ad...</td>\n",
       "      <td>kids plates and bowls sets Rainforest</td>\n",
       "      <td>2135.500000</td>\n",
       "      <td>9.845000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>520</th>\n",
       "      <td>28-May-21</td>\n",
       "      <td>8-Jun-21</td>\n",
       "      <td>Floral</td>\n",
       "      <td>Exact Ad Group</td>\n",
       "      <td>toddler bowls</td>\n",
       "      <td>EXACT</td>\n",
       "      <td>toddler bowls</td>\n",
       "      <td>675</td>\n",
       "      <td>11</td>\n",
       "      <td>1.63%</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>19.40</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>toddler bowls Floral Exact Ad Group toddler bowls</td>\n",
       "      <td>toddler bowls Floral</td>\n",
       "      <td>61.363636</td>\n",
       "      <td>1.763636</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229</th>\n",
       "      <td>25-May-21</td>\n",
       "      <td>11-Jun-21</td>\n",
       "      <td>Rainforest</td>\n",
       "      <td>ASIN</td>\n",
       "      <td>asin=\"B07KYWP2MT\"</td>\n",
       "      <td>-</td>\n",
       "      <td>b07kywp2mt</td>\n",
       "      <td>3495</td>\n",
       "      <td>21</td>\n",
       "      <td>0.60%</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17.57</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17</td>\n",
       "      <td>b07kywp2mt Rainforest ASIN asin=\"B07KYWP2MT\"</td>\n",
       "      <td>b07kywp2mt Rainforest</td>\n",
       "      <td>205.588235</td>\n",
       "      <td>1.033529</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Start Date   End Date Campaign Name   Ad Group Name  \\\n",
       "376  26-May-21  19-Jun-21        Floral  Exact Ad Group   \n",
       "328   5-Jun-21  19-Jun-21        Floral            ASIN   \n",
       "357  27-May-21  17-Jun-21        Floral  Exact Ad Group   \n",
       "270  25-May-21  12-Jun-21    Rainforest  Exact Ad Group   \n",
       "342  25-May-21  16-Jun-21        Floral            ASIN   \n",
       "314  27-May-21  17-Jun-21        Floral            ASIN   \n",
       "257  26-May-21  12-Jun-21    Rainforest            ASIN   \n",
       "163  25-May-21  27-May-21    Rainforest  Broad Ad Group   \n",
       "520  28-May-21   8-Jun-21        Floral  Exact Ad Group   \n",
       "229  25-May-21  11-Jun-21    Rainforest            ASIN   \n",
       "\n",
       "                 Targeting Match Type        Customer Search Term  \\\n",
       "376  bamboo toddler plates      EXACT       bamboo toddler plates   \n",
       "328      asin=\"B08F2PR7JS\"          -                  b08f2pr7js   \n",
       "357        plates for kids      EXACT             plates for kids   \n",
       "270        plates for kids      EXACT             plates for kids   \n",
       "342      asin=\"B07KYWP2MT\"          -                  b07kywp2mt   \n",
       "314      asin=\"B01MG7OE9X\"          -                  b01mg7oe9x   \n",
       "257      asin=\"B07DD9WBZW\"          -                  b07dd9wbzw   \n",
       "163  kids plates and bowls      BROAD  kids plates and bowls sets   \n",
       "520          toddler bowls      EXACT               toddler bowls   \n",
       "229      asin=\"B07KYWP2MT\"          -                  b07kywp2mt   \n",
       "\n",
       "     Impressions  Clicks Click-Thru Rate (CTR)  ...  7 Day Total Sales   \\\n",
       "376          757      33                 4.36%  ...                 0.0   \n",
       "328         5157      40                 0.78%  ...                 0.0   \n",
       "357          713      17                 2.38%  ...                 0.0   \n",
       "270          664      15                 2.26%  ...                 0.0   \n",
       "342         3552      24                 0.68%  ...                 0.0   \n",
       "314         2136      28                 1.31%  ...                 0.0   \n",
       "257         1011      18                 1.78%  ...                 0.0   \n",
       "163         4271      15                 0.35%  ...                 0.0   \n",
       "520          675      11                 1.63%  ...                 0.0   \n",
       "229         3495      21                 0.60%  ...                 0.0   \n",
       "\n",
       "     Spend  Total Advertising Cost of Sales (ACoS)   \\\n",
       "376  70.82                                        0   \n",
       "328  30.31                                        0   \n",
       "357  29.47                                        0   \n",
       "270  27.42                                        0   \n",
       "342  23.48                                        0   \n",
       "314  23.08                                        0   \n",
       "257  20.19                                        0   \n",
       "163  19.69                                        0   \n",
       "520  19.40                                        0   \n",
       "229  17.57                                        0   \n",
       "\n",
       "    Total Return on Advertising Spend (RoAS)  Number of Days  \\\n",
       "376                                      0.0              24   \n",
       "328                                      0.0              14   \n",
       "357                                      0.0              21   \n",
       "270                                      0.0              18   \n",
       "342                                      0.0              22   \n",
       "314                                      0.0              21   \n",
       "257                                      0.0              17   \n",
       "163                                      0.0               2   \n",
       "520                                      0.0              11   \n",
       "229                                      0.0              17   \n",
       "\n",
       "                                                   Key  \\\n",
       "376  bamboo toddler plates Floral Exact Ad Group ba...   \n",
       "328           b08f2pr7js Floral ASIN asin=\"B08F2PR7JS\"   \n",
       "357  plates for kids Floral Exact Ad Group plates f...   \n",
       "270  plates for kids Rainforest Exact Ad Group plat...   \n",
       "342           b07kywp2mt Floral ASIN asin=\"B07KYWP2MT\"   \n",
       "314           b01mg7oe9x Floral ASIN asin=\"B01MG7OE9X\"   \n",
       "257       b07dd9wbzw Rainforest ASIN asin=\"B07DD9WBZW\"   \n",
       "163  kids plates and bowls sets Rainforest Broad Ad...   \n",
       "520  toddler bowls Floral Exact Ad Group toddler bowls   \n",
       "229       b07kywp2mt Rainforest ASIN asin=\"B07KYWP2MT\"   \n",
       "\n",
       "                                 Short Key Impressions Per Day  Spend Per Day  \\\n",
       "376           bamboo toddler plates Floral           31.541667       2.950833   \n",
       "328                      b08f2pr7js Floral          368.357143       2.165000   \n",
       "357                 plates for kids Floral           33.952381       1.403333   \n",
       "270             plates for kids Rainforest           36.888889       1.523333   \n",
       "342                      b07kywp2mt Floral          161.454545       1.067273   \n",
       "314                      b01mg7oe9x Floral          101.714286       1.099048   \n",
       "257                  b07dd9wbzw Rainforest           59.470588       1.187647   \n",
       "163  kids plates and bowls sets Rainforest         2135.500000       9.845000   \n",
       "520                   toddler bowls Floral           61.363636       1.763636   \n",
       "229                  b07kywp2mt Rainforest          205.588235       1.033529   \n",
       "\n",
       "     Sales Per Day  \n",
       "376            0.0  \n",
       "328            0.0  \n",
       "357            0.0  \n",
       "270            0.0  \n",
       "342            0.0  \n",
       "314            0.0  \n",
       "257            0.0  \n",
       "163            0.0  \n",
       "520            0.0  \n",
       "229            0.0  \n",
       "\n",
       "[10 rows x 21 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "zero_df = Zero.sort_values(by='Spend', ascending=False).head(10)\n",
    "zero_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv(r'data\\ad2.csv', index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}