Question: would it be possible to create a master database which lists all zip/postal codes only once (vertically, y-axis) with a lead owner for each brand (horizontally, x-axis) that would be setup and stored as an external object?
The goal would be to set this up in a way that we would not have to repeat any zip/postal codes or geographical information, but simply list an assignment by brand for all 6. When a new lead would come into SFDC, depending on the brand flag/identifier, the system would run a query on the database and pull the lead assignment.
By keeping this information external, we would also like to consider maintaining our "Find a Rep" lookup information in the same place. This way there is no discrepancy in coverage and assignment of territory.
Am I completely off track here or is this something that we could pull off? I know it will be a massive database, but I'd rather one massive database stored outside of Salesforce than 6 slightly-less-massive databases for each brand.
Thank you!
2 件の回答
Hi Danielle,
I may not have any useful information for you yet, but may I ask how you are planning to query on the external database? Also, in case you don't receive any other response here, may I suggest posting your query on the developer forums as well since I do believe this would revolve around custom coding and the members there can surely help.
Thanks!
