Query
Click here for a complete list of operations.
ExecuteQuery
Returns the results of a query for a site. In order for this function to work, you must manually add a unique authorization code into the AuthorizationCode element of the App_Data\Config\AppConfig.xml file. This code must be at least 10 alphanumeric characters long. For the highest security, it is recommended that this be a GUID.
Test
The test form is only available for methods with primitive types as parameters.SOAP 1.1
The following is a sample SOAP 1.1 request and response. The placeholders shown need to be replaced with actual values.
POST /Services/Query.asmx HTTP/1.1
Host: stats.smartertools.com
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://smartertools.com/smarterstats/query/ExecuteQuery"
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<ExecuteQuery xmlns="http://smartertools.com/smarterstats/query/">
<authUserName>string</authUserName>
<authPassword>string</authPassword>
<authorizationCode>string</authorizationCode>
<queryName>string</queryName>
<keyValuePairs>
<string>string</string>
<string>string</string>
</keyValuePairs>
</ExecuteQuery>
</soap:Body>
</soap:Envelope>
HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<ExecuteQueryResponse xmlns="http://smartertools.com/smarterstats/query/">
<ExecuteQueryResult>
<Success>boolean</Success>
<Completed>boolean</Completed>
<CompletedPercent>int</CompletedPercent>
<AsyncGuid>string</AsyncGuid>
<QueryTimeMilliseconds>long</QueryTimeMilliseconds>
<TableData>
<QueryResultRow>
<ID>int</ID>
<ItemCount>long</ItemCount>
<DateTicks>long</DateTicks>
<Name>string</Name>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<RegionCode>string</RegionCode>
<RegionName>string</RegionName>
<RegionFipsCode>string</RegionFipsCode>
<City>string</City>
<IpAddress>string</IpAddress>
<Browser>string</Browser>
<Device>string</Device>
<BrowserVersion>string</BrowserVersion>
<Platform>string</Platform>
<SearchEngine>string</SearchEngine>
<Phrase>string</Phrase>
<ProtocolStatus>string</ProtocolStatus>
<URIStemText>string</URIStemText>
<BandwidthIn>long</BandwidthIn>
<BandwidthOut>long</BandwidthOut>
<DateOfLog>dateTime</DateOfLog>
<DateFirst>dateTime</DateFirst>
<DateLast>dateTime</DateLast>
<ServerName>string</ServerName>
<Username>string</Username>
<Bounces>long</Bounces>
<Entrances>long</Entrances>
<Exits>long</Exits>
<Visitors>long</Visitors>
<UniqueVisits>long</UniqueVisits>
<ReturnVisits>long</ReturnVisits>
<NewVisits>long</NewVisits>
<TimeTakenMs>long</TimeTakenMs>
<VisitLengthSeconds>long</VisitLengthSeconds>
<Hits>long</Hits>
<Views>long</Views>
<Visits>long</Visits>
<BandwidthBytes>long</BandwidthBytes>
<RawBandwidthBytes>long</RawBandwidthBytes>
<FileBandwidth>long</FileBandwidth>
<Keyword>string</Keyword>
<SearchRank>int</SearchRank>
<ResultCount>long</ResultCount>
<ViewsDuringVisit>long</ViewsDuringVisit>
<SiteUrl>string</SiteUrl>
<SiteUrlLink>string</SiteUrlLink>
<Location xsi:nil="true" />
</QueryResultRow>
<QueryResultRow>
<ID>int</ID>
<ItemCount>long</ItemCount>
<DateTicks>long</DateTicks>
<Name>string</Name>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<RegionCode>string</RegionCode>
<RegionName>string</RegionName>
<RegionFipsCode>string</RegionFipsCode>
<City>string</City>
<IpAddress>string</IpAddress>
<Browser>string</Browser>
<Device>string</Device>
<BrowserVersion>string</BrowserVersion>
<Platform>string</Platform>
<SearchEngine>string</SearchEngine>
<Phrase>string</Phrase>
<ProtocolStatus>string</ProtocolStatus>
<URIStemText>string</URIStemText>
<BandwidthIn>long</BandwidthIn>
<BandwidthOut>long</BandwidthOut>
<DateOfLog>dateTime</DateOfLog>
<DateFirst>dateTime</DateFirst>
<DateLast>dateTime</DateLast>
<ServerName>string</ServerName>
<Username>string</Username>
<Bounces>long</Bounces>
<Entrances>long</Entrances>
<Exits>long</Exits>
<Visitors>long</Visitors>
<UniqueVisits>long</UniqueVisits>
<ReturnVisits>long</ReturnVisits>
<NewVisits>long</NewVisits>
<TimeTakenMs>long</TimeTakenMs>
<VisitLengthSeconds>long</VisitLengthSeconds>
<Hits>long</Hits>
<Views>long</Views>
<Visits>long</Visits>
<BandwidthBytes>long</BandwidthBytes>
<RawBandwidthBytes>long</RawBandwidthBytes>
<FileBandwidth>long</FileBandwidth>
<Keyword>string</Keyword>
<SearchRank>int</SearchRank>
<ResultCount>long</ResultCount>
<ViewsDuringVisit>long</ViewsDuringVisit>
<SiteUrl>string</SiteUrl>
<SiteUrlLink>string</SiteUrlLink>
<Location xsi:nil="true" />
</QueryResultRow>
</TableData>
<FooterUnknown>
<ID>int</ID>
<ItemCount>long</ItemCount>
<DateTicks>long</DateTicks>
<Name>string</Name>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<RegionCode>string</RegionCode>
<RegionName>string</RegionName>
<RegionFipsCode>string</RegionFipsCode>
<City>string</City>
<IpAddress>string</IpAddress>
<Browser>string</Browser>
<Device>string</Device>
<BrowserVersion>string</BrowserVersion>
<Platform>string</Platform>
<SearchEngine>string</SearchEngine>
<Phrase>string</Phrase>
<ProtocolStatus>string</ProtocolStatus>
<URIStemText>string</URIStemText>
<BandwidthIn>long</BandwidthIn>
<BandwidthOut>long</BandwidthOut>
<DateOfLog>dateTime</DateOfLog>
<DateFirst>dateTime</DateFirst>
<DateLast>dateTime</DateLast>
<ServerName>string</ServerName>
<Username>string</Username>
<Bounces>long</Bounces>
<Entrances>long</Entrances>
<Exits>long</Exits>
<Visitors>long</Visitors>
<UniqueVisits>long</UniqueVisits>
<ReturnVisits>long</ReturnVisits>
<NewVisits>long</NewVisits>
<TimeTakenMs>long</TimeTakenMs>
<VisitLengthSeconds>long</VisitLengthSeconds>
<Hits>long</Hits>
<Views>long</Views>
<Visits>long</Visits>
<BandwidthBytes>long</BandwidthBytes>
<RawBandwidthBytes>long</RawBandwidthBytes>
<FileBandwidth>long</FileBandwidth>
<Keyword>string</Keyword>
<SearchRank>int</SearchRank>
<ResultCount>long</ResultCount>
<ViewsDuringVisit>long</ViewsDuringVisit>
<SiteUrl>string</SiteUrl>
<SiteUrlLink>string</SiteUrlLink>
<Location>
<area_code>int</area_code>
<city>string</city>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<DmaCode>int</DmaCode>
<Latitude>double</Latitude>
<Longitude>double</Longitude>
<PostalCode>string</PostalCode>
<region>string</region>
</Location>
</FooterUnknown>
<FooterOtherItems>
<ID>int</ID>
<ItemCount>long</ItemCount>
<DateTicks>long</DateTicks>
<Name>string</Name>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<RegionCode>string</RegionCode>
<RegionName>string</RegionName>
<RegionFipsCode>string</RegionFipsCode>
<City>string</City>
<IpAddress>string</IpAddress>
<Browser>string</Browser>
<Device>string</Device>
<BrowserVersion>string</BrowserVersion>
<Platform>string</Platform>
<SearchEngine>string</SearchEngine>
<Phrase>string</Phrase>
<ProtocolStatus>string</ProtocolStatus>
<URIStemText>string</URIStemText>
<BandwidthIn>long</BandwidthIn>
<BandwidthOut>long</BandwidthOut>
<DateOfLog>dateTime</DateOfLog>
<DateFirst>dateTime</DateFirst>
<DateLast>dateTime</DateLast>
<ServerName>string</ServerName>
<Username>string</Username>
<Bounces>long</Bounces>
<Entrances>long</Entrances>
<Exits>long</Exits>
<Visitors>long</Visitors>
<UniqueVisits>long</UniqueVisits>
<ReturnVisits>long</ReturnVisits>
<NewVisits>long</NewVisits>
<TimeTakenMs>long</TimeTakenMs>
<VisitLengthSeconds>long</VisitLengthSeconds>
<Hits>long</Hits>
<Views>long</Views>
<Visits>long</Visits>
<BandwidthBytes>long</BandwidthBytes>
<RawBandwidthBytes>long</RawBandwidthBytes>
<FileBandwidth>long</FileBandwidth>
<Keyword>string</Keyword>
<SearchRank>int</SearchRank>
<ResultCount>long</ResultCount>
<ViewsDuringVisit>long</ViewsDuringVisit>
<SiteUrl>string</SiteUrl>
<SiteUrlLink>string</SiteUrlLink>
<Location>
<area_code>int</area_code>
<city>string</city>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<DmaCode>int</DmaCode>
<Latitude>double</Latitude>
<Longitude>double</Longitude>
<PostalCode>string</PostalCode>
<region>string</region>
</Location>
</FooterOtherItems>
<FooterTotals>
<ID>int</ID>
<ItemCount>long</ItemCount>
<DateTicks>long</DateTicks>
<Name>string</Name>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<RegionCode>string</RegionCode>
<RegionName>string</RegionName>
<RegionFipsCode>string</RegionFipsCode>
<City>string</City>
<IpAddress>string</IpAddress>
<Browser>string</Browser>
<Device>string</Device>
<BrowserVersion>string</BrowserVersion>
<Platform>string</Platform>
<SearchEngine>string</SearchEngine>
<Phrase>string</Phrase>
<ProtocolStatus>string</ProtocolStatus>
<URIStemText>string</URIStemText>
<BandwidthIn>long</BandwidthIn>
<BandwidthOut>long</BandwidthOut>
<DateOfLog>dateTime</DateOfLog>
<DateFirst>dateTime</DateFirst>
<DateLast>dateTime</DateLast>
<ServerName>string</ServerName>
<Username>string</Username>
<Bounces>long</Bounces>
<Entrances>long</Entrances>
<Exits>long</Exits>
<Visitors>long</Visitors>
<UniqueVisits>long</UniqueVisits>
<ReturnVisits>long</ReturnVisits>
<NewVisits>long</NewVisits>
<TimeTakenMs>long</TimeTakenMs>
<VisitLengthSeconds>long</VisitLengthSeconds>
<Hits>long</Hits>
<Views>long</Views>
<Visits>long</Visits>
<BandwidthBytes>long</BandwidthBytes>
<RawBandwidthBytes>long</RawBandwidthBytes>
<FileBandwidth>long</FileBandwidth>
<Keyword>string</Keyword>
<SearchRank>int</SearchRank>
<ResultCount>long</ResultCount>
<ViewsDuringVisit>long</ViewsDuringVisit>
<SiteUrl>string</SiteUrl>
<SiteUrlLink>string</SiteUrlLink>
<Location>
<area_code>int</area_code>
<city>string</city>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<DmaCode>int</DmaCode>
<Latitude>double</Latitude>
<Longitude>double</Longitude>
<PostalCode>string</PostalCode>
<region>string</region>
</Location>
</FooterTotals>
</ExecuteQueryResult>
</ExecuteQueryResponse>
</soap:Body>
</soap:Envelope>
SOAP 1.2
The following is a sample SOAP 1.2 request and response. The placeholders shown need to be replaced with actual values.
POST /Services/Query.asmx HTTP/1.1
Host: stats.smartertools.com
Content-Type: application/soap+xml; charset=utf-8
Content-Length: length
<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
<soap12:Body>
<ExecuteQuery xmlns="http://smartertools.com/smarterstats/query/">
<authUserName>string</authUserName>
<authPassword>string</authPassword>
<authorizationCode>string</authorizationCode>
<queryName>string</queryName>
<keyValuePairs>
<string>string</string>
<string>string</string>
</keyValuePairs>
</ExecuteQuery>
</soap12:Body>
</soap12:Envelope>
HTTP/1.1 200 OK
Content-Type: application/soap+xml; charset=utf-8
Content-Length: length
<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
<soap12:Body>
<ExecuteQueryResponse xmlns="http://smartertools.com/smarterstats/query/">
<ExecuteQueryResult>
<Success>boolean</Success>
<Completed>boolean</Completed>
<CompletedPercent>int</CompletedPercent>
<AsyncGuid>string</AsyncGuid>
<QueryTimeMilliseconds>long</QueryTimeMilliseconds>
<TableData>
<QueryResultRow>
<ID>int</ID>
<ItemCount>long</ItemCount>
<DateTicks>long</DateTicks>
<Name>string</Name>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<RegionCode>string</RegionCode>
<RegionName>string</RegionName>
<RegionFipsCode>string</RegionFipsCode>
<City>string</City>
<IpAddress>string</IpAddress>
<Browser>string</Browser>
<Device>string</Device>
<BrowserVersion>string</BrowserVersion>
<Platform>string</Platform>
<SearchEngine>string</SearchEngine>
<Phrase>string</Phrase>
<ProtocolStatus>string</ProtocolStatus>
<URIStemText>string</URIStemText>
<BandwidthIn>long</BandwidthIn>
<BandwidthOut>long</BandwidthOut>
<DateOfLog>dateTime</DateOfLog>
<DateFirst>dateTime</DateFirst>
<DateLast>dateTime</DateLast>
<ServerName>string</ServerName>
<Username>string</Username>
<Bounces>long</Bounces>
<Entrances>long</Entrances>
<Exits>long</Exits>
<Visitors>long</Visitors>
<UniqueVisits>long</UniqueVisits>
<ReturnVisits>long</ReturnVisits>
<NewVisits>long</NewVisits>
<TimeTakenMs>long</TimeTakenMs>
<VisitLengthSeconds>long</VisitLengthSeconds>
<Hits>long</Hits>
<Views>long</Views>
<Visits>long</Visits>
<BandwidthBytes>long</BandwidthBytes>
<RawBandwidthBytes>long</RawBandwidthBytes>
<FileBandwidth>long</FileBandwidth>
<Keyword>string</Keyword>
<SearchRank>int</SearchRank>
<ResultCount>long</ResultCount>
<ViewsDuringVisit>long</ViewsDuringVisit>
<SiteUrl>string</SiteUrl>
<SiteUrlLink>string</SiteUrlLink>
<Location xsi:nil="true" />
</QueryResultRow>
<QueryResultRow>
<ID>int</ID>
<ItemCount>long</ItemCount>
<DateTicks>long</DateTicks>
<Name>string</Name>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<RegionCode>string</RegionCode>
<RegionName>string</RegionName>
<RegionFipsCode>string</RegionFipsCode>
<City>string</City>
<IpAddress>string</IpAddress>
<Browser>string</Browser>
<Device>string</Device>
<BrowserVersion>string</BrowserVersion>
<Platform>string</Platform>
<SearchEngine>string</SearchEngine>
<Phrase>string</Phrase>
<ProtocolStatus>string</ProtocolStatus>
<URIStemText>string</URIStemText>
<BandwidthIn>long</BandwidthIn>
<BandwidthOut>long</BandwidthOut>
<DateOfLog>dateTime</DateOfLog>
<DateFirst>dateTime</DateFirst>
<DateLast>dateTime</DateLast>
<ServerName>string</ServerName>
<Username>string</Username>
<Bounces>long</Bounces>
<Entrances>long</Entrances>
<Exits>long</Exits>
<Visitors>long</Visitors>
<UniqueVisits>long</UniqueVisits>
<ReturnVisits>long</ReturnVisits>
<NewVisits>long</NewVisits>
<TimeTakenMs>long</TimeTakenMs>
<VisitLengthSeconds>long</VisitLengthSeconds>
<Hits>long</Hits>
<Views>long</Views>
<Visits>long</Visits>
<BandwidthBytes>long</BandwidthBytes>
<RawBandwidthBytes>long</RawBandwidthBytes>
<FileBandwidth>long</FileBandwidth>
<Keyword>string</Keyword>
<SearchRank>int</SearchRank>
<ResultCount>long</ResultCount>
<ViewsDuringVisit>long</ViewsDuringVisit>
<SiteUrl>string</SiteUrl>
<SiteUrlLink>string</SiteUrlLink>
<Location xsi:nil="true" />
</QueryResultRow>
</TableData>
<FooterUnknown>
<ID>int</ID>
<ItemCount>long</ItemCount>
<DateTicks>long</DateTicks>
<Name>string</Name>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<RegionCode>string</RegionCode>
<RegionName>string</RegionName>
<RegionFipsCode>string</RegionFipsCode>
<City>string</City>
<IpAddress>string</IpAddress>
<Browser>string</Browser>
<Device>string</Device>
<BrowserVersion>string</BrowserVersion>
<Platform>string</Platform>
<SearchEngine>string</SearchEngine>
<Phrase>string</Phrase>
<ProtocolStatus>string</ProtocolStatus>
<URIStemText>string</URIStemText>
<BandwidthIn>long</BandwidthIn>
<BandwidthOut>long</BandwidthOut>
<DateOfLog>dateTime</DateOfLog>
<DateFirst>dateTime</DateFirst>
<DateLast>dateTime</DateLast>
<ServerName>string</ServerName>
<Username>string</Username>
<Bounces>long</Bounces>
<Entrances>long</Entrances>
<Exits>long</Exits>
<Visitors>long</Visitors>
<UniqueVisits>long</UniqueVisits>
<ReturnVisits>long</ReturnVisits>
<NewVisits>long</NewVisits>
<TimeTakenMs>long</TimeTakenMs>
<VisitLengthSeconds>long</VisitLengthSeconds>
<Hits>long</Hits>
<Views>long</Views>
<Visits>long</Visits>
<BandwidthBytes>long</BandwidthBytes>
<RawBandwidthBytes>long</RawBandwidthBytes>
<FileBandwidth>long</FileBandwidth>
<Keyword>string</Keyword>
<SearchRank>int</SearchRank>
<ResultCount>long</ResultCount>
<ViewsDuringVisit>long</ViewsDuringVisit>
<SiteUrl>string</SiteUrl>
<SiteUrlLink>string</SiteUrlLink>
<Location>
<area_code>int</area_code>
<city>string</city>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<DmaCode>int</DmaCode>
<Latitude>double</Latitude>
<Longitude>double</Longitude>
<PostalCode>string</PostalCode>
<region>string</region>
</Location>
</FooterUnknown>
<FooterOtherItems>
<ID>int</ID>
<ItemCount>long</ItemCount>
<DateTicks>long</DateTicks>
<Name>string</Name>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<RegionCode>string</RegionCode>
<RegionName>string</RegionName>
<RegionFipsCode>string</RegionFipsCode>
<City>string</City>
<IpAddress>string</IpAddress>
<Browser>string</Browser>
<Device>string</Device>
<BrowserVersion>string</BrowserVersion>
<Platform>string</Platform>
<SearchEngine>string</SearchEngine>
<Phrase>string</Phrase>
<ProtocolStatus>string</ProtocolStatus>
<URIStemText>string</URIStemText>
<BandwidthIn>long</BandwidthIn>
<BandwidthOut>long</BandwidthOut>
<DateOfLog>dateTime</DateOfLog>
<DateFirst>dateTime</DateFirst>
<DateLast>dateTime</DateLast>
<ServerName>string</ServerName>
<Username>string</Username>
<Bounces>long</Bounces>
<Entrances>long</Entrances>
<Exits>long</Exits>
<Visitors>long</Visitors>
<UniqueVisits>long</UniqueVisits>
<ReturnVisits>long</ReturnVisits>
<NewVisits>long</NewVisits>
<TimeTakenMs>long</TimeTakenMs>
<VisitLengthSeconds>long</VisitLengthSeconds>
<Hits>long</Hits>
<Views>long</Views>
<Visits>long</Visits>
<BandwidthBytes>long</BandwidthBytes>
<RawBandwidthBytes>long</RawBandwidthBytes>
<FileBandwidth>long</FileBandwidth>
<Keyword>string</Keyword>
<SearchRank>int</SearchRank>
<ResultCount>long</ResultCount>
<ViewsDuringVisit>long</ViewsDuringVisit>
<SiteUrl>string</SiteUrl>
<SiteUrlLink>string</SiteUrlLink>
<Location>
<area_code>int</area_code>
<city>string</city>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<DmaCode>int</DmaCode>
<Latitude>double</Latitude>
<Longitude>double</Longitude>
<PostalCode>string</PostalCode>
<region>string</region>
</Location>
</FooterOtherItems>
<FooterTotals>
<ID>int</ID>
<ItemCount>long</ItemCount>
<DateTicks>long</DateTicks>
<Name>string</Name>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<RegionCode>string</RegionCode>
<RegionName>string</RegionName>
<RegionFipsCode>string</RegionFipsCode>
<City>string</City>
<IpAddress>string</IpAddress>
<Browser>string</Browser>
<Device>string</Device>
<BrowserVersion>string</BrowserVersion>
<Platform>string</Platform>
<SearchEngine>string</SearchEngine>
<Phrase>string</Phrase>
<ProtocolStatus>string</ProtocolStatus>
<URIStemText>string</URIStemText>
<BandwidthIn>long</BandwidthIn>
<BandwidthOut>long</BandwidthOut>
<DateOfLog>dateTime</DateOfLog>
<DateFirst>dateTime</DateFirst>
<DateLast>dateTime</DateLast>
<ServerName>string</ServerName>
<Username>string</Username>
<Bounces>long</Bounces>
<Entrances>long</Entrances>
<Exits>long</Exits>
<Visitors>long</Visitors>
<UniqueVisits>long</UniqueVisits>
<ReturnVisits>long</ReturnVisits>
<NewVisits>long</NewVisits>
<TimeTakenMs>long</TimeTakenMs>
<VisitLengthSeconds>long</VisitLengthSeconds>
<Hits>long</Hits>
<Views>long</Views>
<Visits>long</Visits>
<BandwidthBytes>long</BandwidthBytes>
<RawBandwidthBytes>long</RawBandwidthBytes>
<FileBandwidth>long</FileBandwidth>
<Keyword>string</Keyword>
<SearchRank>int</SearchRank>
<ResultCount>long</ResultCount>
<ViewsDuringVisit>long</ViewsDuringVisit>
<SiteUrl>string</SiteUrl>
<SiteUrlLink>string</SiteUrlLink>
<Location>
<area_code>int</area_code>
<city>string</city>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<DmaCode>int</DmaCode>
<Latitude>double</Latitude>
<Longitude>double</Longitude>
<PostalCode>string</PostalCode>
<region>string</region>
</Location>
</FooterTotals>
</ExecuteQueryResult>
</ExecuteQueryResponse>
</soap12:Body>
</soap12:Envelope>
HTTP GET
The following is a sample HTTP GET request and response. The placeholders shown need to be replaced with actual values.
GET /Services/Query.asmx/ExecuteQuery?authUserName=string&authPassword=string&authorizationCode=string&queryName=string&keyValuePairs=string&keyValuePairs=string HTTP/1.1 Host: stats.smartertools.com
HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length
<?xml version="1.0" encoding="utf-8"?>
<QueryResult xmlns="http://smartertools.com/smarterstats/query/">
<Success>boolean</Success>
<Completed>boolean</Completed>
<CompletedPercent>int</CompletedPercent>
<AsyncGuid>string</AsyncGuid>
<QueryTimeMilliseconds>long</QueryTimeMilliseconds>
<TableData>
<QueryResultRow>
<ID>int</ID>
<ItemCount>long</ItemCount>
<DateTicks>long</DateTicks>
<Name>string</Name>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<RegionCode>string</RegionCode>
<RegionName>string</RegionName>
<RegionFipsCode>string</RegionFipsCode>
<City>string</City>
<IpAddress>string</IpAddress>
<Browser>string</Browser>
<Device>string</Device>
<BrowserVersion>string</BrowserVersion>
<Platform>string</Platform>
<SearchEngine>string</SearchEngine>
<Phrase>string</Phrase>
<ProtocolStatus>string</ProtocolStatus>
<URIStemText>string</URIStemText>
<BandwidthIn>long</BandwidthIn>
<BandwidthOut>long</BandwidthOut>
<DateOfLog>dateTime</DateOfLog>
<DateFirst>dateTime</DateFirst>
<DateLast>dateTime</DateLast>
<ServerName>string</ServerName>
<Username>string</Username>
<Bounces>long</Bounces>
<Entrances>long</Entrances>
<Exits>long</Exits>
<Visitors>long</Visitors>
<UniqueVisits>long</UniqueVisits>
<ReturnVisits>long</ReturnVisits>
<NewVisits>long</NewVisits>
<TimeTakenMs>long</TimeTakenMs>
<VisitLengthSeconds>long</VisitLengthSeconds>
<Hits>long</Hits>
<Views>long</Views>
<Visits>long</Visits>
<BandwidthBytes>long</BandwidthBytes>
<RawBandwidthBytes>long</RawBandwidthBytes>
<FileBandwidth>long</FileBandwidth>
<Keyword>string</Keyword>
<SearchRank>int</SearchRank>
<ResultCount>long</ResultCount>
<ViewsDuringVisit>long</ViewsDuringVisit>
<SiteUrl>string</SiteUrl>
<SiteUrlLink>string</SiteUrlLink>
<Location>
<area_code>int</area_code>
<city>string</city>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<DmaCode>int</DmaCode>
<Latitude>double</Latitude>
<Longitude>double</Longitude>
<PostalCode>string</PostalCode>
<region>string</region>
</Location>
</QueryResultRow>
<QueryResultRow>
<ID>int</ID>
<ItemCount>long</ItemCount>
<DateTicks>long</DateTicks>
<Name>string</Name>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<RegionCode>string</RegionCode>
<RegionName>string</RegionName>
<RegionFipsCode>string</RegionFipsCode>
<City>string</City>
<IpAddress>string</IpAddress>
<Browser>string</Browser>
<Device>string</Device>
<BrowserVersion>string</BrowserVersion>
<Platform>string</Platform>
<SearchEngine>string</SearchEngine>
<Phrase>string</Phrase>
<ProtocolStatus>string</ProtocolStatus>
<URIStemText>string</URIStemText>
<BandwidthIn>long</BandwidthIn>
<BandwidthOut>long</BandwidthOut>
<DateOfLog>dateTime</DateOfLog>
<DateFirst>dateTime</DateFirst>
<DateLast>dateTime</DateLast>
<ServerName>string</ServerName>
<Username>string</Username>
<Bounces>long</Bounces>
<Entrances>long</Entrances>
<Exits>long</Exits>
<Visitors>long</Visitors>
<UniqueVisits>long</UniqueVisits>
<ReturnVisits>long</ReturnVisits>
<NewVisits>long</NewVisits>
<TimeTakenMs>long</TimeTakenMs>
<VisitLengthSeconds>long</VisitLengthSeconds>
<Hits>long</Hits>
<Views>long</Views>
<Visits>long</Visits>
<BandwidthBytes>long</BandwidthBytes>
<RawBandwidthBytes>long</RawBandwidthBytes>
<FileBandwidth>long</FileBandwidth>
<Keyword>string</Keyword>
<SearchRank>int</SearchRank>
<ResultCount>long</ResultCount>
<ViewsDuringVisit>long</ViewsDuringVisit>
<SiteUrl>string</SiteUrl>
<SiteUrlLink>string</SiteUrlLink>
<Location>
<area_code>int</area_code>
<city>string</city>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<DmaCode>int</DmaCode>
<Latitude>double</Latitude>
<Longitude>double</Longitude>
<PostalCode>string</PostalCode>
<region>string</region>
</Location>
</QueryResultRow>
</TableData>
<FooterUnknown>
<ID>int</ID>
<ItemCount>long</ItemCount>
<DateTicks>long</DateTicks>
<Name>string</Name>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<RegionCode>string</RegionCode>
<RegionName>string</RegionName>
<RegionFipsCode>string</RegionFipsCode>
<City>string</City>
<IpAddress>string</IpAddress>
<Browser>string</Browser>
<Device>string</Device>
<BrowserVersion>string</BrowserVersion>
<Platform>string</Platform>
<SearchEngine>string</SearchEngine>
<Phrase>string</Phrase>
<ProtocolStatus>string</ProtocolStatus>
<URIStemText>string</URIStemText>
<BandwidthIn>long</BandwidthIn>
<BandwidthOut>long</BandwidthOut>
<DateOfLog>dateTime</DateOfLog>
<DateFirst>dateTime</DateFirst>
<DateLast>dateTime</DateLast>
<ServerName>string</ServerName>
<Username>string</Username>
<Bounces>long</Bounces>
<Entrances>long</Entrances>
<Exits>long</Exits>
<Visitors>long</Visitors>
<UniqueVisits>long</UniqueVisits>
<ReturnVisits>long</ReturnVisits>
<NewVisits>long</NewVisits>
<TimeTakenMs>long</TimeTakenMs>
<VisitLengthSeconds>long</VisitLengthSeconds>
<Hits>long</Hits>
<Views>long</Views>
<Visits>long</Visits>
<BandwidthBytes>long</BandwidthBytes>
<RawBandwidthBytes>long</RawBandwidthBytes>
<FileBandwidth>long</FileBandwidth>
<Keyword>string</Keyword>
<SearchRank>int</SearchRank>
<ResultCount>long</ResultCount>
<ViewsDuringVisit>long</ViewsDuringVisit>
<SiteUrl>string</SiteUrl>
<SiteUrlLink>string</SiteUrlLink>
<Location>
<area_code>int</area_code>
<city>string</city>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<DmaCode>int</DmaCode>
<Latitude>double</Latitude>
<Longitude>double</Longitude>
<PostalCode>string</PostalCode>
<region>string</region>
</Location>
</FooterUnknown>
<FooterOtherItems>
<ID>int</ID>
<ItemCount>long</ItemCount>
<DateTicks>long</DateTicks>
<Name>string</Name>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<RegionCode>string</RegionCode>
<RegionName>string</RegionName>
<RegionFipsCode>string</RegionFipsCode>
<City>string</City>
<IpAddress>string</IpAddress>
<Browser>string</Browser>
<Device>string</Device>
<BrowserVersion>string</BrowserVersion>
<Platform>string</Platform>
<SearchEngine>string</SearchEngine>
<Phrase>string</Phrase>
<ProtocolStatus>string</ProtocolStatus>
<URIStemText>string</URIStemText>
<BandwidthIn>long</BandwidthIn>
<BandwidthOut>long</BandwidthOut>
<DateOfLog>dateTime</DateOfLog>
<DateFirst>dateTime</DateFirst>
<DateLast>dateTime</DateLast>
<ServerName>string</ServerName>
<Username>string</Username>
<Bounces>long</Bounces>
<Entrances>long</Entrances>
<Exits>long</Exits>
<Visitors>long</Visitors>
<UniqueVisits>long</UniqueVisits>
<ReturnVisits>long</ReturnVisits>
<NewVisits>long</NewVisits>
<TimeTakenMs>long</TimeTakenMs>
<VisitLengthSeconds>long</VisitLengthSeconds>
<Hits>long</Hits>
<Views>long</Views>
<Visits>long</Visits>
<BandwidthBytes>long</BandwidthBytes>
<RawBandwidthBytes>long</RawBandwidthBytes>
<FileBandwidth>long</FileBandwidth>
<Keyword>string</Keyword>
<SearchRank>int</SearchRank>
<ResultCount>long</ResultCount>
<ViewsDuringVisit>long</ViewsDuringVisit>
<SiteUrl>string</SiteUrl>
<SiteUrlLink>string</SiteUrlLink>
<Location>
<area_code>int</area_code>
<city>string</city>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<DmaCode>int</DmaCode>
<Latitude>double</Latitude>
<Longitude>double</Longitude>
<PostalCode>string</PostalCode>
<region>string</region>
</Location>
</FooterOtherItems>
<FooterTotals>
<ID>int</ID>
<ItemCount>long</ItemCount>
<DateTicks>long</DateTicks>
<Name>string</Name>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<RegionCode>string</RegionCode>
<RegionName>string</RegionName>
<RegionFipsCode>string</RegionFipsCode>
<City>string</City>
<IpAddress>string</IpAddress>
<Browser>string</Browser>
<Device>string</Device>
<BrowserVersion>string</BrowserVersion>
<Platform>string</Platform>
<SearchEngine>string</SearchEngine>
<Phrase>string</Phrase>
<ProtocolStatus>string</ProtocolStatus>
<URIStemText>string</URIStemText>
<BandwidthIn>long</BandwidthIn>
<BandwidthOut>long</BandwidthOut>
<DateOfLog>dateTime</DateOfLog>
<DateFirst>dateTime</DateFirst>
<DateLast>dateTime</DateLast>
<ServerName>string</ServerName>
<Username>string</Username>
<Bounces>long</Bounces>
<Entrances>long</Entrances>
<Exits>long</Exits>
<Visitors>long</Visitors>
<UniqueVisits>long</UniqueVisits>
<ReturnVisits>long</ReturnVisits>
<NewVisits>long</NewVisits>
<TimeTakenMs>long</TimeTakenMs>
<VisitLengthSeconds>long</VisitLengthSeconds>
<Hits>long</Hits>
<Views>long</Views>
<Visits>long</Visits>
<BandwidthBytes>long</BandwidthBytes>
<RawBandwidthBytes>long</RawBandwidthBytes>
<FileBandwidth>long</FileBandwidth>
<Keyword>string</Keyword>
<SearchRank>int</SearchRank>
<ResultCount>long</ResultCount>
<ViewsDuringVisit>long</ViewsDuringVisit>
<SiteUrl>string</SiteUrl>
<SiteUrlLink>string</SiteUrlLink>
<Location>
<area_code>int</area_code>
<city>string</city>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<DmaCode>int</DmaCode>
<Latitude>double</Latitude>
<Longitude>double</Longitude>
<PostalCode>string</PostalCode>
<region>string</region>
</Location>
</FooterTotals>
</QueryResult>
HTTP POST
The following is a sample HTTP POST request and response. The placeholders shown need to be replaced with actual values.
POST /Services/Query.asmx/ExecuteQuery HTTP/1.1 Host: stats.smartertools.com Content-Type: application/x-www-form-urlencoded Content-Length: length authUserName=string&authPassword=string&authorizationCode=string&queryName=string&keyValuePairs=string&keyValuePairs=string
HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length
<?xml version="1.0" encoding="utf-8"?>
<QueryResult xmlns="http://smartertools.com/smarterstats/query/">
<Success>boolean</Success>
<Completed>boolean</Completed>
<CompletedPercent>int</CompletedPercent>
<AsyncGuid>string</AsyncGuid>
<QueryTimeMilliseconds>long</QueryTimeMilliseconds>
<TableData>
<QueryResultRow>
<ID>int</ID>
<ItemCount>long</ItemCount>
<DateTicks>long</DateTicks>
<Name>string</Name>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<RegionCode>string</RegionCode>
<RegionName>string</RegionName>
<RegionFipsCode>string</RegionFipsCode>
<City>string</City>
<IpAddress>string</IpAddress>
<Browser>string</Browser>
<Device>string</Device>
<BrowserVersion>string</BrowserVersion>
<Platform>string</Platform>
<SearchEngine>string</SearchEngine>
<Phrase>string</Phrase>
<ProtocolStatus>string</ProtocolStatus>
<URIStemText>string</URIStemText>
<BandwidthIn>long</BandwidthIn>
<BandwidthOut>long</BandwidthOut>
<DateOfLog>dateTime</DateOfLog>
<DateFirst>dateTime</DateFirst>
<DateLast>dateTime</DateLast>
<ServerName>string</ServerName>
<Username>string</Username>
<Bounces>long</Bounces>
<Entrances>long</Entrances>
<Exits>long</Exits>
<Visitors>long</Visitors>
<UniqueVisits>long</UniqueVisits>
<ReturnVisits>long</ReturnVisits>
<NewVisits>long</NewVisits>
<TimeTakenMs>long</TimeTakenMs>
<VisitLengthSeconds>long</VisitLengthSeconds>
<Hits>long</Hits>
<Views>long</Views>
<Visits>long</Visits>
<BandwidthBytes>long</BandwidthBytes>
<RawBandwidthBytes>long</RawBandwidthBytes>
<FileBandwidth>long</FileBandwidth>
<Keyword>string</Keyword>
<SearchRank>int</SearchRank>
<ResultCount>long</ResultCount>
<ViewsDuringVisit>long</ViewsDuringVisit>
<SiteUrl>string</SiteUrl>
<SiteUrlLink>string</SiteUrlLink>
<Location>
<area_code>int</area_code>
<city>string</city>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<DmaCode>int</DmaCode>
<Latitude>double</Latitude>
<Longitude>double</Longitude>
<PostalCode>string</PostalCode>
<region>string</region>
</Location>
</QueryResultRow>
<QueryResultRow>
<ID>int</ID>
<ItemCount>long</ItemCount>
<DateTicks>long</DateTicks>
<Name>string</Name>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<RegionCode>string</RegionCode>
<RegionName>string</RegionName>
<RegionFipsCode>string</RegionFipsCode>
<City>string</City>
<IpAddress>string</IpAddress>
<Browser>string</Browser>
<Device>string</Device>
<BrowserVersion>string</BrowserVersion>
<Platform>string</Platform>
<SearchEngine>string</SearchEngine>
<Phrase>string</Phrase>
<ProtocolStatus>string</ProtocolStatus>
<URIStemText>string</URIStemText>
<BandwidthIn>long</BandwidthIn>
<BandwidthOut>long</BandwidthOut>
<DateOfLog>dateTime</DateOfLog>
<DateFirst>dateTime</DateFirst>
<DateLast>dateTime</DateLast>
<ServerName>string</ServerName>
<Username>string</Username>
<Bounces>long</Bounces>
<Entrances>long</Entrances>
<Exits>long</Exits>
<Visitors>long</Visitors>
<UniqueVisits>long</UniqueVisits>
<ReturnVisits>long</ReturnVisits>
<NewVisits>long</NewVisits>
<TimeTakenMs>long</TimeTakenMs>
<VisitLengthSeconds>long</VisitLengthSeconds>
<Hits>long</Hits>
<Views>long</Views>
<Visits>long</Visits>
<BandwidthBytes>long</BandwidthBytes>
<RawBandwidthBytes>long</RawBandwidthBytes>
<FileBandwidth>long</FileBandwidth>
<Keyword>string</Keyword>
<SearchRank>int</SearchRank>
<ResultCount>long</ResultCount>
<ViewsDuringVisit>long</ViewsDuringVisit>
<SiteUrl>string</SiteUrl>
<SiteUrlLink>string</SiteUrlLink>
<Location>
<area_code>int</area_code>
<city>string</city>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<DmaCode>int</DmaCode>
<Latitude>double</Latitude>
<Longitude>double</Longitude>
<PostalCode>string</PostalCode>
<region>string</region>
</Location>
</QueryResultRow>
</TableData>
<FooterUnknown>
<ID>int</ID>
<ItemCount>long</ItemCount>
<DateTicks>long</DateTicks>
<Name>string</Name>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<RegionCode>string</RegionCode>
<RegionName>string</RegionName>
<RegionFipsCode>string</RegionFipsCode>
<City>string</City>
<IpAddress>string</IpAddress>
<Browser>string</Browser>
<Device>string</Device>
<BrowserVersion>string</BrowserVersion>
<Platform>string</Platform>
<SearchEngine>string</SearchEngine>
<Phrase>string</Phrase>
<ProtocolStatus>string</ProtocolStatus>
<URIStemText>string</URIStemText>
<BandwidthIn>long</BandwidthIn>
<BandwidthOut>long</BandwidthOut>
<DateOfLog>dateTime</DateOfLog>
<DateFirst>dateTime</DateFirst>
<DateLast>dateTime</DateLast>
<ServerName>string</ServerName>
<Username>string</Username>
<Bounces>long</Bounces>
<Entrances>long</Entrances>
<Exits>long</Exits>
<Visitors>long</Visitors>
<UniqueVisits>long</UniqueVisits>
<ReturnVisits>long</ReturnVisits>
<NewVisits>long</NewVisits>
<TimeTakenMs>long</TimeTakenMs>
<VisitLengthSeconds>long</VisitLengthSeconds>
<Hits>long</Hits>
<Views>long</Views>
<Visits>long</Visits>
<BandwidthBytes>long</BandwidthBytes>
<RawBandwidthBytes>long</RawBandwidthBytes>
<FileBandwidth>long</FileBandwidth>
<Keyword>string</Keyword>
<SearchRank>int</SearchRank>
<ResultCount>long</ResultCount>
<ViewsDuringVisit>long</ViewsDuringVisit>
<SiteUrl>string</SiteUrl>
<SiteUrlLink>string</SiteUrlLink>
<Location>
<area_code>int</area_code>
<city>string</city>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<DmaCode>int</DmaCode>
<Latitude>double</Latitude>
<Longitude>double</Longitude>
<PostalCode>string</PostalCode>
<region>string</region>
</Location>
</FooterUnknown>
<FooterOtherItems>
<ID>int</ID>
<ItemCount>long</ItemCount>
<DateTicks>long</DateTicks>
<Name>string</Name>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<RegionCode>string</RegionCode>
<RegionName>string</RegionName>
<RegionFipsCode>string</RegionFipsCode>
<City>string</City>
<IpAddress>string</IpAddress>
<Browser>string</Browser>
<Device>string</Device>
<BrowserVersion>string</BrowserVersion>
<Platform>string</Platform>
<SearchEngine>string</SearchEngine>
<Phrase>string</Phrase>
<ProtocolStatus>string</ProtocolStatus>
<URIStemText>string</URIStemText>
<BandwidthIn>long</BandwidthIn>
<BandwidthOut>long</BandwidthOut>
<DateOfLog>dateTime</DateOfLog>
<DateFirst>dateTime</DateFirst>
<DateLast>dateTime</DateLast>
<ServerName>string</ServerName>
<Username>string</Username>
<Bounces>long</Bounces>
<Entrances>long</Entrances>
<Exits>long</Exits>
<Visitors>long</Visitors>
<UniqueVisits>long</UniqueVisits>
<ReturnVisits>long</ReturnVisits>
<NewVisits>long</NewVisits>
<TimeTakenMs>long</TimeTakenMs>
<VisitLengthSeconds>long</VisitLengthSeconds>
<Hits>long</Hits>
<Views>long</Views>
<Visits>long</Visits>
<BandwidthBytes>long</BandwidthBytes>
<RawBandwidthBytes>long</RawBandwidthBytes>
<FileBandwidth>long</FileBandwidth>
<Keyword>string</Keyword>
<SearchRank>int</SearchRank>
<ResultCount>long</ResultCount>
<ViewsDuringVisit>long</ViewsDuringVisit>
<SiteUrl>string</SiteUrl>
<SiteUrlLink>string</SiteUrlLink>
<Location>
<area_code>int</area_code>
<city>string</city>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<DmaCode>int</DmaCode>
<Latitude>double</Latitude>
<Longitude>double</Longitude>
<PostalCode>string</PostalCode>
<region>string</region>
</Location>
</FooterOtherItems>
<FooterTotals>
<ID>int</ID>
<ItemCount>long</ItemCount>
<DateTicks>long</DateTicks>
<Name>string</Name>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<RegionCode>string</RegionCode>
<RegionName>string</RegionName>
<RegionFipsCode>string</RegionFipsCode>
<City>string</City>
<IpAddress>string</IpAddress>
<Browser>string</Browser>
<Device>string</Device>
<BrowserVersion>string</BrowserVersion>
<Platform>string</Platform>
<SearchEngine>string</SearchEngine>
<Phrase>string</Phrase>
<ProtocolStatus>string</ProtocolStatus>
<URIStemText>string</URIStemText>
<BandwidthIn>long</BandwidthIn>
<BandwidthOut>long</BandwidthOut>
<DateOfLog>dateTime</DateOfLog>
<DateFirst>dateTime</DateFirst>
<DateLast>dateTime</DateLast>
<ServerName>string</ServerName>
<Username>string</Username>
<Bounces>long</Bounces>
<Entrances>long</Entrances>
<Exits>long</Exits>
<Visitors>long</Visitors>
<UniqueVisits>long</UniqueVisits>
<ReturnVisits>long</ReturnVisits>
<NewVisits>long</NewVisits>
<TimeTakenMs>long</TimeTakenMs>
<VisitLengthSeconds>long</VisitLengthSeconds>
<Hits>long</Hits>
<Views>long</Views>
<Visits>long</Visits>
<BandwidthBytes>long</BandwidthBytes>
<RawBandwidthBytes>long</RawBandwidthBytes>
<FileBandwidth>long</FileBandwidth>
<Keyword>string</Keyword>
<SearchRank>int</SearchRank>
<ResultCount>long</ResultCount>
<ViewsDuringVisit>long</ViewsDuringVisit>
<SiteUrl>string</SiteUrl>
<SiteUrlLink>string</SiteUrlLink>
<Location>
<area_code>int</area_code>
<city>string</city>
<CountryCode>string</CountryCode>
<CountryName>string</CountryName>
<DmaCode>int</DmaCode>
<Latitude>double</Latitude>
<Longitude>double</Longitude>
<PostalCode>string</PostalCode>
<region>string</region>
</Location>
</FooterTotals>
</QueryResult>