Skip to main content
Skip table of contents

Data Reports

Data reports allow you to download summary spreadsheets of results from your emails and campaigns, or have them emailed to you on a schedule. Note that you can also view your results graphically within the software using our Visual Reports.

Data reports are accessed via Data & Reports > Data

You will see a screen in which you can select the types of data you would like to report on.

There are currently three types of data reports: Advocacy, Fundraising and Email

Creating an Advocacy Data Report

We provide an Advocacy Summary report which reports on any non-fundraising pages:

Downloading a report

If you click download

, you can quickly export the report, and customize the date range and settings of the report.:

You can either return the data:

  • by Page, which allows you to select the type of pages you want to report on, or you can select all advocacy pages. Note that legacy pages cannot be filtered on, but are reported on if you choose to report on all pages
  • by Attribute, which allows you to filter on specific attributes

Clicking “Generate” will start a job that you can retrieve from the Job Monitor menu.

The file will contain summary data for each advocacy page that took submissions during the timeframe you chose.

Scheduling reports

You can schedule reports to be emailed to you on a regular basis. Click New Report

instead of Download and complete the settings there.

You will need to choose the email address, set a frequency, and a day that you want the report to run. Tick the “active” box to schedule the automated report and save.

What’s in an Advocacy Data Report?

The report groups advocacy pages, showing a row of data for each tracking source and then a total row. The columns are explained below:

Page NameThe name of the advocacy page
Page TypeThe page type: ETT for email-to-target, PET for petition, DCF for data capture, TWT for tweet-to-target, ECF for ecards, UNSUB for unsubscribe pages
Tracking SourceThe tracking ID if used
Total ActionsNumber of actions. Note: This includes blocked actions should a supporter ETT more than once within 24 hours
Total Messages SentFor ETT or TWT this is the number of emails or tweets sent
Page ViewsEstimated page views of the campaign page
Page Conversion RatePercentage conversion. Total Actions/Page Views
Total Actions From EmailFor actions taken via a campaign link, the number of actions taken
% Actions from EmailTotal email actions as a percentage of all actions taken
Total Actions From MobileActions taken via a mobile device
Page Views From MobileEstimated page views of the campaign page via a mobile device
Page Conversion Rate from mobilePercentage conversion of mobile pages
% Actions From MobilePercentage of actions taken via a mobile device

Creating a Fundraising Data Report

Out of the box, you can run two fundraising data report types:

  • Fundraising Summary gives a report on single transactions with some comparisons to recurring. It groups the data by page name, currency and tracking
  • Fundraising Recurring Summary gives a report on recurring transactions with some comparisons to single. It groups the data by page name, month and currency

Downloading a report

if you click download

next to a report type you can customize the reporting currency, date range, and whether report on specific (or all) fundraising pages, or on an attribute.

You can either return the data:

  • by Page, which allows you to select the type of pages you want to report on, or you can select all fundraising pages. Note that legacy pages cannot be filtered on, but are reported on if you choose to report on all pages
  • by Attribute, which allows you to filter on specific attributes

Clicking “Generate” will start a job that you can retrieve from the Job Monitor menu.

The file will contain summary data for each fundraising page that took submissions during the timeframe you chose.

Scheduling reports

You can schedule reports to be emailed to you on a regular basis. Click New Report

instead of Download and complete the settings there.

You will need to choose the email address, set a frequency, and a day that you want the report to run. Tick the “active” box to schedule the automated report and save.

What’s in an Fundraising Data Report?

Fundraising Summary

Page NameThe name of the page. The report will be grouped by this
CurrencyThe donated currency, e.g. USD or GBP. The report will show a line for each currency used
Tracking SourceThe tracking ID if relevant
Total Single TransactionsThe number of successful single donations made
Total Single AmountThe total value donated
Avg Single AmountThe average donation made
Number of Failed TransactionsFor that page, the number of failed transactions. If this is high it is recommended you investigate to ensure there are no problems with the set-up of your page
Number of Refunded Single TransactionsThe number of transactions marked as refunded
Total Amount of Refunded Single TransactionsThe total value of transactions marked as refunded
Total Single Transactions from EmailOf the total single transactions, the number that were made as a result of an email campaign
Avg Single Transaction from EmailOf the total single transactions, the average donation made as a result of an email campaign
% of Total Transactions from EmailOf the total single transactions, the percentage that were made as a result of an email campaign
Total Number of Single and Recurring TransactionsThe total number of donations made including recurring
Total Amount Including Single and Recurring TransactionsThe total value of donations made including recurring
Total Single Transactions from MobileOf the total single transactions, the number that were made from a mobile device (tablets are not seen as mobiles)
% of Single Transactions from MobileOf the total single transactions, the percentage that were made from a mobile device (tablets are not seen as mobiles)
% of Single Transactions vs. RecurringThe percentage of all transactions that are single. If all donations are single, then this will be 100%

