Learn how to export Acuity Pricing data into Excel, ready for further analysis.
Contents
Acuity Pricing allows most information to be exported into Excel for further
analysis. This can be done on an ad hoc basis, or scheduled to be sent
directly to the user’s email.
What you need:
-
Access to the Acuity Pricing Platform and reporting suite.
-
Knowledge on how to create a standard Acuity Pricing Report.
- Knowledge on the additional report filtering options available.
Exporting A Report
- To export a report created in the platform, firstly make sure you have selected the correct parameters.
- Once selected, click the Export button.
- Click Download now.
Please note: each report has slightly different export options.
Saving a report
Reports can be saved at any time.
- Click on the Save button.
- Give the report a name.
- Click the next Save button.
- To create a copy of the report, first alter the report name.
- Click the new Save As button.
Accessing the Report
Once saved, the report can be accessed from the Open button. Any changes can be made here, just ensure you save the report again after any changes are made.
Scheduling a Report
You can schedule the excel export to be delivered regularly, without logging in.
- Ensure the report is set up as per the above instructions.
- Click on the Save button.
- Click on Export.
- Click the Scheduled Export tab
- Select the day of the week required (you can select multiple), or the day of the month.
Sending to non-Acuity Pricing Users
- Tick Send to external sources.
- Enter the recipients‘ email addresses.
Chosen recipients will then receive the report via email on scheduled days with the excel report attached.
Please be aware, if over 5MB, the report will be a download link.
Sharing the Report
You can share the report with any other Acuity Pricing user within the same account (this includes the report within the tool and any associated scheduling).
- Click the Share button.
- Select everyone or choose selected colleagues.
- Click Share.
- Use the comment box to make a comment about the report.
Download Instructions
Download these instructions for future use by clicking here.