<div>
<style scoped>
    .dataframe tbody tr th:only-of-type {
        vertical-align: middle;
    }

    .dataframe tbody tr th {
        vertical-align: top;
    }

    .dataframe thead th {
        text-align: right;
    }
</style>
<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>No</th>
      <th>Date (Indonesia)</th>
      <th>Week (Monday to Sunday)</th>
      <th>Month</th>
      <th>Link</th>
      <th>Type</th>
      <th>Post Message</th>
      <th>ER</th>
      <th>Engagement</th>
      <th>Total Reach</th>
      <th>...</th>
      <th>Unnamed: 21</th>
      <th>Unnamed: 22</th>
      <th>Unnamed: 23</th>
      <th>Unnamed: 24</th>
      <th>Unnamed: 25</th>
      <th>Unnamed: 26</th>
      <th>Unnamed: 27</th>
      <th>Unnamed: 28</th>
      <th>Unnamed: 29</th>
      <th>Unnamed: 30</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>1.0</td>
      <td>3/28/2023 11:02:26</td>
      <td>13.0</td>
      <td>3.0</td>
      <td>NaN</td>
      <td>Video</td>
      <td>NaN</td>
      <td>0.65%</td>
      <td>9,245</td>
      <td>1,432,343</td>
      <td>...</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
    </tr>
    <tr>
      <th>1</th>
      <td>2.0</td>
      <td>4/3/2023 12:24:50</td>
      <td>14.0</td>
      <td>4.0</td>
      <td>NaN</td>
      <td>Video</td>
      <td>NaN</td>
      <td>2.71%</td>
      <td>328</td>
      <td>12,097</td>
      <td>...</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
    </tr>
    <tr>
      <th>2</th>
      <td>3.0</td>
      <td>4/4/2023 13:15:19</td>
      <td>14.0</td>
      <td>4.0</td>
      <td>NaN</td>
      <td>Video</td>
      <td>NaN</td>
      <td>1.51%</td>
      <td>61</td>
      <td>4,043</td>
      <td>...</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
    </tr>
    <tr>
      <th>3</th>
      <td>4.0</td>
      <td>4/15/2023 13:00:00</td>
      <td>15.0</td>
      <td>4.0</td>
      <td>NaN</td>
      <td>Video</td>
      <td>NaN</td>
      <td>2.45%</td>
      <td>1,189</td>
      <td>48,472</td>
      <td>...</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
    </tr>
    <tr>
      <th>4</th>
      <td>5.0</td>
      <td>4/17/2023 22:00:00</td>
      <td>16.0</td>
      <td>4.0</td>
      <td>NaN</td>
      <td>Video</td>
      <td>NaN</td>
      <td>2.57%</td>
      <td>727</td>
      <td>28,291</td>
      <td>...</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
    </tr>
  </tbody>
</table>
<p>5 rows × 31 columns</p>
</div>

    No    Date (Indonesia)  Week (Monday to Sunday)  Month  Link   Type  \
0  1.0  3/28/2023 11:02:26                     13.0    3.0   NaN  Video   
1  2.0   4/3/2023 12:24:50                     14.0    4.0   NaN  Video   
2  3.0   4/4/2023 13:15:19                     14.0    4.0   NaN  Video   
3  4.0  4/15/2023 13:00:00                     15.0    4.0   NaN  Video   
4  5.0  4/17/2023 22:00:00                     16.0    4.0   NaN  Video   

   Post Message     ER Engagement Total Reach  ... Unnamed: 21 Unnamed: 22  \
0           NaN  0.65%      9,245   1,432,343  ...         NaN         NaN   
1           NaN  2.71%        328      12,097  ...         NaN         NaN   
2           NaN  1.51%         61       4,043  ...         NaN         NaN   
3           NaN  2.45%      1,189      48,472  ...         NaN         NaN   
4           NaN  2.57%        727      28,291  ...         NaN         NaN   

   Unnamed: 23  Unnamed: 24  Unnamed: 25 Unnamed: 26  Unnamed: 27  \
