--- title: "How to: Query For Top Racers In A Given Date Range" description: Clubspeed Customer Knowledge Center --- [Skip to content](https://help.clubspeed.com/clubspeed-knowledge-center/how-to-query-for-top-racers-in-a-given-date-range#main-content) English Show submenu for translations [More support](https://help.clubspeed.com/clubspeed-knowledge-center/kb-tickets/new?hsLang=en) [![Clubspeed Logo](https://help.clubspeed.com/hs-fs/hubfs/Logo_Grey.png?width=500&height=86&name=Logo_Grey.png)](https://help.clubspeed.com/clubspeed-knowledge-center?hsLang=en) Open main navigation Close main navigation - English Show submenu for translations - [More support](https://help.clubspeed.com/clubspeed-knowledge-center/kb-tickets/new) - [Contact us](https://share.hsforms.com/1B5QyPF-YRQutaoGEnmQD5w1etz6) [Contact us](https://share.hsforms.com/1B5QyPF-YRQutaoGEnmQD5w1etz6) How can we help you? - There are no suggestions because the search field is empty. 1. [Clubspeed Customer Knowledge Center](https://help.clubspeed.com/clubspeed-knowledge-center?hsLang=en) December 6, 2024 # How to: Query For Top Racers In A Given Date Range Search ### How to: Query For Top Racers In A Given Date Range Using SQL Scripts and Google Sheets Formulas to return your desired top racers data (based on RPM/ProSkill) Be sure to download the attached XLSX file and import it into Google Sheets first Use the following SQL script to pull customer data of a specified date range. This example below is the date range of 1/1/2022 - 12/31/2022 This will return everyone that was in the activity - both their positive and negative score. ![](https://help.clubspeed.com/hubfs/Knowledge%20Base%20Import/attachment-3.png) Copy the data and add it to a spreadsheet called "Sheet1"**EVERY**  To export the data you have to right-click the data, and then "save results as..." ![](https://help.clubspeed.com/hubfs/Knowledge%20Base%20Import/attachment-Dec-06-2024-07-13-04-1046-PM.png) From there, you can use the import function at the top of the task bar in Google Sheets and upload the data. Rename the imported data to Sheet2 if needed or directly import the data/replace to Sheet2 ![](https://help.clubspeed.com/hubfs/Knowledge%20Base%20Import/JR6H3SWI6Klm47jgupmyBIsDL3D3cQqXEA.png)![](https://help.clubspeed.com/hubfs/Knowledge%20Base%20Import/dvRIcNT7XLeNrRu4CtXVdMWT9ug49h2zEQ.png) Sheet3 is where the Google Sheets magic comes in. Column A needs to be populated so you can simply copy all the CustomerID in "Sheet1" and wait for the page to load because once you enter the CustomerID values, the sheet will populate the rest of the data for you. Example of before (top) and after (bottom) the CustomerID is added:![](https://help.clubspeed.com/hubfs/Knowledge%20Base%20Import/attachment-Dec-06-2024-07-13-19-1882-PM.png) Copy the top 100 results into a separate sheet and export it to the customer   xlsx (6.88 MB) - - - - ### Related Articles - [FAQs](https://help.clubspeed.com/clubspeed-knowledge-center/faqs?hsLang=en#main-content) - [Software Questions](https://help.clubspeed.com/clubspeed-knowledge-center/faqs?hsLang=en#software-questions) - [Payments Questions](https://help.clubspeed.com/clubspeed-knowledge-center/faqs?hsLang=en#payments-questions) - [Getting started](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#main-content) - [Clubspeed](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#clubspeed) - [Administration](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#administration) - [Product Setup](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#product-setup) - [Customer Experience](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#customer-experience) - [Race Control](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#race-control) - [Manager Controls](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#manager-controls) - [Point of Sale Operations](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#point-of-sale-operations) - [Venue Operations](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#venue-operations) - [Race Control Operations](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#race-control-operations) - [Event Calendar](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#event-calendar) - [Open & Closing Shifts](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#open-closing-shifts) - [Activity Setup (FEC Non Karting)](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#activity-setup-fec-non-karting) - [Kart Focused](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#kart-focused) - [Troubleshooting](https://help.clubspeed.com/clubspeed-knowledge-center/troubleshooting?hsLang=en#main-content) - [networking](https://help.clubspeed.com/clubspeed-knowledge-center/troubleshooting?hsLang=en#networking) - [General](https://help.clubspeed.com/clubspeed-knowledge-center/general?hsLang=en) - [Reports](https://help.clubspeed.com/clubspeed-knowledge-center/reports?hsLang=en#main-content) - [Gift Cards](https://help.clubspeed.com/clubspeed-knowledge-center/reports?hsLang=en#gift-cards) - [Integrations](https://help.clubspeed.com/clubspeed-knowledge-center/integrations?hsLang=en) - [Payments](https://help.clubspeed.com/clubspeed-knowledge-center/payments?hsLang=en) - [Email and Text Messaging](https://help.clubspeed.com/clubspeed-knowledge-center/email-and-text-messaging?hsLang=en) - [Item Management](https://help.clubspeed.com/clubspeed-knowledge-center/item-management?hsLang=en) - [Resources](https://help.clubspeed.com/clubspeed-knowledge-center/resources?hsLang=en) - [Calendar Management](https://help.clubspeed.com/clubspeed-knowledge-center/calendar-management?hsLang=en) - [Customer Management](https://help.clubspeed.com/clubspeed-knowledge-center/customer-management?hsLang=en) - [Promotions and Marketing](https://help.clubspeed.com/clubspeed-knowledge-center/promotions-and-marketing?hsLang=en) - [Updates](https://help.clubspeed.com/clubspeed-knowledge-center/updates?hsLang=en#main-content) - [Release Notes](https://help.clubspeed.com/clubspeed-knowledge-center/updates?hsLang=en#release-notes) - [Registration](https://help.clubspeed.com/clubspeed-knowledge-center/registration?hsLang=en#main-content) - [Setting up Your Registration](https://help.clubspeed.com/clubspeed-knowledge-center/registration?hsLang=en#setting-up-your-registration) - [iPads](https://help.clubspeed.com/clubspeed-knowledge-center/registration?hsLang=en#ipads) - [Products](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#main-content) - [Business Additions](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#business-additions) - [Extra Tips & Tricks](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#extra-tips-tricks) - [Setup](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#setup) - [Point of Sale](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#point-of-sale) - [Barcode](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#barcode) - [Activities](https://help.clubspeed.com/clubspeed-knowledge-center/activities?hsLang=en#main-content) - [Activity Operations](https://help.clubspeed.com/clubspeed-knowledge-center/activities?hsLang=en#activity-operations) - [Reporting](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#main-content) - [Sales Reports](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#sales-reports) - [Operational Reports](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#operational-reports) - [Labor Report](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#labor-report) - [Accounting](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#accounting) - [Race Operations](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#race-operations) - [Quickbooks Online](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#quickbooks-online) - [Club Booking](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#main-content) - [Setup - Club Booking](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#setup-club-booking) - [Operations](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#operations) - [Booking Manager](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#booking-manager) - [Bonus Material - Club Booking](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#bonus-material-club-booking) - [Operational Flows](https://help.clubspeed.com/clubspeed-knowledge-center/operational-flows?hsLang=en) - [Food & Beverage](https://help.clubspeed.com/clubspeed-knowledge-center/food-beverage?hsLang=en) - [Speed Screen Displays](https://help.clubspeed.com/clubspeed-knowledge-center/speed-screen-displays?hsLang=en) - [Garage](https://help.clubspeed.com/clubspeed-knowledge-center/garage?hsLang=en) - [Support Task](https://help.clubspeed.com/clubspeed-knowledge-center/support-task?hsLang=en) - [Webinar](https://help.clubspeed.com/clubspeed-knowledge-center/webinar?hsLang=en) - [Playbook](https://help.clubspeed.com/clubspeed-knowledge-center/playbook?hsLang=en) [![2022-clubspeed-newsletter-header-logo](https://help.clubspeed.com/hs-fs/hubfs/2022-clubspeed-newsletter-header-logo.png?width=240&height=42&name=2022-clubspeed-newsletter-header-logo.png "2022-clubspeed-newsletter-header-logo")](https://help.clubspeed.com/?hsLang=en) Copyright © 2024, Club Speed, LLC