This information will help Member Associations to learn how to use the reporting functionality. Reporting helps you produce reports on your members that can be saved to run again at any time, or exported into csv.
Improvements to Reporting:
We have made significant improvements to the Reporting tool that now allows you to report on up to 500,000 records at any one time.
In order to achieve this we have changed how Reporting now functions, where each report now goes into a ''Queue'' that runs the report in the background without impacting the performance of the platform.
What has changed?
The biggest change that was necessary is now every report that is run can only be viewable by selecting to ''Download CSV'', moving forward the reports can no longer be viewable on screen, regardless of the size of the report. This now creates consistency with how reports are viewed and allows reports to be part of the queue to maximize performance.
When logged in click on the ‘Reports’ option.
2. Reports Manager
Under the default tab, 'People', select from the two available options
- Build a Report
- Run a Report
'Build a Report' allows you to create your own custom reports. 'Run a Report' allows you to run default system report or previously created custom Reports
By selecting ‘Advanced People (My Level)’ it allows you to set your own parameters for reporting on any Member role registered directly to your Member Association (Referees for example). To continue select ‘Build’.
By selecting ‘Advanced People (Below My Level)’ it allows you to set your own parameters for reporting on any Member role within an Organisation below the Member Association (Clubs for example). To continue select ‘Build’.
5. Reportable Fields
The reporting Fields are separated into 7 Options:- Personal Details
- Registrations
- Contact Details
- Identifications
- Other Fields
- Transactions
- Certification Types
The fields you would select would depend on the type of report you were trying to extract.
For example if you wanted to know how many female players you had at Club level for the current season you would require to select some of the fields found under ‘Personal Details’ and 'Registrations'.
If you also wanted to report on the phone number and email address, you would also then require fields found under the ‘Contact Details’.
To select the fields you require for the report, click on the ‘tick box’ next to each Field Name. As you select the field, they will then show under ‘Selected Fields’ on the right of the page.
7. Specific Search (Filter)
On certain fields you can specify in more detail what you want the report to include, for example by selecting gender as a Selected Field, you can then specify the gender for the report by selecting = male or female.
8. Run Report
Once you have selected the fields from the available options then click on ‘Run Report’
9. Queue Report
After you click on ''Run Report'' you will now see the below screen
Some Reports will still take only a few seconds to be completed. However for larger reports you will now be able to see the progress of the report as per the screen shot below
Once Report is completed you will now see the below screen.
Once the report has been downloaded once, you are not able to download again, you will need to ''Run'' the report again.
10. Additional Options – Sort
To improve the report you can select to ‘Sort By’ the report (for example alphabetical Family Name or Age of Players youngest to oldest) . This can be done by click on ‘Sort By’ and selecting the available options.
Please ensure you have selected the field you want to Sort By in the report. e.g. Family Name
11. Additional Options – Secondary Sort
Once you have selected how you want to sort the report by, you can also include a Secondary Sort.
12. Additional Options – Grouping
To improve the viewing of the report, you can select to ‘Group’ the report so it splits into two categories on the one report, for example ‘Gender’ so all the Male Players are grouped together and the female players are grouped in the report together also.
Once the Sort and Grouping options have been selected (if required) then click ‘Run Report’. To edit report selections, click 'Back to Configure'
Reports that will be run on a regular basis can be saved in order to reproduce them with a simple click.
To save a report select the fields you wish to include in the report, ensure the Output is set to 'Display', click 'Run Report', then click 'Save Report'
Enter name of report, or replace existing report. Click 'Save'.
15. Run a Saved Report
To run a saved report, return to the Reports Manager, by clicking ‘Reports’ in the menu. Saved reports are located within the 'Run a Report' list. Click 'Run' to run the report.
16. Edit a Saved Report
To edit a saved report, return to the Reports Manager, by clicking ‘Reports’ in the menu. Saved reports are located within the 'Run a Report' list.
Select the report you wish to change and click on ‘edit’, you can then add or remove fields to this report and click on ‘Save Report’ to keep the changes you have made to the report. To replace the existing file when saving, select the report from the Replace Existing Report drop down list. To create a new file, add a new name and click 'Save'.
The Reporting functionality provides you with the ability to run reports on Members that have registered to your Association or organisations below the Member Association. A good report to run to see which members have been registered for the current season would be as follows:
- Click on 'Reports' from the menu
- Under ‘Reports Manager', 'Build a Report'
- For ‘Advanced People (My Level)’ click 'Build'
-
Under ‘Person Details’ select the following fields
- National Identification Number
- First Name
- Family Name
- Date of Birth
- Gender
-
Under ‘Registrations’ select the following fields
- Role
- Level
- Status
- Registration Period
- Apply a filter to 'Registration Period', to that it equals the current season
Click on ‘Run Report’ for the report to see all persons that have registered to the Organisation or level you selected in the current season.
You can modify the report to include more or fewer fields, such as including email addresses so that you can email all of your active members, or also filtering by role if required
As you run reports, you can move to complete other tasks within FIFA Connect such as approving players as the report is being run in the background, you can check the status of your report to know when it is complete and ready to download by viewing the ''Queue Reports'' sub menu
An example of this can be seen below, please note that only reports created by the admin user will be viewable and not other users reports.