0          NaN          NaN          NaN         NaN          NaN   
1          NaN          NaN          NaN         NaN          NaN   
2          NaN          NaN          NaN         NaN          NaN   
3          NaN          NaN          NaN         NaN          NaN   
4          NaN          NaN          NaN         NaN          NaN   

   Unnamed: 28  Unnamed: 29 Unnamed: 30  
0          NaN          NaN         NaN  
1          NaN          NaN         NaN  
2          NaN          NaN         NaN  
3          NaN          NaN         NaN  
4          NaN          NaN         NaN  

[5 rows x 31 columns]

<div>
<style scoped>
    .dataframe tbody tr th:only-of-type {
        vertical-align: middle;
    }

    .dataframe tbody tr th {
        vertical-align: top;
    }

    .dataframe thead th {
        text-align: right;
    }
</style>
<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>Total Engagement</th>
      <th>Total Reach</th>
      <th>Total Posts</th>
      <th>Average Engagement per Post</th>
      <th>KPI (Average Engagement per Post)</th>
      <th>Comparison with KPI</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>14026.0</td>
      <td>1642657.0</td>
      <td>782</td>
      <td>17.936061</td>
      <td>592</td>
      <td>-574.063939</td>
    </tr>
  </tbody>
</table>
</div>

   Total Engagement  Total Reach  Total Posts  Average Engagement per Post  \
0           14026.0    1642657.0          782                    17.936061   

   KPI (Average Engagement per Post)  Comparison with KPI  
0                                592          -574.063939  

<div>
<style scoped>
    .dataframe tbody tr th:only-of-type {
        vertical-align: middle;
    }

    .dataframe tbody tr th {
        vertical-align: top;
    }

    .dataframe thead th {
        text-align: right;
    }
</style>
<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>Total Engagement</th>
      <th>Total Reach</th>
      <th>Total Posts</th>
      <th>Average Engagement per Post</th>
      <th>KPI (Average Engagement per Post)</th>
      <th>Comparison with KPI (Percentage)</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>14026.0</td>
      <td>1642657.0</td>
      <td>782</td>
      <td>17.936061</td>
      <td>592</td>
      <td>-96.97026</td>
    </tr>
  </tbody>
</table>
</div>

   Total Engagement  Total Reach  Total Posts  Average Engagement per Post  \
0           14026.0    1642657.0          782                    17.936061   

   KPI (Average Engagement per Post)  Comparison with KPI (Percentage)  
0                                592                         -96.97026  

<div>
<style scoped>
    .dataframe tbody tr th:only-of-type {
        vertical-align: middle;
    }

    .dataframe tbody tr th {
        vertical-align: top;
    }

    .dataframe thead th {
        text-align: right;
    }
</style>
<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>Total Engagement</th>
      <th>Total Reach</th>
      <th>Total Posts</th>
      <th>Average Engagement per Post</th>
      <th>KPI (Average Engagement per Post)</th>
      <th>Comparison with KPI (Percentage)</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>14026.0</td>
      <td>1642657.0</td>
      <td>8</td>
      <td>1753.25</td>
      <td>592</td>
      <td>196.157095</td>
    </tr>
  </tbody>
</table>
</div>

   Total Engagement  Total Reach  Total Posts  Average Engagement per Post  \
0           14026.0    1642657.0            8                      1753.25   

   KPI (Average Engagement per Post)  Comparison with KPI (Percentage)  
0                                592                        196.157095  

Data Analysis: Engagement Metrics and Monthly Trends

Hi, I am data analyst in digital marketing agency. I need your help to read this file. This file contains insight data of Skincare Campaign's content in Facebook. Please create summary with this detail:

Summary Table

1. Please double check the total posts and please provide the percentage rate for the comparison with KPI

Summary Table

Graph

1. You still provide inaccurate results in total post which should be one digit only

Summary Table

Please help me to analyze the data

Analysis of the Data

Insights

No	Date (Indonesia)	Week (Monday to Sunday)	Month	Link	Type	Post Message	ER	Engagement	Total Reach	...
1	3/28/2023 11:02:26	13	3	NaN	Video	NaN	0.65%	9,245	1,432,343	...
2	4/3/2023 12:24:50	14	4	NaN	Video	NaN	2.71%	328	12,097	...
3	4/4/2023 13:15:19	14	4	NaN	Video	NaN	1.51%	61	4,043	...