2022
Hi to everyone!
I have been working a while ago on a spreadsheet that can help every local guide (of any level) to evaluate his activity. Because I started using this spreadsheet months ago, I have been able to amend it and optimize it many times 🙂
Well.. Let's not wait too much!
What do I need to do?
To make it as easy as possible, I made it available on a Google Spreadsheet through this link. The way to fill it is simply going back to your Gmail inbox and searching for all emails received from Local Guides Email (noreply-local-guides [at] google.com). And here are the basic three pieces of information you need to take from the email message to your spreadsheet:
- Email date (you can change the date format on the spreadsheet to fit your preference);
- Total Views;
- Total photos.
Sample email:
Just inject these three figures into the spreadsheet in the three Orange columns (delete the sample numbers, they are only for illustration), and the rest of statistics will automatically be calculated by the formulas already added. Accordingly, each email you have received will be one row. Just to note that you should start from bottom and start filling to the top.
The spreadsheet with illustrative figures:
Finally, from the data that represented my personal activity through local guides program, I was able to see my performance. Therefore, evaluate whether my photos were useful for Google Maps users or not, and whether my current performance is better or worse than before.
I hope everyone uses the spreadsheet and tells us about his findings 🙂
P.S: for anyone that is not familiar with Google Spreadsheets, you can download the Excel version here.
