Yes those are collections. The name of a collection is provided via the full_name attribute: collection – Collection level operations — PyMongo 4.3.3 documentation
>>> client['test']['hanna_barbera'].full_name
'test.hanna_barbera'
>>> client['test']['hanna_barbera']['spacely_sprockets']['contact_list'].full_name
'test.hanna_barbera.spacely_sprockets.contact_list'
>>> client['test']['hanna_barbera.spacely_sprockets.contact_list'].full_name
'test.hanna_barbera.spacely_sprockets.contact_list'
Note that different collections in the same database are completely unrelated no matter the naming convention.
It might make sense to put all the reports in a single collection, eg ‘test.reports’. You can add a “vendor” and “report” field to every document. Eg:
data = {"ID": ..., "DATE":..., "NAME": ..., etc.}
data["vendor"] = "spacely_sprockets"
data["report"] = "contact_list"
client.test.reports.insert_one(data)