Leverage Excel to Build Custom Reports and Charts that Stay Updated

Using the data export engine and the power of excel, you can build out charts, reports and dashboards leveraging live data as it's generated in PeopleVine.


To get started, you will need to identify the data you will need to generate your report.  Once identified, you will need to first build the data export file.

Step 1: Build the Data Export File
Follow these steps to setup your data file:

  1. Go to Settings > Reports and Data > Reporting Dashboard
  2. Go to Build a Custom Report and select the data set you want to work with


  3. Select the fields you want in your report, keeping in mind that personal info shouldn't be needed if you're building a chart or summary report.  Keep their info private!
  4. You can filter the dates by using variables such as 8/1/2020 12:00 AM, 8/31/2020 11:59:59 PM, 7/1/2020 12:00 AM, 7/31/2020 11:59:59 PM to pull monthly based reports.  Without filters, it may take some time for the data to load.
  5. Then click Generae Report
  6. Once the report is generated, you need to save the report (as it will be needed to future access).


  7. If you go back to export data to file, you'll see the Last Month's Transactions report.
  8. Click on the report and click load.  You will now see a URL where to get the data from.


Load the Data in Excel and Keep it Refreshed
Now that you have the URL of your report, you can setup an import in excel.

  1. Start by opening up excel and creating a new workbook.
  2. Go to the Data tab and choose import data from web.
  3. Past the URL that you got in the steps above.


  4. Feel free to clean up the data or confirm the settings that were loaded.

  5. Then click load.
  6. Your data will be loaded for you to generate your charts.

Based on the report URL provided and the {@ filters, you can re-load this data each month.  You can keep the data updated by clicking on the data and clicking on the Refresh data option.



Additional Help Tutorials

Find more ways to grow on PeopleVine.

Use HAPI to Include Event Info in Your Email

You can use HAPI to generate additional field data when sending an e-mail.

Posted August 5, 2020

HAPI - Data - Years, States, Countries

We added a new HAPI feature so you can output specific data elements with ease.

Posted August 5, 2020

Leverage our New Webhook Authentication Engine - Enabling You to Send Your Data to Any System Using OAUTH

You are no longer limited to the systems you can post webhooks to, you can now include any system that requires an OAUTH and refresh.

Posted August 4, 2020

Set a Membership/ID Card to Expire After x Time After Being Issued

When setting up a membership program for IDs, you can set the membership card to auto expire after a period of time.

Posted July 22, 2020

We Updated our Flow When Becoming a Member - For Maximum Conversion

We updated our membership signup flow (for those allowing people to signup online) in order to ensure you can upsell add-ons along with streamline the signup process.

Posted July 20, 2020

Setup Rules to Limit Access to Members at Specific Times

You can enable Valid Rules to enable specific times and blackout dates when a membership card is considered valid.

Posted July 10, 2020

Contactless Dining Experience - Let customers order from their phones for table side service.

With our new Shop F&B capability, you can allow people to order from their phone while dining at your restaurant for a true contactless experience.

Posted July 10, 2020

Add Notes to Your Packing Slips

Need to inform your team on how to handle a specific item? Use our packing slip notes that get added to the order packing slip for your team.

Posted July 7, 2020

Integration - Toast POS - Using PeopleVine for Membership and Loyalty with the Toast POS

With our Toast integration, you can reward people points, use rewards to pay for the check and track/manage your member accounts.

Posted July 2, 2020

API Sample - Book a Reservation

A quick few steps to getting availability and booking a reservation.

Posted June 30, 2020

Send Your Message with Importance - Ensure People Who Opted Out get Important Emails

We know there are messages that are important to communicate with your members, so we've enabled the ability to send directly to specific groups with high importance, even if they opted out.

Posted June 25, 2020

Add Additional Security Measures to Ensure People Don't Change their Name

Finding that people are cheating the system by changing their name on their membership profile? Add this code to prevent them from editing it.

Posted June 19, 2020

Make a Field Required When Signing up as a Member

Make the fields we don't require as required by adding these lines of code to your layout.

Posted June 19, 2020

Setup a Warehouse to get Notified when an Order is Placed

Looking to notify a different warehouse or split orders between your bar and kitchen? Leverage these steps to configure a packing slip and quick links to validate orders.

Posted June 15, 2020

Connect Your Square POS for Order History, Loyalty, Card on File and More

With our integration to Square you can track member spend to their CRM profile in PeopleVine while enabling a secured way for registering your card on file at the POS.

Posted June 12, 2020

© PeopleVine 2020. Powered by PeopleVine. Terms of use | Privacy & cookies