CMOPS How-to: Updating the weekly Listings & Leads on the CMOPS MMM Sheet
Last updated: December 18, 2025
Updating the sheet is done on Friday mornings with a date range of Friday-Thursday
Q listings
Open up the Q Listings Report on Metabase
Set dates Friday-Thursday & download data
Scroll all the way to the bottom of the "Q Report listing tasks" tab in the CMOPS MMM Sheet
Import data into the bottom of the sheet "Replace data at selected cell"
Delete the row with the column titles
Drag blue formulas (on the right) all the way down to the bottom
Check the "Summary for weekly graphs" tab to make sure the data imported correctly for all the correct days
Leads
Open up the Leads Report on Metabase
Set dates Friday-Friday & download data (This will NOT pull data for the current Friday, only till the end of day Thursday)
Scroll all the way to the bottom of the "Metabase Leads" tab in the CMOPS MMM Sheet
Import data into the bottom of the sheet "Replace data at selected cell"
Delete the row with the column titles
Drag blue formulas (on the right) all the way down to the bottom
Check the "Summary for weekly graphs" tab to make sure the data imported correctly for all the correct days
** If any data was collected for the current Friday go back into the Q Listing tab or Metabase leads tab and find & delete the data for the current day!
Update cell A2 in the Summary tab with the date the data was updated.
Slack Barbara that the CMOPS MMM data has been updated! 🎉