Tag: marketing

  • Spring in The Dynamics 365 World

    Spring in The Dynamics 365 World

    The recent Business Forward event with a keynote from Satya Nadella served as the launch event for the Spring 2017 wave of Dynamics 365 product functionality. If you didn’t catch the live stream, you can see the recordings of the various presentations here. Of if you just wants some snacks from the event, why not take a look at my Storify collection of tweets shared on the event backchannel:

    Let’s explore some of the most exciting pieces of news that we know about the upcoming release.

    I’d Like To Add You To My Professional Network on LinkedIn

    LinkedIn is naturally a big focus for Microsoft, after paying some seriously big money for the network. The first commercial offering from MS on the sales side seems like more of an evolutionary step in bringing the LinkedIn Sales Navigator product closer to Dynamics 365 Customer Engagement. The familiar iFrames will still be how LinkedIn content is displayed in the context of accounts and opportunities, but now also the activities from LinkedIn will show up on the standard Social Pane of Dynamics 365 entities.

    If you think of the old “democratizing social” message we’ve heard with capabilities like Microsoft Social Engagement offered at no extra charge, LinkedIn won’t follow exactly the same pattern. The bundle of Sales Navigator + Dynamics 365 Sales App (not Plan) now called Microsoft Relationship Sales solution still comes with a price tag that will not lead into everyone having unlocked LinkedIn tools and network data at their disposal. Not a huge surprise, since why would you give away this “new oil” for free to customers who’ve just bought the car from you? Those target groups who see value in these sales acceleration tools may still find this to be a better deal than the earlier offers.

    The other new product seems to be a bigger step forward as MS enters the Human Capital Management (HCM) game with their Dynamics 365 for Talent app. Again, the foundation here is sure to have a lot of the LinkedIn recruiter functionality covered in a new coat of Dynamics paint, but at least based on the Business Forward live demo this looks like quite a thorough paint job. The sales guys will apparently still be kept largely in the familiar LinkedIn territory in terms of the user experience, but Talent seems like an “authentic” MS app following their design language.

    There probably won’t be so much beef in Talent for the XRM people, but the ERP integration with existing AX/Operations HR features surely has great potential.

    It’s The Insight That Counts

    Talking about other Dynamics products outside of the XRM platform, one new entrant into the scene that has been popping up quite frequently on the recent slides is Dynamics 365 Customer Insights. Judging by what MS showed to the industry analysts at the BF event, there will be some UI changes from the current Preview that will bring this closer to Dynamics and further away from the initial “Azure Customer Insights” version that we saw last fall.

    It’s been a bit difficult to evaluate the true capabilities of the Customer Insights application up until now, since actually connecting it with Dynamics 365 data hasn’t been possible earlier. Once all the Azure Data Lake and other elements that this application depends on are fully available across different regions, perhaps we’ll soon get some hands-on experience to contrast with all the big words that have been associated with Customer Insights so far. At least all the segmentation and visualization features appear to be much more targeted towards real life CRM scenarios than some of the more generic analytics capabilities in products like Power BI.

    Speaking of which: I almost missed this announcement, but Power BI now as a connector to Customer Insights, which opens up some new scenarios. If the various analytics options didn’t have your head spinning yet, then the new Power BI Premium with on-prem server deployment options might just do the trick.

    What About XRM?

    Looks like there are shiny new applications coming for the Dynamics 365 product portfolio, some of which are leveraging the Common Data Service (CDS) as the backbone. It makes a whole lot of sense to use the latest technology for brand new apps, but that doesn’t mean the XRM platform would have been forgotten. To get a glimpse of what the Spring release will be introducing on this front, you can head over to the Dynamics 365 Roadmap site and pick an XRM based app like Sales, then see the “In Development” lane. Below are a few examples of the items currently listed:

    • Virtual Entities. “With Virtual Entities, System Customizers and Developer have the power to build complex business applications to view external data in Dynamics 365 at runtime without having to make multiple copies of the data.”
    • Portal interaction tracking. “Track your customer’s interactions with your Portal and funnel it to Dynamics 365 Customer Intelligence to plot a 360 view.”
    • Support Azure AD-B2C for Portal authentication using a single sign-on (SSO) configuration.
    • Source code for Portals. “A one time release of Portals code will be released to the Microsoft Download Center under MIT license for developers to download. This feature enables Portals to be deployed to Dynamics 365 on-premise environments, and allows developers to customize the code to suit their specific business needs.”

    Expect to see the list grow as we move closer to the planned release date. A lot of great features have already been presented in MS events, like in-context Flows in Dynamics 365, or improvements to the user experience. If you want to be the first to gain access to the upcoming features, then be sure to check out the recently announced Dynamics 365 Insider Program.

  • Analyzing Customer Behavior Data with CRM 2015 Rollup Fields

    CRM_2015_field_type_rollupFrom a system customizer perspective, one of the most intriguing new features in Dynamics CRM 2015 is the addition of two new  field types. Alongside the traditional “simple” fields we can now define our custom attributes to be somewhat more “complex”, by choosing to create them as either calculated fields or rollup fields. These new field type options allow us to create point & click solutions to cover scenarios that would have previously required custom code.

    Microsoft haven’t been advertising this feature much in their “what’s new” materials for the CRM 2015 version release, but great blog articles have already been written on the topic, like this one by Peter Majer on the Sonoma Partners blog. There are also articles on Technet for both rollup fields and calculated fields, which provide all the details you need for getting the new feature implemented in you CRM Online or CRM 2015 on-premises organization.

    Rather than repeating this documentation, I’ll be exploring the different scenarios where the new complex field types can be leveraged, as well as the considerations and limitations to be aware of. In this first blog post I’ll demonstrate how the rollup fields can give us better insights on how our customers are reacting to email marketing campaigns sent to them.

    Summarize Marketing Automation Data for Contacts

    When our own CRM Online production organization received the 2015 update, the first use case I had on my mind for the shiny new features was to apply the rollup field functionality to the online marketing data that our ClickDimensions solution has been storing into the CRM database. If you’re not familiar with ClickDimensions, it’s a marketing automation service that allows you to send and track email campaigns, collect website visitor data, publish web forms integrated with CRM fields, configure automatic nurture programs for new leads, among other things (see this page for a detailed feature listing).

    What makes ClickDimensions particularly interesting in this case is that all of the behavior data is available inside the CRM application, in the dedicated custom entities contained in the managed CD solution package. For example, a page view transaction from a website with the CD tracking script deployed will be stored as a record for the Page View entity and then linked to either an anonymous visitor or an existing lead or contact record in CRM. Since it’s an “XRM” solution that you install as an add-in to Dynamics CRM, rather than an external marketing database that would be just synchronized with CRM, we can leverage all of the CRM platform functionality for showing and analyzing the data, automating related business processes with workflows and so on.

    Now with CRM 2015, the rollup and calculated fields have been added to our marketing automation toolkit. So, what do they allow us to do that would have previously been difficult/expensive to implement? As mentioned, all of the events tracked by ClickDimensions are linked to a CRM contact or lead record when the person performing the actions can be identified from browser cookies, unique id’s in links or submitted form data. If we would now like to view this data from the perspective of an individual contact, the rollup fields provide a way to summarize the data from related entities into fields available directly on the contact form.

    Creating Rollup Fields for Contact’s Email Link Clicks

    Let’s go ahead and add a new field for the contact entity. Yes, it must be a completely new field as you cannot convert existing standard or custom fields into calculated or rollup fields. Not a problem in our scenario, as we’re building a brand new feature into our CRM organization. The first field will be called Total Clicks and we’ll use it to count the number of related records found, so whole number is a suitable data type for us. By setting the field type as “Rollup” we’re given the option to edit the rollup formula.

    CRM_2015_rollup_field_Clicks_1

    In the rollup field definition editor we must now choose the related entity from which we wish to roll the data up to the contact entity. As we’re dealing with email link clicks, these are stored in the Email Event entity in the ClickDimensions solution, so that will be our choice. However, since the entity also contains data about events other than link clicks, we’ll need to add a filter into the related entity section and define that only email events where the field “type” equals “click” should be included in our rollup. As a final step, in the aggregation section we select “count” as the function that will provide the actual value for this new field on the contact record.

    CRM_2015_rollup_field_Clicks_2

    Let’s repeat the process for another new field: Latest Click. Instead of counting records, we’ll be looking at the date values on the related records, retrieving the highest date available and storing it into our rollup field. This means the data type should now be “date and time”. The rollup field definition is otherwise the same as with the first field, but in the aggregation section we’ll now have a different list of functions available for this data type. Let’s pick the Max function and apply it on the creation date of the email event records associated with the contact.

    CRM_2015_rollup_field_Clicks_3

    Alright, let’s save these fields and get them published! Oh, by the way, did you notice the yellow notification bar down in the rollup field definition editor window? That’s actually very useful information to be aware of once we move on to the next stage of our customization process.

    Displaying the Rollup Field Data for Contacts

    There are two main places where fields are presented in Dynamics CRM: forms and views. Let’s start from the contact form and include our new rollup fields there. In my scenario, we already have a suitable custom form available for the contact entity, which has been used for summarizing all the ClickDimensions data related to an individual contact record. Notice those fancy embedded charts and subgrids showing the email events for this test contact record of mine? That’s actually something you’ve been able to do already since the CRM 2011 version, so not exactly related to our agenda of the day, but a good reminder about how you can leverage the XRM capabilities of the Dynamics CRM platform to present data in a format that’s easier for end users to consume. (Check out my 10 tips for better CRM user experience for more discussion on that topic.)

    CRM_2015_rollup_field_Clicks_4

    I’ve added the Latest Clicks and Total Clicks on the contact form, below the existing chart and subgrid. But wait a minute: why are they empty? Did we do a mistake in the rollup field definitions? Don’t worry, this is exactly the expected result after creating a rollup field. If you took a moment to read that yellow notification bar I mentioned earlier, you’ll know that a mass calculation job was created by the CRM system after you added the rollup fields for the contact entity. Also, since it was by default scheduled to be run 12 hours after the field creation, we’re not going to see the whole magic until the next day in many cases.

    If you’d rather validate that the new customizations you’ve created are working as planned, instead of just taking my word for it, open up a contact record form and hover over the rollup field. You’ll see a “recycle” icon that you can click on, after which CRM will perform the rollup calculation for that field, for only the currently selected record. (more…)

  • Advanced Queries with Advanced Find

    Advanced Queries with Advanced Find

    Dynamics_CRM_Advanced_FindOne of the more powerful features of Microsoft Dynamics CRM has to be the Advanced Find tool. What may initially seem like an intimidating maze of menus to a new Dynamics CRM user unfamiliar with the underlying data model, Advanced Find may quickly turn into an invaluable tool for anyone who needs to be able to retrieve specific sets of data from CRM, be it for marketing campaign target groups, ad-hoc data analysis or simply streamlining the usage of the system with saved views for surfacing frequently needed information from the database.

    Here are a couple of examples that show you how Advanced Find can go beyond the typical queries and deliver results that you might have not initially thought of being possible with the tool.

    Referencing the Current User

    Suppose you have a Business Unit structure set up in Dynamics CRM to reflect organizational units where the users generally work together on the same accounts. However, you’ve not restricted their visibility to records from other BU’s, so their view of all active accounts displays the complete contents of the database in a long list. While the users can easily filter their own records by using the My Accounts view, you’d like to offer them an option to see just the accounts owned by any user from their own Business Unit.

    Sure, you could create a long list of system views that are dedicated to a particular business unit (“Accounts from Finland”, “Accounts from Sweden”, “Accounts from Cayman Islands” etc.). The problem with this approach, apart from the number of view variations you need to create and present in the view list, is that it’s not dynamic by nature. Since you can’t centrally set different default views for different user groups in Dynamics CRM, all the users would have to know how to navigate to the “View” tab and click on the “Set As Default View” button to select the view specific to their business unit.

    Instead of all that manual labor, why don’t we build a query criteria with Advanced Find that says “show all accounts where the related owner is in a business unit that has a user that is me. Yes, it’s not exactly the way you would formulate the sentence when communicating with human beings, but this is the language that works with Advanced Find. If you don’t believe me, just try the query below for yourself:

    Advanced_Find_Acocunts_from_My_Business_Unit

    How about if you’re using Teams and would like to create a “my team’s records” type of a view? No problem, you can use the exact same method as with Business Units. Just reference the Team record under the Owning User entity and then add the same “user equals current user” criteria under the related user entity.

    In fact, since starting from CRM 2011 all business units also have a default team where the BU’s users are automatically added to as members, the team approach actually covers both the “my business unit” and “my team” scenarios. If, on the other hand, you’d like to only reference custom teams and not BU teams, include a criteria for the team records that says “Is Default equals No” to exclude the default business unit teams from your view results.

    Ok, so we get the results we were after, but what is the underlying logic that makes this query work? What we are doing in the Advanced Find query criteria definition in the above examples is referencing the relationships through this type of a pattern:

    Advanced_Find_Current_User_Relationships

    The key takeaway here is that there’s no need to limit your queries to only traditional one-to-many (1:N) type of hierarchies. In this example you start from the N side, then go through a “1” and spread out back into the N. Due to the flexible nature of the Advanced Find query designer in presenting all the available relationships, we are free to explore multiple different types of connections between the same entity in a single query. We pass through the user entity more than once but approach it from different relationships in order to define the final filter for the query.

    Multiple Conditions for Related Child Record

    Taking the exploration further, here’s a query method that may seem even less intuitive but is actually a more common requirement than the team/BU membership example. Sometimes you need to search for parent records that have two or more specific child records underneath them, meaning that the single query will have to find several different matches from the child records in order to qualify the parent record into the query results. Examples of such a scenario could be:

    • Accounts that have child contacts with the roles Decision Maker and Influencer
    • Customers who have bought both product A and B
    • Contacts that have attended events in the years 2011, 2012 and 2013
    • Orders that included line items for both Sales Inventory and Services

    When building such queries the problem you may face is that the results include parent record that meet any single criteria, when what you’re interested in is only the records that meet all the different conditions. Taking the last example of searching for line items of several different product types and using the Opportunity and Opportunity Product entities, if we’re including the Sales Inventory and Services values into a single condition for the Product Type field, any opportunity that has either Sales Inventory or Service products will be retrieved. (more…)

  • Getting back at blog content thieves

    Blogs are not only a valuable information source, they are also incredibly efficient vehicles for performing content marketing to promote a company or its products. In the line of professional services, many organizations want to use blog content created by experts in their own organization to prove to their potential customers that they are a viable business partner.

    Unfortunately there are also companies who don’t possess the required expertise or haven’t assigned proper resources for content creation, but they still wish to drive traffic to their website through articles that contain keywords they expect potential customers to be searching for. As the web is already full of content, why not just grab a suitable piece of it and post it in your own name? Sure, it’s unethical and mostly illegal, but what’s the risk of getting caught on the wild wild west of the Internet?

    Microsoft Dynamics CRM community has tons of great experts that choose to share their knowledge with others without asking for any direct monetary compensation for it. Lurking inside this community (or perhaps rather outside at the gates of the community) is a small number of players who are willing to take advantage of all this free content and use it to fill up their own blogs with direct copies of the original posts. Typically the only difference is the lack of reference to the original author of the content, because it wouldn’t look very smart if someone finds out you haven’t actually added any value in the copy-paste process. It’s not content sharing like posting links to articles by others, it is content theft with a very clear intention of benefiting from the works of others.

    This week I ran into two cases where the posts from my Surviving CRM blog had been posted on another blog, word by word, without my permission. The first one was a blog by an individual, who apparently was trying to build up his profile as a Dynamics CRM expert. The second one, however, was a Microsoft Dynamics CRM consulting company that’s a listed partner on Microsoft’s Pinpoint service (I won’t post the name of the company, but this is their profile). Looking at their Blogger profile, it was apparent that this company was misusing blogs and stolen content from also many other sources in an effort to gain traffic for their own website.

    I spotted that the company in question had hotlinked the article images from my web server, instead of re-posting them on Blogger. That’s of course the easiest way for them to steal content, but it also opened up an opportunity for me to teach them a lesson. See the slide deck below for the results of the little trick I played on them. If you’re interested in viewing the actual page and seeing if the modified images are still there, just open my original article about subgrids and associated views in CRM 2011, copy a sentence from it and paste it into Google to find the unauthorized copy of my article hosted on the company’s blog (tip: it’s the Blogger blog with a dynamics-crm2011 prefix in the URL, the article’s posted in September 2011).

    Despite of me getting to have some fun at the expense of the content thief, it is of course a very sad thing to see such practices being utilized in selling services for Microsoft Dynamics CRM. Out of all people, it’s CRM consultants who should understand the importance of building long term business relationships on trust, not short term money grabs from gaming the search engines with keywords to lure in customers. In this light, who in their right mind would consider ripping off content from others as a viable tactic to be used for selling services related to customer relationship management?

    The unfortunate fact is that there are many people who work with CRM solutions purely from a technical perspective, without understanding the business problems that these solutions are meant to solve. For a customer looking for experts to guide them through the process of deploying Microsoft Dynamics CRM in their organization, it’s not easy to spot the bad apples and choose the right partner. So many professional organizations working with the Dynamics CRM product still today do not bring out their expertise online but rather just settle for having a brochure website with generic, static content about their products and services. This leaves the door open for unethical marketers to flood the net with their blogs and steal the top spots on search listings. It’s not something we can blame Google for; their tactics work because we allow them to work.

    To quote myself (or rather the updated blog post image):

    So, as a conclusion, when you’re looking for Dynamics CRM professionals to help you implement & develop your CRM system, do some background checks first. It’s all too easy to steal content from others and build up a web presence to lure in potential customers. Online content is easy to generate, building a reputation requires hard work. Some of us choose to skip that ”hard work” part.

    Have you encountered content theft on Dynamics CRM blogs you’ve written, or consulting companies that take advantage of stolen content? Any thoughts or ideas on how the Dynamics CRM community could weed out this unwanted behavior?

  • Convergence 2012 in a (virtual) nutshell

    Full disclosure: I didn’t actually physically attend Microsoft Convergence 2012 in Houston, Texas. However, that doesn’t mean you have to feel left in the dark, thanks to the immersive experience that is the social web of our times. With live webcasts, near-live blogging and some 6000 tweets on the #CONV12 hashtag, keeping up with the online buzz has never been easier. Here’s my summary of what the event looked like through the eyes of a virtual attendee and some thoughts on where Microsoft and its Dynamics product line appear to be heading based on the announcements at Convergence.

    Microsoft Convergence 2012 keynote summary on StorifyKeynote

    The opening keynote is where the stage is set for the rest of the event, so watching the live broadcast on Monday was definitely on my agenda. Sure, it’s all about building up hype for your products by telling how great you’ve done so far, how excited you are about your future roadmap and showing off with future concept demos that have little to do with the current reality. So what! You need a little show business alongside your business applications conference.

    Having the luxury of my PC keyboard & mouse at my disposal during the event allowed me to experiment with Storify, a social media storytelling tool. I captured the best tweets, photos and screenshots during the keynote and compiled them into my Convergence 2012 story. If you’re anything like me, the mental barrier for sitting down and watching a recorded conference event for 1.5 hours is quite high, so why not glance through the highlights of the show on the Storify summary? After that, you can decide if you want to read the full transcript or watch the recording on the Virtual Convergence site.

    Some notes picked up from the opening keynote included:

    • The Dynamics CRM momentum now stands at 2,250,000 users in 33,000 customer organizations.
    • “There are no happy Siebel customers in the world, there just aren’t.” – COO Kevin Turner on Microsofts internal journey from Siebel to Dynamics CRM.
    • Nearly half of the deals won by Microsoft over Salesforce.com have been due to the on-premises option and the hybrid model.

    Metro

    It’s Windows reimagined time all across Redmond now as we’re nearing the launch of Windows 8 later this year. This means everything that can be shown as a Metro style app running on a tablet, will be shown precisely that way. The fictional Contoso Electronics scenario of the big keynote demo used a highly customized UI built for the retail store experience only. A much more interesting demo was the project management Metro app that looked so realistic you could imagine it becoming an actual UI to some future Microsoft product to be rolled out at Windows 8 launch.

    We didn’t get any official screenshots of a Dynamics CRM Metro app yet, but luckily Garth Knutson was able to snap & tweet this picture of a UI concept presented in one of the sessions. Just imagine if assigning users onto a Dynamics CRM opportunity record would look like this, how much higher would the user adoption of a CRM system be among sales people? Ah, CRM reimagined…

    Microsoft Dynamics CRM and Metro UI

    But the road to metro is paved with Apples. The actual tablet product Microsoft had to show at Convergence was the Dynamics CRM Mobile client for iPad, which meant that Apple devices were well presented in many of the Convergence sessions. Funnily enough, during the conference an internal email leak revealed that Microsoft was banning the use of company budget to buy any Apple products for its Sales, Marketing, Services, IT, & Operations Group. Oh well, guess we won’t be seeing many iPads on stage anymore in the following events. For those of you who haven’t seen the current client yet (developed by CWR Mobility), see my previous post on Microsoft Dynamics CRM Mobile iPad screenshots.

    Microsoft Dynamics Metro app running on a Windows 8 tabletAn important aspect to note is that the move towards Metro apps and tablet devices does also have an impact on traditional desktop usage of Dynamics CRM. Back in November I speculated that the legacy of Outlook could not be carried over to the world of Windows 8 tablets in its existing form. Since then this assumption has only been enforced by the announcement of Windows on ARM (WOA) tablets with no classic Windows application support and no sign of Outlook in the list of Office apps promised for these “iPad killers”. What this means is that the functionality exclusive to Dynamics CRM Outlook client must be moved to the cloud. At Convergence, the following functionality was more or less revealed to be included in the R9 release later this year:

    • Direct synchronization of activities through Exchange (instead of Outlook)
    • Support for “track in CRM” functionality in Outlook Web Access (OWA client)

    Woo-hoo! It’s been a long time coming, but to me this is a clear sign that Dynamics CRM is definitely on the right track in terms of becoming more compatible with the habits of today’s mobile workforce; how they manage their activities and messages on multiple clients, not just the single Outlook on their work laptop. Making the CRM features available through new channels, such as the Office 15 Agaves, is very important for making Dynamics CRM a relevant tool for knowledge sharing as the applications and devices surrounding it are evolving.

    (more…)