{"id":4041,"date":"2023-08-10T12:35:09","date_gmt":"2023-08-10T12:35:09","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/?p=4041"},"modified":"2023-09-12T12:37:01","modified_gmt":"2023-09-12T12:37:01","slug":"create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\/","title":{"rendered":"Create Dynamic Email Dashboards with ReportWORQ: Personalized Financial Reporting Across 50 States without Attachments"},"content":{"rendered":"<p><script src=\"https:\/\/fast.wistia.com\/embed\/medias\/txf5jknb6b.jsonp\" async><\/script><script src=\"https:\/\/fast.wistia.com\/assets\/external\/E-v1.js\" async><\/script><\/p>\n<div class=\"wistia_responsive_padding\" style=\"padding: 56.25% 0 0 0; position: relative;\">\n<div class=\"wistia_responsive_wrapper\" style=\"height: 100%; left: 0; position: absolute; top: 0; width: 100%;\">\n<div class=\"wistia_embed wistia_async_txf5jknb6b seo=true videoFoam=true\" style=\"height: 100%; position: relative; width: 100%;\">\n<div class=\"wistia_swatch\" style=\"height: 100%; left: 0; opacity: 0; overflow: hidden; position: absolute; top: 0; transition: opacity 200ms; width: 100%;\"><img decoding=\"async\" style=\"filter: blur(5px); height: 100%; object-fit: contain; width: 100%;\" src=\"https:\/\/fast.wistia.com\/embed\/medias\/txf5jknb6b\/swatch\" alt=\"\" aria-hidden=\"true\" \/><\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>ReportWORQ\u2019s rich and dynamic email dashboards help Finance drive data adoption by enabling business users with clear and timely data, while also helping IT improve the security and availability of sensitive data.<\/p>\n<p>Watch as we demonstrate how to use ReportWORQ variables to generate personalized email dashboards, complete with conditional formatting, snippets from reports, and visuals. Our task is to generates reports for 50 states across 6 regions, sending personalized email dashboards while also securely storing copies of reports in a logical folder structure by year, month, and region.<\/p>\n<p>Using an Excel profit and loss statement as a template, we&#8217;ll save PDF files to our secure network folder. Due to company policy, we won&#8217;t send attachments but create an impressive dashboard in the email body.<\/p>\n<p>Key information in the email includes:<\/p>\n<ul>\n<li>Revenue section from the financial statement.<\/li>\n<li>5 lines of commentary with conditional formatting indicating financial position changes (red for worse, green for improved).<\/li>\n<li>2 charts as visuals.<\/li>\n<\/ul>\n<p>Learn how to dynamically construct folder paths using ReportWORQ variables and data sourced from Excel calculation. Watch as we create a professional an email dashboard that delivers critical financial information without attachments, impressing your users.<\/p>\n<p>ReportWORQ is designed for finance teams, automating the process and providing fast, reliable results. Try ReportWORQ today to deliver compelling financial reports directly in Email, SharePoint, Google Drive, or Microsoft Teams. Visit reportworq.com now for a trial!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>ReportWORQ\u2019s rich and dynamic email dashboards help Finance drive data adoption by enabling business users with clear and timely data, while also helping IT improve the security and availability of sensitive data. Watch as we demonstrate how to use ReportWORQ variables to generate personalized email dashboards, complete with conditional formatting, snippets from reports, and visuals.&hellip;<\/p>\n","protected":false},"author":5,"featured_media":4099,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[27],"tags":[90,29,91],"class_list":["post-4041","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-quebit-value","tag-quebit-value-reportworq","tag-reportworq","tag-reportworq-variables"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Create Dynamic Email Dashboards with ReportWORQ: Personalized Financial Reporting Across 50 States without Attachments - QueBIT<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/quebit.com\/askquebit\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create Dynamic Email Dashboards with ReportWORQ: Personalized Financial Reporting Across 50 States without Attachments - QueBIT\" \/>\n<meta property=\"og:description\" content=\"ReportWORQ\u2019s rich and dynamic email dashboards help Finance drive data adoption by enabling business users with clear and timely data, while also helping IT improve the security and availability of sensitive data. Watch as we demonstrate how to use ReportWORQ variables to generate personalized email dashboards, complete with conditional formatting, snippets from reports, and visuals.&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-10T12:35:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-09-12T12:37:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2023\/08\/Personalize-Financial-Reports.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"523\" \/>\n\t<meta property=\"og:image:height\" content=\"296\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jennifer Field\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jennifer Field\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\\\/\"},\"author\":{\"name\":\"Jennifer Field\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/082a9c4156466b9cdad2632e3de62601\"},\"headline\":\"Create Dynamic Email Dashboards with ReportWORQ: Personalized Financial Reporting Across 50 States without Attachments\",\"datePublished\":\"2023-08-10T12:35:09+00:00\",\"dateModified\":\"2023-09-12T12:37:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\\\/\"},\"wordCount\":242,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/Personalize-Financial-Reports.jpg\",\"keywords\":[\"QueBIT Value ReportWORQ\",\"ReportWORQ\",\"ReportWORQ Variables\"],\"articleSection\":[\"QueBIT Value\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\\\/\",\"name\":\"Create Dynamic Email Dashboards with ReportWORQ: Personalized Financial Reporting Across 50 States without Attachments - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/Personalize-Financial-Reports.jpg\",\"datePublished\":\"2023-08-10T12:35:09+00:00\",\"dateModified\":\"2023-09-12T12:37:01+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/082a9c4156466b9cdad2632e3de62601\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/Personalize-Financial-Reports.jpg\",\"contentUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/Personalize-Financial-Reports.jpg\",\"width\":523,\"height\":296},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Create Dynamic Email Dashboards with ReportWORQ: Personalized Financial Reporting Across 50 States without Attachments\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\",\"name\":\"QueBIT\",\"description\":\"QueBIT\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/082a9c4156466b9cdad2632e3de62601\",\"name\":\"Jennifer Field\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g\",\"caption\":\"Jennifer Field\"},\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/author\\\/quebit\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Create Dynamic Email Dashboards with ReportWORQ: Personalized Financial Reporting Across 50 States without Attachments - QueBIT","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/quebit.com\/askquebit\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\/","og_locale":"en_US","og_type":"article","og_title":"Create Dynamic Email Dashboards with ReportWORQ: Personalized Financial Reporting Across 50 States without Attachments - QueBIT","og_description":"ReportWORQ\u2019s rich and dynamic email dashboards help Finance drive data adoption by enabling business users with clear and timely data, while also helping IT improve the security and availability of sensitive data. Watch as we demonstrate how to use ReportWORQ variables to generate personalized email dashboards, complete with conditional formatting, snippets from reports, and visuals.&hellip;","og_url":"https:\/\/quebit.com\/askquebit\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\/","og_site_name":"QueBIT","article_published_time":"2023-08-10T12:35:09+00:00","article_modified_time":"2023-09-12T12:37:01+00:00","og_image":[{"width":523,"height":296,"url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2023\/08\/Personalize-Financial-Reports.jpg","type":"image\/jpeg"}],"author":"Jennifer Field","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jennifer Field","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\/"},"author":{"name":"Jennifer Field","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/082a9c4156466b9cdad2632e3de62601"},"headline":"Create Dynamic Email Dashboards with ReportWORQ: Personalized Financial Reporting Across 50 States without Attachments","datePublished":"2023-08-10T12:35:09+00:00","dateModified":"2023-09-12T12:37:01+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\/"},"wordCount":242,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2023\/08\/Personalize-Financial-Reports.jpg","keywords":["QueBIT Value ReportWORQ","ReportWORQ","ReportWORQ Variables"],"articleSection":["QueBIT Value"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\/","url":"https:\/\/quebit.com\/askquebit\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\/","name":"Create Dynamic Email Dashboards with ReportWORQ: Personalized Financial Reporting Across 50 States without Attachments - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2023\/08\/Personalize-Financial-Reports.jpg","datePublished":"2023-08-10T12:35:09+00:00","dateModified":"2023-09-12T12:37:01+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/082a9c4156466b9cdad2632e3de62601"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2023\/08\/Personalize-Financial-Reports.jpg","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2023\/08\/Personalize-Financial-Reports.jpg","width":523,"height":296},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/create-dynamic-email-dashboards-with-reportworq-personalized-financial-reporting-across-50-states-without-attachments\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"Create Dynamic Email Dashboards with ReportWORQ: Personalized Financial Reporting Across 50 States without Attachments"}]},{"@type":"WebSite","@id":"https:\/\/quebit.com\/askquebit\/#website","url":"https:\/\/quebit.com\/askquebit\/","name":"QueBIT","description":"QueBIT","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/quebit.com\/askquebit\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/082a9c4156466b9cdad2632e3de62601","name":"Jennifer Field","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g","caption":"Jennifer Field"},"url":"https:\/\/quebit.com\/askquebit\/author\/quebit\/"}]}},"_links":{"self":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/4041","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/comments?post=4041"}],"version-history":[{"count":1,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/4041\/revisions"}],"predecessor-version":[{"id":4042,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/4041\/revisions\/4042"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media\/4099"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=4041"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=4041"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=4041"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}