Exploratory Analysis
Edwin Santos
23/11/2021
LECTURA DEL DATASET
Se hace la lectura del dataset entregado.
# C:\Users\USER\OveDecors Dropbox\OVE DECORS NEW\_PROJECTS\YTD Report\All Documents
db<-read.csv("Documents/Amazon SB YTD - Edwin.csv")
db<-data.frame(db)VISUALIZACION INICIAL
Resumen de todas las columnas
summary(db)## ï..State Campaigns Status Type
## Length:41 Length:41 Length:41 Length:41
## Class :character Class :character Class :character Class :character
## Mode :character Mode :character Mode :character Mode :character
##
##
##
## Targeting Campaign.bidding.strategy Start.date
## Length:41 Length:41 Length:41
## Class :character Class :character Class :character
## Mode :character Mode :character Mode :character
##
##
##
## End.date Portfolio Budget.USD. Top.of.search.IS
## Length:41 Length:41 Min. : 5.0 Length:41
## Class :character Class :character 1st Qu.: 20.0 Class :character
## Mode :character Mode :character Median : 25.0 Mode :character
## Mean : 36.1
## 3rd Qu.: 50.0
## Max. :100.0
## Cost.type Impressions Clicks CTR
## Length:41 Min. : 0 Min. : 0 Min. :0.000000
## Class :character 1st Qu.: 0 1st Qu.: 0 1st Qu.:0.000000
## Mode :character Median : 10664 Median : 48 Median :0.003500
## Mean : 302702 Mean : 1576 Mean :0.003961
## 3rd Qu.: 128417 3rd Qu.: 799 3rd Qu.:0.005700
## Max. :3654553 Max. :20984 Max. :0.021300
## Spend.USD. CPC.USD. Orders Sales.USD.
## Min. : 0.00 Min. :0.0000 Min. : 0.000 Min. : 0
## 1st Qu.: 0.00 1st Qu.:0.0000 1st Qu.: 0.000 1st Qu.: 0
## Median : 29.25 Median :0.4200 Median : 0.000 Median : 0
## Mean : 708.12 Mean :0.3571 Mean : 5.951 Mean : 5131
## 3rd Qu.: 481.48 3rd Qu.:0.6100 3rd Qu.: 5.000 3rd Qu.: 3279
## Max. :11734.31 Max. :1.1100 Max. :100.000 Max. :112886
## ACOS ROAS NTB.orders X..of.orders.NTB
## Min. :0.0000 Min. : 0.000 Min. : 0.000 Min. :0.0000
## 1st Qu.:0.0000 1st Qu.: 0.000 1st Qu.: 0.000 1st Qu.:0.0000
## Median :0.0000 Median : 0.000 Median : 0.000 Median :0.0000
## Mean :0.1140 Mean : 4.354 Mean : 4.195 Mean :0.2272
## 3rd Qu.:0.1461 3rd Qu.: 6.377 3rd Qu.: 1.000 3rd Qu.:0.6000
## Max. :1.0834 Max. :30.836 Max. :81.000 Max. :1.0000
## NTB.sales.USD. X..of.sales.NTB Viewable.impressions VCPM.USD.
## Min. : 0.0 Min. :0.0000 Min. :0 Min. :0
## 1st Qu.: 0.0 1st Qu.:0.0000 1st Qu.:0 1st Qu.:0
## Median : 0.0 Median :0.0000 Median :0 Median :0
## Mean : 3968.6 Mean :0.2276 Mean :0 Mean :0
## 3rd Qu.: 444.4 3rd Qu.:0.4591 3rd Qu.:0 3rd Qu.:0
## Max. :95335.5 Max. :1.0000 Max. :0 Max. :0Tipos de las columnas
str(db)## 'data.frame': 41 obs. of 27 variables:
## $ ï..State : chr "ENABLED" "PAUSED" "PAUSED" "ENABLED" ...
## $ Campaigns : chr "2021_06_SB_Tampa Pro 54 to 67" "2021_06_SB_Pasadena 28 to 40" "2021_06_SB_Pasadena 60 to 69" "2021_SBV_Cherry36" ...
## $ Status : chr "RUNNING" "PAUSED" "PAUSED" "CAMPAIGN_STATUS_ENABLED" ...
## $ Type : chr "SB" "SB" "SB" "SBV" ...
## $ Targeting : chr "MANUAL" "MANUAL" "MANUAL" "MANUAL" ...
## $ Campaign.bidding.strategy: chr "" "" "" "Dynamic bids - down only" ...
## $ Start.date : chr "6/7/21" "6/7/21" "6/7/21" "11/12/21" ...
## $ End.date : chr "" "" "" "" ...
## $ Portfolio : chr "SHOWERS AND ACCESORIES" "SHOWERS AND ACCESORIES" "SHOWERS AND ACCESORIES" "" ...
## $ Budget.USD. : num 25 25 25 50 25 25 25 25 50 100 ...
## $ Top.of.search.IS : chr "10.6278418411199%" "17.437870361686517%" "16.96416565629629%" "" ...
## $ Cost.type : chr "" "" "" "CPC" ...
## $ Impressions : int 235715 838216 286472 32431 386151 340654 433026 471472 84174 1961208 ...
## $ Clicks : int 862 3146 1785 251 1403 1646 1720 1786 799 13271 ...
## $ CTR : num 0.0037 0.0038 0.0062 0.0077 0.0036 0.0048 0.004 0.0038 0.0095 0.0068 ...
## $ Spend.USD. : num 481 1909 795 251 814 ...
## $ CPC.USD. : num 0.56 0.61 0.45 1 0.58 0.47 0.64 0.46 0.73 0.37 ...
## $ Orders : int 1 4 1 1 5 5 8 6 9 38 ...
## $ Sales.USD. : num 444 2671 1199 821 3279 ...
## $ ACOS : num 1.083 0.715 0.663 0.306 0.248 ...
## $ ROAS : num 0.923 1.399 1.508 3.273 4.028 ...
## $ NTB.orders : int 1 4 1 0 4 3 8 5 0 31 ...
## $ X..of.orders.NTB : num 1 1 1 0 0.8 ...
## $ NTB.sales.USD. : num 444 2671 1199 0 3024 ...
## $ X..of.sales.NTB : num 1 1 1 0 0.922 ...
## $ Viewable.impressions : int 0 0 0 0 0 0 0 0 0 0 ...
## $ VCPM.USD. : num 0 0 0 0 0 0 0 0 0 0 ...VEMOS LOS DATOS FALTANTES
Datos Faltantes
library(mice)## Warning: package 'mice' was built under R version 4.0.4md.pattern(db,rotate.names = TRUE)
## /\ /\
## { `---' }
## { O O }
## ==> V <== No need for mice. This data set is completely observed.
## \ \|/ /
## `-----'
##
## ï..State Campaigns Status Type Targeting Campaign.bidding.strategy
## 41 1 1 1 1 1 1
## 0 0 0 0 0 0
## Start.date End.date Portfolio Budget.USD. Top.of.search.IS Cost.type
## 41 1 1 1 1 1 1
## 0 0 0 0 0 0
## Impressions Clicks CTR Spend.USD. CPC.USD. Orders Sales.USD. ACOS ROAS
## 41 1 1 1 1 1 1 1 1 1
## 0 0 0 0 0 0 0 0 0
## NTB.orders X..of.orders.NTB NTB.sales.USD. X..of.sales.NTB
## 41 1 1 1 1
## 0 0 0 0
## Viewable.impressions VCPM.USD.
## 41 1 1 0
## 0 0 0No hay datos faltantes.