Hi all,
I have a question regarding an AJAX Function. It is at the below.
function setJsonSer(){
formData = {
'Email': 'clientlink@russell.com',
'Password': 'russell1234',
'URL': getVaria()
};
$.ajax({
url: "/APIWebService.asmx/AnalyticsDataShowWithPost",
type: 'POST',
data: formData,
complete: function(data) {
alert("This is Set JSON In "+JSON.stringify(data));
}
});
$.ajax({
url: "/APIWebService.asmx/AnalyticsDataShowWithPost",
type: 'GET',
data: formData,
complete: function(data) {
alert("This is Get JSON Out "+JSON.stringify(data));
}
});
}
Above function setJsonSer() generate a JSON string according to aQueryString from Google Analytics. The JSON String creation is ok and it will display using an alert statement like in the below
alert("This is Set JSON In "+JSON.stringify(data));
If it's displaying correctly means that it is giving me the correct JSON value. So now I want to not to alert that value but to pass to a variable that resides outside of that SetJsonSer() function.
Look at the following code snippet. In there rowData variable is used to set the JSON response. But that response is static. What I wanted to do is get 2 dates from a HTML form and pass them to to an Analytics Query and according to that query build the JSON response and pass that response to rowData variable.
Update
Below resides the complete JavaScript code block.
function retStartDate(){
var strStartDate = document.getElementById("from_date").value;
return strStartDate;
}
function retEndDate(){
var strEndDate = document.getElementById("to_date").value;
return strEndDate;
}
function getVaria(){
var strWsUrl = 'https://www.googleapis.com/analytics/v3/data/ga?ids=ga%3A76546294&dimensions=ga%3Asource&metrics=ga%3Ausers&filters=ga%3Asource!%3D(direct)&sort=-ga%3Ausers&start-date= ' + retStartDate() + ' &end-date= ' + retEndDate() + ' &max-results=10';
return strWsUrl;
}
function setJsonSer() {
formData = {
'Email': 'clientlink@russell.com',
'Password': 'russell1234',
'URL': getVaria()
};
$.ajax({
url: "/APIWebService.asmx/AnalyticsDataShowWithPost",
type: 'POST',
data: formData,
complete: function(data) {
alert("This is Set JSON In "+JSON.stringify(data));
}
});
$.ajax({
url: "/APIWebService.asmx/AnalyticsDataShowWithPost",
type: 'GET',
data: formData,
complete: function(data) {
alert("This is Get JSON Out "+JSON.stringify(data));
}
});
}
function BarChart(inData) {
var labels = new Array();
var values = new Array();
for (var key in inData.rows) {
var dt = new Array();
dt[0] = parseInt(inData.rows[key][1]);
var jsRow = { name: inData.rows[key][0], data: dt };
labels[key] = jsRow;
}
$(function () {
$('#container').highcharts({
chart: {
type: 'column'
},
title: {
text: 'Which Source brought more users?'
},
subtitle: {
text: 'Source: Google Analytics'
},
xAxis: {
categories: ['Source'],
title: {
text: null
}
},
yAxis: {
min: 0,
title: {
text: 'Number of Users',
align: 'high'
},
labels: {
overflow: 'justify'
}
},
tooltip: {
valueSuffix: null
},
plotOptions: {
bar: {
dataLabels: {
enabled: true
}
}
},
legend: {
layout: 'vertical',
align: 'right',
verticalAlign: 'top',
x: -40,
y: 100,
floating: true,
borderWidth: 1,
backgroundColor: '#FFFFFF',
shadow: true
},
credits: {
enabled: false
},
series: labels
});
});
}
google.load('visualization', '1', { packages: ['table'] });
google.load("visualization", "1", { packages: ["corechart"] });
function Load(){
var labels = new Array();
var values = new Array();
var catogories = new Array();
var arrayOfArray = new Array();
var rowData =
'{"kind":"analytics#gaData","id":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:date&metrics=ga:uniquePageviews,ga:bounces&start-date=2014-01-01&end-date=2014-04-25","query":{"start-date":"2014-01-01","end-date":"2014-04-25","ids":"ga:76546294","dimensions":"ga:date","metrics":["Unique Page views","Bounces"],"start-index":1,"max-results":1000},"itemsPerPage":1000,"totalResults":115,"selfLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:date&metrics=ga:uniquePageviews,ga:bounces&start-date=2014-01-01&end-date=2014-04-25","profileInfo":{"profileId":"76546294","accountId":"289147","webPropertyId":"UA-289147-1","internalWebPropertyId":"456104","profileName":"US - Institutional Investors - NP Microsite","tableId":"ga:76546294"},"containsSampledData":false,"columnHeaders":[{"name":"ga:date","columnType":"DIMENSION","dataType":"STRING"},{"name":"ga:uniquePageviews","columnType":"METRIC","dataType":"INTEGER"},{"name":"ga:bounces","columnType":"METRIC","dataType":"INTEGER"}],"totalsForAllResults":{"ga:uniquePageviews":"2663","ga:bounces":"1048"},"rows":[["20140101","75","60"],["20140102","173","108"],["20140103","98","76"],["20140104","1","1"],["20140105","4","2"],["20140106","14","8"],["20140107","11","7"],["20140108","23","10"],["20140109","21","5"],["20140110","45","4"],["20140111","24","0"],["20140112","5","2"],["20140113","33","4"],["20140114","41","7"],["20140115","25","9"],["20140116","16","7"],["20140117","19","8"],["20140118","9","5"],["20140119","7","2"],["20140120","5","5"],["20140121","25","6"],["20140122","15","11"],["20140123","42","3"],["20140124","2","2"],["20140125","2","1"],["20140126","4","1"],["20140127","23","6"],["20140128","16","3"],["20140129","39","8"],["20140130","9","6"],["20140131","18","7"],["20140201","6","6"],["20140202","5","3"],["20140203","31","15"],["20140204","21","7"],["20140205","43","6"],["20140206","19","6"],["20140207","25","7"],["20140208","4","2"],["20140209","5","2"],["20140210","21","9"],["20140211","20","8"],["20140212","18","11"],["20140213","17","7"],["20140214","5","4"],["20140215","3","2"],["20140216","6","2"],["20140217","8","5"],["20140218","35","10"],["20140219","20","13"],["20140220","14","9"],["20140221","19","6"],["20140222","20","4"],["20140223","6","3"],["20140224","20","10"],["20140225","53","9"],["20140226","20","9"],["20140227","42","12"],["20140228","34","8"],["20140301","5","4"],["20140302","11","7"],["20140303","16","9"],["20140304","20","5"],["20140305","25","7"],["20140306","26","11"],["20140307","38","10"],["20140308","10","3"],["20140309","10","5"],["20140310","21","7"],["20140311","17","9"],["20140312","17","6"],["20140313","46","10"],["20140314","33","6"],["20140315","13","4"],["20140316","27","9"],["20140317","19","10"],["20140318","38","15"],["20140319","19","7"],["20140320","22","11"],["20140321","34","17"],["20140322","2","1"],["20140323","12","3"],["20140324","42","8"],["20140325","30","7"],["20140326","21","8"],["20140327","64","36"],["20140328","24","5"],["20140329","25","1"],["20140330","16","2"],["20140331","55","4"],["20140401","37","12"],["20140402","42","17"],["20140403","37","23"],["20140404","40","13"],["20140405","15","3"],["20140406","12","8"],["20140407","23","11"],["20140408","20","11"],["20140409","18","9"],["20140410","21","9"],["20140411","27","18"],["20140412","4","4"],["20140413","7","6"],["20140414","12","6"],["20140415","27","9"],["20140416","28","9"],["20140417","18","13"],["20140418","10","3"],["20140419","3","3"],["20140420","5","3"],["20140421","26","9"],["20140422","28","6"],["20140423","27","2"],["20140424","17","6"],["20140425","17","9"]]}'
inData = JSON.parse(rowData);
var count = 0;
var headers = new Array();
for (var i = 0; i < inData.columnHeaders.length; i++) {
headers[i] = inData.columnHeaders[i].name;
}
var dates = new Array();
var pageViews = new Array();
var uniqueViews = new Array();
for (var key in inData.rows) {
dates[key] = inData.rows[key][0];
pageViews[key] = parseInt(inData.rows[key][1]);
uniqueViews[key] = parseInt(inData.rows[key][2]);
}
$('#c>5 Pages","columnType":"METRIC","dataType":"INTEGER"},{"name":">5 Mins","columnType":"METRIC","dataType":"INTEGER"}],"totalsForAllResults":{"PDF Downloads":"219","Video views":"47",">5 Pages":"71",">5 Mins":"120"},"rows":[["banner","0","8","0","0","0"],["cpc","2","36","6","9","16"],["email","0","2","3","0","2"],["organic","1","69","13","8","28"],["ppcads","1","16","2","4","10"],["referral","1","88","23","50","64"],["social","0","0","0","0","0"]]}';
inData = JSON.parse(rowData);
var count = 0;
var headers = new Array();
for (var i = 1; i < inData.columnHeaders.length;i++) {
headers[i - 1] = inData.columnHeaders[i].name;
}
for (var key in inData.rows) {
var dt = new Array();
dt[0] = parseInt(inData.rows[key][1]);
dt[1] = parseInt(inData.rows[key][2]);
dt[2] = parseInt(inData.rows[key][3]);
arrayOfArray[count] = dt;
catogories[count] = inData.rows[key][0];
count++
}
var dynamicArray = new Array();
for (var i = 0; i < headers.length; i++) {
var temp = new Array();
for (var c = 0; c < arrayOfArray.length; c++) {
temp[c] = arrayOfArray[c][i];
}
dynamicArray[i] = temp;
}
var js>{series.name}</span>: {point.y} ({point.percentage:.0f}%)<br/>',
shared: true
},
plotOptions: {
column: {
stacking: 'percent'
}
},
series:
jsonCollection
});
});
//----------------------------------------------- Faahika
//<!-- Which Source/Medium brought more users? - data for column chart-->
var jsonData = {"kind":"analytics#gaData","id":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:source&metrics=ga:users&sort=-ga:users&filters=ga:source!%3D(direct)&start-date=2014-01-01&end-date=2014-04-25&max-results=10","query":{"start-date":"2014-01-01","end-date":"2014-04-25","ids":"ga:76546294","dimensions":"ga:source","metrics":["ga:users"],"sort":["-ga:users"],"filters":"ga:source!=(direct)","start-index":1,"max-results":10},"itemsPerPage":10,"totalResults":30,"selfLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:source&metrics=ga:users&sort=-ga:users&filters=ga:source!%3D(direct)&start-date=2014-01-01&end-date=2014-04-25&max-results=10","nextLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:source&metrics=ga:users&sort=-ga:users&filters=ga:source!%3D(direct)&start-date=2014-01-01&end-date=2014-04-25&start-index=11&max-results=10","profileInfo":{"profileId":"76546294","accountId":"289147","webPropertyId":"UA-289147-1","internalWebPropertyId":"456104","profileName":"US - Institutional Investors - NP Microsite","tableId":"ga:76546294"},"containsSampledData":true,"sampleSize":"1360","sampleSpace":"1666","columnHeaders":[{"name":"ga:source","columnType":"DIMENSION","dataType":"STRING"},{"name":"ga:users","columnType":"METRIC","dataType":"INTEGER"}],"totalsForAllResults":{"ga:users":"1244"},"rows":[["google","579"],["dianomi.com","277"],["russell.com","197"],["AdsByVSW","110"],["iimagazine.verticalsearchworks.com","11"],["bing","10"],["semalt.com","9"],["Eloqua","7"],["fiduciary-matters.russell.com","7"],["semalt.semalt.com","5"]]};
//<!--Unique visitors-->
//<!-- https://www.googleapis.com/analytics/v3/data/ga?ids=ga%3A76546294&metrics=ga%3AnewUsers&start-date=2014-01-01&end-date=2014-04-25 -->
var UniqueVisitors= {"kind":"analytics#gaData","id":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&metrics=ga:newUsers&start-date=2014-01-01&end-date=2014-04-25","query":{"start-date":"2014-01-01","end-date":"2014-04-25","ids":"ga:76546294","metrics":["ga:newUsers"],"start-index":1,"max-results":10},"itemsPerPage":10,"totalResults":1,"selfLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&metrics=ga:newUsers&start-date=2014-01-01&end-date=2014-04-25","profileInfo":{"profileId":"76546294","accountId":"289147","webPropertyId":"UA-289147-1","internalWebPropertyId":"456104","profileName":"US - Institutional Investors - NP Microsite","tableId":"ga:76546294"},"containsSampledData":false,"columnHeaders":[{"name":"ga:newUsers","columnType":"METRIC","dataType":"INTEGER"}],"totalsForAllResults":{"ga:newUsers":"1330"},"rows":[["1330"]]};
//<!--Nurture Activities-->
//<!--https://www.googleapis.com/analytics/v3/data/ga?ids=ga%3A76546294&metrics=ga%3Agoal8Completions%2Cga%3Agoal4Completions%2Cga%3Agoal5Completions%2Cga%3Agoal7Completions%2Cga%3Agoal6Completions&start-date=2014-01-01&end-date=2014-04-25-->
var NurtureActivities= '{"kind":"analytics#gaData","id":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&metrics=ga:goal8Completions,ga:goal4Completions,ga:goal5Completions,ga:goal7Completions,ga:goal6Completions&start-date=2014-01-01&end-date=2014-04-25","query":{"start-date":"2014-01-01","end-date":"2014-04-25","ids":"ga:76546294","metrics":["ga:goal8Completions","ga:goal4Completions","ga:goal5Completions","ga:goal7Completions","ga:goal6Completions"],"start-index":1,"max-results":1000},"itemsPerPage":1000,"totalResults":1,"selfLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&metrics=ga:goal8Completions,ga:goal4Completions,ga:goal5Completions,ga:goal7Completions,ga:goal6Completions&start-date=2014-01-01&end-date=2014-04-25","profileInfo":{"profileId":"76546294","accountId":"289147","webPropertyId":"UA-289147-1","internalWebPropertyId":"456104","profileName":"US - Institutional Investors - NP Microsite","tableId":"ga:76546294"},"containsSampledData":false,"columnHeaders":[{"name":"ga:goal8Completions","columnType":"METRIC","dataType":"INTEGER"},{"name":"ga:goal4Completions","columnType":"METRIC","dataType":"INTEGER"},{"name":"ga:goal5Completions","columnType":"METRIC","dataType":"INTEGER"},{"name":"ga:goal7Completions","columnType":"METRIC","dataType":"INTEGER"},{"name":"ga:goal6Completions","columnType":"METRIC","dataType":"INTEGER"}],"totalsForAllResults":{"ga:goal8Completions":"8","ga:goal4Completions":"247","ga:goal5Completions":"61","ga:goal7Completions":"87","ga:goal6Completions":"143"},"rows":[["8","247","61","87","143"]]}';
//<!--Channels for Nurture Activities-->
//<!--https://www.googleapis.com/analytics/v3/data/ga?ids=ga%3A76546294&dimensions=ga%3Amedium&metrics=ga%3Agoal8Completions%2Cga%3Agoal4Completions%2Cga%3Agoal5Completions%2Cga%3Agoal7Completions%2Cga%3Agoal6Completions&filters=ga%3Amedium!%3D(not%20set)%3Bga%3Amedium!%3D(none)&start-date=2014-01-01&end-date=2014-04-25&max-results=12-->
var ChannelNurtureActivities= '{"kind":"analytics#gaData","id":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:medium&metrics=ga:goal8Completions,ga:goal4Completions,ga:goal5Completions,ga:goal7Completions,ga:goal6Completions&filters=ga:medium!%3D(not+set);ga:medium!%3D(none)&start-date=2014-01-01&end-date=2014-04-25&max-results=12","query":{"start-date":"2014-01-01","end-date":"2014-04-25","ids":"ga:76546294","dimensions":"ga:medium","metrics":["ga:goal8Completions","ga:goal4Completions","ga:goal5Completions","ga:goal7Completions","ga:goal6Completions"],"filters":"ga:medium!=(not set);ga:medium!=(none)","start-index":1,"max-results":12},"itemsPerPage":12,"totalResults":7,"selfLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:medium&metrics=ga:goal8Completions,ga:goal4Completions,ga:goal5Completions,ga:goal7Completions,ga:goal6Completions&filters=ga:medium!%3D(not+set);ga:medium!%3D(none)&start-date=2014-01-01&end-date=2014-04-25&max-results=12","profileInfo":{"profileId":"76546294","accountId":"289147","webPropertyId":"UA-289147-1","internalWebPropertyId":"456104","profileName":"US - Institutional Investors - NP Microsite","tableId":"ga:76546294"},"containsSampledData":false,"columnHeaders":[{"name":"ga:medium","columnType":"DIMENSION","dataType":"STRING"},{"name":"ga:goal8Completions","columnType":"METRIC","dataType":"INTEGER"},{"name":"ga:goal4Completions","columnType":"METRIC","dataType":"INTEGER"},{"name":"ga:goal5Completions","columnType":"METRIC","dataType":"INTEGER"},{"name":"ga:goal7Completions","columnType":"METRIC","dataType":"INTEGER"},{"name":"ga:goal6Completions","columnType":"METRIC","dataType":"INTEGER"}],"totalsForAllResults":{"ga:goal8Completions":"5","ga:goal4Completions":"219","ga:goal5Completions":"47","ga:goal7Completions":"71","ga:goal6Completions":"120"},"rows":[["banner","0","8","0","0","0"],["cpc","2","36","6","9","16"],["email","0","2","3","0","2"],["organic","1","69","13","8","28"],["ppcads","1","16","2","4","10"],["referral","1","88","23","50","64"],["social","0","0","0","0","0"]]}';
//<!-- Top Site Referrers-->
//<!--https://www.googleapis.com/analytics/v3/data/ga?ids=ga%3A76546294&dimensions=ga%3Asource&metrics=ga%3Aentrances&filters=ga%3Asource!%3D(direct)%3Bga%3Asource!%3D74.125.225.72&sort=-ga%3Aentrances&start-date=2014-01-01&end-date=2014-04-25&max-results=12-->
var TopSiteReferrers= '{"kind":"analytics#gaData","id":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:source&metrics=ga:entrances&sort=-ga:entrances&filters=ga:source!%3D(direct);ga:source!%3D74.125.225.72&start-date=2014-01-01&end-date=2014-04-25&max-results=12","query":{"start-date":"2014-01-01","end-date":"2014-04-25","ids":"ga:76546294","dimensions":"ga:source","metrics":["ga:entrances"],"sort":["-ga:entrances"],"filters":"ga:source!=(direct);ga:source!=74.125.225.72","start-index":1,"max-results":12},"itemsPerPage":12,"totalResults":31,"selfLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:source&metrics=ga:entrances&sort=-ga:entrances&filters=ga:source!%3D(direct);ga:source!%3D74.125.225.72&start-date=2014-01-01&end-date=2014-04-25&max-results=12","nextLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:source&metrics=ga:entrances&sort=-ga:entrances&filters=ga:source!%3D(direct);ga:source!%3D74.125.225.72&start-date=2014-01-01&end-date=2014-04-25&start-index=13&max-results=12","profileInfo":{"profileId":"76546294","accountId":"289147","webPropertyId":"UA-289147-1","internalWebPropertyId":"456104","profileName":"US - Institutional Investors - NP Microsite","tableId":"ga:76546294"},"containsSampledData":false,"columnHeaders":[{"name":"Source","columnType":"DIMENSION","dataType":"STRING"},{"name":"Entrances","columnType":"METRIC","dataType":"INTEGER"}],"totalsForAllResults":{"ga:entrances":"1447"},"rows":[["google","677"],["russell.com","300"],["dianomi.com","237"],["AdsByVSW","139"],["iimagazine.verticalsearchworks.com","16"],["bing","12"],["Eloqua","8"],["fiduciary-matters.russell.com","7"],["semalt.com","7"],["semalt.semalt.com","6"],["InstitutionalInvestor.com","4"],["FT","3"]]}';
//<!-- Top Campaigns-->
//<!--https://www.googleapis.com/analytics/v3/data/ga?ids=ga%3A76546294&dimensions=ga%3Acampaign&metrics=ga%3Aentrances&filters=ga%3Acampaign!%3D(not%20set)&sort=-ga%3Aentrances&start-date=2014-01-01&end-date=2014-04-25&max-results=12-->
var TopCampaigns= '{"kind":"analytics#gaData","id":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:campaign&metrics=ga:entrances&sort=-ga:entrances&filters=ga:campaign!%3D(not+set)&start-date=2014-01-01&end-date=2014-04-25&max-results=12","query":{"start-date":"2014-01-01","end-date":"2014-04-25","ids":"ga:76546294","dimensions":"ga:campaign","metrics":["ga:entrances"],"sort":["-ga:entrances"],"filters":"ga:campaign!=(not set)","start-index":1,"max-results":12},"itemsPerPage":12,"totalResults":11,"selfLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:campaign&metrics=ga:entrances&sort=-ga:entrances&filters=ga:campaign!%3D(not+set)&start-date=2014-01-01&end-date=2014-04-25&max-results=12","profileInfo":{"profileId":"76546294","accountId":"289147","webPropertyId":"UA-289147-1","internalWebPropertyId":"456104","profileName":"US - Institutional Investors - NP Microsite","tableId":"ga:76546294"},"containsSampledData":false,"columnHeaders":[{"name":"Campaign","columnType":"DIMENSION","dataType":"STRING"},{"name":"Visits","columnType":"METRIC","dataType":"INTEGER"}],"totalsForAllResults":{"ga:entrances":"619"},"rows":[["AI NP OCIO - Search Network","442"],["iimagazine","138"],["AI Fiduciary Solutions - Search Network","17"],["AI_14_03_Institutional-Insights-NP_E","8"],["ai-NP_Question_OS_Provider-201402","7"],["ai-042214-Research-tweet----Nonprofit,-managing-risks","2"],["04320e4ee1-corp-newsletter-20140313","1"],["CEA0214","1"],["ai-042414-Research-tweet----Nonprofit,-managing-risks","1"],["ai-NP_Dynamic_Investing-201402","1"],["corp-LinkedIn updates -20140106","1"]]}';
//<!--Top Keywords-->
//<!--https://www.googleapis.com/analytics/v3/data/ga?ids=ga%3A76546294&dimensions=ga%3Akeyword&metrics=ga%3Aentrances&filters=ga%3Akeyword!%3D(not%20provided)%3Bga%3Akeyword!%3D(not%20set)&sort=-ga%3Aentrances&start-date=2014-01-01&end-date=2014-04-25&max-results=12-->
var TopKeywords='{"kind":"analytics#gaData","id":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:keyword&metrics=ga:entrances&sort=-ga:entrances&filters=ga:keyword!%3D(not+provided);ga:keyword!%3D(not+set)&start-date=2014-01-01&end-date=2014-04-25&max-results=12","query":{"start-date":"2014-01-01","end-date":"2014-04-25","ids":"ga:76546294","dimensions":"ga:keyword","metrics":["ga:entrances"],"sort":["-ga:entrances"],"filters":"ga:keyword!=(not provided);ga:keyword!=(not set)","start-index":1,"max-results":12},"itemsPerPage":12,"totalResults":59,"selfLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:keyword&metrics=ga:entrances&sort=-ga:entrances&filters=ga:keyword!%3D(not+provided);ga:keyword!%3D(not+set)&start-date=2014-01-01&end-date=2014-04-25&max-results=12","nextLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:keyword&metrics=ga:entrances&sort=-ga:entrances&filters=ga:keyword!%3D(not+provided);ga:keyword!%3D(not+set)&start-date=2014-01-01&end-date=2014-04-25&start-index=13&max-results=12","profileInfo":{"profileId":"76546294","accountId":"289147","webPropertyId":"UA-289147-1","internalWebPropertyId":"456104","profileName":"US - Institutional Investors - NP Microsite","tableId":"ga:76546294"},"containsSampledData":false,"columnHeaders":[{"name":"Keyword","columnType":"DIMENSION","dataType":"STRING"},{"name":"Visits","columnType":"METRIC","dataType":"INTEGER"}],"totalsForAllResults":{"ga:entrances":"486"},"rows":[["endowment investment policy","118"],["non profit investment policy","101"],["asset allocation +endowment","56"],["nonprofit investment policy","48"],["foundation investment policy","35"],["investments for non profit organizations","13"],["investment management +non +profit","11"],["nonprofit investment strategy","11"],["asset management +foundation","7"],["asset management +non +profit","7"],["asset allocation +foundation","6"],["asset allocation +non +profit","4"]]}';
//<!--Top 10 Web Pages-->
//<!--https://www.googleapis.com/analytics/v3/data/ga?ids=ga%3A76546294&dimensions=ga%3ApageTitle&metrics=ga%3Apageviews&filters=ga%3ApageTitle!%3D(not%20set)&sort=-ga%3Apageviews&start-date=2014-01-01&end-date=2014-04-25&max-results=12-->
var WebPages={"kind":"analytics#gaData","id":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:pageTitle&metrics=ga:pageviews&sort=-ga:pageviews&filters=ga:pageTitle!%3D(not+set)&start-date=2014-01-01&end-date=2014-04-25&max-results=12","query":{"start-date":"2014-01-01","end-date":"2014-04-25","ids":"ga:76546294","dimensions":"ga:pageTitle","metrics":["ga:pageviews"],"sort":["-ga:pageviews"],"filters":"ga:pageTitle!=(not set)","start-index":1,"max-results":12},"itemsPerPage":12,"totalResults":77,"selfLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:pageTitle&metrics=ga:pageviews&sort=-ga:pageviews&filters=ga:pageTitle!%3D(not+set)&start-date=2014-01-01&end-date=2014-04-25&max-results=12","nextLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:pageTitle&metrics=ga:pageviews&sort=-ga:pageviews&filters=ga:pageTitle!%3D(not+set)&start-date=2014-01-01&end-date=2014-04-25&start-index=13&max-results=12","profileInfo":{"profileId":"76546294","accountId":"289147","webPropertyId":"UA-289147-1","internalWebPropertyId":"456104","profileName":"US - Institutional Investors - NP Microsite","tableId":"ga:76546294"},"containsSampledData":false,"columnHeaders":[{"name":"Page Title","columnType":"DIMENSION","dataType":"STRING"},{"name":"Views","columnType":"METRIC","dataType":"INTEGER"}],"totalsForAllResults":{"ga:pageviews":"3237"},"rows":[["Outsourced CIO (OCIO) for Non-Profits | Russell","1036"],["Outsourced CIO (OCIO) for Non-Profits | Russell Investments","344"],["Benefits of outsourced CIO for your non-profit | Russell","134"],["Resources & research for non-profits | Russell","118"],["Investment strategy research | Russell","100"],["Meet Russell's experienced non-profit team | Russell","96"],["Choosing the right outsourced CIO for your non-profit | Russell","81"],["Investment outsourcing fee basics | Russell Investments","74"],["Governance research | Russell","72"],["Benefits of outsourced CIO for your non-profit | Russell Investments","67"],["Fiscal year 2013 performance drivers – Endowments and Foundations | Russell","65"],["The complete fiduciary: Choosing a provider to share duties | Russell","57"]]};
//<!--Social Networks-->
//<!--https://www.googleapis.com/analytics/v3/data/ga?ids=ga%3A76546294&dimensions=ga%3AsocialNetwork&metrics=ga%3Apageviews&filters=ga%3AsocialNetwork!%3D(not%20set)&start-date=2014-01-01&end-date=2014-04-25&max-results=12-->
var SocialNetworks='{"kind":"analytics#gaData","id":"https:
var ResearchDocuments='{"kind":"analytics#gaData","id":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:eventLabel&metrics=ga:goal4Completions&sort=-ga:goal4Completions&start-date=2014-01-01&end-date=2014-04-25&max-results=10","query":{"start-date":"2014-01-01","end-date":"2014-04-25","ids":"ga:76546294","dimensions":"ga:eventLabel","metrics":["ga:goal4Completions"],"sort":["-ga:goal4Completions"],"start-index":1,"max-results":10},"itemsPerPage":15,"totalResults":37,"selfLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:eventLabel&metrics=ga:goal4Completions&sort=-ga:goal4Completions&start-date=2014-01-01&end-date=2014-04-25&max-results=10","nextLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:eventLabel&metrics=ga:goal4Completions&sort=-ga:goal4Completions&start-date=2014-01-01&end-date=2014-04-25&start-index=16&max-results=10","profileInfo":{"profileId":"76546294","accountId":"289147","webPropertyId":"UA-289147-1","internalWebPropertyId":"456104","profileName":"US - Institutional Investors - NP Microsite","tableId":"ga:76546294"},"containsSampledData":true,"sampleSize":"1360","sampleSpace":"1666","columnHeaders":[{"name":"Document Title","columnType":"DIMENSION","dataType":"STRING"},{"name":"Views","columnType":"METRIC","dataType":"INTEGER"}],"totalsForAllResults":{"ga:goal4Completions":"243"},"rows":[["private-foundation-case-study.pdf","33"],["russell-client-case-study-nonprofit-school.pdf","32"],["fiscal-year-2013-performance-drivers-endowments-and-foundations.pdf","29"],["know-what-you-are-buying.pdf","21"],["drivers-of-investment-management-success-for-non-profit-organizations.pdf","18"],["brochure-non-profit-organizations.pdf","17"],["2014-global-annual-outlook.pdf","16"],["7-key-questions-to-ask-ocio.pdf","12"],["brochure-non-profit-organizations.pdf","10"],["governance-implications-of-ny-non-profit-revitalization-act-.pdf","7"]]}';
var TopVideos='{"kind":"analytics#gaData","id":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:eventLabel&metrics=ga:goal5Completions&sort=-ga:goal5Completions&start-date=2014-01-01&end-date=2014-04-25&max-results=6","query":{"start-date":"2014-01-01","end-date":"2014-04-25","ids":"ga:76546294","dimensions":"ga:eventLabel","metrics":["ga:goal5Completions"],"sort":["-ga:goal5Completions"],"start-index":1,"max-results":6},"itemsPerPage":6,"totalResults":37,"selfLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:eventLabel&metrics=ga:goal5Completions&sort=-ga:goal5Completions&start-date=2014-01-01&end-date=2014-04-25&max-results=6","nextLink":"https://www.googleapis.com/analytics/v3/data/ga?ids=ga:76546294&dimensions=ga:eventLabel&metrics=ga:goal5Completions&sort=-ga:goal5Completions&start-date=2014-01-01&end-date=2014-04-25&start-index=7&max-results=6","profileInfo":{"profileId":"76546294","accountId":"289147","webPropertyId":"UA-289147-1","internalWebPropertyId":"456104","profileName":"US - Institutional Investors - NP Microsite","tableId":"ga:76546294"},"containsSampledData":true,"sampleSize":"1360","sampleSpace":"1666","columnHeaders":[{"name":"Video","columnType":"DIMENSION","dataType":"STRING"},{"name":"Views","columnType":"METRIC","dataType":"INTEGER"}],"totalsForAllResults":{"ga:goal5Completions":"57"},"rows":[["2014 global market outlook","21"],["four questions to ask your outsourced investment provider","17"],["three steps to help you dynamically manage your investment portfolio","12"],["multi-asset solutions: a total portfolio approach","4"],["latest trends among us non-profits","2"],["multi-asset solutions","1"]]}';
BarChart(jsonData);
DrawGoogleTable(NurtureActivities,[0,1,2,3,4],'table_div4',false);
DrawGoogleTable(ChannelNurtureActivities,[1,2],'table_div5',false);
DrawGoogleTable(TopSiteReferrers,[0,1],'table_div6',false);
DrawGoogleTable(TopCampaigns,[0,1],'table_div7',false);
DrawGoogleTable(TopKeywords,[0,1],'table_div8',false);
DrawGoogleTable(WebPages,[0,1],'table_div9',true);
DrawGoogleTable(ResearchDocuments,[0,1],'table_div11',false);
DrawGoogleTable(SocialNetworks,[0,1],'table_div10',false);
DrawGoogleTable(TopVideos,[0,1],'table_div12',false);
}
function drawTable3(tbData) {
var data = new google.visualization.DataTable();
data.addColumn('string', 'Name');
data.addColumn('string', 'Count');
data.addRows(tbData.rows);
var table = new google.visualization.Table(document.getElementById('table_div3'));
table.draw(data, { showRowNumber: false });
}
function DrawGoogleTable(jsText,columnIndex,divId,isJson) {
if(isJson){
inData = jsText
}else{
inData = JSON.parse(jsText);
}
var headers = new Array();
var data = new google.visualization.DataTable();
for (var i = 0; i < columnIndex.length; i++) {
headers[i] = inData.columnHeaders[columnIndex[i]].name;
var type = 'string';
if(inData.columnHeaders[columnIndex[i]].dataType == 'INTEGER')
{ type='number';}
data.addColumn(type,headers[i]);
}
var arrayOfArray = new Array();
data.addRows(inData.rows.length);
for (var key in inData.rows) {
var temp=new Array();
for(var i=0;i<columnIndex.length;i++){
temp[i] = inData.rows[key][columnIndex[i]];
data.setCell(parseInt(key),i,temp[i]);
}
arrayOfArray[key] = temp;
}
var table = new google.visualization.Table(document.getElementById(divId));
table.draw(data, { showRowNumber: false });
}
function drawTable5(tbData) {
var data = new google.visualization.DataTable();
data.addColumn('string', 'Name');
data.addColumn('string', 'Count');
data.addRows(tbData.rows);
var table = new google.visualization.Table(document.getElementById('table_div5'));
table.draw(data, { showRowNumber: false });
}
function drawTable6(tbData) {
var data = new google.visualization.DataTable();
data.addColumn('string', 'Name');
data.addColumn('string', 'Count');
data.addRows(tbData.rows);
var table = new google.visualization.Table(document.getElementById('table_div6'));
table.draw(data, { showRowNumber: false });
}
function drawTable7(tbData) {
var data = new google.visualization.DataTable();
data.addColumn('string', 'Name');
data.addColumn('string', 'Count');
data.addRows(tbData.rows);
var table = new google.visualization.Table(document.getElementById('table_div7'));
table.draw(data, { showRowNumber: false });
}
function drawTable8(tbData) {
var data = new google.visualization.DataTable();
data.addColumn('string', 'Name');
data.addColumn('string', 'Count');
data.addRows(tbData.rows);
var table = new google.visualization.Table(document.getElementById('table_div8'));
table.draw(data, { showRowNumber: false });
}
function drawTable9(tbData) {
var data = new google.visualization.DataTable();
data.addColumn('string', 'Name');
data.addColumn('string', 'Count');
data.addRows(tbData.rows);
var table = new google.visualization.Table(document.getElementById('table_div9'));
table.draw(data, { showRowNumber: false });
}
function drawTable10(tbData) {
var data = new google.visualization.DataTable();
data.addColumn('string', 'Name');
data.addColumn('string', 'Count');
data.addRows(tbData.rows);
var table = new google.visualization.Table(document.getElementById('table_div10'));
table.draw(data, { showRowNumber: false });
}
function drawTable11(tbData) {
var data = new google.visualization.DataTable();
data.addColumn('string', 'Name');
data.addColumn('string', 'Count');
data.addRows(tbData.rows);
var table = new google.visualization.Table(document.getElementById('table_div11'));
table.draw(data, { showRowNumber: false });
}
function drawTable12(tbData) {
var data = new google.visualization.DataTable();
data.addColumn('string', 'Name');
data.addColumn('string', 'Count');
data.addRows(tbData.rows);
var table = new google.visualization.Table(document.getElementById('table_div12'));
table.draw(data, { showRowNumber: false });
}
Using that I can draw a chart using HighCharts JS.
Now I don't know how to do that. So could someone can help me to get out of here please?
Thanks and regards,
Chiranthaka.