protected void Page_Load(object sender, EventArgs e)
{
GooglePageBase google = Page as GooglePageBase;
DataQuery query = new DataQuery();
query.Ids = "ga:" + google.Settings.Current.Id;
query.Metrics = "ga:pageviews";
query.Dimensions = "ga:browser,ga:browserVersion";
query.Sort = "ga:browser,ga:pageviews";
query.GAStartDate = DateTime.Now.AddMonths(-1).AddDays(-1).ToString("yyyy-MM-dd");
query.GAEndDate = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
if (google.Referringpage != null)
{
query.Filters = "ga:pagePath==" + google.Referringpage;
}
DataFeed actual = google.Analytics.Query(query);
System.Data.DataTable browsers = new System.Data.DataTable("Browser");
browsers.Columns.Add("Browser");
browsers.Columns.Add("Views", typeof(int));
System.Data.DataTable versions = new System.Data.DataTable("BrowserVersion");
versions.Columns.Add("Browser");
versions.Columns.Add("Version");
versions.Columns.Add("Views", typeof(int));
System.Collections.SortedList values = new System.Collections.SortedList();
foreach (DataEntry entry in actual.Entries)
{
string browser = entry.Dimensions[0].Value.ToString();
string version = entry.Dimensions[1].Value.ToString();
int visits = int.Parse(entry.Metrics[0].Value);
if (values.ContainsKey(browser))
{
int current = int.Parse(values[browser].ToString());
current += int.Parse(entry.Metrics[0].Value);
values[browser] = current;
}
else
{
values.Add(browser, int.Parse(entry.Metrics[0].Value));
}
versions.Rows.Add(new object[] { browser, version, visits });
}
foreach (String key in values.Keys)
{
browsers.Rows.Add(new object[] { key, int.Parse(values[key].ToString()) });
}
this.pie_Browsers.GviEnableEvents = true;
this.pie_Browsers.ChartData(browsers);
this.tbl_Versions.ChartData(versions);
}
protected void Page_Load(object sender, EventArgs e)
{
GooglePageBase google = Page as GooglePageBase;
DataQuery query = new DataQuery();
query.Ids = "ga:" + google.Settings.Current.Id;
query.Metrics = "ga:pageviews";
query.Dimensions = "ga:pagePath,ga:pageTitle";
query.Sort = "-ga:pageviews";
query.NumberToRetrieve = 10;
query.GAStartDate = DateTime.Now.AddDays(-14).ToString("yyyy-MM-dd");
query.GAEndDate = DateTime.Now.AddDays(-2).ToString("yyyy-MM-dd");
DataFeed actual = google.Analytics.Query(query);
System.Data.DataTable dt = new System.Data.DataTable("Browser");
dt.Columns.Add("Path");
dt.Columns.Add("Title");
dt.Columns.Add("Views", typeof(int));
foreach (DataEntry entry in actual.Entries)
{
dt.Rows.Add(new object[] { entry.Dimensions[0].Value, entry.Dimensions[1].Value, int.Parse(entry.Metrics[0].Value) });
}
foreach (DataRow row in dt.Rows)
{
//Response.Write(row["Title"].ToString() + " : " + row["Views"].ToString());
}
//Response.Write(dt.Rows.Count.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
GooglePageBase google = Page as GooglePageBase;
//ltl_ProfileID.Text = google.Settings.Current.ProfileId;
ltl_AccountID.Text = google.Settings.Current.AccountId;
//ltl_Token.Text = google.Settings.Current.Token;
}
protected void Page_Load(object sender, EventArgs e)
{
GooglePageBase google = Page as GooglePageBase;
DataQuery query = new DataQuery();
query.Ids = "ga:" + google.Settings.Current.Id;
query.Metrics = "ga:visits,ga:pageviews";
query.Dimensions = "ga:date";
query.Sort = "ga:date";
query.GAStartDate = DateTime.Now.AddMonths(-1).AddDays(-1).ToString("yyyy-MM-dd");
query.GAEndDate = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
if (google.Referringpage != null)
{
query.Filters = "ga:pagePath==" + google.Referringpage;
}
DataFeed actual = google.Analytics.Query(query);
System.Data.DataTable dt = new System.Data.DataTable("Visits / Page Views");
dt.Columns.Add("Date");
dt.Columns.Add("Visits", typeof(int));
dt.Columns.Add("Page Views", typeof(int));
dt.Columns.Add("Page Views per Visit", typeof(int));
foreach (DataEntry entry in actual.Entries)
{
try
{
string date = entry.Title.Text.Split(new char[] { '=' })[1].ToString();
DateTime datetime = new DateTime(int.Parse(date.Substring(0, 4)), int.Parse(date.Substring(4, 2)), int.Parse(date.Substring(6, 2)));
date = datetime.ToString("yyyy-MM-dd");
int visits = int.Parse(entry.Metrics[0].Value);
int views = int.Parse(entry.Metrics[1].Value);
int viewspervisit = 0;
try
{
viewspervisit = (views / visits);
}
catch (Exception ex)
{
ex.ToString();
}
// entry.Metrics[2].Value;
dt.Rows.Add(new object[] { date, visits, views, viewspervisit });
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
this.area_visits.GviEnableEvents = true;
this.area_visits.ChartData(dt);
}
protected void Page_Load(object sender, EventArgs e)
{
google = Page as GooglePageBase;
if (!Page.IsPostBack)
{
SetNotice();
}
}
protected void Page_Load(object sender, EventArgs e)
{
GooglePageBase google = Page as GooglePageBase;
DataQuery query = new DataQuery();
query.Ids = "ga:" + google.Settings.Current.Id;;
query.Metrics = "ga:visits,ga:pageviews,ga:timeOnSite,ga:exits";
query.Dimensions = "ga:source,ga:medium";
query.Sort = "-ga:visits";
query.GAStartDate = DateTime.Now.AddMonths(-1).AddDays(-1).ToString("yyyy-MM-dd");
query.GAEndDate = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
if (google.Referringpage != null)
{
query.Filters = "ga:pagePath==" + google.Referringpage;
}
DataFeed actual = google.Analytics.Query(query);
System.Data.DataTable dt = new System.Data.DataTable("Usage");
dt.Columns.Add("Visits", typeof(int));
dt.Columns.Add("Page Views", typeof(int));
dt.Columns.Add("Time On Site", typeof(int));
dt.Columns.Add("Exits", typeof(int));
dt.Columns.Add("Source"); //, typeof(int));
dt.Columns.Add("Medium"); //, typeof(int));
foreach (DataEntry entry in actual.Entries)
{
try
{
int visits = int.Parse(entry.Metrics[0].Value);
int pageviews = int.Parse(entry.Metrics[1].Value);
float timeOnSite = float.Parse(entry.Metrics[2].Value);
int exits = int.Parse(entry.Metrics[3].Value);
string source = entry.Dimensions[0].Value.ToString();
string medium = entry.Dimensions[1].Value.ToString();
dt.Rows.Add(new object[] { visits, pageviews, timeOnSite, exits, source, medium });
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
this.tbl_Usage.ChartData(dt);
}
protected void Page_Load(object sender, EventArgs e)
{
google = Page as GooglePageBase;
{
if (google.Referringpage != null)
{
previousDT.Columns.Add("Source");
previousDT.Columns.Add("Target"); //, typeof(int));
previousDT.Columns.Add("Title"); //, typeof(int));
nextDT.Columns.Add("Source");
nextDT.Columns.Add("Target"); //, typeof(int));
nextDT.Columns.Add("Title"); //, typeof(int));
try
{
previousDT.Rows.Add(new object[] { "(entrance)", "", "(entrance)" });
nextDT.Rows.Add(new object[] { "(entrance)", "", "(entrance)" });
SPSite site = SPContext.Current.Site;
SPWeb web = site.OpenWeb(google.Referringpage);
root = web.GetListItem(google.Referringpage);
//string serverRelativeListItemUrl = SPUrlUtility.CombineUrl(SPContext.Current.Site.RootWeb.ServerRelativeUrl,google.Referringpage);
//root = SPContext.Current.Site.RootWeb.GetListItem(serverRelativeListItemUrl);
//dt.Rows.Add(new object[] { root.Title, SPContext.Current.Site.PortalName, root.Title });
previousDT.Rows.Add(new object[] { root.Title, "(entrance)", root.Title });
}
catch (Exception ex)
{
Response.Write("Root" + ex.ToString());
}
GetNext();
this.org_tracking_next.ChartData(nextDT);
GetPrevious();
this.org_tracking_prev.ChartData(previousDT);
this.tbl_Tracking.ChartData(nextDT);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
google = Page as GooglePageBase;
try
{
//dimensions=ga:operatingSystem,ga:operatingSystemVersion,ga:browser,ga:browserVersion
//metrics=ga:visits
DataQuery query = new DataQuery();
query.Ids = "ga:" + google.Settings.Current.Id;;
query.Dimensions = "ga:operatingSystem,ga:operatingSystemVersion";
query.Metrics = "ga:visits";
query.Sort = "-ga:visits";
query.GAStartDate = DateTime.Now.AddMonths(-1).AddDays(-1).ToString("yyyy-MM-dd");
query.GAEndDate = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
if (google.Referringpage != null)
{
query.Filters = "ga:pagePath==" + google.Referringpage;
}
DataFeed actual = google.Analytics.Query(query);
System.Data.DataTable dt = new System.Data.DataTable("Operating Systems");
dt.Columns.Add("Operating System");
dt.Columns.Add("System Version");
dt.Columns.Add("Visits", typeof(int));
foreach (DataEntry entry in actual.Entries)
{
int visits = int.Parse(entry.Metrics[0].Value);
string os = entry.Dimensions[0].Value.ToString();
string osVersion = entry.Dimensions[1].Value.ToString();
dt.Rows.Add(new object[] { os, osVersion, visits });
}
this.tbl_OS.ChartData(dt);
}
catch (Exception ex)
{
ex.ToString();
//TextBox1.Text = ex.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
google = Page as GooglePageBase;
if (google.Settings.Analytics.Length == 0 && !String.IsNullOrEmpty(google.Settings.Username) && !string.IsNullOrEmpty(google.Settings.Password))
{
ReloadAnalytics();
}
if (google.Settings.WebmasterTools.Length == 0 && !String.IsNullOrEmpty(google.Settings.Username) && !string.IsNullOrEmpty(google.Settings.Password))
{
ReloadWebmasterTools();
}
if (!Page.IsPostBack)
{
foreach (GoogleAnalyticsSettings analytics in google.Settings.Analytics)
{
if (SPContext.Current.Site.HostName == analytics.WebsiteUrl)
{
tbx_Hostname.Text = analytics.Name;
tbx_AccountId.Text = analytics.AccountId;
//tbx_ProfileId.Text = analytics.ProfileId;
//tbx_Token.Text = analytics.Token;
cbx_Active.Checked = analytics.Active;
cbx_ClientInfo.Checked = analytics.ClientInfo;
cbx_Flash.Checked = analytics.DetectFlash;
cbx_Hash.Checked = analytics.AllowHash;
cbx_Linker.Checked = analytics.AllowLinker;
cbx_Title.Checked = analytics.DetectTitle;
ddl_Google_Account_Profiles.Items.Add(new ListItem(analytics.Name, analytics.WebPropertyId, true));
ddl_Google_Account_Profiles.SelectedValue = analytics.WebPropertyId;
}
else
{
ddl_Google_Account_Profiles.Items.Add(new ListItem(analytics.Name, analytics.WebPropertyId));
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
GooglePageBase google = Page as GooglePageBase;
DataQuery query = new DataQuery();
query.Ids = "ga:" + google.Settings.Current.Id;
query.Metrics = "ga:visits";
query.Dimensions = "ga:date";
query.Sort = "ga:medium==(none)";
query.GAStartDate = DateTime.Now.AddMonths(-1).AddDays(-1).ToString("yyyy-MM-dd");
query.GAEndDate = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
if (google.Referringpage != null)
{
query.Filters = "ga:pagePath==" + google.Referringpage;
}
DataFeed actual = google.Analytics.Query(query);
System.Data.DataTable dt = new System.Data.DataTable("Browser");
dt.Columns.Add("Visits");
dt.Columns.Add("Date", typeof(int));
//int total = 0;
foreach (DataEntry entry in actual.Entries)
{
dt.Rows.Add(new object[] { entry.Title.Text.Split(new char[] { '=' })[1].ToString(), int.Parse(entry.Metrics[0].Value) });
//total += int.Parse(entry.Metrics[0].Value);
}
//Response.Write(total.ToString());
this.pie_Source.GviEnableEvents = true;
this.pie_Source.ChartData(dt);
}
protected void Page_Load(object sender, EventArgs e)
{
GooglePageBase google = Page as GooglePageBase;
DataQuery query = new DataQuery();
query.Ids = "ga:" + google.Settings.Current.Id;
query.Metrics = "ga:visits";
query.Dimensions = "ga:visitorType,ga:date";
query.Sort = "ga:date";
query.GAStartDate = DateTime.Now.AddMonths(-1).AddDays(-1).ToString("yyyy-MM-dd");
query.GAEndDate = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
if (google.Referringpage != null)
{
query.Filters = "ga:pagePath==" + google.Referringpage;
}
DataFeed actual = google.Analytics.Query(query);
System.Data.DataTable nvsr = new System.Data.DataTable("New vs Returning");
nvsr.Columns.Add("visitorType", typeof(string));
nvsr.Columns.Add("Visits", typeof(int));
System.Collections.SortedList visitors = new System.Collections.SortedList();
System.Data.DataTable nandr = new System.Data.DataTable("New and Returning");
nandr.Columns.Add("Date");
nandr.Columns.Add("New Visitor", typeof(int));
nandr.Columns.Add("Returning Visitor", typeof(int));
System.Collections.SortedList newvisitors = new System.Collections.SortedList();
System.Collections.SortedList returningvisitors = new System.Collections.SortedList();
foreach (DataEntry entry in actual.Entries)
{
try
{
int visits = int.Parse(entry.Metrics[0].Value);
string visitorType = entry.Dimensions[0].Value.ToString();
DateTime datetime = new DateTime(int.Parse(entry.Dimensions[1].Value.Substring(0, 4)), int.Parse(entry.Dimensions[1].Value.Substring(4, 2)), int.Parse(entry.Dimensions[1].Value.Substring(6, 2)));
string date = datetime.ToString("yyyy-MM-dd");
//dt.Rows.Add(new object[] { visitorType,visits });
if (visitorType.StartsWith("New"))
{
if (newvisitors.ContainsKey(date))
{
int current = int.Parse(newvisitors[date].ToString());
current += visits;
newvisitors[date] = current;
}
else
{
newvisitors.Add(date, visits);
}
}
else
{
if (returningvisitors.ContainsKey(date))
{
int current = int.Parse(returningvisitors[date].ToString());
current += visits;
returningvisitors[date] = current;
}
else
{
returningvisitors.Add(date, visits);
}
}
if (visitors.ContainsKey(visitorType))
{
int current = int.Parse(visitors[visitorType].ToString());
current += visits;
visitors[visitorType] = current;
}
else
{
visitors.Add(visitorType, visits);
}
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
foreach (String key in visitors.Keys)
{
nvsr.Rows.Add(new object[] { key, int.Parse(visitors[key].ToString()) });
}
ArrayList keys = new ArrayList();
keys.AddRange(newvisitors.Keys);
keys.AddRange(returningvisitors.Keys);
foreach (object key in keys)
{
int _newvisitors = 0;
int _returningvisitors = 0;
if (newvisitors.ContainsKey(key))
{
_newvisitors = int.Parse(newvisitors[key].ToString());
}
if (returningvisitors.ContainsKey(key))
{
_returningvisitors = int.Parse(returningvisitors[key].ToString());
}
nandr.Rows.Add(new object[] { key, _newvisitors, _returningvisitors });
}
this.pie_newvsreturning.GviEnableEvents = true;
this.pie_newvsreturning.ChartData(nvsr);
this.area_newvsreturning.GviEnableEvents = true;
this.area_newvsreturning.ChartData(nandr);
}
protected void Page_Load(object sender, EventArgs e)
{
google = Page as GooglePageBase;
System.Data.DataTable dt = new System.Data.DataTable("Keywords");
dt.Columns.Add("Keywords");
dt.Columns.Add("Visitors", typeof(int));
System.Data.DataTable wm = new System.Data.DataTable("Keywords");
wm.Columns.Add("Name");
wm.Columns.Add("Value");
try
{
DataQuery query = new DataQuery();
query.Ids = "ga:" + google.Settings.Current.Id;
query.Dimensions = "ga:keyword";
query.Metrics = "ga:visits";
query.Sort = "-ga:visits";
query.GAStartDate = DateTime.Now.AddMonths(-1).AddDays(-1).ToString("yyyy-MM-dd");
query.GAEndDate = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
if (google.Referringpage != null)
{
query.Filters = "ga:pagePath==" + google.Referringpage;
}
/*
* if (google.Referringpage != null)
* {
* query.Filters = "ga:keyword!=(not set),ga:pagePath==" + google.Referringpage;
* }
* else
* {
* query.Filters = "ga:keyword!=(not set)";
* }
*/
DataFeed actual = google.Analytics.Query(query);
foreach (DataEntry entry in actual.Entries)
{
dt.Rows.Add(new object[] { entry.Dimensions[0].Value, int.Parse(entry.Metrics[0].Value) });
}
}
catch (Exception ex)
{
ex.ToString();
//TextBox1.Text = ex.ToString();
}
try
{
/*
* MessagesQuery mquery = new MessagesQuery();
*
* MessagesFeed messages = google.Webmastertools.Query(mquery);
*
* TextBox1.Text += messages.Title.Text + "\n";
* TextBox1.Text += messages.TotalResults + "\n";
* TextBox1.Text += messages.Entries.Count + "\n";
*
* foreach (MessagesEntry entry in messages.Entries)
* {
*
* TextBox1.Text += entry.Title.Text + "\n";
* TextBox1.Text += entry.Subject.Value + "\n";
* TextBox1.Text += entry.Body + "\n";
* entry.Delete();
* }
*/
using (GoogleWebmasterToolsSettings settings = google.Settings.Webmaster)
{
KeywordsQuery query = new KeywordsQuery(KeywordsQuery.CreateCustomUri(settings.EncodedSiteId));
KeywordsFeed keywords = google.Webmastertools.Query(query);
/*
* TextBox1.Text += keywords.Title.Text + "\n";
* TextBox1.Text += keywords.TotalResults + "\n";
* TextBox1.Text += keywords.Entries.Count + "\n";
*/
foreach (KeywordsEntry entry in keywords.Entries)
{
wm.Rows.Add(new object[] { entry.Keyword.Name, entry.Keyword.Value });
}
/*
* SitemapsQuery squery = new SitemapsQuery(SitemapsQuery.CreateCustomUri(settings.EncodedSiteId));
* SitemapsFeed sitemaps = google.Webmastertools.Query(squery);
*
* TextBox1.Text += sitemaps.Title.Text + "\n";
* TextBox1.Text += sitemaps.TotalResults + "\n";
* TextBox1.Text += sitemaps.Entries.Count + "\n";
*
* foreach (SitemapsEntry entry in sitemaps.Entries)
* {
* TextBox1.Text += entry.Title.Text + "\n";
* TextBox1.Text += entry.SitemapLastDownloaded + "\n";
* TextBox1.Text += entry.SitemapType + "\n";
* TextBox1.Text += entry.SitemapUrlCount + "\n";
* }
*
*
* CrawlIssuesQuery cquery = new CrawlIssuesQuery(CrawlIssuesQuery.CreateCustomUri(settings.EncodedSiteId));
* CrawlIssuesFeed crawlissues = google.Webmastertools.Query(cquery);
*
* TextBox1.Text += crawlissues.Title.Text + "\n";
* TextBox1.Text += crawlissues.TotalResults + "\n";
* TextBox1.Text += crawlissues.Entries.Count + "\n";
*
* foreach (CrawlIssuesEntry entry in crawlissues.Entries)
* {
*
* TextBox1.Text += entry.Title.Text + "\n";
* TextBox1.Text += entry.IssueType + "\n";
* TextBox1.Text += entry.IssueDetail + "\n";
* //entry.Delete();
* }
*/
}
/*
* TextBox1.Text += google.Settings.Webmaster.EncodedSiteId;
* KeywordsQuery query = new KeywordsQuery(KeywordsQuery.CreateCustomUri(google.Settings.Webmaster.EncodedSiteId));
* KeywordsFeed keywords = google.Webmastertools.Query(query);
*
* TextBox1.Text += keywords.Title.Text + "\n";
* //TextBox1.Text += keywords.Subtitle.Text + "\n";
* TextBox1.Text += keywords.TotalResults + "\n";
* TextBox1.Text += keywords.Entries.Count + "\n";
*
* foreach (KeywordsEntry entry in keywords.Entries)
* {
* TextBox1.Text += entry.Title + "\n";
* TextBox1.Text += entry.Content.Content + "\n";
* TextBox1.Text += entry.Content.Src + "\n";
* TextBox1.Text += entry.Keyword.ChildNodes.Count + "\n";
* TextBox1.Text += entry.Keyword.Name + "\n";
* TextBox1.Text += entry.Keyword.Value + "\n";
*
* //dt.Rows.Add(new object[] { entry.Keyword.Name, entry.Keyword.Value });
* }
*/
}
catch (Exception ex)
{
ex.ToString();
//TextBox1.Text += ex.ToString();
}
this.tbl_Keywords.ChartData(dt);
this.tbl_Webmaster.ChartData(wm);
}
protected void Page_Load(object sender, EventArgs e)
{
GooglePageBase google = Page as GooglePageBase;
DataQuery query = new DataQuery();
query.Ids = "ga:" + google.Settings.Current.Id;;
query.Metrics = "ga:visits,ga:timeOnSite";
query.Dimensions = "ga:date";
query.Sort = "ga:date";
query.GAStartDate = DateTime.Now.AddMonths(-1).AddDays(-1).ToString("yyyy-MM-dd");
query.GAEndDate = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
if (google.Referringpage != null)
{
query.Filters = "ga:pagePath==" + google.Referringpage;
}
DataFeed actual = google.Analytics.Query(query);
System.Data.DataTable dt = new System.Data.DataTable("Average Time by Date");
dt.Columns.Add("Date");
dt.Columns.Add("Average Time", typeof(float));
dt.Columns.Add("Visits", typeof(int));
System.Data.DataTable avg = new System.Data.DataTable("Average Time");
avg.Columns.Add("Average");//, typeof(int));
int visitstotal = 0;
float time = float.Parse("0.0");
foreach (DataEntry entry in actual.Entries)
{
try
{
DateTime datetime = new DateTime(int.Parse(entry.Dimensions[0].Value.Substring(0, 4)), int.Parse(entry.Dimensions[0].Value.Substring(4, 2)), int.Parse(entry.Dimensions[0].Value.Substring(6, 2)));
string date = datetime.ToString("yyyy-MM-dd");
int visits = int.Parse(entry.Metrics[0].Value);
visitstotal += visits;
string timeonsite = entry.Metrics[1].Value.ToString();
time += float.Parse(timeonsite);
if (visits > 0)
{
dt.Rows.Add(new object[] { date, (float.Parse(timeonsite) / visits), visits });
}
else
{
dt.Rows.Add(new object[] { date, float.Parse("0.0"), visits });
}
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
avg.Rows.Add(new object[] { (time / visitstotal).ToString() + " seconds" });
this.tbl_averageTime.ChartData(avg);
this.area_averageTime.GviEnableEvents = true;
this.area_averageTime.ChartData(dt);
}
