Get summary statistics
SmsMmsSummaryStatistics collection allows retrieving summary performance statistics of your messages. Statistics may be filtered and grouped by various parameters, exactly the same as using Reports->SMS/MMS Summary page in ExpertSender Web Panel.
Request data format
Request URL parameters:
Element/attribute | Type | Notes |
---|---|---|
apiKey | string | Your API key, required for authentication. Required. |
startDate | date | Start date. Optional. If not specified, business unit creation date will be taken. YYYY-MM-DD format. |
endDate | date | End date. Optional. If not specified, current date will be taken. YYYY-MM-DD format. |
scope | string | Filtering scope. Optional. If not specified, no filtering will be applied (data for the whole business unit will be returned). Available scopes are: List — only results for specific subscriber list SmsMmsMessageType — only results for specific message type* Segment — only results for specific subscriber segment Vendor — only results for specific vendor Tag — only results for messages marked with a tag MobileOS — only results for specific Mobile OS Sender — only results for specific sender |
scopeValue | mixed | Filtering scope value. Required if scope was specified. This is a mixed value, type depends on selected scope: List — List ID, int, e.g. 123 Segment — Segment ID, int, e.g. 123 SmsMmsMessageType — message type name, string, e.g. Newsletter* Vendor — vendor name, string, e.g. foobar Tag — Tag name, string, e.g. holidays MobileOS — mobile OS name, string, e.g. Android Sender — sender name, string, e.g. smsApi |
grouping | string | Results grouping. Optional. If not specified, results will be grouped by whole business unit (one row of data will be returned with all values summed up). Available groupings are: Date Month SmsMmsMessage SmsMmsMessageType List Segment Vendor Tag MobileOS Sender NOTE: It is impossible to filter and group by the same thing. scope parameter value must be different from grouping parameter value. |
returnMessageTags | boolean | If set to true and grouping set to SmsMmsMessage, then Tags used in each message will be returned. Optional. Default set to false. |
Examples:
https://api.esv2.com/v2/Api/SmsMmsSummaryStatistics?apiKey=YOUR_API_KEY_HERE
https://api.esv2.com/v2/Api/SmsMmsSummaryStatistics?apiKey=YOUR_API_KEY_HERE&startDate=2022-12-01&endDate=2022-12-31
https://api.esv2.com/v2/Api/SmsMmsSummaryStatistics?apiKey=YOUR_API_KEY_HERE&scope=List&scopeValue=123
https://api.esv2.com/v2/Api/SmsMmsSummaryStatistics?apiKey=YOUR_API_KEY_HERE&scope=SmsMmsMessageType&scopeValue=Newsletter&grouping=Date
https://api.esv2.com/v2/Api/SmsMmsSummaryStatistics?apiKey=YOUR_API_KEY_HERE&startDate=2022-12-01&endDate=2022-12-31&scope=SmsMmsMessageType&scopeValue=Newsletter&scope2=Segment&scopeValue2=13&grouping=Date
SummaryStatistic element children:
Element/attribute | Type | Notes |
---|---|---|
IsSummaryRow | boolean | If set to true, marks the summary row of statistic table (values are sums of all other rows).* |
Date | date | Date. Returned only if grouping by dates was requested. |
Month | string | Month represented as date period. Returned only if grouping by months was requested. Example: 2018-01-01 : 2018-01-31 |
SmsMmsMessageId | int | Message ID. Returned only if grouping by messages was requested. |
Campaign | string | Campaign description. Returned only if grouping by messages was requested. |
SmsMmsMessageType | string | Message type name. Returned only if grouping by message type was requested. |
ListId | int | Subscriber list ID. Returned only if grouping by lists was requested. |
ListName | string | Subscriber list name. Returned only if grouping by lists was requested. |
SegmentId | int | Subscriber segment ID. Returned only if grouping by segments was requested. |
SegmentName | string | Subscriber segment name. Returned only if grouping by segments as requested. If row contains data about unsegmented subscribers, it will return dash («-«) as value. |
Vendor | string | Vendor name. Returned only if grouping by vendors was requested. If row contains data about subscribers with no vendor, dash («-«) will be returned. |
Tag | string | Tag name. Returned only if grouping by tags was requested. |
MobileOS | string | Mobile OS name. Returned only if grouping by mobile OS was requested. |
Sender | string | Sender. Returned only if grouping by senders was requested. |
Sent | int | Number of sent messages. |
PartsSent | int | Number of sent message parts. |
Bounced | int | Number of bounced messages. |
Delivered | int | Number of delivered (sent — bounced) messages. |
Clicks | int | Number of link clicks. |
Clickers | int | Number of unique subscribers that clicked any link. |
Unsubscribes | int | Number of “unsubscribe” link clicks. |
Goals | int | Number of achieved business goals. |
GoalsValue | int | Value of achieved business goals. |
*Summary rows do not contain grouping columns (e.g. Date, Month).
Examples
Statistics grouped by list from a certain period of time:
Request:
GET https://api.esv2.com/v2/Api/SmsMmsSummaryStatistics?apiKey=test_api_key1&startDate=2018-01-01&endDate=2018-01-30&grouping=List HTTP/1.1
Accept-Encoding: gzip,deflate
User-Agent: Jakarta Commons-HttpClient/3.1
Host: api.esv2.com
OK response:
HTTP/1.1 200 OK
Cache-Control: private
Content-Type: text/xml; charset=utf-8
Server: Microsoft-IIS/7.5
X-AspNetMvc-Version: 5.0
X-AspNet-Version: 4.0.30319
Set-Cookie: TEMP_DATA=209ffb47-7020-4508-99dc-8f7083928452; path=/
X-Powered-By: ASP.NET
Date: Wed, 21 Feb 2018 14:51:50 GMT
Content-Length: 97229
<ApiResponse xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Data>
<SummaryStatistics>
<SummaryStatistic>
<IsSummaryRow>true</IsSummaryRow>
<Sent>3656424</Sent>
<PartsSent>7334910</PartsSent>
<Bounced>478621</Bounced>
<Delivered>3177803</Delivered>
<Clicks>145664</Clicks>
<Clickers>98761</Clickers>
<Unsubscribes>34211</Unsubscribes>
<Goals>12344</Goals>
<GoalsValue>123440</GoalsValue>
</SummaryStatistic>
<SummaryStatistic>
<ListId>38</ListId>
<ListName>test list</ListName>
<Sent>1262372</Sent>
<PartsSent>1490223</PartsSent>
<Bounced>144511</Bounced>
<Delivered>1117861</Delivered>
<Clicks>83445</Clicks>
<Clickers>34552</Clickers>
<Unsubscribes>56775</Unsubscribes>
<Goals>3345</Goals>
<GoalsValue>33450</GoalsValue>
</SummaryStatistic>
...
</SummaryStatistics>
</Data>
</ApiResponse>
Statistics filtered by message type and grouped by month:
Request:
GET https://api.esv2.com/v2/Api/SummaryStatistics?apiKey=test_api_key1&scope=SmsMmsMessageType&scopeValue=Newsletter&grouping=Month HTTP/1.1
Accept-Encoding: gzip,deflate
User-Agent: Jakarta Commons-HttpClient/3.1
Host: api.esv2.com
OK response:
HTTP/1.1 200 OK
Cache-Control: private
Content-Type: text/xml; charset=utf-8
Server: Microsoft-IIS/7.5
X-AspNetMvc-Version: 5.0
X-AspNet-Version: 4.0.30319
Set-Cookie: TEMP_DATA=90015733-b2c3-4a23-93ac-b9bce60ab8af; path=/
X-Powered-By: ASP.NET
Date: Wed, 21 Feb 2018 15:04:03 GMT
Content-Length: 5655
<ApiResponse xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Data>
<SummaryStatistics>
<SummaryStatistic>
<IsSummaryRow>true</IsSummaryRow>
<Sent>21256701</Sent>
<PartsSent>32721341</PartsSent>
<Bounced>6136556</Bounced>
<Delivered>15120145</Delivered>
<Clicks>17264</Clicks>
<Clickers>12326</Clickers>
<Unsubscribes>3351</Unsubscribes>
<Goals>0</Goals>
<GoalsValue>0</GoalsValue>
</SummaryStatistic>
<SummaryStatistic>
<Month>2018-01-01 : 2018-01-31</Month>
<Sent>5051025</Sent>
<PartsSent>6725568</PartsSent>
<Bounced>1814659</Bounced>
<Delivered>3236366</Delivered>
<Clicks>4194</Clicks>
<Clickers>2887</Clickers>
<Unsubscribes>799</Unsubscribes>
<Goals>0</Goals>
<GoalsValue>0</GoalsValue>
</SummaryStatistic>
...
</SummaryStatistics>
</Data>
</ApiResponse>