0.5in 8 textbox6 0.25in 1.5in =Count(Fields!SearchTermDesc.Value, "Keywords") > 0 0.375in true No results to display 0.625in 7 1.125in 0in 7.25in =Count(Fields!SearchTermDesc.Value, "Keywords") = 0 6 0.33333in 0.36458in Embedded 5 textbox4 0.5in 1in =Count(Fields!SearchTermDesc.Value, "Keywords") = 0 0.375in true * This keyword also contained a best bet 6.25in 30 30 Simple 50 4 true RightCenter Default =Sum(Fields!HitCount.Value) 6pt <Caption>Hits</Caption> Outside 0 Keywords 0 Column 1.25in <Width>7.25in</Width> <Height>3in</Height> <SeriesGroupings> <SeriesGrouping> <DynamicSeries> <Grouping Name="chart1_SeriesGroup1"> <GroupExpressions> <GroupExpression>=Fields!SearchTermDesc.Value</GroupExpression> </GroupExpressions> </Grouping> <Label>=Fields!SearchTermDesc.Value</Label> </DynamicSeries> </SeriesGrouping> </SeriesGroupings> <Subtype>Plain</Subtype> <PlotArea> <Style> <BackgroundColor>LightGrey</BackgroundColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> </PlotArea> <ValueAxis> <Axis> <Title /> <MajorGridLines> <ShowGridLines>true</ShowGridLines> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> </MajorGridLines> <MinorGridLines> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> </MinorGridLines> <MajorTickMarks>Outside</MajorTickMarks> <Min>0</Min> <Margin>true</Margin> <Visible>true</Visible> <Scalar>true</Scalar> </Axis> </ValueAxis> </Chart> <Textbox Name="textbox2"> <Style> <PaddingLeft>2pt</PaddingLeft> <FontFamily>Verdana</FontFamily> <FontSize>12pt</FontSize> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>3</ZIndex> <rd:DefaultName>textbox2</rd:DefaultName> <Height>0.25in</Height> <Width>2.875in</Width> <Top>0.125in</Top> <CanGrow>true</CanGrow> <Value>Best Bet Keyword Report</Value> <Left>0.625in</Left> </Textbox> <Textbox Name="textbox1"> <Style> <PaddingLeft>2pt</PaddingLeft> <TextAlign>Left</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>2</ZIndex> <rd:DefaultName>textbox1</rd:DefaultName> <Height>0.25in</Height> <Width>4.75in</Width> <Visibility> <Hidden>=Count(Fields!SearchTermDesc.Value, "Keywords") = 0</Hidden> </Visibility> <Top>0.625in</Top> <CanGrow>true</CanGrow> <Value>= Parameters!NumSelect.Label + " Used Keywords"</Value> </Textbox> <Table Name="table1"> <Height>0.46in</Height> <ZIndex>1</ZIndex> <Style> <BackgroundColor>White</BackgroundColor> <BorderStyle> <Top>Solid</Top> </BorderStyle> </Style> <Header> <TableRows> <TableRow> <Height>0.25in</Height> <TableCells> <TableCell> <ReportItems> <Textbox Name="textbox3"> <Style> <PaddingLeft>2pt</PaddingLeft> <FontFamily>Trebuchet MS</FontFamily> <BackgroundColor>Gray</BackgroundColor> <BorderStyle> <Bottom>None</Bottom> <Top>Solid</Top> <Right>None</Right> <Left>None</Left> </BorderStyle> <Color>White</Color> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>900</FontWeight> </Style> <ZIndex>3</ZIndex> <rd:DefaultName>textbox3</rd:DefaultName> <CanGrow>true</CanGrow> <Value>Keyword</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox5"> <Style> <PaddingLeft>2pt</PaddingLeft> <FontFamily>Trebuchet MS</FontFamily> <BackgroundColor>Gray</BackgroundColor> <BorderStyle> <Bottom>None</Bottom> <Top>Solid</Top> <Right>None</Right> <Left>None</Left> </BorderStyle> <TextAlign>Left</TextAlign> <Color>White</Color> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>900</FontWeight> </Style> <ZIndex>2</ZIndex> <CanGrow>true</CanGrow> <Value>Usage Count</Value> </Textbox> </ReportItems> </TableCell> </TableCells> </TableRow> </TableRows> <RepeatOnNewPage>true</RepeatOnNewPage> </Header> <Details> <TableRows> <TableRow> <Height>0.21in</Height> <TableCells> <TableCell> <ReportItems> <Textbox Name="SearchTermDesc_1"> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>1</ZIndex> <rd:DefaultName>SearchTermDesc_1</rd:DefaultName> <CanGrow>true</CanGrow> <Value>=Fields!SearchTermDesc.Value</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="Count"> <Style> <PaddingLeft>2pt</PaddingLeft> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <rd:DefaultName>Count</rd:DefaultName> <CanGrow>true</CanGrow> <Value>=Fields!HitCount.Value</Value> </Textbox> </ReportItems> </TableCell> </TableCells> </TableRow> </TableRows> </Details> <DataSetName>Keywords</DataSetName> <Top>4.5in</Top> <Width>3.125in</Width> <Visibility> <Hidden>=COUNT(Fields!SearchTermDesc.Value) = 0</Hidden> </Visibility> <TableColumns> <TableColumn> <Width>2.125in</Width> </TableColumn> <TableColumn> <Width>1in</Width> </TableColumn> </TableColumns> </Table> <Chart Name="chart3"> <ThreeDProperties> <Rotation>30</Rotation> <Inclination>30</Inclination> <Shading>Simple</Shading> <WallThickness>50</WallThickness> </ThreeDProperties> <Style> <BackgroundColor>White</BackgroundColor> </Style> <Legend> <Visible>true</Visible> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> <Position>RightCenter</Position> </Legend> <Palette>Default</Palette> <ChartData> <ChartSeries> <DataPoints> <DataPoint> <DataValues> <DataValue> <Value>=Sum(Fields!HitCount.Value)</Value> </DataValue> </DataValues> <DataLabel /> <Marker /> </DataPoint> </DataPoints> </ChartSeries> </ChartData> <CategoryAxis> <Axis> <Title /> <MajorGridLines> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> </MajorGridLines> <MinorGridLines> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> </MinorGridLines> <MajorTickMarks>Outside</MajorTickMarks> <Min>0</Min> <Visible>true</Visible> </Axis> </CategoryAxis> <DataSetName>Keywords</DataSetName> <PointWidth>0</PointWidth> <Type>Pie</Type> <Top>4.5in</Top> <Title /> <Width>4in</Width> <Height>2.75in</Height> <SeriesGroupings> <SeriesGrouping> <DynamicSeries> <Grouping Name="chart3_SeriesGroup1"> <GroupExpressions> <GroupExpression>=Fields!SearchTermDesc.Value</GroupExpression> </GroupExpressions> </Grouping> <Label>=Fields!SearchTermDesc.Value</Label> </DynamicSeries> </SeriesGrouping> <SeriesGrouping> <StaticSeries> <StaticMember> <Label>Hit Count</Label> </StaticMember> </StaticSeries> </SeriesGrouping> </SeriesGroupings> <Subtype>Plain</Subtype> <PlotArea> <Style> <BackgroundColor>LightGrey</BackgroundColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> </PlotArea> <Left>3.25in</Left> <ValueAxis> <Axis> <Title /> <MajorGridLines> <ShowGridLines>true</ShowGridLines> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> </MajorGridLines> <MinorGridLines> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> </MinorGridLines> <MajorTickMarks>Outside</MajorTickMarks> <Min>0</Min> <Margin>true</Margin> <Visible>true</Visible> <Scalar>true</Scalar> </Axis> </ValueAxis> </Chart> </ReportItems> <Style /> <Height>7.5in</Height> </Body> <TopMargin>0.5in</TopMargin> <DataSources> <DataSource Name="dbSPSReportingSample"> <rd:DataSourceID>855aa883-0dde-4864-8345-a3151da5bb98</rd:DataSourceID> <DataSourceReference>dbSPSReportingSample</DataSourceReference> </DataSource> </DataSources> <Width>7.5in</Width> <DataSets> <DataSet Name="Keywords"> <Fields> <Field Name="SearchTermDesc"> <DataField>SearchTermDesc</DataField> </Field> <Field Name="HitCount"> <DataField>HitCount</DataField> </Field> </Fields> <Query> <DataSourceName>dbSPSReportingSample</DataSourceName> <CommandType>StoredProcedure</CommandType> <CommandText>usp_Select_Keywords</CommandText> <QueryParameters> <QueryParameter Name="@DateRange"> <Value>=Parameters!DateRange.Value</Value> </QueryParameter> <QueryParameter Name="@NumSelect"> <Value>=Parameters!NumSelect.Value</Value> </QueryParameter> <QueryParameter Name="@VirtualServerName"> <Value>=Parameters!VirtualServerName.Value</Value> </QueryParameter> </QueryParameters> <rd:UseGenericDesigner>true</rd:UseGenericDesigner> </Query> </DataSet> <DataSet Name="VirtualServersWithPortals"> <Fields> <Field Name="VirtualServerName"> <DataField>VirtualServerName</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> </Fields> <Query> <DataSourceName>dbSPSReportingSample</DataSourceName> <CommandText>select distinct VirtualServerName from DimArch where HasPortalSites = 1 order by VirtualServerName</CommandText> <rd:UseGenericDesigner>true</rd:UseGenericDesigner> </Query> </DataSet> </DataSets> <EmbeddedImages> <EmbeddedImage Name="searchlogo"> <MIMEType>image/bmp</MIMEType> <ImageData>Qk22DQAAAAAAADYAAAAoAAAAIwAAACAAAAABABgAAAAAAIANAAAAAAAAAAAAAAAAAAAAAAAA////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////x8f/v7//////////AAAA////////////////////////////////////////////////////////7+/vx8fH////////////////////////////////////////////////////////f3//EBD/FRX/39//////AAAA////////////////////////////////////////r6+vaF5eGA4OAAAAEAcHOBAQAAAADAAAPCUlh4eH19fX////////////////////////////19f/KCj/Cwv/AAD/AAD/MDD/////AAAA////////////////////////////////l5KSGA4OUA8PlwAA5wAA/wAA+wAAvAAAgwAAYAAAQgAAIAAAFgICHBQUdHR0z8/P////////////mpr/EhL/AAD/AAD/AAD/AAD/CAj/l5f/AAAA////////////////////////39/fKBoaaA0N5wAA/wAA/wAA/wAA5wAAmAAARjQ0DhISUFAdf381v79bv79kn59acHBFMDAgSEhI0dHnODj/Dw//AAD/AAD/AAD/AAD/Dw//ODj/7+//AAAA////////////////////x8fHMBUV1wAA/wAA/wAA/wAA/wAA/wAAmgAAGxcXYGAa7+9K//9d//9r//95//+G//+Q//+e//+st7eFAwMoAACfAAD/AAD/AAD/AAD/Fxf/mpr/////////AAAA////////////////t7GxQBQU7wAA/wAA/wAA/wAA/wAA/wAA9wAAKwAAt7co//9G //9P//9d//9r//95//+G//+Q//+e//+s//+57++7UFBCAACvAAD/Cwv/KCj/19f/////////////AAAA////////////19fXOBcX7wAA/wAA/wAA/wAA/wAA/wAA/wAAYQAAh4ci//9B//9G//9P//9d//9r//95//+G//+Q//+e//+s//+5///H5+e9AAAwEhLnf3//////////////////////AAAA////////9/f3KBgY3wAA/wAA/wAA/wAA/wAA/wAA/wAAogAAODgR//9P//9P//9P//9P//9d//9r//95//+G//+Q//+e//+s//+5///H///Rt7egODhI////////////////////////AAAA////////eG1thwgI/wAA/wAA/wAA/wAA/wAA/wAAzwAALxgYj480//9d//9d//9d//9d//9d//9r//95//+G//+Q//+e//+s//+5///H///R///fDQ0N7+/v////////////////////AAAA////5+fnIA4O9wAA/wAA/wAA/wAA/wAA/wAAzwAAZzc3ESUlv79Q//9r//9r//9r//9r//9r//9r//95//+G//+Q//+e//+s//+5///H///R///fQEA7v7+/////////////////////AAAA////h4ODeAgI/wAA/wAA/wAA/wAA/wAA3wAAewkJQ4ODCAgE9/d1//95//95//95//95//95//95//95//+G//+Q//+e//+s//+5///H///R///feHhvenp6////////////////////AAAA////QDAwvwAA/wAA/wAA/wAA/wAA/wAA/wAAzwAAcSAgEBAI7+9+//+G//+G//+G//+G//+G//+G//+G//+G//+Q//+e//+s//+5///H///R///fcHBoWVlZ////////////////////AAAA7+/vEAcH/wAA/wAA/wAA/wAA/wAA/wAA/wAA/wAA7wAAIgYGt7dq//+ U//+U//+U//+U//+U//+U//+U//+U//+U//+e//+s//+5///H///R///fODg0PjMz////////////////////AAAAx8fHOBAQ/wAA/wAA/wAA/wAA/wAA/wAA/wAA/wAA/wAAVwAAh4dW//+i//+i//+i//+i//+i//+i//+i//+i//+i//+i//+s//+5///H///R///fBwAAJxkZ////////////////////AAAAr6+vUA8P/wAA/wAA/wAA/wAA/wAA/wAA/wAA/wAA/wAArwAAODgm9/en//+s//+s//+s//+s//+s//+s//+s//+s//+s//+s//+5///H///Rn5+LWgAAEAkJ////////////////////AAAAn5+fYAwM/wAA/wAA/wAA/wAA/wAA/wAA/wAA/wAA/wAA2wAAPxgYcHBR//+5//+5//+5//+5//+5//+5//+5//+5//+5//+5//+5///H39+3MAAA7wAAAAAA////////////////////AAAAp6enWA4O/wAA/wAA/wAA7wAA3wAA4wAA/wAA/wAA4wAAnAAAVH5+FSYmn598///H///H///H///H///H///H///H///H///H///H5+e0ODguxwAA9wAACAQE////////////////////AAAAx8fHOBAQ/wAA/wAA0wAAbxUVZyIibB8fgAAAgAAAcSAgT3d3TJaWUI6OIzo6SEg85+fB///V///V///V///V///V///V///Vn5+FKCghvwAA/wAA1wAAKBoa////////////////////AAAA5+fnGAoK/wAA7wAAbhUVF4GBHIiIJYuLLY2NNY+PPZGRRJOTTJaWVZiYXZubSHFxKCgkQEA5eHhrn5+Ot7ejf39xUFBHKCgkUQAA7wAA/wAA/wAAtwAASDg4////////////////////AAAA////MCEhzwAAzwAAVTExFIWFHIiIJYuLLY2NNY+PPZGRRJ OTTJaWVZiYXZubZZ2dZpWVWHl5RAsLMQoKJhUVRSoqXR4eoQAA/wAA/wAA/wAA/wAAcAcHj4+P////////////////////AAAA////f3t7fwQE3wAAYyEhFIWFHIiIJYuLLY2NNY+PPZGRRJOTTJaWVZiYXZubZZ2dbZ+fd35+nAAA+wAAxwAAvwAA3wAA/wAA/wAA/wAA/wAA/wAAIAwM39/f////////////////////AAAA////39/fKBAQ9wAAqAAASkJCVzc3chYWWUJCPn19PZGRRJOTTJaWVZiYXZubZZ2dbZ+fe0xMwwAA/wAA/wAA/wAA/wAA/wAA/wAA/wAA/wAArwAAUEFB////////////////////////AAAA////////cGVljwQE+wAAvwAAywAA6wAAwwAAdBYWR3p6RJOTTJaWVZiYXZubZZ2dbZ+ffxQU7wAA/wAA/wAA/wAA/wAA/wAA/wAA/wAA/wAAMA8Pz8/P////////////////////////AAAA////////5+fnKBMT7wAA/wAA/wAA/wAA5wAAjAAAaTIyYklJXGdnVZiYXZubZZ2dcXx8kAAA+wAA/wAA/wAA/wAA/wAA/wAA/wAA/wAApwUFWEdH////////////////////////////AAAA////////////x8fHQBQU9wAA/wAA/wAA9wAAvwAAvwAAsAAAcyYmVZiYXZubZZ2dbpqae0dHlAAA3wAA/wAA/wAA/wAA/wAA/wAAxwAAQCws9/f3////////////////////////////AAAA////////////////p6KiUA8P9wAA/wAA/wAA/wAA/wAA6wAAeBgYVZiYXZubZZ2dbZ+fdaGhfY+PkAAA8wAA/wAA/wAA/wAAzwAAOB4e5+fn////////////////////////////////AAAA////////////////////p6KiQBQU7wAA/wAA/ wAA/wAA/wAAqAAAYmhoXZubZZ2dbZ+fdaGhfaOjglhYuAAA/wAA/wAArwUFQCgo39/f////////////////////////////////////AAAA////////////////////////x8fHIBAQfwgI9wAA/wAA/wAA5wAAeB0dXZubZ46Oc2hofEJCgBoagRAQvAAA1wAAUA8PUD4+7+/v////////////////////////////////////////AAAA////////////////////////////7+/vf3d3IA4OaAoKrwAA/wAAqAAAfBMTfg8PrAAAywAA1wAAlwAAUA8PKBoar6+v////////////////////////////////////////////////AAAA////////////////////////////////////5+fnl5eXUEFBAAAAHgkJSg0NQBAQQBAQAAAAGA4OaF5er6+v////////////////////////////////////////////////////////AAAA////////////////////////////////////////////////////5+fnv7+/v7+/v7+/////////////////////////////////////////////////////////////////////////AAAA</ImageData> </EmbeddedImage> </EmbeddedImages> <LeftMargin>0.5in</LeftMargin> <rd:SnapToGrid>true</rd:SnapToGrid> <rd:DrawGrid>true</rd:DrawGrid> <Description>Shows top 20, top 10, bottom 10 or bottom 20 keywords used for searching. It also shows which keywords have best bets.</Description> <rd:ReportID>1ef1e009-6f5d-45b3-b575-4b628d75d843</rd:ReportID> <BottomMargin>0.5in</BottomMargin> <ReportParameters> <ReportParameter Name="DateRange"> <DataType>String</DataType> <AllowBlank>true</AllowBlank> <Prompt>Filter by:</Prompt> <ValidValues> <ParameterValues> <ParameterValue> <Value>30D</Value> <Label>Last 30 Days</Label> </ParameterValue> <ParameterValue> <Value>60D</Value> <Label>Last 60 Days</Label> </ParameterValue> <ParameterValue> <Value>90D</Value> <Label>Last 90 Days</Label> </ParameterValue> <ParameterValue> <Value>6M</Value> <Label>Last 6 Months</Label> </ParameterValue> <ParameterValue> <Value>1Y</Value> <Label>Last 12 Months</Label> </ParameterValue> <ParameterValue> <Value>10Y</Value> <Label>Last 10 Years</Label> </ParameterValue> </ParameterValues> </ValidValues> </ReportParameter> <ReportParameter Name="NumSelect"> <DataType>String</DataType> <AllowBlank>true</AllowBlank> <Prompt>Limit by:</Prompt> <ValidValues> <ParameterValues> <ParameterValue> <Value>20</Value> <Label>Top 20</Label> </ParameterValue> <ParameterValue> <Value>10</Value> <Label>Top 10</Label> </ParameterValue> <ParameterValue> <Value>-10</Value> <Label>Bottom 10</Label> </ParameterValue> <ParameterValue> <Value>-20</Value> <Label>Bottom 20</Label> </ParameterValue> </ParameterValues> </ValidValues> </ReportParameter> <ReportParameter Name="VirtualServerName"> <DataType>String</DataType> <Prompt>Portal Site Name</Prompt> <ValidValues> <DataSetReference> <DataSetName>VirtualServersWithPortals</DataSetName> <ValueField>VirtualServerName</ValueField> <LabelField>VirtualServerName</LabelField> </DataSetReference> </ValidValues> </ReportParameter> </ReportParameters> <Language>en-US</Language> </Report>