Search
This will return everyone that was in the activity - both their positive and negative score.
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..."
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:
Copy the top 100 results into a separate sheet and export it to the customer
xlsx (6.88 MB)
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/2022This will return everyone that was in the activity - both their positive and negative score.
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..."
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
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:
Copy the top 100 results into a separate sheet and export it to the customer
xlsx (6.88 MB)