{"id":271,"date":"2022-01-12T15:05:20","date_gmt":"2022-01-12T15:05:20","guid":{"rendered":"https:\/\/blog.citrus-lime.com\/crmc\/?p=271"},"modified":"2022-01-12T15:05:21","modified_gmt":"2022-01-12T15:05:21","slug":"dynamics-365-marketing-reports-in-microsoft-teams","status":"publish","type":"post","link":"https:\/\/blog.citrus-lime.com\/crmc\/dynamics-365-marketing-reports-in-microsoft-teams\/","title":{"rendered":"Dynamics 365 Marketing Reports in Microsoft Teams"},"content":{"rendered":"\n

At CRMCS, we are big fans of using Microsoft Teams to pull all our Collaboration into one place.<\/p>\n\n\n\n

When we look at Dynamics 365 Marketing, we can implement a powerful level of Reporting by combining Power BI with the Marketing App<\/a>.<\/p>\n\n\n\n

Earlier articles on this blog look at how this is done with Azure Storage and then Power BI.<\/p>\n\n\n\n

  1. Establish a link to pull our Marketing Interaction Data from Dynamics 365 Marketing to Azure Storage<\/a><\/li>
  2. Connect Power BI to CRM and the Marketing Interaction Data using one of the standard Templates<\/a><\/li><\/ol>\n\n\n\n

    Once our Marketing Reports are ready, we can publish them so they are available to be shared within our Organisation using Power BI:<\/p>\n\n\n\n

    \"image\"<\/a><\/figure>\n\n\n\n

    But if I am using Teams as my common collaboration point, then really I want to get these reports and make them available there.<\/p>\n\n\n\n

    Fortunately we can do this pretty easily as Teams comes with an App to connect Power BI into one of our Channels \u2013 and this article will give a walk through of how this is done:<\/p>\n\n\n\n

    First, we browse to our Channel in Teams and click to Add a New Tab, and within the options, we can pick a new Power BI Tab.<\/p>\n\n\n\n

    \"image\"<\/a><\/figure>\n\n\n\n

    This will then give us options to pick which Power BI Report we want to mount via this Tab in Teams.<\/p>\n\n\n\n

    \"image\"<\/a><\/figure>\n\n\n\n

    We can then view our Report or Dashboard directly within Microsoft Teams as another Tab in our Channel bringing that particular Workspace together:<\/p>\n\n\n\n

    \"image\"<\/a><\/figure>\n\n\n\n

    Power BI Report for Dynamics 365 Marketing within Microsoft Teams<\/em><\/strong><\/p>\n\n\n\n

    At heart this is the same Dashboard as we could see in \u2018normal\u2019 Power BI \u2013 but the power of Teams is that this now sits alongside the other Tabs where we surface Dynamics 365, SharePoint and Task Notifications.<\/p>\n\n\n\n

    This gives us a true \u2018one-stop-shop\u2019 for the data relevant to that Team.<\/p>\n\n\n\n

    Our Team Members don\u2019t need to waste time jumping from Dynamics to Power BI as separate Apps, they can instead simply refer to the Tabs we have configured in this Channel.<\/p>\n\n\n\n

    \"image\"<\/a><\/figure>\n\n\n\n

    Our Power BI Dashboard is one click away from the Record in Dynamics 365 that the Dashboard relates to<\/em><\/strong><\/p>\n\n\n\n

    This can be great for building a joined up Marketing Team that can have a Channel in Teams for each major Customer Journey \u2013 and then configure Teams to work by:<\/p>\n\n\n\n

    • New Microsoft Teams Channel <\/strong>for each Customer Journey in D4M (potentially automatically integrated by DocDrive365 to keep things in synch)<\/li>
    • Dynamics 365 Tab<\/strong> in the Channel for easy access to the Customer Journey Record in D4M<\/li>
    • Power BI Tab<\/strong> to report on the performance of the Marketing Activities in the Customer Journey<\/li>
    • SharePoint Tab or Tabs<\/strong> to track Marketing Literature relevant to this Customer Journey<\/li>
    • Posts and Chat<\/strong> for members of the Marketing Team to exchange Communications, Calls and Tasks<\/li><\/ul>\n\n\n\n

      This builds an integrated Marketing approach where the Team can collaborate to the common goal of delivering the best possible Customer Journey \u2013 and so improve our performance as a Marketing Team by the clever application of technology using the Microsoft Cloud.<\/p>\n\n\n\n

      The combination of Dynamics, Power BI and Teams has massive potential for many organisations, particularly in summarising larger volumes of Marketing Data into a meaningful report and then making this report available through a common platform such as Teams.<\/p>\n\n\n\n

      This joined up approach can then solve common problems for Marketeers in connecting their activity to the outcomes and so to resulting performance.<\/p>\n\n\n\n

      This can bring several benefits to our Marketing:<\/p>\n\n\n\n

      • Provide a Feedback Loop so we can act, learn from the results and then improve \u2013 and so avoid simply repeating the same activity and achieving the same results.<\/li>
      • Avoid \u2018fire and forget\u2019 marketing where we cannot correctly calculate our Return on Investment from our Activity.<\/li>
      • Demonstrate the usefulness of the Marketing function in the business \u2013 and how this connects to new Prospects and Sales within CRM. (particularly in lean times when marketing spend may come under increasing scrutiny)<\/li><\/ul>\n\n\n\n

        So whilst we are using several pieces of technology here (Dynamics + Teams + Power BI), these can be easily brought together in the cloud to produce a single unified solution that connects Marketing to the other divisions within an organisation \u2013 and this can strengthen our organisational effectiveness.<\/p>\n","protected":false},"excerpt":{"rendered":"

        At CRMCS, we are big fans of using Microsoft Teams to pull all our Collaboration into one place. When we look at Dynamics 365 Marketing, we can implement a powerful level of Reporting by combining Power BI with the Marketing App. Earlier articles on this blog look at how this is done with Azure Storage and<\/p>\n","protected":false},"author":43,"featured_media":29,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_price":"","_stock":"","_tribe_ticket_header":"","_tribe_default_ticket_provider":"","_tribe_ticket_capacity":"0","_ticket_start_date":"","_ticket_end_date":"","_tribe_ticket_show_description":"","_tribe_ticket_show_not_going":false,"_tribe_ticket_use_global_stock":"","_tribe_ticket_global_stock_level":"","_global_stock_mode":"","_global_stock_cap":"","_tribe_rsvp_for_event":"","_tribe_ticket_going_count":"","_tribe_ticket_not_going_count":"","_tribe_tickets_list":"[]","_tribe_ticket_has_attendee_info_fields":false,"footnotes":""},"categories":[3,4,5],"tags":[],"class_list":{"0":"post-271","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-crm","8":"category-docdrive365","9":"category-marketing"},"featured_image_src":"https:\/\/blog.citrus-lime.com\/crmc\/wp-content\/uploads\/sites\/30\/2021\/11\/Dynamics-365-Marketing-scaled.jpg","author_info":{"display_name":"jadesmith","author_link":"https:\/\/blog.citrus-lime.com\/crmc\/author\/jadesmith\/"},"_links":{"self":[{"href":"https:\/\/blog.citrus-lime.com\/crmc\/wp-json\/wp\/v2\/posts\/271","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.citrus-lime.com\/crmc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.citrus-lime.com\/crmc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.citrus-lime.com\/crmc\/wp-json\/wp\/v2\/users\/43"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.citrus-lime.com\/crmc\/wp-json\/wp\/v2\/comments?post=271"}],"version-history":[{"count":1,"href":"https:\/\/blog.citrus-lime.com\/crmc\/wp-json\/wp\/v2\/posts\/271\/revisions"}],"predecessor-version":[{"id":272,"href":"https:\/\/blog.citrus-lime.com\/crmc\/wp-json\/wp\/v2\/posts\/271\/revisions\/272"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.citrus-lime.com\/crmc\/wp-json\/wp\/v2\/media\/29"}],"wp:attachment":[{"href":"https:\/\/blog.citrus-lime.com\/crmc\/wp-json\/wp\/v2\/media?parent=271"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.citrus-lime.com\/crmc\/wp-json\/wp\/v2\/categories?post=271"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.citrus-lime.com\/crmc\/wp-json\/wp\/v2\/tags?post=271"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}