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 11/1/2019 12:00 AM, 11/30/2019 11:59:59 PM, 10/1/2019 12:00 AM, 10/31/2019 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.

Integrating and Configuring your Aireus POS with PeopleVine

This step-by-step guide will show you how to utilize the Aireus POS integration with PeopleVine and configure the initial pieces.

Posted November 13, 2019

Understand How Subscriptions are Processed and How to Put on Hold

In this article, we'll share with you the various statuses available for subscriptions and how to leverage them to put people on hold and/or control their access.

Posted November 4, 2019

We Added New Newsletter Snippets and Perfected the Others

You may notice some new snippets in the builder, we just launched 12 additional snippets to help you build better newsletters.

Posted October 31, 2019

Add a CC Email to a CRM Account for their Admin or Another Inbox to get the Same

You can now add a CC Email address to a CRM record that is used to carbon copy any outgoing e-mail to this person.

Posted October 30, 2019

We Updated the Plot on a Map and Added New Reports to Target Groups

With the updated "plot on a map" feature you get a better view of where your customers live. And with our new CRM reports, you can totals of people by location.

Posted October 28, 2019

People Can Transfer Tickets to Other People To Build Your CRM

The goal is to build your CRM of loyal customers and the best way to do that is enabling your ticket purchasers to allow others to participate in the experience with them.

Posted October 28, 2019

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.

Posted October 26, 2019

Introducing the Reporting Guidebook - An Outline of Available Reports

See samples of the types of reports PeopleVine can generate in order to get a snapshot of your business in real-time.

Posted October 26, 2019

Deploy Your PeopleVine App to the App Store Under Your Brand & Developer Account

Looking to add an app to your digital portfolio? This article will show you how to ensure your brand is all over it including being the publisher, your app name, icon and more. As well helps you gain access to statistics and reviews.

Posted October 24, 2019

How to Setup a Magic Link Login for Your Members who Forget Their Password

You can setup a magic link login form so it's only one-click for your members to access their account.

Posted October 23, 2019

Upcoming Birthdays, Anniversary, Member, Member Since, Applied and Applied On are Now Standard in the CRM

We started to merge our member and CRM experiences into one, as majority of your data is from members.

Posted October 23, 2019

Setup an Application to Capture Spouse/Partner Info and Link Together

Make sure you follow these steps when setting up your application and looking to include spouse or partner information in the application.

Posted October 22, 2019

A Step by Step Guide to Using Rewards at the POS

A quick guide on how to add the member number, check their balance and then process their rewards.

Posted October 12, 2019

Keep Track of How Long Your Event Attendees Are There with Check In and Check Out Abilities

You can scan someone out using the same event ticket to track how long they attended the event for.

Posted October 11, 2019

The Scheduler Now Supports Daily Blocks for Reserving Hotel Rooms with Member vs. Public Based Pricing (and we added Taxes too)

With our recent updates to the scheduler engine, you can now book things like hotel rooms and vacation stays by setting daily availability. As well, you can configure different pricing and availability based on public or specific membership levels, including peak and off-peak times. And we even itemize out the different taxes that are collected for full transparency.

Posted October 4, 2019

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