 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
Yourwebness |
 |
Yourwebness |
 |
SherryShopperFL |
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
 |
|
The Reports are also an automated feature. They are created using Pivot Tables. Pivot Tables are an easy way to create a report with only the information you want. Each report worksheet contains a separate report, because the data will grow as the number of your shops increase, I did not want to crowd these reports.. The other tracks the assignments. Let me review the reports so you have a better idea of what they actually do. |
||
Mystery Shop Number of Assignments Status Report |
||
This report tracks the number of assignments. |
||
This report is very simple, and just counts your assignments for each week, month and year. Again this is based on the Shop Date, which is entered AFTER you have completed your shop assignment. |
||
This report is listed first by Year, Month, then by Week. You can easily know how busy you have been, and compare your current Month (or Week or even Year) to the previous ones. We as shoppers have found that some months are busier than others, and some months are slower. This way you will know how busy you have been. |
||
This information can easily be updated, simply place your cursor anywhere INSIDE the Pivot table, where the data is located. Click on DATA > REFRESH DATA. |
||
|
||
 |
 |
|
This is a screen shot of the top portion of the Report-Assign Worksheet . As I stated, it is basically a count of all assignments you have done, sorted by Year, Month, and then Week. |
This screen shot shows a closer look at how the data is reported, first by year, then month, then week, and the fee breakdowns. Look over to the right. Those red figured in the last column show fees for shops done in that month (whatever is listed to the left) that have not been paid yet. At the top is a button the says MS COMPANY, and to the right it says "(ALL)." However you do also have the ability to look at the payment status for any Mystery Shopping Company you have listed on your Assignments Worksheet. Just click on the small arrow to the right of (ALL) and then select the company you want to see the data for. |
|
 |
 |
|
This screen shot shows how you can customize your report to display ONLY information for one Company. Do you know how well you are doing specifically with one company? You can now! At the top is a button the says MS COMPANY, and to the right it says "(ALL)." However you do also have the ability to look at the payment status for any Mystery Shopping Company you have listed on your Assignments Worksheet. Just click on the small arrow to the right of (ALL) and then select the company you want to see the data for. |
This screen shot shows the result of selecting one company using the MS Company field. To return to the "normal" report, just change the company from whatever you selected back to (ALL). |
|
I personally love the reports, I like to be able to see various reports, and having the ability to easily change what I am viewing is helpful to me. But I am just one shopper. Many experienced shoppers will find that this is just a waste. Whatever is helpful to you is what you should use. Remember, what works for one person, may not work for another. I could not imagine using a notebook and a pen to track everything, there is just not enough ability to track things the way I wish to see them. Now that doesn't make this their or this system better, it only makes this system better for me, because it tracks what I want it too. Use a system (any system you choose) that is designed to meet your needs whatever they may be. |
||
© 2000 - 2007 Yourwebness' Cyber Corner |
||
