Skip to main content

CRM - Overview Diagram


CRM is an interesting topic.

I had the opportunity to work for a company where I participated in a project for the integration of:
  • Microsoft Dynamics GP
  • Microsoft Dynamics CRM
  • Sharepoint (for the intranet)
I’ve also worked in the Digital Agency industry, involved in Web App solutions, where CRM strategies play an important role.
For a client (Eg: An online company in retail selling shoes) would be beneficial to find a Shop (Digital Agency) that understands CRM from the strategic point of view and also offers services using software tools that facilitate the finding of insights, track consumer behaviors and helps to provide a personalize experience to the consumer; bringing value to the business.

There are CRM solution providers out there that a Shop can partner with. To name a couple:

There could also be a case where a Shop can create their own custom solution that could have as their center piece a BI system, created as a product/service for their clients. This flexible and scalable product/service can evolve to get integrated with 3rd party vendors and/or partners if it needs to. In terms of Data It does not have to be a complex data warehousing. A dataset, as a starting point, should be enough for storing data making it easier for finding valuable insights, defining targets and design/enhance the strategy that make sense for their client’s business, moving from a campaign focused to a customer focused strategy. Without going too deep into the details here are a couple of suggestions regarding the products that can be used:
  • Microsoft SQL Server (including SSIS for data transformation). find more here
  • Pentaho: it has a commercial and Community version (currently installed it for a POC. I'm hoping to get to a point that I can write a post about it). Find more here

As I continued looking more into CRM solutions I ran into the book “Connected CRM – Implementing a Data-Driven, Customer-Centric Business Strategy” by David S. Williams. Instead of writing an article with multiple pages about the subject I ended up drawing this high-level diagram as a visual overview of the concept that I wanted to express in this post, which is focus on online properties (Web Apps) from the Digital Shop perspective. It could also be considered as a subset of a bigger CRM Integration Design for a client that has other systems (Example: ERPs (Enterprise Resource Planning), internal CRM solutions, POS (Point
Of Sale system), others) and channels.
Diagram created using

Trending posts

Gaming trends: What to expect

Gaming continues with an accelerated evolution and significant business growth. The incredible virtual worlds are receiving thousands of real-time players, becoming another avenue for networking, as well as entertainment. This is just impossible to ignore. The gaming industry is one of the most dynamic and innovative sectors, constantly evolving and adapting to new technologies, consumer preferences, and market opportunities. Photo by Mikhail Nilov via Pexels   Newzoo forecast the game market will grow to $217.9 billion in 2023. Newzoo 2020 Global Game Market Cloud and gaming There was a time, not too long ago, when you would buy your games and play them by inserting them into your console or computer. As more gamers demand access to high-quality games on any device, anywhere, anytime, cloud gaming will become a mainstream option for delivering games over the internet. Games are now becoming available via subscription model. An example of this is the Microsoft Xbox game pass and Xbox L

Analytics and Attribution models

The customer journey is packed with multiple touchpoints, making it challenging to determine which of these “moments” (actions taken by the user) have played the most significant role in the conversion of the customer.  Photo by Mikael Blomkvist from Pexels Model attribution provides insights into how users interacts with your web and mobile apps. The decision-makers leverage the insights to understand what marketing efforts are driving “value”, allowing them to focus on the channels that provide the best Return on Investment (ROI).  There are several attribution models that can be used to assign credit. We will go through some of those in this article. Customer Journey - First touch attribution It is an awareness focus, being an introduction to the brand. This model gives the conversion credit to the first point of contact (i.e. a video or a social link).  Last touch attribution It is a model that gives the conversion credit entirely to the final touchpoint from which a lea

Your platform as a positive force in the world

If you are managing a platform, even if it is small, then you are leveraging one of the elements and popular channels used to build digital communities. These platforms, and channels, can come in the shape of websites, blogs, mobile apps, podcasts, vlogs, social media, or a combination of the ones mentioned. Photo by Tatiana Syrikova from Pexels   There are many reasons for building a community, such as sharing knowledge, promoting businesses, branding, the need for engaging with others, etc. However as Spiderman’s Uncle Ben said: “With great power comes great responsibility.” If you like to build better communities with more collaboration and less silos then how would you do it? How can communities come together to drive a “ positive force ”? The current world is mired in conflicts. How long are we willing to go on in such disarray? All the continents are in some kind of “a demonstration of partisanship, intolerance and selfishness”. There are nations in the Americas, Africa, Middl

This blog uses cookies to improve your browsing experience. Simple analytics might be in place for pageviews purposes. They are harmless and never personally identify you.