OK, the problem here is that it's not an exact science. Perhaps you can glean a few pointers from some the following ramble...
Have a look at
this view scheme I detailed away back for version 11.1 and see if it makes sense to you. I still give this view scheme a tweak now and again, and it now has the following expression based pane:
which is derived from the following expression:
if(isequal([keywords],vinyl,8),Vinyl,
if(isequal([archive],retail,8),
if(isequal([archive],backup,8),Retail/, Backed Up,
if(isequal([archive],ripped,8),Retail/, No Backup,Not Ripped)),
if(isequal([file type],flac),
if(isequal([archive],backup,8),Downloaded/, Lossless/, Backed Up,
Downloaded/, Lossless/, No Backup),
if(isequal([file type],ape),
if(isequal([archive],backup,8),Downloaded/, Lossless/, Backed Up,
Downloaded/, Lossless/, No Backup),
if(isequal([file type],apl),
if(isequal([archive],backup,8),Downloaded/, Lossless/, Backed Up,
Downloaded/, Lossless/, No Backup),
if(isequal([archive],lossless,8),Downloaded/, Lossless/, Backed Up,
if(isequal([archive],backup,8),Downloaded/, Lossy/, Backed Up,
if(isequal([media type],image,1),Artwork,
Downloaded/, Lossy/, No Backup)))))))
It's still got a couple of kinks that need ironed out, but overall, it gives me a shedload of useful information in just a few mouse clicks.
Now, the limitation here is that MC does not ship the database info offline along with the files, so, you need to get your most pertinent information stored in file tags, which is OK as long as your media files can accomodate the metadata. No luck if you're backing up a load of .tif image files for example. Once you bring up your cd/dvd database viewscheme however, you're free to tag the offline files any way you desire, and the tags will be retained, albeit in the database only (obviously).
Earlier on in the beta cycle, I began experimenting with
burning my picture files to DVD and using a similar viewscheme to the one linked above to keep me up to speed with what was where... (tif files needed to be re-tagged as MC does not save any metadata in these files, despite the anacronym that gives them their filetype name)
As you begin to see some of the options open to you, you can snip and idea from here, tweak another from there, and finish up with a custom view scheme setup that fits your needs.
I strongly recommend that you try setting up the cd database view scheme as I think you will find it to be quite helpful to you. Remember that MC just needs to 'see' the disc and it will be imported to the offline database.
If you have any more specific questions then just fire away.
-marko.