Stores

Stores lets you go to any store across the estate and see which planograms are live there, along with the store’s format and address. It answers “what does this store actually look like” in seconds.

Use it to:

• see how stores of each format are spread across the country;
• see what planograms look like across the different store clusters, to make ranging recommendations that suit each one;
• prepare for a store visit.

Explore covers the dropdowns, tables, details panel and map that Stores shares with Plans and Products.

Find a store

This main view shows you where each store is located on the map. Select a date to get a view of all the stores of a given date. The table beneath the map lists each store’s ID, Name, Country, Format and Status for that date. Where your data includes sales, it adds Total Spend and Total Units, and the store that sold the most units comes first.

Explore lists trading stores only.

Choose a store by selecting it on the map, or from the table.

Select Track location on the map to see the stores near you.

Store details

Once a store is selected, its information appears in the details panel on the right: its ID, format, address, country and status. Where your data includes sales, the panel adds the store’s sales for the week. Below them the panel lists whatever else the retailer supplies about its stores.

Select View under Plans or Products to see a full list of the plans or products that have been assigned to the selected store. Select a plan in that list to open it in Plans and see the planogram live in that store.

Before a store visit

A field team can use Explore to prepare for a visit. Ask your account manager if you would like to give field teams access.

• The map finds the store you are visiting, and Track location shows the stores near you.
• View under Plans lists the plans the store has. The plan for your category is the planogram to check the shelf against.
• On the plan, a grey band marks each product that sits in shelf ready packaging.
• A gap on a shelf of the plan is space the planogram leaves empty, for example for point of sale material.

Store clusters

Where a retailer plans by store cluster, Coplan loads the clusters each week with the plans. You can find them in three places:

• In Stores, scroll down the details panel to see every cluster the selected store belongs to.
• In Plans, the details panel shows the store cluster id and store cluster name of the cluster a plan is for.
• In Compare, the export’s Location_Raw_Data sheet holds the store_cluster_id and store_cluster_name of each store, alongside plan IDs and store names.

What clusters mean for brands

Brands can see what the planograms look like in each cluster, and so make ranging recommendations that suit each cluster within a category.

Questions retailers will ask

• What is the impact on the category and brand?
• Which clusters and ranges are driving the most value?
• Do any clusters push the range too far, for example too premium?