Campaign Reports

Robust reporting and statistics are available in real-time to quickly analyze the audience responses and help you act faster. You have two options for viewing the Campaign reports: Download Campaign Report or View Analytics. You can view these options when you click the Actions button found on the right side of each campaign.

Download Campaign Report

View Campaign Analytics

 

download-campaign-summary-engagesparkDownload Campaign Report

Gain deeper insights by diving into the details of individual responses. Click Download Report to export detailed information about your campaign and every interaction with your contacts into an Excel spreadsheet.

The downloaded report contains seven sheets:

  1. By contact
  2. By subscription
  3. SMS Log
  4. WhatsApp Log
  5. Call (Voice) Log
  6. Airtime TopUp Log
  7. API Call Log

All seven sheets are included in the spreadsheet, but the log sheets are populated only when that message (transaction) type occurred in your campaign. For example, an SMS Blast will normally have data in By contact, By subscription, and SMS Log. A campaign containing WhatsApp messages and API Call actions may also have data in the WhatsApp Log and API Call Log. If your campaign combines multiple types of messages, such as an IVR survey that sends an airtime incentive, the corresponding additional log sheets will also contain data.

Time-related columns show the timezone you chose during download directly in the column heading, for example Time of Message (Africa/Cairo).

By contact

The By contact sheet gives you one row for each contact in the campaign.

It includes basic contact information such as:

  • Contact ID
  • First Name
  • Last Name
  • Phone Number
  • Campaign ID
  • Campaign Name

Additional columns are automatically added based on the questions and actions included in your campaign. For example, a survey may include columns for a contact’s answer to each question, timeout or invalid-response counts, the question ID, and when the question was sent. A voice campaign may include call duration and reconnect information, while campaigns containing Airtime Top-Up or API Call actions may include the corresponding TopUp ID, status, API Call ID, or API Call result.

Because this sheet gives you a contact-level view, each contact appears only once even if that contact has been subscribed to the campaign more than once.

To see every individual subscription separately, use the By subscription sheet.

By subscription

The By subscription sheet gives you one row for every time a contact was subscribed to the campaign.

This means the same contact can appear more than once if they participated in or were subscribed to the campaign multiple times.

It contains the same campaign-specific response and action information available in the By contact report, together with:

  • Subscription ID – the unique ID for that campaign subscription.
  • Subscription Time – when the contact was subscribed to the campaign.
  • Subscription Status – the status of that subscription, such as Completed or Unsubscribed.

Depending on the campaign type, this sheet may also include additional summary information such as the number of survey questions reached, call duration, reconnects, or other campaign-action results.

SMS Log

The SMS Log records individual outbound and inbound SMS messages associated with the campaign. Each message is recorded on a separate row.

The report includes fields such as:

  • Campaign ID / Campaign Name – identifies the campaign.
  • Subscription ID / Subscription Start – identifies the campaign subscription associated with the message.
  • Contact ID / First Name / Last Name / Phone Number – identifies the contact.
  • Direction – whether the SMS was outbound or inbound.
  • Sender ID or Receiving Number – the Sender ID or phone number used to send or receive the SMS.
  • Time of Message – when the SMS was sent or received.
  • Delivery Status – the current delivery status of the message, such as Sent or Delivered.
  • Delivery Error – delivery status or error information returned for the message, when available.
  • Cost in USD – the cost associated with the SMS.
  • Message – the content of the SMS that was sent or received.
  • Message ID – the unique engageSPARK ID for the message.
  • Error – additional error information, if applicable.

WhatsApp Log

The WhatsApp Log records individual outbound and inbound WhatsApp messages associated with the campaign. Each message is recorded on a separate row. It contains many of the same fields as the SMS Log, including campaign and contact information, Direction, Sender ID or Receiving Number, message time, delivery status, cost, message content, Message ID, and error information.

The WhatsApp Log also includes WhatsApp-specific fields such as:

  • Read – when the WhatsApp message was marked as read, when available.
  • Template Registered – indicates whether the message was sent using a registered WhatsApp template.
  • Template Category – the WhatsApp template category, when applicable.

Inbound media responses may also be identified in the Message column—for example, an image response may appear as [image].

