Books > Help Center > Data Management > Data Management > Custom Reports >  



Sample Report: Pledge-a-thon - Offline Donations only

To create a Custom Report which only displays the offline donations/pledges for your Pledge-a-thons:

  1. Click the Account link located in the top right corner of your GiftTool BackOffice account.
  2. Click Custom Report.
  3. To create a new report, click Add Custom Report.
  4. On page 1:
    • Select a date range for your report by clicking the Date Picker icons.
    • Enter the Report Name.
    • Select the currency of the transactions to be displayed.
    • For GiftTool Services, check the box for "Pledge-a-thon offline orders"
    • For Include, check the boxes for:
      • Items purchased
      • Balances due
      • Profile fields
      • Questions
      • Sponsored Participants (Pledge-a-thon)
      • Teams (Pledge-a-thon)
      • Additionally, check whatever else you wish to display (Report header, Tax Receipt numbers, etc). 
    • Click Next
  5. On page 2, determine which fields should be displayed in each column:
    • Drag & Drop columns from the "Don't show columns" list to the "Show columns" list or back to control what columns are shown.
    • Drag & Drop columns up and down within the "Show columns" list to control the order in which they appear in the report.
    • Tip: Try moving all the fields into the “Show Columns”. Once you have seen the report, remove unnecessary columns as required by dragging them back to the "Don't show columns" list.
    • Click Next
  6. [Optional] On page 3:
        Condition Field Operator Value
       1 Activity equals **Type the name of the Pledge-a-thon as written in the setup
    • In row 1 - Create a filter to restrict data to a single Pledge-a-thon by selecting the Field, Operator and typing the Valueas shown in Condition 1 above.
      • The Value is case sensitive, and must not include extra spaces or other characters.
      • When entering the Value, type the name of the Pledge-a-thon exactly as it is written in your Pledge-a-thon setup. Be careful not to paste extra spaces. Alternatively, you can run the report without this filter, then you can see which Activity Name you want to filter on and copy/paste the exact value into your filter.
  7. Click Save & Run to view your report.
    • Review the Excel and determine which columns you do not need. Repeat step 5 to remove unnecessary columns, and rearrange the remaining columns to your liking.
    • Use your computer functions, to print or save a copy of the report.
    • Having difficulty viewing Excel reports?
Note:
  • If you first run the report without any filters, you can see which data you want to filter on and copy/paste the exact value into your filter.
  • Filters are "AND"ed together if no advanced filter logic is provided.
  • For ID fields, the prefix letter (R, S, D, etc) before the ID cannot be filtered on. Instead filter on the Service field (Registrar, Shop, Donations, etc).
  • Date values must be in the form YYYY-MM-DD.



Was this information helpful?
Yes   No




Search Help Center

Today's Top 10 Articles
  1. Discounts, Promotional Codes & Surcharges
  2. Creating a table within the HTML editor
  3. How does the credit card payment process work?
  4. How do I change a Pledge-a-thon coordinator profile?
  5. I am having difficulty logging into GiftTool
  6. What is a membership order?
  7. How do I confirm receipt of a pending cash or cheque pledge?
  8. Dates
  9. How do I change a Pledge-a-thon order profile?
  10. How do I create an event?