Add the ability to report on specific Sku's by state

[srl6920]

I think it would be nice to be able to do sales by state by sku.  Maybe just be able to imput the skus you want the sales for.  This helps with anyone who has sales reps to see what states still need focusing on.

[srl6920]

Also, would it be possible to do this on a Zip code level?

[Delphi Centurion]

I think it would be nice to be able to do sales by state by sku.  Maybe just be able to imput the skus you want the sales for.  This helps with anyone who has sales reps to see what states still need focusing on.

Yes, this is a good idea.  We incldued a new report in a recent release which does this exact thing for international orders.  It's located in the Geo -> International Sales -> Intl SKU Sales.  Take a look at this report and let us know what you think.  We could easily do this very same report by US State.

The same report by ZIP Code is also possible, but I am not sure how helpful this would be.  How does a report like this help with your business?

Delphi Centurion

[srl6920]

I took a look at the International Sku Sales.  That is exactly what we are looking for.  Instead of Countries you can swap states as a filter tab. 

The reason for zip code for us and i can't imagine we are alone is because we might have several sales reps in a single state.  In order to measure sales figures for the rep's commission we need to report back sales for specific sku's or category of skus for a specific state.  When there is more than one rep per state the rep's divide themselves into specific zip codes within that state.  California is much too large for one rep to cover so a company might have 15 reps in the state of california and assign them to 15 sets of zip codes.  Each rep gets commission based on their performance in those zip codes.  I think this would be a nice marketing point too.  Use Communique to track sales reps sales figures.

[Delphi Centurion]

I took a look at the International Sku Sales.  That is exactly what we are looking for.  Instead of Countries you can swap states as a filter tab. 

Yes you are right.  It would not be too difficult to add these reports into Communique.  I will put it on the wish list.  Thanks for the suggestion.

Delphi Centurion

[Delphi Centurion]

The reason for zip code for us and i can't imagine we are alone is because we might have several sales reps in a single state.  In order to measure sales figures for the rep's commission we need to report back sales for specific sku's or category of skus for a specific state.  When there is more than one rep per state the rep's divide themselves into specific zip codes within that state.  California is much too large for one rep to cover so a company might have 15 reps in the state of california and assign them to 15 sets of zip codes.  Each rep gets commission based on their performance in those zip codes.  I think this would be a nice marketing point too.  Use Communique to track sales reps sales figures.

I see what you are getting at, but this report is a bit more difficult.  It would have to be filtered by state first and then ZIP code. 

It would seem 5 digit ZIP codes would be sufficient or would you want them broken out by 9 digit ZIPs as well?

Delphi Centurion

[srl6920]

I think the 5 digit zip would suffice.  However, is it a big issue to do zip + 4?  While i don't think i will have a need for the +4 some other user might?

[Delphi Centurion]

I think the 5 digit zip would suffice.  However, is it a big issue to do zip + 4?  While i don't think i will have a need for the +4 some other user might?

As far as the report in concerned, it would not matter; However, 40 million ZIP+4's vs 43,000 5 digit ZIPs would make a huge difference with the number of pages a report would print.  And with a huge report like that, I am not sure how useful it would be combing through all of the data. 

I tend to think a 5 digit ZIP code is sufficient for a report like this unless someone could explain why a ZIP+4 would be desireable. 

Delphi Centurion

[srl6920]

I see now.  For me 5 digit zip is perfect i don't see the need for zip+4 and don't ever see the need for it in the future either because we would not do that far of a breakdown for our purposes.