{"id":752,"date":"2017-05-25T06:30:11","date_gmt":"2017-05-25T06:30:11","guid":{"rendered":"https:\/\/www.sidekicksolutionsllc.com\/etapestry\/?p=752"},"modified":"2019-04-10T16:46:34","modified_gmt":"2019-04-10T16:46:34","slug":"annual-etapestry-database-review-why-and-how-to-do-one","status":"publish","type":"post","link":"https:\/\/www.sidekicksolutionsllc.com\/etapestry\/blog\/annual-etapestry-database-review-why-and-how-to-do-one","title":{"rendered":"Annual eTapestry Database Review: Why and How to Do One"},"content":{"rendered":"<p>A lot can happen in a year: you may implement new development initiatives, abandon old fundraising strategies, set new goals, and experience staff transitions or role changes.<\/p>\n<p>As your organization evolves, it is important for your Blackbaud\u00ae eTapestry\u00ae database to evolve too. The best way to keep your eTapestry database current as your organization evolves is to complete an annual database review.<!--more--><\/p>\n<p>An eTapestry database review gives you and your team an opportunity to step back, lift your heads from the daily grind of data entry and database management, and look at eTapestry from a global perspective.<\/p>\n<p>Complete an annual database review to:<\/p>\n<ul>\n<li>Identify updates that will keep eTapestry effective<\/li>\n<li>Evaluate weaknesses and inefficiencies in existing processes<\/li>\n<li>Assess parallel systems and whether they can be consolidated or integrated<\/li>\n<li>Estimate next year&#8217;s spending on eTapestry (license, training, and updates)<\/li>\n<\/ul>\n<p>For the best results, complete an annual database review with an open mind. Keep biases about cost, effort to implement, and any other barriers out of the discussion. Uncover the truth about your eTapestry database and then evaluate whether the solutions you\u2019ve identified are practical.<\/p>\n<p>Here are a few high-level questions to ask during an annual database review.<br \/>\n<div class=\"list-dropdown \"><ul class=\"list-dropdown-ul\"><li>\r\n          <h4><span class=\"drop-btn\"><\/span><span>1.<\/span> What systems will be required to ensure the success of our upcoming fundraising strategies?<\/h4> \r\n          <div class=\"content custom-content\"><p>A lot can happen in a year: you may implement new development initiatives, abandon old fundraising strategies, set new goals, and experience staff transitions or role changes.<\/p>\n<p>As your organization evolves, it is important for your Blackbaud\u00ae eTapestry\u00ae database to evolve too. The best way to keep your eTapestry database current as your organization evolves is to complete an annual database review.<!--more--><\/p>\n<p>An eTapestry database review gives you and your team an opportunity to step back, lift your heads from the daily grind of data entry and database management, and look at eTapestry from a global perspective.<\/p>\n<p>Complete an annual database review to:<\/p>\n<ul>\n<li>Identify updates that will keep eTapestry effective<\/li>\n<li>Evaluate weaknesses and inefficiencies in existing processes<\/li>\n<li>Assess parallel systems and whether they can be consolidated or integrated<\/li>\n<li>Estimate next year&#8217;s spending on eTapestry (license, training, and updates)<\/li>\n<\/ul>\n<p>For the best results, complete an annual database review with an open mind. Keep biases about cost, effort to implement, and any other barriers out of the discussion. Uncover the truth about your eTapestry database and then evaluate whether the solutions you\u2019ve identified are practical.<\/p>\n<p>Here are a few high-level questions to ask during an annual database review.<\/p>\n\r\n          <\/div>\r\n        <\/li><br \/>\n<li>\r\n          <h4><span class=\"drop-btn\"><\/span><span>2.<\/span> What are the top three to five eTapestry tasks that take the most time?<\/h4> \r\n          <div class=\"content custom-content\"><p>Of all the questions you should ask on an annual basis, this may be the most important. What areas of eTapestry require the most time, cause the most stress, or keep you from more important fundraising and development tasks? Your response to this question will offer a prioritized list of improvements that if addressed will make the biggest impact on your organization.<\/p>\n\r\n          <\/div>\r\n        <\/li><li>\r\n          <h4><span class=\"drop-btn\"><\/span><span>3.<\/span> What reports are we missing?<\/h4> \r\n          <div class=\"content custom-content\"><p> Fundraising is an analytical discipline as much as it is a relationship and engagement practice. Data can help you to identify valuable donor prospects, uncover untapped fundraising potential, and pinpoint the most effective strategies for fund development.<\/p>\n<p>Something is wrong if you spend hours of time generating reports or if you can&#8217;t get the reports you need at all. If queries and reports aren&#8217;t strengths for you now, this is an area to address during your annual database review.\u00a0Cutting hours of time on reporting could mean getting weeks (yes, weeks!) of time back in the coming year.<\/p>\n\r\n          <\/div>\r\n        <\/li><br \/>\n<li>\r\n          <h4><span class=\"drop-btn\"><\/span><span>4.<\/span> What are our primary data quality and data accuracy concerns?<\/h4> \r\n          <div class=\"content custom-content\"><p>Are you spending hours cleaning up reports once you\u2019ve exported them from eTapestry? Is the data in your database messy or inaccurate? If yes, you may need to invest in cleaning up your historical data and ensuring any new data doesn\u2019t contribute to bad data quality.<\/p>\n<p>Staff turnover, inconsistent procedures, lack of training, faulty imports, and a variety of other causes contribute to poor data quality. Data quality challenges should not go unaddressed because the longer they persist the more pervasive they become in your system.<\/p>\n<p><strong>At Sidekick Solutions, we complete annual cleanups of our data systems.<\/strong> We encourage you to do the same.<\/p>\n\r\n          <\/div>\r\n        <\/li><br \/>\n<li>\r\n          <h4><span class=\"drop-btn\"><\/span><span>5.<\/span> What data do we currently track in spreadsheets that could be tracked in eTapestry?<\/h4> \r\n          <div class=\"content custom-content\"><p>Prospects? Volunteers? Planned gifts? Grants? Events? <a href=\"\/etapestry\/blog\/11-etapestry-user-defined-field-applications\" rel=\"noopener\">That data can be tracked in eTapestry.<\/a><\/p>\n<p>Most data sets can be tracked in eTapestry. If you rely on spreadsheets to track the functions listed above, take a look at tracking them in eTapestry. At a minimum, identify the systems you use outside of eTapestry and assess whether they are a positive or negative for you.<\/p>\n\r\n          <\/div>\r\n        <\/li><br \/>\n<li>\r\n          <h4><span class=\"drop-btn\"><\/span><span>6.<\/span> What other systems do we use that could be integrated with eTapestry?<\/h4> \r\n          <div class=\"content custom-content\"><p>Software is getting easier to use and more capable. This includes eTapestry. Automation can save time and streamline daily tasks. Sometimes automation requires integration (the &#8220;auto-magical&#8221; kind) and sometimes it requires <a href=\"\/etapestry\/blog\/how-to-use-exports-and-imports-for-etapestry-integrations\" rel=\"noopener\">design of simple \u201cpeople-based\u201d systems<\/a>\u00a0(like imports and exports). In either case, the goal of automation is to cut wasteful steps and streamline burdensome processes.<\/p>\n<p>It isn\u2019t normal or expected for you to struggle needlessly with eTapestry or any of your software tools. Automation, integration, and system simplification are all features of a well-oiled eTapestry database.<\/p>\n\r\n          <\/div>\r\n        <\/li><\/ul><\/div><br \/>\n<span class=\"color-blue font-size-24\">Evolving your eTapestry database<\/span><\/p>\n<p>Your eTapestry software system is a dynamic tool and should evolve with your organization, but eTapestry must be a priority. An annual database review may seem like it will take time that you don&#8217;t have, but a review doesn&#8217;t need to be an overly involved process. If you&#8217;re crunched on time and want to make eTapestry a priority, start by asking some simple questions like those outlined in this post. A little bit of thought spent on how eTapestry fits in your organization will go a long way toward sustaining it long term.<\/p>\n<p><strong>Looking for an assessment template?<\/strong> Check out our eTapestry self-assessment guide and worksheet. It has everything you&#8217;ll need to review eTapestry and define an action plan for next steps. <a href=\"\/etapestry\/the-essential-kit-to-etapestry-software-best-practices\" rel=\"noopener\">Click here to get your free copy.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A lot can happen in a year: you may implement new development initiatives, abandon old fundraising strategies, set new goals, and experience staff transitions or role changes. As your organization evolves, it is important for your Blackbaud\u00ae eTapestry\u00ae database to evolve too. The best way to keep your eTapestry database current as your organization evolves [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":935,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,7],"tags":[],"class_list":["post-752","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-best-practices","category-database-admin"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v14.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Annual eTapestry Database Review: Why and How to Do One<\/title>\n<meta name=\"description\" content=\"Continue to get the most from your Blackbaud eTapestry database year after year. Answer these questions to identify improvements and enhancements.\" \/>\n<meta name=\"robots\" content=\"index, follow\" \/>\n<meta name=\"googlebot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta name=\"bingbot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sidekicksolutionsllc.com\/etapestry\/blog\/annual-etapestry-database-review-why-and-how-to-do-one\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Annual eTapestry Database Review: Why and How to Do One\" \/>\n<meta property=\"og:description\" content=\"Continue to get the most from your Blackbaud eTapestry database year after year. Answer these questions to identify improvements and enhancements.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sidekicksolutionsllc.com\/etapestry\/blog\/annual-etapestry-database-review-why-and-how-to-do-one\" \/>\n<meta property=\"og:site_name\" content=\"eTapestry\" \/>\n<meta property=\"article:published_time\" content=\"2017-05-25T06:30:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-04-10T16:46:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sidekicksolutionsllc.com\/etapestry\/wp-content\/uploads\/sites\/2\/2018\/06\/etapestry-database-review.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"811\" \/>\n\t<meta property=\"og:image:height\" content=\"256\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sidekicksolutionsllc.com\/etapestry\/#website\",\"url\":\"https:\/\/www.sidekicksolutionsllc.com\/etapestry\/\",\"name\":\"eTapestry\",\"description\":\"Just another Sidekick Site\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/www.sidekicksolutionsllc.com\/etapestry\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.sidekicksolutionsllc.com\/etapestry\/blog\/annual-etapestry-database-review-why-and-how-to-do-one#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.sidekicksolutionsllc.com\/etapestry\/wp-content\/uploads\/sites\/2\/2018\/06\/etapestry-database-review.jpg\",\"width\":811,\"height\":256},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sidekicksolutionsllc.com\/etapestry\/blog\/annual-etapestry-database-review-why-and-how-to-do-one#webpage\",\"url\":\"https:\/\/www.sidekicksolutionsllc.com\/etapestry\/blog\/annual-etapestry-database-review-why-and-how-to-do-one\",\"name\":\"Annual eTapestry Database Review: Why and How to Do One\",\"isPartOf\":{\"@id\":\"https:\/\/www.sidekicksolutionsllc.com\/etapestry\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sidekicksolutionsllc.com\/etapestry\/blog\/annual-etapestry-database-review-why-and-how-to-do-one#primaryimage\"},\"datePublished\":\"2017-05-25T06:30:11+00:00\",\"dateModified\":\"2019-04-10T16:46:34+00:00\",\"author\":{\"@id\":\"https:\/\/www.sidekicksolutionsllc.com\/etapestry\/#\/schema\/person\/f425b8f1a3f7732b2ae8426ab3a7f563\"},\"description\":\"Continue to get the most from your Blackbaud eTapestry database year after year. Answer these questions to identify improvements and enhancements.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sidekicksolutionsllc.com\/etapestry\/blog\/annual-etapestry-database-review-why-and-how-to-do-one\"]}]},{\"@type\":[\"Person\"],\"@id\":\"https:\/\/www.sidekicksolutionsllc.com\/etapestry\/#\/schema\/person\/f425b8f1a3f7732b2ae8426ab3a7f563\",\"name\":\"Sidekick Solutions\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.sidekicksolutionsllc.com\/etapestry\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5edfa2692bdacc5e6ee805c626c50cb44cebb065f092d9a1067d89f74dacd326?s=96&d=mm&r=g\",\"caption\":\"Sidekick Solutions\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/www.sidekicksolutionsllc.com\/etapestry\/wp-json\/wp\/v2\/posts\/752","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sidekicksolutionsllc.com\/etapestry\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sidekicksolutionsllc.com\/etapestry\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sidekicksolutionsllc.com\/etapestry\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sidekicksolutionsllc.com\/etapestry\/wp-json\/wp\/v2\/comments?post=752"}],"version-history":[{"count":0,"href":"https:\/\/www.sidekicksolutionsllc.com\/etapestry\/wp-json\/wp\/v2\/posts\/752\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sidekicksolutionsllc.com\/etapestry\/wp-json\/wp\/v2\/media\/935"}],"wp:attachment":[{"href":"https:\/\/www.sidekicksolutionsllc.com\/etapestry\/wp-json\/wp\/v2\/media?parent=752"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sidekicksolutionsllc.com\/etapestry\/wp-json\/wp\/v2\/categories?post=752"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sidekicksolutionsllc.com\/etapestry\/wp-json\/wp\/v2\/tags?post=752"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}