Administrative Reporting

Prerequisites

• Access to the Jumbo Lottery Platform
• Level of access required to view and generate reports

1. How To View All Reports

To navigate to the Reports section of the JLP admin, click the “Reports” option from the top toolbar.

This will show a break down of all available reports that can be run.

The reports tab will be split into several categories:

• Finance reports;
  • Customer Account Balances – this generates a summary of all incoming and outgoing funds processed on customer accounts
  • Sales – a breakdown of sales which can be run by product; applicable if more than one type of draw is sold on your website
  • Supplier Costs – a breakdown of wagers purchased from a provider only applicable for re-sellers
  • Draw Reconciliation – a summary of tickets and books purchased from a charity lottery, used for comparison with external systems
  • Channel Report – report based on sales by a specific channel
  • Trustee Prizes – this report is no longer in use
  • Prize – a breakdown of prizes won, refined by draw number and amount
• Marketing Reports
  • Sign Up & Verification – a summary of sign-up and verification for marketing purposes
  • AutoPlay Activity – a summary of AutoPlay activity filtered by date range and amount
• Consumer Behaviour Reports
  • Suspicious Signups – a list of all customer registrations that have been duplicated by name, registered at the same IP and reverse name registration
  • Unusual Behaviour – a report by date which shows all changes to email addresses and passwords, duplicated bank accounts, duplicated credit cards
  • Retention Report – a summary of customer retention since sign up
• Transfer Activity Reports
  • Individual Deposits By Value – a list of customers who have deported large amounts of funds, this can be useful in identifying responsible gambling risks, fraudulent accounts and accidental deposits
  • Multiple Deposits By Value – a list of customer who have spent a large amount of funds, this can be useful in identifying responsible gambling risks, fraudulent accounts and accidental deposits
  • Multiple Deposits Count – a summary of customers who are making many deposits in a short amount of time, this can be useful in identifying responsible gambling risks, fraudulent accounts and accidental deposits
  • Internal Transfers Summary – a list of admin operators who have processed manual admin deposits and withdrawals, this can be useful in identifying internal fraud

2. Commonly Used Reports

You may not find all reports useful to parts of your organisation. As such we have created some examples of commonly used reports and how to run them. Please see the following reports below:

• Draw Reconciliation Report
• Deposit Analysis Report
• Channel Report
• Suspicious Signups Report
• Custom customer search

How To Run A Draw Reconciliation Report

As above, to run the Draw Reconciliation report first click on the “Reports” option from the top toolbar. Then select “Draw Reconciliation” from either the left tool bar or from the reports page.

This will show a pop-up window that appears as follows:

Fill in the relevant information:

1. Lottery Name- select the relevant option by either typing the lottery name or selecting from the drop-down menu
2. Draw No- type in the required draw number
3. Period start
4. Period end

Click “Apply” and “OK” to run this report.

This report will show a breakdown of the following:

1. Book count- a breakdown of total sales by a specific book
2. Ticket count- a breakdown of total ticket sales
3. Financial summary- full financial summary of the draw
4. Ticket status- a running count by ticket range of ticket statuses

You will able to download this report in various formats by selecting the export drop down list form the top menu.

How To Run A Deposit Analysis Report

Navigate to the Deposit Analysis report on the left tool bar under the reports tab.

This will show the following data fields:

Fill in the following relevant fields:

1. Date from
2. Date to
3. Deposit status change- This indicates the status of a transaction, e.g. successful, failed, processing, refunded
4. Deposit method- Indicates how the payment has been made, e.g. credit card, BPAY, Direct deposit, cheque
5. Payment gateway- How the payment has been transacted, e.g. PayStream, PayPal, eWay

Note that the time fields are not required to run this report successfully. One this report has been generated you will see a breakdown of the following information:

How To Run A Channel Report

Navigate to the “Channel Report” report on the left tool bar under the “reports” tab.

This will show a pop-up window that appears as follows:

Select the following items:

1. Lottery name- select the desired lottery you would like to run the report for, this is only applicable if multiple types of draws are provided on your website
2. Draw no.- select the draw number you would like to run the report for

To select the date and time range for the report scroll further down the pop-up.

Note: multiple draws and Lotteries can be run on the same report, you can select and deselect as many options as you choose.

This will then generate a report showing the following information:

1. Lottery draw name
2. Channel- how the tickets were purchased e.g. purchased directly through charity via phone call or offline sales upload, web based purchase, operator purchase
3. Draw no.- which draw numbers the report has been run for
4. Report period date and time
5. Number of ticket book- number of books sold refined by VIP, Non- VIP and total
6. $ Value purchased- total dollar amount of purchases refined by VIP, Non- VIP and total

How To Run A Suspicious Signups Report

Navigate to the Suspicious Signups report by clicking the “Reports” option from the top toolbar. Then select “Suspicious Signups” from either the left toolbar or from the reports page.

The fields will show as follows:

Populate the fields as follows:

1. From DD/MM/YYYY
2. To DD/MM/YYYY

Note that the time fields are not necessary for the report to be successfully generated.

Click “Update” to generate the report. Now that the report has been generated you will see a summary of the following categories:

Duplicated Signups

Duplicated Signups at the Same IP Address

Reversed Named Signups

This report will help you in identifying customers with multiple accounts and incorrect details. However, be mindful that multiple customers may be using the same device, as such the Duplicated Signups at the Same IP Address field may throw a false positive.

How To Run A Custom Report

We also offer the ability to run a custom customer report. This can be used to specifically find a group or single customer of interest. This report can be found by selecting the “Search” option for the top toolbar.

This will show a list of pre-defined search queries as follows:

This search is split into three search fields which can be used to refine your search by customer ID details, personal details and special filters. You can use a combination of these filters to refine a search to locate a group of customers or a single customer depending on your requirements.

To run this report, select your filters and click the “Search” button located in the bottom left corner. This will show a list of all customers with the details refined by your search.