Skip to content

Instantly share code, notes, and snippets.

@steviemcg

steviemcg/ExmAggregation.aspx

Created January 31, 2018 16:18
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save steviemcg/1b410cd3a3b41b1f19f7d1661f812b6d to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save steviemcg/1b410cd3a3b41b1f19f7d1661f812b6d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ExmAggregation.aspx
<%@ Page Language="C#" AutoEventWireup="true" Inherits="Sitecore.sitecore.admin.AdminPage" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Aggregation</title>
<script runat="server" language="C#">
protected void Page_Load(object sender, EventArgs e)
{
CheckSecurity(true);
}
protected void btnGetAggregatedData_OnClick(object sender, EventArgs e)
{
Guid messageId = Guid.Parse(txtMessageId.Text);
Guid segmentId = Guid.Parse(txtSegmentId.Text);
datasource.SelectCommand = string.Format("SELECT Visits, Value, Bounces, Conversions, TimeOnSite, Pageviews, Count, Date, DimensionKey FROM ReportDataView WHERE SegmentId='{0}' AND DimensionKey LIKE '%{1:N}%'", segmentId, messageId);
gridview.DataBind();
}
</script>
</head>
<body>
<form id="form1" runat="server">
<p>
Message Id: <asp:TextBox runat="server" id="txtMessageId" Width="400" />
</p>
<p>
Segment Id: <asp:TextBox runat="server" id="txtSegmentId" Width="400" text="{7558FC89-C25F-4606-BBC5-43B91A382AC9}" />
</p>
<p>
<asp:Button runat="server" id="btnGetAggregatedData" Text="Get aggregated data" OnClick="btnGetAggregatedData_OnClick"/>
</p>
<asp:SqlDataSource ID="datasource" Runat="server" ConnectionString="<%$ ConnectionStrings:Reporting %>" DataSourceMode="DataReader" />
<asp:GridView runat="server" id="gridview" AutoGenerateColumns="True" DataSourceID="datasource"
CellPadding="5" />
</form>
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment