Created
April 27, 2016 16:37
-
-
Save dotspencer/5f2e6f1dd0173e5692bd21b0374e20e9 to your computer and use it in GitHub Desktop.
Mailchimp Statistics Viewer
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<script src="http://papaparse.com/resources/js/papaparse.js"></script> | |
<input type="file" id="file-input" /> | |
<script type="text/javascript"> | |
var finput = document.getElementById('file-input'); | |
window.onload = function(){ | |
main() | |
} | |
function main(){ | |
var config = { | |
delimiter: ",", // auto-detect | |
newline: "", // auto-detect | |
header: false, | |
dynamicTyping: false, | |
preview: 0, | |
encoding: "", | |
step: undefined, | |
complete: dataLoaded, | |
} | |
function readFile() { | |
var file = finput.files[0]; | |
console.log(file.size); | |
var p = Papa.parse(file, config); | |
} | |
function dataLoaded(results){ | |
var body = document.body; | |
var data = results.data; | |
hide(finput); | |
body.innerHTML = "<button onclick='location.reload()'>Restart</button>" + body.innerHTML | |
body.innerHTML += "<h2>" + data[1][1] + "</h2>"; // Title | |
//body.innerHTML += "<p>" + data[3][1] + "</p>"; // Date | |
body.innerHTML += "<h3>Mailchimp Statistics</h3>"; | |
body.innerHTML += "<p><span class='first'>" + data[6][0] + "</span>" + data[6][1] + "</p>"; // Total Recipents | |
body.innerHTML += "<p><span class='first'>" + data[12][0] + "</span>" + data[12][1] + "</p>"; // Total Opens | |
body.innerHTML += "<p><span class='first'>" + data[15][0] + "</span>" + data[15][1] + "</p>"; // Total Clicks | |
body.innerHTML += "<p><span class='first'>" + data[8][0] + "</span>" + data[8][1] + "</p>"; // Bounced | |
body.innerHTML += "<h3 class='article'>Top Articles</h3>"; | |
body.innerHTML += "<div class='article-wrap'></div>"; | |
var articleWrap = document.getElementsByClassName('article-wrap')[0]; | |
articleWrap.innerHTML += "<span style='margin-bottom: 5px;margin-top:-24px;display: inline-block;'><span class='article' style='padding-right: 0;'></span>Clicks</span>"; | |
for(i = 23; i <= 27; i++){ | |
articleWrap.innerHTML += "<p><span class='article'>" + data[i][0].replace(/\//g, " ").trim().split(" ").pop() + "</span>" + data[i][1] + "</p>"; | |
} | |
body.innerHTML += "<h3 class='article'>All Articles</h3>"; | |
body.innerHTML += "<div class='article-wrap'></div>"; | |
articleWrap = document.getElementsByClassName('article-wrap')[1]; | |
articleWrap.innerHTML += "<span style='margin-bottom: 5px;margin-top:-24px;display: inline-block;'><span class='article' style='padding-right: 0;'></span>Clicks</span>"; | |
for(i = 23; i <= 45; i++){ | |
articleWrap.innerHTML += "<p><span class='article'>" + data[i][0].replace(/\//g, " ").trim().split(" ").pop() + "</span>" + data[i][1] + "</p>"; | |
} | |
} | |
function hide(a){ | |
a.style.display = "none"; | |
} | |
finput.addEventListener("change", readFile); | |
} | |
</script> | |
<style> | |
body{ | |
font-family: Helvetica; | |
} | |
span.first { | |
width: 150px; | |
display: inline-block; | |
} | |
span.article{ | |
width: 400px; | |
display: inline-flex; | |
padding-right: 15px; | |
} | |
h3{ | |
margin-top: 30px; | |
margin-bottom: 10px; | |
} | |
.article-wrap{ | |
display: inline-block; | |
} | |
.article-wrap p { | |
margin: 0; | |
padding: 5px; | |
} | |
.article-wrap p:nth-child(odd) { | |
background-color: whitesmoke; | |
} | |
.article-wrap p:nth-child(even) { | |
background-color: #DCDCDC; | |
} | |
@media print | |
{ | |
#file-input{ | |
display: none; | |
} | |
button{ | |
display: none; | |
} | |
} | |
</style> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment