Hello, colleagues
My script
rbind(
googleads_report %>%
mutate(sourceMedium = "google / cpc") %>%
dplyr::select(date, sourceMedium, campaign_name, impressions, clicks, cost, device) %>%
dplyr::rename(campaign = campaign_name),
yadir_report %>%
mutate(sourceMedium = "yandex / cpc") %>%
dplyr::select(Date, sourceMedium, CampaignName, Impressions, Clicks, Cost, Device) %>%
dplyr::rename(date = Date, campaign = CampaignName, impressions = Impressions,clicks = Clicks, cost = Cost, device = Device)
) %>%
mutate(device = case_when(
grepl("DESKTOP", device, ignore.case = T) ~ "desktop",
grepl(".(Mobile|TABLET|CONNECTED_TV).", device, ignore.case = T) ~ "mobile",
TRUE ~ "others")) %>%
group_by(date, sourceMedium, campaign, impressions, clicks, cost, device) %>%
summarise(cost = sum(cost)) %>%
View()
I can't summarise values in columns "impressions", "clicks", "cost" by column "device" after i renamed
".(Mobile|TABLET|CONNECTED_TV). to "mobile".
On the screen we can see that each campaign contains two devices "mobile" and they don`t summarise.
