title: “Ad” output: html_document date: ‘2022-05-13’ —

Plotting Missing Data

## 
## Attaching package: 'dplyr'

## The following objects are masked from 'package:stats':
## 
##     filter, lag

## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union

## Loading required package: plotly

## 
## Attaching package: 'plotly'

## The following object is masked from 'package:ggplot2':
## 
##     last_plot

## The following object is masked from 'package:stats':
## 
##     filter

## The following object is masked from 'package:graphics':
## 
##     layout

## Loading required package: viridis

## Loading required package: viridisLite

## 
## ======================
## Welcome to heatmaply version 1.3.0
## 
## Type citation('heatmaply') for how to cite the package.
## Type ?heatmaply for the main documentation.
## 
## The github page is: https://github.com/talgalili/heatmaply/
## Please submit your suggestions and bug-reports at: https://github.com/talgalili/heatmaply/issues
## You may ask questions at stackoverflow, use the r and heatmaply tags: 
##   https://stackoverflow.com/questions/tagged/heatmaply
## ======================

## 
## Attaching package: 'kableExtra'

## The following object is masked from 'package:dplyr':
## 
##     group_rows

Top 10 ad_ids by number of impressions

Bottom 10 ad_ids by number of impressions

Ad with least CPC that leAd to most impressions

ad_id	CPC	impressions	clicks
203	0	9	0

Ad with highest CPC that leAd to least impressions

ad_id	CPC	impressions	clicks
240	8.058235	3697	0

What campaign spent least efficiently on brand awareness on an average

campaign_id	CPM	impressions	clicks
2.38e+16	132	5	0

What campaign spent most efficiently on brand awareness on an average

campaign_id	CPM	impressions	clicks
2.38e+16	0	9	0