Skip to main content

Google Analytic Dashboard Controls



"Google Analytic Dashboard Controls" is costume controls library which contain ASP.NET costume controls which generate different types of charts like Google analytic dashboard using Google analytic data export api. Its include following controls.


  1. Visitors overviews
  2. Word map overview
  3. Traffic source overview
  4. Content overview

Followings are the images of the resulting graphs using them

Visitors Overview








Traffic Source Overview











Word Map Overview












Content Visits Overview










To use this controls into your ASP.NET projects follow the below steps.


2. Add reference of "Google Analytics Desbord Controls.dll" to your project.

3. In toolbox add controls by Right Click -> Choose Items -> browse dll.

4. Now Drag and drop control to your .aspx file.

5. Set Properties GAEmailAddress to your Google Analytic account email id, GAPassword to password , GAProfileId to analytic profile id for which you want to show report, FromDate to start date, ToDate to end date.

Following is the example code for VisitorOverview control.

In .aspx file

<cc1:VisitorsOverview ID="VisitorsOverview1" runat="server">
cc1:VisitorsOverview>

In .aspx.cs file

VisitorsOverview1.GAEmailAddress = "EmailAddress";
VisitorsOverview1.GAPassword = "Password";
VisitorsOverview1.AnalyticsProfileId = "23177177";
VisitorsOverview1.FromDate = new DateTime(2009, 11, 1);
VisitorsOverview1.ToDate = new DateTime(2010, 1, 8);


I found that many user use the Web Property ID (UA-XXXXXXXX-X) as AnaliticsProfileId and get error.
Following are the step to get your desire profile id from your analytic account

1) Go to the edit profile on analytic home page after login.














2) the page display your profile detail and you get your profile id over here
Use this id with the AnalyticsProfileId property of control to display the data.

 
Labels:

Popular posts from this blog

LINQ union with group by

In my recent development activity with LINQ query, I need to get the some of user points from tow different tables where user's points are based on some activities. There are many users who are into one table but not in another table and some are in both table. For example tables having data like this Table 1 UserID   Points 1           10 2           20 Table 2 UserID    Points 2           20 3           30 Result should be UserID    Points 1           10 2           40 3           30 I try to get this result with LINQ query using joins and group by samples from the web. I had googling to get something useful but dont get any success. So I try with new logic and here it is, I think it will help full to other also. Example Item class to use public class Item {   public int ID { get ; set ; }   public int Total { get ; set ; }   public Item()   {   }   public Item( int ID, int Total)   {     this .ID = ID; this .Total = Total;   }
read more >>

SqlConnection from ObjectContext.Connection

Following is C# code to get the  SqlConnection from ObjectContext.Connection . This is usefully to run dynamically created query using ADO.NET using connection string specified into the EDMX ObjectContext object. C# Code Example : using ( EntityContext context = new EntityContext ()) { EntityConnection ec = ( EntityConnection )context.Connection; SqlConnection sc = ( SqlConnection )ec.StoreConnection; SqlDataAdapter da = new SqlDataAdapter (strQuery, sc); DataSet ds = new DataSet (); da.Fill(ds); return ds.Tables[0]; }
Post a Comment
read more >>

Get Tables and Columns Names by LINQ

Here I am explaining one of the tricks to get all table name list along with column of it from your DataContext. I am using the System.Data.Linq.Mapping.MetaModel to get information about tables and it have much more database related information. Following are the code to list all table name along with column from your DataContext. //DataContext object. DataClassesDataContext DB = new DataClassesDataContext ();         //String variable to stor html to render. string strHtmlToLoad = "" ;         //Heading strHtmlToLoad = "<-h2->Table Names<-/h2-><-ol->" ;         //Loop through tables add name to string foreach ( var mTable in DB.Mapping.GetTables()) { strHtmlToLoad += "<-li->" + mTable.TableName + "<-ul->" ; //Loop through table's columns add name to string foreach ( var mColumn in mTable.RowType.DataMembers) strHtmlToLoad += "<-li->
read more >>