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.

Add Venue Locations to Your Event Setup

You can customize the list of locations where you host your events by following these steps. You can use it to provide locations that are within your space or remote locations.

Posted November 19, 2019

Need to Resend an E-mail/Newsletter to Someone Individually? And even include cc.

You can use the Send Email feature on the CRM to send an e-mail directly to a person, using an existing template.

Posted November 15, 2019

How to Setup a Portal to Allow Your Partners/Operators to Redeem Gift Cards

See how to setup a portal designed for your partners to redeem rewards/gift cards.

Posted November 14, 2019

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

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