Get a custom report by email

Use this article to generate a custom report from Travel reporting in Perk and get it by email as an attachment, with a link to download it from Perk. The custom report lives on the Reports and schedules page, under the Generate report tab.

Only account admins and analysts can perform this task.

Get a custom report by email

Getting a custom report in Perk means choosing your filters and columns, then asking Perk to email the file to one or more recipients. Perk generates the report in the background and sends each recipient an email with a download link.

  1. Go to Analyze > Travel reporting > Reports and schedules, and open the Generate report tab.
  2. Apply the filters you want, such as date range, service type, cost object, or trip status.
  3. Select the columns you want to include from the available static and dynamic columns.
  4. Select Get report.
  5. In the Get report modal, choose a file type in the Format field: CSV or Excel.
  6. In the Recipients field, add the active users on your account who should get the report.
  7. Select Get.

The modal tells you, "We'll generate this report and email it to the recipients below as soon as possible." Each recipient gets one email with the file attached and a link to download it. To change the view, run the custom report again with a new selection. To reuse a setup you run often, see Save and reuse custom report templates.

Note: Perk emails the report as an attachment and also includes a download link. Recipients need to be signed in to Perk on the correct account to use the link, but they can open the attachment without signing in.

Open or download the report from the email

The email from Perk for a custom report contains the file as an attachment and a temporary link to download it from Perk. Recipients don't need reporting permissions to use either, but they do need to be signed in to Perk on the correct account to use the link.

  1. Open the email about your custom report.
  2. To use the attached file, open the attachment.
  3. To download the file from Perk instead, select the download link in the email.
  4. Wait for the Download report page to open. The page says "Your file is ready" and starts the download automatically.
  5. If the download doesn't start, select Download file.

Caution: The download link and the copy of the file in Perk expire after 7 days. The attachment stays in your mailbox, but Perk can't regenerate an expired file from the link, so download the report before then if you need it from Perk.

If the link has expired

An expired Perk report link opens a page that says "This report has expired or does not exist." The page explains that download links are only valid for a limited time.

  1. Open the expired link.
  2. Select Generate new report.
  3. Wait for the new email with a fresh link, and then follow the steps in Open or download the report from the email.

For more information about what the custom report contains, see Explore custom reports for admins and analysts.

 

Was this article helpful?