Call (Voice) Log

The Call (Voice) Log records individual inbound and outbound calls associated with the campaign. Each call attempt is recorded on a separate row. If your campaign is configured to reconnect or retry a contact, those attempts can therefore appear as additional rows.

The report includes fields such as:

  • Campaign ID / Campaign Name
  • Subscription ID / Subscription Start
  • Contact ID / First Name / Last Name / Phone Number
  • Direction – whether the call was outbound or inbound.
  • Caller ID or Called Number – the number used for the call.
  • Time call made – when the call attempt started.
  • Time call answered – when the contact answered the call, or the corresponding call result when it was not answered.
  • Time call ended – when the call ended.
  • Reconnect Attempt No. – identifies reconnect attempts associated with the subscription.
  • Duration (s) – the duration of that call attempt in seconds.
  • Speech Recognition Questions Reached – the number of speech-recognition questions reached during the call.
  • Speech Recognition Cost in USD – speech-recognition charges associated with the call, when applicable.
  • Call Cost in USD – the cost of the voice call.
  • Call ID – the unique engageSPARK ID for that call.
  • Voicemail Detected – indicates whether voicemail was detected.
  • Error – the call error or failure reason, when applicable.

The By contact and By subscription sheets may also contain call-level summary fields such as total call duration across reconnects, number of reconnects, how the call ended, and the number of questions reached.

Airtime TopUp Log

The Airtime TopUp Log records individual airtime top-up requests made through the campaign.

The report includes:

  • Campaign ID / Campaign Name
  • Contact ID / First Name / Last Name / Phone Number
  • Desired Amount – the requested airtime amount.
  • Max Amount – the maximum airtime amount allowed for the top-up.
  • Sent Amount – the amount that was actually sent.
  • Amount Currency – the currency of the airtime top-up.
  • Delivery Status – whether the top-up was successful or failed.
  • Cost in USD – the cost of the airtime top-up.
  • Time of TopUp – when the airtime top-up request was made.
  • TopUp ID – the unique ID for the airtime top-up.
  • Error – the failure reason or other error information, when applicable.

API Call Log

The API Call Log records API Call actions triggered from within your campaign.

Each API request is recorded separately and can include:

  • API Call ID – the unique ID for the API call.
  • Time – when the API call was made.
  • Request Method – the HTTP method used, such as GET or POST.
  • Request URL – the URL called by the campaign.
  • Request Result Body – request result information, when available.
  • Result Status Code – the HTTP status code returned by the request.
  • Result Body – the response returned by the API.
  • Success – whether the API Call action succeeded or failed.
  • Error – error information, when applicable.

API Call actions may also appear in the By contact and By subscription sheets, where you can see the API Call ID and whether the action succeeded for each contact or subscription.

campaigns-report-engagesparkView Campaign Analytics

The Campaign Analytics provides effortless viewing of what happened on your campaign at a quick glance. The Campaigns Analytics View has three pages: Overview, Analytics, and Subscriptions.

  • Overview – from here, you can see how many contacts were subscribed, contacts engaged, SMS sent, calls made, total cost of campaign, message cost, voice calls cost, WhatsApp cost, and airtime topup cost. The message delivery overview section tells you how many contacts were engaged (i.e., calls answered or picked up), contacts that were not engaged (i.e., calls not answered or picked up), and contacts that had an error (i.e., invalid number, insufficient funds, system issue, etc.). Also, you can see here an overview of your message content like the number of questions, what each question or messages are (Voice blast, Voice IVR question, SMS question, SMS blast, or Action only).
    Sample screenshot of the Overview page of Campaign Summary View
  • Analytics – this is where you can see a quick breakdown of answers or keypresses for each of your SMS survey and Voice IVR survey questions.campaign-report-engageSPARKSample screenshot of the Analytics page of Campaign Summary View
  • Subscriptions – from here, you can continue managing your subscriptions by either subscribing, unsubscribing, or resubscribing contacts or group of contacts after you have launched your campaign.campaign-report-engageSPARK
    Sample screenshot of the Subscriptions page of Campaign Summary View

Related Pages

Have questions or need a little extra help?