Automated Reports

Introduction

You can generate a couple of data exports with custom filters/parameters in the system. The automated reports feature allows you to automatize these exports to generate them repeatedly with a set of configurations according to your needs. This is helpful when you need to fetch such data every certain period.

Right now it is enabled only in these exports:

• Orders

• Commissions

But we will continuously extend the feature to be available in every export.

Only users with any of these roles can use the feature:

• Super Admin

• Admin

• Sales manager

If you need this enabled for a person who does not has any of these roles you can attach it manually the permission Create automated report under the General module.

Create an automated report

1. We will use the Orders export as an example, but the same logic will apply to others.

2. Click on the Advanced Search button.
   

   

3. Select the filters you will apply. If you select a date range, it will be ignored. We will show later how to define it.
   

   

4. Click on the vertical dots.
   

   

5. Click on Create automated report.
   

   

6. You will see a form with the following fields:

   1. Alias: It is a name to identify your automated report.

      

   2. Period: The period or range of dates that the report will use, the current day is not being considered in this range, you have many options here:

      

      1. Last 7 days

      2. Last 14 days

      3. Last 30 days

      4. Last week

      5. Last 2 weeks

      6. Last 3 weeks

      7. Last half of the month: It divides the month into 2 periods, from day 1 to 15 and from day 16 to the end of the month. When being calculated the current day is ignored.

      8. Last month

      9. Last 2 months

      10. Last 3 months

      11. Last quarter: The last quarter that has ended.

      12. Custom period: You can define a custom period of days or weeks, if days are selected you can put a maximum of 90, in the case of weeks max allowed range is 12.
          

          

   3. Repeat Period: Here you can define how often the export will be autogenerated, available options are:

      

      1. Daily

      2. Weekly

      3. Every 2 weeks

      4. Every 3 weeks

      5. Every half of the month

      6. Monthly

      7. Every 2 months

      8. Every quarter: Run the report every 3 months.

      9. Custom period: Run the report every x days/weeks, you will define the period.
         

         

7. Start on: The date when the first run will start. This field is not visible if you selected Every half of the month.

   

8. After days: If in the repeat period, you selected Every half of the month you need to specify how many days after the current half of the month finishes the report will run. The maximum value is 13.

   

9. Time delivery range: An estimated time when the report will be scheduled and delivered. This is only an approximation, there could happen some situations where the report is delivered later, for example, the report is too heavy, or the server is handling other heavy processes.
   

   

10. Finally, you will see when the following 4 schedules will be executed along the range of dates to be applied.
    

    

11. Click on save.

Manage automated reports

You can manage the reports that you have created. If you want to see/delete automated reports created by other people, you should have the permission called Manage all automated reports (enabled in Super Admin and Admin roles by default), such permission can be found in the General module when updating employee permissions.

To manage the automated reports, you should follow these steps:

1. Click on the user icon on the top right of the screen, then click on My automated reports.
   

   

2. If you have the Manage all automated reports this would be your view:
   

   

   1. By default, the enabled checkmark indicates that you are watching only records created by you, if you disable it, you will see all the records created.

   2. Additionally, you can filter in the search user field by inputting a user's name.

   3. Also, you can see the user who owns the report in a column.

3. If you don’t have that permission, your view would be:
   

   

4. You will have the columns:

   1. Alias: The alias to identify the record.

   2. Type: The type of report to generate, it can be Orders or Commissions.

   3. Period: The period selected by you when you created the record.

   4. Repeat: The repeat period selected in the creation form.

   5. Scheduled at: The date of the next schedule.

   6. Executions: The number of successful executions.

   7. Created at: The date when this record was created.

5. If you click on the 3 vertical dots in the last column, you will see a couple of actions:
   

   

   1. If the record has at least 1 execution, you can see the generated reports. If you click on that option, you will see this UI:
      

      

   2. You can also delete the automated report by selecting Delete, if you delete it the current generated reports will still be available in the My reports section.
      

      

Notifications for reports

Like a single data export in the system, when a report is autogenerated, you will receive an email notification and an in-app notification (the bell on the top right section) to download your report.

You will also be notified if the report fails and is not generated. We will try to generate it again in one hour. We only make 2 extra tries. If the report fails 3 times we only schedule the next execution, and you would need to contact support to get more info about why the report was not generated.