Campaign Statistics Report

From Documentation
Jump to navigation Jump to search

Overview of FR263

The Campaign Statistics Report gathers campaign statistics broken down by donor segments and by groupings related to the amount of gifts. This report is based on campaign history records. The statistics related to total returns, total sent, percentage of returns, total revenue, total cost, net revenue, average gift, cost per percentage raised, yield per 1,000, net yield per 1,000, and cost per piece. The amount groupings are $0-$9, $10-$24, $25-$49, $50-$99, $100-$249, and $250-$499, $500-$999, and over $1,000.

  • Because FR263 is based on campaign history, it should not be used to compare against FR266.


  • From the DDI Connect main menu, double-click Connect FR
  • Double-click Campaigns & Appeals
  • Double-click 263 Campaign Statistics Report. The parameters screen will launch:


FR263.png


The following fields are available on this screen:


Field Description
Start date/thru Enter the beginning and ending date(s) that you wish to report against. You can type the date in mm/dd/yyyy format or click the calendar icons to select the date(s)
Audience If you wish to report for a particular audience, you can do so here. Type the audience code or click the list icon to select the audience you wish to report against
Theme If you wish to report for a particular theme, you can do so here. Type the theme code or click the list icon to select the theme you wish to report against
Approach If you wish to report for a particular approach, you can do so here. Type the approach code or click the list icon to select the approach you wish to report against
Region If you wish to report against a particular region, you can do so here. Type the region code or click the list icon to select from a list of active regions in the system
Campaign If you wish to report at the campaign level, enter the campaign ID here. You can also click the list icon to select from a list of active campaigns in the system
Campaign Type If you prefer to report against all campaigns of a certain type, you can do so here. Click the drop down arrow to select from a list of active campaign types in the system
Group If you wish to report at the Group level, click the Group radio button. This enables the field to allow you to either enter the Group code or click the list icon to select from a list of active groups in the system
Appeal If you wish to report at the Appeal level, click the Appeal radio button. This enables the field to allow you to either enter the Appeal code or click the list icon to select from a list of active appeals in the system
Packages To report only on specific packages, enter the package code or codes, separated by commas, in this field
Separate appeals To separate the appeals on the report output, select this box
Separate packages To separate the packages on the report output, select this box
Segment code position Largest gift amount If you wish to see results only from those donors whose segment code has a particular largest gift amount, enter the code that represents that information in the donor code. Leave as a * to show all
Segment code position Number of gifts If you wish to see results only from those donors whose segment code has a particular number of gifts, enter the code that represents that information in the donor code. Leave as a * to show all
Segment code position Months since last If you wish to see results only from those donors whose segment code has a particular months since last gift, enter the code that represents that information in the donor code. Leave as a * to show all
Segment code position Recent gift amount If you wish to see results only from those donors whose segment code has a particular recent gift amount, enter the code that represents that information in the donor code. Leave as a * to show all
Print all promotion sources If selected, the report output will contain all promotion sources for gifts linked to the campaign/group/appeal
Promotion sources To report only on donations with one or more promotion sources, type the code or codes, separated by commas, or click the list icon to select from a list of active promotion sources in the system
Report fields This field lists all of the available fields for the report. You can select one or more fields by holding down the CTRL key on your keyboard and clicking the fields you wish to add. You can also select all fields by clicking the Select All button


Print Options

After clicking the Print Options button you will see the following options. Choose the desired options and click OK to return to the report parameters screen.


Print options.png


Option Description
Printer Click the drop down arrow to select from a list of available printers. DDI Connect uses your default printer unless told otherwise
Format Click the drop down arrow to select from a list of available formats. Select paper size, number of columns, and number of rows for printing. Each report has built-in format defaults. Select “Use Defaults” to use the built-in report defaults. The number of rows and columns controls the print size and amount of information per page
Memo If you wish, you can add a memo to the output of the report. NOTE: It is recommended that Word documents be saved with the .docx extension
View Report This option generates a pdf file that is displayed on the screen when the report is generated
Archive Report If this option is selected, the system will archive the report in the DDI Connect report archives. For information on working with archived reports, please reference this page: Archived Report Viewer
Print Report If selected, the system will generate the report output to your default printer. NOTE: You will also receive a pdf version of the report, displayed on your screen
Print via PDF Prints directly to your printer.
Email This option allows you to send a .pdf attachment of the report to the indicated users' email addresses. When OK is clicked, a dialog box will open requesting a recipient
Duplex/Top Prints the report on both sides of the paper in landscape style. The printer must be capable of printing on both sides or an error will occur
Duplex/Side Prints the report on both sides of the paper in portrait style. The printer must be capable of printing on both sides or an error will occur
Green bar Adds shaded, horizontal bars to the report, making it easier to read across columns
No dialog Selecting this option means that no ‘Report Completed’ dialog will display after the report has been generated
Extra copies If you want extra copies of the report generated, type the number in this field


Click Start. The system will generate the report based on the parameters you selected, and display the results. Click below to view a sample of this report.


Sample FR263.pdf