How to Calculate your Total Sent of Emails and SMSs

It's possible to calculate how many emails or SMS messages you've sent from your Agillic instance in a given period. This can be helpful when you want an overview of the number of communications you send. For example, it could help you get a feel for an upcoming invoice.

How to Calculate your Total Sent Emails

To calculate sent emails in a given period, you'll need to create a report as described below.

1. Log into Production.
2. Open the Reports module.
3. Click on a Dashboard or create a new Dashboard.
4. Create a new Report.
5. Select 'Email' under 'Select Data'.
6. Click the 'Show deleted' checkbox.
7. Click 'Select all'.
8. Select the period that you want to see your total sent for in 'Date Range' or by selecting a 'Start date' and 'End date'.
9. Select 'KPI' as the report type.
10. Check the 'Sent' checkbox.
11. Click on 'Refresh'.

The number that returns will match the number of emails you've sent in the given period. 

The total amount of emails sent in the period 01.10.2019 - 01.10.2020

How to Calculate Your Total Sent SMS

If you make a report on an SMS, you'll see the number of SMS 'templates' sent out. This means the number of SMS messages created in Agillic and sent through a Flow. The SMS messages could be longer than 1 SMS (160 characters if no Unicode characters are used) causing them to count as 2 or more SMSs when invoiced.

Learn more about how SMS characters are calculated here.

Because of this, it's necessary to create an Activity Export instead to get the full picture. To calculate sent SMSs for a given period, you'll need to create an Activity Export as described below.

1. Create an Activity Export.
2. Check the checkbox 'SMS' under items when creating the Activity Export.
3. Select an Export Profile in the drop-down.
4. Choose a period in the 'Execution' panel.
5. Run the Activity Export.
6. Use WebDAV to access the created Activity Export.
7. Open the CSV file called 'SMS'.
8. Select the entire column H.
9. Retrieve the SUM of the column to get the number of SMS message parts sent.

Now, you've calculated how many SMS message parts you send out in the chosen period. 

A CSV file opened in Excel where the H column, containing the SMS message parts, is ready to have its SUM calculated

Suggested Next Steps:

• Understanding Reports
• Calculating Email Reports
• Understanding how SMS characters are calculated