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 2/1/2023 12:00 AM, 2/28/2023 11:59:59 PM, 1/1/2023 12:00 AM, 1/31/2023 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.

Register Your Twilio Account for A2P 10DLC Registration with the Carriers to Ensure Delivery

Due to requirements in the US, all clients using Twilio to send SMS to US based customers must register their business and campaigns for outbound messages.

Posted January 6, 2023

Peoplevine is Live on the Toast Marketplace for 1-click Enablement

We've made it easier for you to activate Peoplevine with Toast by using the standard integration.

Posted December 9, 2022

Track an Alternate ID for Membership Card Scans and Identify Primary Membership

We made some updates to the membership experience by adding an alternate ID used to ensure keycards and other IDs are scannable in our platform along with flagging the primary membership.

Posted November 29, 2022

Login with Azure MFA to Enable Secured Azure Active Directory Login

You can now login to Peoplevine with your Azure Active Directory account in addition to your email and password or force the user down MFA only.

Posted September 21, 2022

Approve Multiple Applications at Once or Change the Person on the Application

With our new updates to the application engine, you can now approve (or reject) multiple applicants at once along with the ability to re-assign a CRM record to an application.

Posted August 19, 2022

Connect Your Stripe Account to Peoplevine

Follow the new flow to setup your Stripe connection using our v2 rails.

Posted August 2, 2022

Setup Your Global Network to Create Seamless Reciprocity Between Clubs

Once you've been approved and added to the Global Network, you'll be able to auto-enroll your members into all clubs linked to that Global Network. If your member resigns, then their Global Network access is also revoked.

Posted July 1, 2022

Updated GoCardless Flow and Connection

Connect your GoCardless account to Peoplevine to enable direct debit and bank transfer capabilities.

Posted June 9, 2022

Click Out to Send an SMS Message with a Pre-set Body

Need someone to click a link to send an SMS with a pre-defined body? For example if someone wants to text Valet to get their car.

Posted June 9, 2022

Updated Bookings Page with Appointments, Reservations, Events and Classes on One Screen

We updated the /account/bookings page to display both upcoming appointments/reservations along with event/class registrations.

Posted May 31, 2022

Combine Initiation and First Month/Year Dues into a Single Charge + Other Updates to Application Approval Flow

We updated the application approval flow to give you more control over charging your new members.

Posted May 20, 2022

Integrated to Calteq for Displaying Caller ID with Member Details

Leverage our integration with Calteq to automatically sync your membership database to Calteq, so when a member calls, you'll be able to identify them immediately and greet them accordingly.

Posted May 16, 2022

Add a Member Client Tag to Your Members in Sevenrooms

With a little setup you can map the membership sku in Peoplevine to the Client Tag in Sevenrooms.

Posted April 14, 2022

Updates to Importing Data to Simplify Onboarding

We enabled some new features when importing data into the platform.

Posted April 1, 2022

Setup Peoplevine House Accounts with Toast

You can now simplify the approach for making House Account payments in Toast.

Posted March 31, 2022

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