<p><strong>NOTE:</strong> Feedback should be send to <code>goran.milovanovic_ext@wikimedia.de</code>.</p>
<p><strong>NOTE:</strong> The campaign will be run from … to … of October 2017.</p>
<!-- rnb-text-end -->
<!-- rnb-chunk-begin -->
<!-- rnb-chunk-end -->
<!-- rnb-text-begin -->
<div id="data-acquisiton" class="section level2">
<h2>0. Data Acquisiton</h2>
<p><strong>NOTE:</strong> the Data Acquisition code chunk is not fully reproducible from this Report. The data are collected by running the script <code>abc2017_PROD_OverallDailyUpdate.R</code> on stat1005.eqiad.wmnet, collecting the data as <code>.tsv</code> and <code>.csv</code> files, copying manually, and processing locally. Run from stat1005 stat box by executing <code>Rscript /home/goransm/RScripts/abc2017/abc2017_PROD_OverallDailyUpdate.R</code>.</p>
### --- loop over date range, create query, fetch, and store
dateRange <- seq(from = as.Date(startDate),
to = as.Date(endDate),
by = 'day')
dateRange <- as.character(dateRange)
# - set outDir
outDir <- bannerClicksDir
# - store query dir:
qDir <- bannerClicksDir
setwd(qDir)
# - set HiveQL query dir:
for (i in 1:length(dateRange)) {
# - construct HiveQL query:
y <- as.numeric(strsplit(dateRange[i], split = "-")[[1]][1])
m <- as.numeric(strsplit(dateRange[i], split = "-")[[1]][2])
d <- as.numeric(strsplit(dateRange[i], split = "-")[[1]][3])
q <- paste(
"USE wmf;
SELECT uri_path, uri_query, referer FROM webrequest
WHERE (uri_host = 'de.wikipedia.org'
AND (uri_path = '/wiki/Wikipedia:Wikimedia_Deutschland/Fehler_korrigieren' OR uri_path = '/wiki/Wikipedia:Wikimedia_Deutschland/Mach_mit' OR uri_path = '/wiki/Spezial:Benutzerkonto_anlegen')
<p>The following three pie charts present a breakdown of referers (i.e. sources) for the Campaign pages (two landing pages and one registration page.</p>
<p>The following chart presents the number of page views for the two landing pages and one registration page during the course of the campaign, and encompassing only page views generated from the campaign.</p>
<p>The <code>Page</code> column refers to either one of the two campaign landing pages or the registration page. The <code>Source</code> column encompasses both campaign banner clicks and campaign pages as referers of the <code>Page</code>. The <code>Count</code> data have a daily resolution.</p>
<p><strong>NOTE:</strong> the following code is not fully reproducible from this Report. The data are collected by running the script <code>abc2017_PROD_GuidedTour.R</code> on stat1005.eqiad.wmnet, collecting the data as <code>.csv</code> files, copying manually, and processing locally.</p>