SHARE
TWEET

Untitled

a guest Nov 19th, 2019 73 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. this became a bit messy now due to the disconnects etc. but there are some timings in there.
  2. in total it was 210 minutes it seems.
  3.  
  4. Command was:
  5. Rscript ${DMP_PATH}/attribution_app/load_data.R --user bettzeit  --date-since 2019-10-20 --date-until 2019-10-24 --refresh-attributions-and-tables
  6.  
  7. INFO:  rename_attribution_columns_from_costs - indexes creation done time spent=00:03:24.752837INFO:  rename_attribution_columns_from_costs - costdims done time spent=00:04:57.54149INFO:  rename_attribution_columns_from_costs - costdims_source done time spent=00:04:59.03411INFO:  rename_attribution_columns_from_costs - costdims_source_medium done time spent=00:05:01.081279INFO:  rename_attribution_columns_from_costs - costdims_source_medium_campaign done time spent=00:05:06.605207INFO:  rename_attribution_columns_from_costs - costdims_source_medium_campaign_keyword done time spent=00:05:18.449738INFO:  rename_attribution_columns_from_costs - costdims_source_medium_campaign_keyword_adcontent_adgroup done time spent=00:05:33.635656INFO:  rename_attribution_columns_from_costs - costdims_source_medium_campaign_keyword_adcontent_adgroup_placement_creative done time spent=00:05:51.801492INFO:  rename_attribution_columns_from_costs - costdims_by_adid done time spent=00:06:28.249441INFO:  rename_attribution_columns_from_costs - costdims_by_adid_keyword done time spent=00:06:35.629263
  8.  
  9.  manual_costs_filtered_by_date - done time spent=00:00:00.01628INFO:  create_cost_with_types - done time spent=00:00:01.455076INFO:  costs_filtered_by_date - done time spent=00:00:06.879186INFO:  get_costs_with_renamings - done time spent=00:00:10.407767INFO:  get_costs_with_exchange_rates - done time spent=00:00:02.297458INFO:  attributions_filtered_by_date - done time spent=00:00:00.809198INFO:  get_attributions_with_processed_columns - done time spent=00:00:00.655119INFO:  get_attributions_with_renamings - done time spent=00:00:00.181518INFO:  get_costs_with_renamings - done time spent=00:00:37.912417INFO:  rename_attribution_columns_from_costs - indexes creation done time spent=00:03:24.752837INFO:  rename_attribution_columns_from_costs - costdims done time spent=00:04:57.54149INFO:  rename_attribution_columns_from_costs - costdims_source done time spent=00:04:59.03411INFO:  rename_attribution_columns_from_costs - costdims_source_medium done time spent=00:05:01.081279INFO:  rename_attribution_columns_from_costs - costdims_source_medium_campaign done time spent=00:05:06.605207INFO:  rename_attribution_columns_from_costs - costdims_source_medium_campaign_keyword done time spent=00:05:18.449738INFO:  rename_attribution_columns_from_costs - costdims_source_medium_campaign_keyword_adcontent_adgroup done time spent=00:05:33.635656INFO:  rename_attribution_columns_from_costs - costdims_source_medium_campaign_keyword_adcontent_adgroup_placement_creative done time spent=00:05:51.801492INFO:  rename_attribution_columns_from_costs - costdims_by_adid done time spent=00:06:28.249441INFO:  rename_attribution_columns_from_costs - costdims_by_adid_keyword done time spent=00:06:35.629263
  10.  
  11. INFO:  rename_attribution_columns_from_costs - done time spent=01:38:38.849298INFO:  get_renamed_channel_groupings - done time spent=00:00:00.253067INFO:  get_channelgroupings_with_costdims - done time spent=00:00:00.006412INFO:  get_unique_channel_groupings - done time spent=00:00:00.007977INFO:  join_attributions_and_costs - grouped_costs done time spent=00:00:20.424822INFO:  join_attributions_and_costs - grouped_attributions done time spent=00:00:21.156659INFO:  join_attributions_and_costs - done time spent=00:00:41.303682INFO:  refresh_aac - delete values done time spent=00:00:05.89369INFO:  refresh_aac - update needs_refresh done time spent=00:00:05.918529INFO:  refresh_aac - insert new values done time spent=00:00:14.911462[2019-11-19 22:19:35] Not refreshing the bettzeit_attributions_and_costs view because it was dropped and created new. Explicitly set force=TRUE to override[2019-11-19 22:19:35] Updating permissions for the costs_uploader user[1] "Latest tv data downloaded for country UK"[1] "Latest tv data downloaded for country FR"[1] "Latest tv data downloaded for country NL"[1] "Latest tv data downloaded for country DE"[1] "Latest tv data downloaded for country IT"[1] "Latest tv data downloaded for country ES"[1] "Latest tv data downloaded for country PT"[1] "Latest tv data downloaded for country BE"[1] "Latest tv data downloaded for country IE"[1] "Latest tv data downloaded for country CH"[1] "Cost file * doesnt exist"[2019-11-19 22:20:40] Loading data for UK E-commerce conversion ...2019-11-19 22:20:40> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:20:40> Finding how much sampling in data request...2019-11-19 22:20:57> Downloaded [10] rows from a total of [699].2019-11-19 22:20:57> No sampling found, returning call2019-11-19 22:21:02> Downloaded [699] rows from a total of [699].2019-11-19 22:21:03> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:21:03> Finding how much sampling in data request...2019-11-19 22:21:09> Downloaded [10] rows from a total of [699].2019-11-19 22:21:09> No sampling found, returning call2019-11-19 22:21:16> Downloaded [699] rows from a total of [699].2019-11-19 22:21:16> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:21:16> Finding how much sampling in data request...2019-11-19 22:21:22> Downloaded [10] rows from a total of [699].2019-11-19 22:21:22> No sampling found, returning call2019-11-19 22:21:49> Downloaded [699] rows from a total of [699].[2019-11-19 22:21:49] Loading data for FR E-commerce conversion ...2019-11-19 22:21:49> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:21:49> Finding how much sampling in data request...2019-11-19 22:21:50> Downloaded [10] rows from a total of [688].2019-11-19 22:21:50> No sampling found, returning call2019-11-19 22:21:50> Downloaded [688] rows from a total of [688].2019-11-19 22:21:51> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:21:51> Finding how much sampling in data request...2019-11-19 22:21:51> Downloaded [10] rows from a total of [688].2019-11-19 22:21:51> No sampling found, returning call2019-11-19 22:21:51> Downloaded [688] rows from a total of [688].2019-11-19 22:21:52> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:21:52> Finding how much sampling in data request...2019-11-19 22:21:52> Downloaded [10] rows from a total of [688].2019-11-19 22:21:52> No sampling found, returning call2019-11-19 22:21:52> Downloaded [688] rows from a total of [688].[2019-11-19 22:21:52] Loading data for NL E-commerce conversion ...2019-11-19 22:21:53> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:21:53> Finding how much sampling in data request...2019-11-19 22:21:53> Downloaded [10] rows from a total of [682].2019-11-19 22:21:53> No sampling found, returning call2019-11-19 22:21:53> Downloaded [682] rows from a total of [682].2019-11-19 22:21:54> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:21:54> Finding how much sampling in data request...2019-11-19 22:21:54> Downloaded [10] rows from a total of [682].2019-11-19 22:21:54> No sampling found, returning call2019-11-19 22:21:54> Downloaded [682] rows from a total of [682].2019-11-19 22:21:54> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:21:54> Finding how much sampling in data request...2019-11-19 22:21:55> Downloaded [10] rows from a total of [682].2019-11-19 22:21:55> No sampling found, returning call2019-11-19 22:21:55> Downloaded [682] rows from a total of [682].[2019-11-19 22:21:55] Loading data for DE E-commerce conversion ...2019-11-19 22:21:56> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:21:56> Finding how much sampling in data request...2019-11-19 22:22:05> Downloaded [10] rows from a total of [699].2019-11-19 22:22:05> No sampling found, returning call2019-11-19 22:22:15> Downloaded [699] rows from a total of [699].2019-11-19 22:22:15> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:22:15> Finding how much sampling in data request...2019-11-19 22:22:23> Downloaded [10] rows from a total of [699].2019-11-19 22:22:23> No sampling found, returning call2019-11-19 22:22:31> Downloaded [699] rows from a total of [699].2019-11-19 22:22:31> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:22:31> Finding how much sampling in data request...2019-11-19 22:22:38> Downloaded [10] rows from a total of [699].2019-11-19 22:22:38> No sampling found, returning call2019-11-19 22:22:45> Downloaded [699] rows from a total of [699].[2019-11-19 22:22:45] Loading data for IT E-commerce conversion ...2019-11-19 22:22:45> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:22:45> Finding how much sampling in data request...2019-11-19 22:22:52> Downloaded [10] rows from a total of [262].2019-11-19 22:22:52> No sampling found, returning call2019-11-19 22:22:55> Downloaded [262] rows from a total of [262].2019-11-19 22:22:55> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:22:55> Finding how much sampling in data request...2019-11-19 22:22:57> Downloaded [10] rows from a total of [262].2019-11-19 22:22:57> No sampling found, returning call2019-11-19 22:22:59> Downloaded [262] rows from a total of [262].2019-11-19 22:22:59> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:22:59> Finding how much sampling in data request...2019-11-19 22:23:01> Downloaded [10] rows from a total of [262].2019-11-19 22:23:01> No sampling found, returning call2019-11-19 22:23:03> Downloaded [262] rows from a total of [262].[2019-11-19 22:23:03] Loading data for ES E-commerce conversion ...2019-11-19 22:23:03> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:23:03> Finding how much sampling in data request...2019-11-19 22:23:03> Downloaded [10] rows from a total of [258].2019-11-19 22:23:03> No sampling found, returning call2019-11-19 22:23:04> Downloaded [258] rows from a total of [258].2019-11-19 22:23:04> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:23:04> Finding how much sampling in data request...2019-11-19 22:23:04> Downloaded [10] rows from a total of [258].2019-11-19 22:23:04> No sampling found, returning call2019-11-19 22:23:05> Downloaded [258] rows from a total of [258].2019-11-19 22:23:05> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:23:05> Finding how much sampling in data request...2019-11-19 22:23:05> Downloaded [10] rows from a total of [258].2019-11-19 22:23:05> No sampling found, returning call2019-11-19 22:23:06> Downloaded [258] rows from a total of [258].[2019-11-19 22:23:06] Loading data for PT E-commerce conversion ...2019-11-19 22:23:06> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:23:06> Finding how much sampling in data request...2019-11-19 22:23:09> Downloaded [10] rows from a total of [271].2019-11-19 22:23:09> No sampling found, returning call2019-11-19 22:23:10> Downloaded [271] rows from a total of [271].2019-11-19 22:23:10> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:23:10> Finding how much sampling in data request...2019-11-19 22:23:11> Downloaded [10] rows from a total of [271].2019-11-19 22:23:11> No sampling found, returning call2019-11-19 22:23:13> Downloaded [271] rows from a total of [271].2019-11-19 22:23:13> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:23:13> Finding how much sampling in data request...2019-11-19 22:23:14> Downloaded [10] rows from a total of [271].2019-11-19 22:23:14> No sampling found, returning call2019-11-19 22:23:15> Downloaded [271] rows from a total of [271].[2019-11-19 22:23:15] Loading data for BN E-commerce conversion ...2019-11-19 22:23:15> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:23:15> Finding how much sampling in data request...2019-11-19 22:23:15> Downloaded [10] rows from a total of [314].2019-11-19 22:23:15> No sampling found, returning call2019-11-19 22:23:16> Downloaded [314] rows from a total of [314].2019-11-19 22:23:16> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:23:16> Finding how much sampling in data request...2019-11-19 22:23:16> Downloaded [10] rows from a total of [314].2019-11-19 22:23:16> No sampling found, returning call2019-11-19 22:23:17> Downloaded [314] rows from a total of [314].2019-11-19 22:23:17> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:23:17> Finding how much sampling in data request...2019-11-19 22:23:17> Downloaded [10] rows from a total of [314].2019-11-19 22:23:17> No sampling found, returning call2019-11-19 22:23:18> Downloaded [314] rows from a total of [314].[2019-11-19 22:23:18] Loading data for IE E-commerce conversion ...2019-11-19 22:23:18> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:23:18> Finding how much sampling in data request...2019-11-19 22:23:21> Downloaded [10] rows from a total of [139].2019-11-19 22:23:21> No sampling found, returning call2019-11-19 22:23:22> Downloaded [139] rows from a total of [139].2019-11-19 22:23:22> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:23:22> Finding how much sampling in data request...2019-11-19 22:23:23> Downloaded [10] rows from a total of [139].2019-11-19 22:23:23> No sampling found, returning call2019-11-19 22:23:25> Downloaded [139] rows from a total of [139].2019-11-19 22:23:25> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:23:25> Finding how much sampling in data request...2019-11-19 22:23:26> Downloaded [10] rows from a total of [139].2019-11-19 22:23:26> No sampling found, returning call2019-11-19 22:23:27> Downloaded [139] rows from a total of [139].[2019-11-19 22:23:27] Loading data for CH E-commerce conversion ...2019-11-19 22:23:27> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:23:27> Finding how much sampling in data request...2019-11-19 22:23:30> Downloaded [10] rows from a total of [137].2019-11-19 22:23:30> No sampling found, returning call2019-11-19 22:23:31> Downloaded [137] rows from a total of [137].2019-11-19 22:23:32> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:23:32> Finding how much sampling in data request...2019-11-19 22:23:33> Downloaded [10] rows from a total of [137].2019-11-19 22:23:33> No sampling found, returning call2019-11-19 22:23:34> Downloaded [137] rows from a total of [137].2019-11-19 22:23:34> anti_sample set to TRUE. Mitigating sampling via multiple API calls.2019-11-19 22:23:34> Finding how much sampling in data request...2019-11-19 22:23:35> Downloaded [10] rows from a total of [137].2019-11-19 22:23:35> No sampling found, returning call2019-11-19 22:23:36> Downloaded [137] rows from a total of [137].Running for UK E-commerce conversion...For channel (not set)...For channel 5star...For channel 5tv...For channel 5usa...For channel boomerang...For channel c4tv...For channel cartnito...For channel cartoon...For channel cdrama...For channel challnge...For channel creality...For channel disney channel...For channel disnyjnr...For channel dmax...For channel dschist...For channel dscinves...For channel dscsci...For channel dsturbo...For channel e! entertainment...For channel film4...For channel foodnet...For channel history channel...For channel lifetime...For channel milkshak...For channel more4...For channel mtv...For channel natgeog...For channel njr...For channel reallive...For channel sky1...For channel skyarts...For channel skyatlan...For channel skycinfa...For channel skycingr...For channel skycinpr...For channel skycinsc...For channel skyspac...For channel skyspar...For channel skyspcr...For channel skyspf1...For channel skyspme...For channel skyspmix...For channel syfy...For channel tinypop...For channel tlc...For channel trutv...For channel univers...For channel wchannel...For channel crimin...For channel disneyxd...For channel goodfood...For channel h2...For channel natgwild...For channel njrtoo...For channel skycinac...For channel skycindr...For channel skywit...For channel home...For channel skycindi...For channel skycinse...For channel animal...For channel skycincr...For channel sonycr...For channel 4seven...For channel really...For channel sky2...For channel skyspfo...For channel skyspgo...For channel skycinco...For channel dscshed...For channel skycinhi...For channel dsch&h...For channel c4london...For channel c4mids...For channel c4north...For channel c4scot...For channel c4south...For channel c4ulster...For channel c4gb...For channel c4lsm...For channel sonymovi...For channel trueent...For channel e4...For channel truemov...For channel c4ls...For channel c4englnd...For channel history2...For channel skycrime...Running for FR E-commerce conversion...For channel (not set)...For channel rmc découverte...For channel rmc story...For channel tf1 séries films...For channel cherie 25...For channel tf1...For channel téva...For channel tmc...For channel m6...For channel tv breizh...For channel w96ter puissance tnt...For channel france 2...For channel france 5...For channel c8+...For channel cnews...For channel paris première...For channel france 3...For channel nrj 12...For channel c8 star +...For channel rmc power...For channel ab1...For channel la chaine l'equipe...For channel chérie 25...For channel w9...For channel auto moto...For channel c8...Running for NL E-commerce conversion...For channel (not set)...For channel comedy xtr...For channel rtlcrime...For channel rtl lounge...For channel rtl z...For channel rtl8...For channel xite...For channel ziggo spor...For channel nat geo wild...For channel zs select...For channel zs voetb...For channel history channel...For channel animal...For channel crime inv...For channel science...For channel zig sp go...For channel net5...For channel sbs 6...For channel sbs 9...For channel veronica...For channel viceland...For channel ons...For channel out tv...For channel 24kitchen...For channel bbcfh...For channel eurosport...For channel fox...For channel fs2...For channel geographic...For channel id...For channel mtv...For channel fs3...For channel spike...For channel tlc...For channel comedy central...For channel discovery...For channel fs1...For channel rtl4...For channel rtl5...For channel rtl7...For channel e! entertainment...For channel insight tv...For channel npo1...For channel npo2...For channel npo3...Running for DE E-commerce conversion...For channel (not set)...For channel 13th street...For channel a&e...For channel deluxe music...For channel dmax...For channel e! entertainment...For channel eotv...For channel family tv...For channel folx tv...For channel fox...For channel gute laune tv (sky)...For channel jukebox...For channel mtv...For channel planet...For channel romance tv...For channel rtl living...For channel rtl passion...For channel servus tv...For channel stingray classica...For channel tlc...For channel tnt comedy...For channel tnt film...For channel tnt serie...For channel welt der wunder tv...For channel n24 doku...For channel discovery...For channel pro7 maxx...For channel sport 1+...For channel sport1 us...For channel tm3...For channel esports1...For channel nat geo wild...For channel national geographic...For channel tele 5...For channel zeeone (visoon)...For channel marco polo tv...For channel welt...For channel bongusto tv...For channel anixe hd serie...For channel silverline...For channel sport1...For channel health tv (vm: goldbach)...For channel heimatkanal...For channel sky cinema...For channel sky cinema emotion...For channel sat.1 emotions...For channel sky cinema family hd...For channel home & gardentv...For channel crime + investigation...For channel BonGusto TV ...For channel NatGeo Wild...For channel comedy central...For channel kinowelt tv...For channel motorvision.tv...For channel syfy...For channel axn...For channel Discovery Channel...For channel Sky 1 HD...For channel Universal TV...For channel Deluxe...For channel Sky Atlantic...For channel ProSieben MAXX...For channel RTL Crime...Running for IT E-commerce conversion...For channel cine sony...For channel comedy central...For channel deejay tv...For channel mtv music...For channel mtv next...For channel paramount channel...For channel radio italia smi tv...For channel spike...For channel vh1...For channel (not set)...For channel d.channel...For channel d.science...For channel dmax...For channel food network...For channel giallo...For channel motor trend...For channel nove...For channel real time...For channel blaze...For channel crime&investigation...For channel dove...For channel fox animation...For channel fox channel...For channel fox comedy...For channel fox crime...For channel fox crime +1...For channel fox crime +2...For channel fox life...For channel fox life +1...For channel gambero rosso...For channel history channel...For channel history channel +1...For channel la effe tv...For channel lei...For channel lei +1...For channel nat geo wild...For channel nat geo wild +1...For channel national geographic...For channel national geographic +1...For channel national geographic people...For channel sky arte...For channel sky atlantic +1...For channel sky atlantic hd...For channel sky cinema collection...For channel sky cinema comedy...For channel sky cinema drama...For channel sky cinema due...For channel sky cinema family...For channel sky cinema romance...For channel sky cinema uno...For channel sky cinema uno + 24...For channel sky meteo 24...For channel sky tg 24...For channel sky uno...For channel sky uno +1...For channel pop up fox...For channel sky cinema due +24...For channel fox channel +1...For channel pop up fox life...For channel sky sport arena...For channel eurosport 2...For channel eurosport 1...For channel premium action...For channel premium cinema...For channel premium cinema comedy...For channel premium cinema emotion...For channel premium cinema energy...For channel premium crime...For channel premium stories...For channel pop up fox crime...For channel nat geo wild pop up...For channel sky cinema suspense...Running for ES E-commerce conversion...For channel axn...For channel discovery...For channel dmax...For channel paramount network...For channel ten...For channel trece...For channel amc...For channel blaze...For channel canal hollywood...For channel decasa...For channel dkiss...For channel fox...For channel fox life...For channel mtv esp...For channel national geographic...For channel ngc wild...For channel odisea...For channel real madrid hd...For channel sundance tv...For channel axn white...For channel calle 13...For channel comedy central...For channel cosmopolitan...For channel dark...For channel historia...For channel canal cocina...For channel viajar...For channel eurosport...For channel syfy...For channel crimen + investigacion...For channel somos...For channel (not set)...For channel xtrm...For channel grupo cuatro...For channel nsf...Running for PT E-commerce conversion...For channel axn...For channel axn black...For channel axn white...For channel discovery...For channel globo...For channel fox...For channel fox comedy...For channel fox life...For channel fox movies portugal...For channel national geographic...For channel (not set)...For channel rtp1...For channel amc...For channel blaze...For channel tvi reality...For channel tvi24...For channel sic mulher...For channel sic radikal...For channel FOX Movies...For channel SIC Radical...For channel historia...For channel odisseia...For channel NGC...Running for BN E-commerce conversion...For channel comedy central...For channel dobbit tv...For channel fox...For channel ment tv nl...For channel mtv (nl)...For channel national geographic nl...For channel evenaar...For channel xite...For channel kanaal z (nl)...For channel spike...For channel history channel nl...For channel viceland vl...For channel (not set)...For channel ment tv north...For channel mtv north...For channel history channel north...For channel plattelands tv...For channel national geographic north...For channel plattelandstv...For channel national geographic fr...For channel viceland fr...For channel mtv (fr)...For channel dobbit fr...For channel 13ieme rue fr...For channel canal z (fr)...For channel eclips tv...Running for IE E-commerce conversion...For channel c4...For channel e4...For channel film4...For channel more4...For channel skysptn...For channel vm1...For channel vm2...For channel cbsreal...For channel mtv...For channel really...For channel nickjr2...For channel skywit...For channel sky atlantic hd...For channel skynews...For channel comedy central...For channel sky2...For channel alibi...For channel discovery...For channel challenge...For channel universal channel...For channel (not set)...Running for CH E-commerce conversion...For channel comedy central ch...For channel dmax ch...For channel kabel eins ch...For channel mtv ch...For channel prosieben ch...For channel rtl ii ch...For channel sport 1 ch...For channel teleclub zoom ch...For channel tlc ch...For channel tv 25 ch...For channel teleclub ch...For channel vox ch...For channel 3+ ch...For channel RTL NITRO CH...For channel sixx CH...For channel TLC CH ...[1] "TV share by country:"
  12.  
  13. Calculating data for UK E-commerce conversion...[1] "transaction_revenue ~ 0 + totalspend + onlinespend"[2] "1.33612112097958"[1] 0.7484351[1] "transaction_revenue ~ 0 + adstock_cost + onlinespend"[2] "1.09184482580421"[1] 0.9158811[1] NA[1] "Warning! Column in the dataframe contains only NA values, assinged 0 to correlation coefficient"[1] "transaction_revenue ~ 0 + adstock_audience_1 + onlinespend"[2] "-0.00063652358985826"[1] -1571.034[1] "entrances ~ 0 + totalspend + onlinespend"[2] "0.131684959377063"[1] 7.593882[1] "entrances ~ 0 + adstock_cost + onlinespend"[2] "0.0964117614945752"[1] 10.37218[1] NA[1] "Warning! Column in the dataframe contains only NA values, assinged 0 to correlation coefficient"[1] "entrances ~ 0 + adstock_audience_1 + onlinespend"[2] "3.76793081233982e-05"[1] 26539.77
  14.  
  15. Calculating data for FR E-commerce conversion...[1] "transaction_revenue ~ 0 + totalspend + onlinespend"[2] "0.381345685947633"[1] 2.622293[1] "transaction_revenue ~ 0 + adstock_cost + onlinespend"[2] "0.339601509698843"[1] 2.944628[1] "transaction_revenue ~ 0 + adstock_grp + onlinespend"[2] "8.35998407799645e-05"[1] 11961.75[1] "transaction_revenue ~ 0 + adstock_audience_1 + onlinespend"[2] "-0.00122689276229803"[1] -815.0672[1] "entrances ~ 0 + totalspend + onlinespend"[2] "0.208800240724921"[1] 4.789267[1] "entrances ~ 0 + adstock_cost + onlinespend"[2] "0.125126577977185"[1] 7.991907[1] "entrances ~ 0 + adstock_grp + onlinespend"[2] "4.63983450307804e-05"[1] 21552.49[1] "entrances ~ 0 + adstock_audience_1 + onlinespend"[2] "0.000427115789450672"[1] 2341.285
  16.  
  17. Calculating data for NL E-commerce conversion...[1] "transaction_revenue ~ 0 + totalspend + onlinespend"[2] "4.47365700996446"[1] 0.2235308[1] "transaction_revenue ~ 0 + adstock_cost + onlinespend"[2] "2.68550619038785"[1] 0.3723693[1] NA[1] "Warning! Column in the dataframe contains only NA values, assinged 0 to correlation coefficient"[1] "transaction_revenue ~ 0 + adstock_audience_1 + onlinespend"[2] "0.000338650044637514"[1] 2952.901[1] "entrances ~ 0 + totalspend + onlinespend"[2] "0.390127188476018"[1] 2.563267[1] "entrances ~ 0 + adstock_cost + onlinespend"[2] "0.228240497931919"[1] 4.381343[1] NA[1] "Warning! Column in the dataframe contains only NA values, assinged 0 to correlation coefficient"[1] "entrances ~ 0 + adstock_audience_1 + onlinespend"[2] "7.37702310558345e-05"[1] 13555.6
  18.  
  19. Calculating data for DE E-commerce conversion...[1] "transaction_revenue ~ 0 + totalspend + onlinespend"[2] "0.440764139305457"[1] 2.268787[1] "transaction_revenue ~ 0 + adstock_cost + onlinespend"[2] "0.216904501117692"[1] 4.610324[1] NA[1] "Warning! Column in the dataframe contains only NA values, assinged 0 to correlation coefficient"[1] "transaction_revenue ~ 0 + adstock_audience_1 + onlinespend"[2] "0.00081001613776333"[1] 1234.543[1] "entrances ~ 0 + totalspend + onlinespend"[2] "0.198465934295547"[1] 5.038648[1] "entrances ~ 0 + adstock_cost + onlinespend"[2] "0.0992853575870227"[1] 10.07198[1] NA[1] "Warning! Column in the dataframe contains only NA values, assinged 0 to correlation coefficient"[1] "entrances ~ 0 + adstock_audience_1 + onlinespend"[2] "0.000114185435707769"[1] 8757.684
  20.  
  21. Calculating data for IT E-commerce conversion...[1] "transaction_revenue ~ 0 + totalspend + onlinespend"[2] "0.854609960378162"[1] 1.170124[1] "transaction_revenue ~ 0 + adstock_cost + onlinespend"[2] "0.518110160395567"[1] 1.930091[1] NA[1] "Warning! Column in the dataframe contains only NA values, assinged 0 to correlation coefficient"[1] "transaction_revenue ~ 0 + adstock_audience_1 + onlinespend"[2] "0.000179973863299071"[1] 5556.362[1] "entrances ~ 0 + totalspend + onlinespend"[2] "0.190535560228373"[1] 5.248364[1] "entrances ~ 0 + adstock_cost + onlinespend"[2] "0.102348330806945"[1] 9.770555[1] NA[1] "Warning! Column in the dataframe contains only NA values, assinged 0 to correlation coefficient"[1] "entrances ~ 0 + adstock_audience_1 + onlinespend"[2] "7.20571955597838e-05"[1] 13877.86
  22.  
  23. Calculating data for ES E-commerce conversion...[1] "transaction_revenue ~ 0 + totalspend + onlinespend"[2] "0.241259159546249"[1] 4.14492[1] "transaction_revenue ~ 0 + adstock_cost + onlinespend"[2] "0.644242448924119"[1] 1.552211[1] NA[1] "Warning! Column in the dataframe contains only NA values, assinged 0 to correlation coefficient"[1] "transaction_revenue ~ 0 + adstock_audience_1 + onlinespend"[2] "0.00177006990094409"[1] 564.9494[1] "entrances ~ 0 + totalspend + onlinespend"[2] "0.0950918915024299"[1] 10.51614[1] "entrances ~ 0 + adstock_cost + onlinespend"[2] "0.064448686167582"[1] 15.51622[1] NA[1] "Warning! Column in the dataframe contains only NA values, assinged 0 to correlation coefficient"[1] "entrances ~ 0 + adstock_audience_1 + onlinespend"[2] "0.000205885230950094"[1] 4857.075
  24.  
  25. Calculating data for PT E-commerce conversion...[1] "transaction_revenue ~ 0 + totalspend + onlinespend"[2] "0.401043768618977"[1] 2.493493[1] "transaction_revenue ~ 0 + adstock_cost + onlinespend"[2] "0.169635939031908"[1] 5.894977[1] NA[1] "Warning! Column in the dataframe contains only NA values, assinged 0 to correlation coefficient"[1] "transaction_revenue ~ 0 + adstock_audience_1 + onlinespend"[2] "2.37893698452362e-05"[1] 42035.58[1] "entrances ~ 0 + totalspend + onlinespend"[2] "0.0674563564112986"[1] 14.8244[1] "entrances ~ 0 + adstock_cost + onlinespend"[2] "0.0342005329720064"[1] 29.23931[1] NA[1] "Warning! Column in the dataframe contains only NA values, assinged 0 to correlation coefficient"[1] "entrances ~ 0 + adstock_audience_1 + onlinespend"[2] "3.25594844225333e-06"[1] 307130.2
  26.  
  27. Calculating data for BN E-commerce conversion...[1] "transaction_revenue ~ 0 + totalspend + onlinespend"[2] "1.4801641345453"[1] 0.6756008[1] "transaction_revenue ~ 0 + adstock_cost + onlinespend"[2] "0.957498056402011"[1] 1.044389[1] NA[1] "Warning! Column in the dataframe contains only NA values, assinged 0 to correlation coefficient"[1] "transaction_revenue ~ 0 + adstock_audience_1 + onlinespend"[2] "0.00477570260588959"[1] 209.3933[1] "entrances ~ 0 + totalspend + onlinespend"[2] "0.0941086770053325"[1] 10.62601[1] "entrances ~ 0 + adstock_cost + onlinespend"[2] "0.0589982756225164"[1] 16.94965[1] NA[1] "Warning! Column in the dataframe contains only NA values, assinged 0 to correlation coefficient"[1] "entrances ~ 0 + adstock_audience_1 + onlinespend"[2] "0.000326507719655493"[1] 3062.715
  28.  
  29. Calculating data for IE E-commerce conversion...[1] "transaction_revenue ~ 0 + totalspend + onlinespend"[2] "-0.0655532101279627"[1] -15.25478[1] "transaction_revenue ~ 0 + adstock_cost + onlinespend"[2] "-0.397491305645564"[1] -2.515778[1] NA[1] "Warning! Column in the dataframe contains only NA values, assinged 0 to correlation coefficient"[1] "transaction_revenue ~ 0 + adstock_audience_1 + onlinespend"[2] "-0.000736722160073606"[1] -1357.364[1] "entrances ~ 0 + totalspend + onlinespend"[2] "0.0871684371222361"[1] 11.47204[1] "entrances ~ 0 + adstock_cost + onlinespend"[2] "0.0479967891590988"[1] 20.83473[1] NA[1] "Warning! Column in the dataframe contains only NA values, assinged 0 to correlation coefficient"[1] "entrances ~ 0 + adstock_audience_1 + onlinespend"[2] "-0.000119262432401848"[1] -8384.87
  30.  
  31. Calculating data for CH E-commerce conversion...[1] "transaction_revenue ~ 0 + totalspend + onlinespend"[2] "1.44655893537915"[1] 0.6912957[1] "transaction_revenue ~ 0 + adstock_cost + onlinespend"[2] "1.67740632827442"[1] 0.5961585[1] NA[1] "Warning! Column in the dataframe contains only NA values, assinged 0 to correlation coefficient"[1] "transaction_revenue ~ 0 + adstock_audience_1 + onlinespend"[2] "0.00132023940879054"[1] 757.4384[1] "entrances ~ 0 + totalspend + onlinespend"[2] "0.0820710208330773"[1] 12.18457[1] "entrances ~ 0 + adstock_cost + onlinespend"[2] "0.0635758761641266"[1] 15.72924[1] NA[1] "Warning! Column in the dataframe contains only NA values, assinged 0 to correlation coefficient"[1] "entrances ~ 0 + adstock_audience_1 + onlinespend"[2] "4.20858189412791e-05"[1] 23760.97There were 50 or more warnings (use warnings() to see the first 50)Error: Total duration of 210.14 minutes longer than 150 minutes[2019-11-19 22:27:00] Done in 210.14 minutesweb-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$[1] "Warning! Column in the dataframe contains only NA values, assinged 0 to correlation coefficient"[1] "entrances ~ 0 + adstock_audience_1 + onlinespend"[2] "4.20858189412791e-05"[1] 23760.97There were 50 or more warnings (use warnings() to see the first 50)Error: Total duration of 210.14 minutes longer than 150 minutes[2019-11-19 22:27:00] Done in 210.14 minutes[2] "0.0635758761641266"[1] 15.72924[1] NA[1] "Warning! Column in the dataframe contains only NA values, assinged 0 to correlation coefficient"[1] "entrances ~ 0 + adstock_audience_1 + onlinespend"[2] "4.20858189412791e-05"[1] 23760.97There were 50 or more warnings (use warnings() to see the first 50)Error: Total duration of 210.14 minutes longer than 150 minutes[2019-11-19 22:27:00] Done in 210.14 minutesweb-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$[1] "entrances ~ 0 + adstock_cost + onlinespend"[2] "0.0635758761641266"[1] 15.72924[1] NA[1] "Warning! Column in the dataframe contains only NA values, assinged 0 to correlation coefficient"[1] "entrances ~ 0 + adstock_audience_1 + onlinespend"[2] "4.20858189412791e-05"[1] 23760.97There were 50 or more warnings (use warnings() to see the first 50)Error: Total duration of 210.14 minutes longer than 150 minutes[2019-11-19 22:27:00] Done in 210.14 minutesweb-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$web-user@dmp:/var/www/html/data-management-platform$[1] "Warning! Column in the dataframe contains only NA values, assinged 0 to correlation coefficient"[1] "transaction_revenue ~ 0 + adstock_audience_1 + onlinespend"[2] "0.00132023940879054"[1] 757.4384[1] "entrances ~ 0 + totalspend + onlinespend"[2] "0.0820710208330773"[1] 12.18457[1] "entrances ~ 0 + adstock_cost + onlinespend"[2] "0.0635758761641266"[1] 15.72924[1] NA[1] "Warning! Column in the dataframe contains only NA values, assinged 0 to correlation coefficient"[1] "entrances ~ 0 + adstock_audience_1 + onlinespend"[2] "4.20858189412791e-05"[1] 23760.97There were 50 or more warnings (use warnings() to see the first 50)Error: Total duration of 210.14 minutes longer than 150 minutes[2019-11-19 22:27:00] Done in 210.14 minutes
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top