# Reports: Matomo Matomo Scheduled Reports ## Documentation The stored, schedulable report definitions of this instance: not the reports themselves, but a definition of which reports are rendered, when, and to whom they are sent. A superuser sees the definitions of every site at once. A definition is created with the procedure Matomo.AddScheduledReport instead of with an insert on this table, and an existing definition cannot be changed; deleting a row deletes the definition. - Catalog: `Matomo` - Schema: `ScheduledReports` - Primary Keys: `idreport` - Label: Matomo Scheduled Reports - Retrieve: True - Insert: False - Update: False - Delete: True ## Table Columns The columns of the table `Reports` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `deleted` | `int32` | | ☐ | 1 if the report has been soft-deleted (Matomo's own deleteReport never hard-deletes the row), 0 otherwise. | | `description` | `varchar2` | | ☐ | Report title, shown in Matomo's own UI and used to build the sent filename. | | `format` | `varchar2` | | ☐ | Output format - 'pdf' or 'html' for the 'email' transport. | | `hour` | `int32` | | ☐ | Hour of day (0-23) the report is sent at, for a period other than 'never'. | | `idreport` | `int32` | | ☑ | Scheduled report ID, assigned by Matomo when the report definition is created, and never written. | | `idsite` | `int32` | | ☑ | Site the report's own data is drawn from. | | `login` | `varchar2` | | ☐ | User the report belongs to - the token's own owning user at the time it was created. | | `parameters` | `varchar2` | | ☐ | Transport-specific settings (displayFormat, emailMe, evolutionGraph, additionalEmails, ...), as JSON text. Read-only; the procedure Matomo.AddScheduledReport takes the display format and the mail-to-me setting as parameters. | | `period` | `varchar2` | | ☐ | Delivery schedule: 'day', 'week', 'month' or 'never'. | | `reports` | `varchar2` | | ☐ | The reporting tables included, as JSON text: a list of unique IDs such as '["VisitsSummary_get"]'. Read-only; the procedure Matomo.AddScheduledReport takes the report to include as a parameter. | | `ts_created` | `varchar2` | | ☐ | Date and time the report definition was created, as reported by Matomo. Matomo does not state which time zone it is expressed in. | | `ts_last_sent` | `varchar2` | | ☐ | Date and time the report was last actually sent, or null if never. Same timezone caveat as ts_created. | | `type` | `varchar2` | | ☐ | Transport medium - 'email' on a standard instance; a plugin may register another. |