Fundraising Recurring Summary

Page NameThe name of the page. The report will be grouped by this
MonthThe month the transaction was made in
CurrencyThe donated currency, e.g. USD or GBP. The report will show a line for each currency used
New Recurring TransactionsNumber of newly initiated recurring transactions
Total Amount New Recurring TransactionsTotal value raised off newly initiated recurring transactions
Avg Amount New Recurring TransactionsAverage value of newly initiated recurring transactions
Total Re-processed Recurring TransactionsNumber of existing recurring transactions that were processed, if data is available
Total Amount Re-processed Recurring TransactionsValue of existing recurring transactions that were processed, if data is available
Avg Re-processed Recurring TransactionsAverage value of existing recurring transactions that were processed, if data is available
Total Failed Re-processed Recurring TransactionsNumber of existing recurring transactions that failed to re-process, if data is available
Total Failed Recurring AmountTotal number lost due to recurring transactions that failed to re-process
Total Active Recurring Transactions at Start of MonthNumber of expected recurring transactions to be processed from the 1st day of the month
Total Active Recurring Transactions at End of MonthNumber of recurring transactions, still active, at the end of the month
Total New Recurring Transactions From EmailTotal value raised off newly initiated recurring transactions that came from email
Avg New Recurring Transactions From EmailAverage value of newly initiated recurring transactions that came from email
% New Recurring Transactions From EmailPercentage of newly initiated recurring transactions that came from email
Total Number of Single and Recurring TransactionsThe total number of donations made including single
Total Amount Including Single and Recurring TransactionsThe total value of donations made including single
Total New Recurring Transactions From MobileTotal value raised off newly initiated recurring transactions that were made on a mobile device (tablets are not seen as mobiles)
% New Recurring Transactions From MobileThe percentage of newly iniriated recurring transactions that were made from a mobile device (tablets are not seen as mobiles)
% New Recurring Transactions vs. SingleThe percentage of all transactions that are recurring. If all donations are recurring, then this will be 100%
 

Creating an Email Data Report

Out of the box, we offer an email campaign summary report:

Downloading a report

If you click the download icon, you can customize the date range and settings of the report.

You can optionally include extra columns that give you statistics on the results of donations and advocacy completions from the email campaign.

Clicking “Generate” will start a job that you can retrieve from the Job Monitor menu.

The file will contain summary data for all the message sent during the timeframe you chose and fundraising and/or advocacy information generated by those emails if you ticked the box to include it.

Scheduling reports

You can schedule reports to be emailed to you on a regular basis. Click New Report

instead of Download and complete the settings there.

You will need to choose the email address, set a frequency, and a day that you want the report to run. Tick the “active” box to schedule the automated report and save.

What’s in an Email Data Report?

Each row of your Email Data Report represents an individual Email Campaign that was sent.

DateThe date of the email campaign send
Message NameThe name of the email message as part of the campaign
AudienceThe name of the saved query if used
CampaignThe name of the email campaign
SenderSender name
SubjectEmail subject
NotesInternal notes
SentNumber of emails sent
OpenedNumber of emails opened
Open ratePercentage of sent emails opened
ClickedNumber of recipients that clicked a link
Click Through RatePercentage of sent emails where a recipient clicked
Clicks/OpensPercentage of opened emails where a recipient clicked
DeliveredThe emails that were successfully sent, without those that were bounced or suppressed.
OptoutsThe number of supporters that opted-out
Optout rateOptouts as a percentage of sent emails
BouncesThe number of bounces
Bounce rateBounces as a percentage of sent emails
ComplaintsNumber of complaints
Gifts/SentCompleted donations as a percentage of sent emails
Gifts/OpensCompleted donations as a percentage of opened emails
Gifts/ClicksCompleted donations as a percentage of clicked emails
Total Single RaisedSum of single donations received from the email
Total Single GiftsNumber of single donations received from the email
Average Single GiftAverage single donation received from the email
Total Sustainer RaisedSum of recurring donations received from the email
Total Sustainer GiftsNumber of recurring donations received from the email
Sustainer 18 months valueThe 18 months value of the recurring donations received
Total RaisedThe grand total raised
Total GiftsThe grand total number of gifts received
ActionsCompleted actions
Actions/SentCompleted actions as a percentage of sent emails
Actions/OpenCompleted actions as a percentage of opened emails
Actions/ClickCompleted actions as a percentage of clicked emails
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.