LookerStudios Reports
      Back to home
      1. VenuePilot Support
      2. Reports
      3. LookerStudios Reports

      Additional VP Reports

      Take a tour of VenuePilot's additional reporting available via Looker Studio

       

       

      👀Please Note!👀

      • To view Looker Studio reports, please make sure you are viewing with an email that has Admin Access to your VenuePilot ORG. You can see/change the email viewing this data in the upper right-hand corner of the report (screenshot below)!
      • Having trouble viewing your data? Check that you aren’t attempting to access the reports from a separate Google account, for example, your personal email.
      • In the upper right-hand corner of the report, click the CIRCLE ICON containing your Chrome Profile Photo. Here you can switch to any email that has ADMIN ACCESS inside the VenuePilot ORG you are pulling data for.
      • You can also use a Guest Chrome Profile to share this data with your team 
        • To create a guest profile in Google Chrome, you can: 
          • Open Chrome
          • Click your profile picture in the top right corner
          • Click Guest under Other profiles
          • A new window will open, indicating that you're in Guest Mode
          • When you're done using the web, close the "Guest mode" browsing window

      Health Reports

      • P&L Flash Report
        • An overview of how yesterday performed, including Total checked-in vs. Total Sold numbers for your event!
        • Pull in details from your Settlement Sheets including Merch cut, concessions, and space rental fees

      Customer Analysis Reports

      • Buyer Locale
        • Learn more in-depth details about the location of your ticket buyers.
      • Ticket Manifest
        • A detailed look at every ticket sold to your event(s)
      • Tops Fans
        • Learn who your accounts' most loyal fans are based on number of tickets bought, total sale revenue & donations.

       

      Accounting Reports
      • Stripe Payout Reports
      • These reports will also help you reconcile your payouts in Stripe!
      • In your Stripe account, navigate to your Payouts by clicking on the left-hand “Balances” from the menu.
      • Next, click the “Payouts” tab on the right-hand side:

      • Your stripe account should list each payout to your bank, which you can then match to your LookerStudios reporting
      • With your payout date selected in Stripe, scroll through the dates under "Stripe Payouts:" in your Settlement Report (By Event 

      • As you scroll down under Events, you will see the shows, tickets, and individual transactions that make up your total stripe payout

      * Gross= The Sum total amount of the orders paid by the ticket buyer
      * Fees= Total fees deducted (both VenuePilot fees and Stripe fees)
      * Total= Total payout minus fees
      * Refunds= Total amount you refunded
      * Adjustments=  There are VenuePilot’s returned fees to you on refunds. If you fully refund a ticket buyer we also will refund the associated fees to you 🙂!

      PRO Reports

      • ASCAP Blanket Concert and Recital Report (BCON)-
        • Looks almost exactly like ASCAPs template report. Use this to save time preparing reports to submit to ASCAP.
          • Type in your account number
          • Type in your “Premise Name” (it must match exactly the “Premise Name” in the table- It’s case sensitive)
          • Select your date range

       

      🆘Still need help? Reach out to us @ clientsupport@venuepilot.co