Data Export Report

The best report for in-depth analysis. An Excel "playground"

Table of Contents

    The Data Export report allows you to extract a report (PDF or Excel) file containing your data for the given Location, Date, Time. This is very useful if you like to manipulate the data in an Excel spreadsheet.

    Report Example:

    How is it Useful?

    In Excel, the format allows for the easy filtering of data and the ability to make pivot tables for in-depth data analysis.

    Who could benefit from this report? 

    Anyone who likes to do their own analysis in an Excel or spreadsheet software.

    How to generate a data export report
    1. Expand Analytics
    2. Select Reports
    3. From Location options select the desired date range and location. (Optional: or select a group under Groups Management)
    4. Select generate report in the Data Export tile.
    5. Input the title name of your choices.
    6. Select on Business hours or Specific Hours; If you selected Specific Hours, Input the desired value;
    7. Click on the dropdown menu and select the interval on which you require the report
    8. For View the selection will sum row data values based on all locations in a chain, district, region or to include individual location values.
    9. For Weekdays select which weekdays to appear (Example: Checking off only Sat will only display each individual Saturday dependent on the selected date range)
    10. For Table Columns select the data value which should appear in the report
    11. (Optional) Select save report preferences if you would like to generate this report again in the future with these settings
    12. Select submit to generate the Data Export

    Data export report will NOT open automatically on your system

    When the report is submitted for generation, it will be downloaded to your PC or device and will need to be opened from the downloaded file's location set on the device.

     

    FAQ

    Q: How do you change the date format of the data export report?
    A: The data export report uses the default date configuration of the Excel software which opens the report.  (Ex: MS Excel may use the Short Date configured in the Date, Time and Regional formatting settings of Windows).  Dependent on the settings, it's possible that this date/time format of the report when opened on difference devices may change. 
    Q: How do you generate this report in PDF?
    A: Uncheck generate report in excel before selecting submit
    Q: What will appear in the fact column?
    A: Facts column are for Special Events or Marketing Campaign info as a sort of note or reminder that that event was taking place during the reporting period. These options are available to configure under Manage > Special events or Marketing Campaigns.
    Q: Weather appears to be incorrect for the configured location address in Manage Locations
    A: The weather location integration using openweather.org has a limitation if multipul locations with the same city name return different weather. Workaround: use another city name which is close to the location.
    Q: Why does Weather, Facts, Sls/SqFT, Trf/Sqft does not appear in PDF output?
    A: Due to limitations with the size of the PDF output template, these columns are NOT included. Data Export Report is designed 1st as an excel generated report for an excel playground experience. PDF output is provided for legacy columns, any new columns added in future releases will also not be included in PDF output.
    Was this article helpful?
    Related Questions
    header-top-left-border Created with Sketch.
    header-top-right-border Created with Sketch.