{"id":79854,"date":"2022-02-16T03:58:11","date_gmt":"2022-02-16T03:58:11","guid":{"rendered":"https:\/\/stage.mosaicmkt.com\/?p=79854"},"modified":"2022-02-16T03:58:20","modified_gmt":"2022-02-16T03:58:20","slug":"the-power-of-database-functions-in-google-sheets-dsum-dcount-dget-daverage-and-more-with-example","status":"publish","type":"post","link":"http:\/\/stage.mosaicmkt.com\/the-power-of-database-functions-in-google-sheets-dsum-dcount-dget-daverage-and-more-with-example\/","title":{"rendered":"The Power of Database Functions in Google Sheets: DSUM, DCOUNT, DGET, DAVERAGE and more&#8230;(with example)"},"content":{"rendered":"\n<p>If you haven&#8217;t used the database functions in Google Sheets you haven&#8217;t truly lived&#8230;well that may be a slight exaggeration, but the power of the database function is truly impressive.  The formula is a little hard to get used to, but once you get comfortable with the functionality you will wonder how you lived without them.  For those of you who haven&#8217;t used a database function before, <a rel=\"noreferrer noopener\" href=\"https:\/\/support.google.com\/docs\/answer\/173497\" data-type=\"URL\" data-id=\"https:\/\/support.google.com\/docs\/answer\/173497\" target=\"_blank\">Google offers this overview to help you get familiar.<\/a>  The reason they are so powerful is that they allow you to perform calculations on datasets using robust criteria.  For instance, a standard report we create for our clients is funnel performance from website users all the way through purchase or deal by channel.  Before the database function, we had to be very specific in how we laid out the report and changes to data could cause hours of work, now we simply need to change the datasource and update the function to account for the field names in the dataset.  <\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>For instance, here is a formula to sum new users in a certain date range by channel based on an export out of Google Analytics: =DSUM(&#8216;Channel Report&#8217;!$A$15:$L,&#8221;New Users&#8221;,{{&#8220;Date&#8221;;&#8221;>=&#8221; &amp; C$11},{&#8220;Date&#8221;;&#8221;&lt;=&#8221; &amp; C$12},{&#8220;Default Channel Grouping&#8221;;&#8221;=<em>&#8221; &amp; $B16 &amp; &#8220;<\/em>&#8220;}}) While the format may be new to you, what the criteria inputs are should be readily apparent.  This formula allows us to quickly build reports that can be easily updated with a few changes to the input cells.  This same structure can also be applied to an exported Salesforce report just by updating the field names.  <\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>If you aren&#8217;t using the database function in your Google Sheets, it is highly recommended that you take a few minutes to check it out today. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you haven&#8217;t used the database functions in Google Sheets you haven&#8217;t truly lived&#8230;well that may be a slight exaggeration, but the power of the database function is truly impressive. The formula is a little hard to get used to, but once you get comfortable with the functionality you will wonder how you lived without [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","content-type":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"episode_type":"","audio_file":"","cover_image":"","cover_image_id":"","duration":"","filesize":"","date_recorded":"","explicit":"","block":"","filesize_raw":"","footnotes":""},"categories":[1],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>The Power of Database Functions in Google Sheets: DSUM, DCOUNT, DGET, DAVERAGE and more...(with example) - Mosaic Growth Solutions - B2B SaaS Marketing Agency for High-Growth Businesses Serving Private Equity, VCs and Start-Ups<\/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:\/\/stage.mosaicmkt.com\/the-power-of-database-functions-in-google-sheets-dsum-dcount-dget-daverage-and-more-with-example\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Power of Database Functions in Google Sheets: DSUM, DCOUNT, DGET, DAVERAGE and more...(with example) - Mosaic Growth Solutions - B2B SaaS Marketing Agency for High-Growth Businesses Serving Private Equity, VCs and Start-Ups\" \/>\n<meta property=\"og:description\" content=\"If you haven&#8217;t used the database functions in Google Sheets you haven&#8217;t truly lived&#8230;well that may be a slight exaggeration, but the power of the database function is truly impressive. The formula is a little hard to get used to, but once you get comfortable with the functionality you will wonder how you lived without [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/stage.mosaicmkt.com\/the-power-of-database-functions-in-google-sheets-dsum-dcount-dget-daverage-and-more-with-example\/\" \/>\n<meta property=\"og:site_name\" content=\"Mosaic Growth Solutions - B2B SaaS Marketing Agency for High-Growth Businesses Serving Private Equity, VCs and Start-Ups\" \/>\n<meta property=\"article:published_time\" content=\"2022-02-16T03:58:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-16T03:58:20+00:00\" \/>\n<meta name=\"author\" content=\"mosaicmktadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"mosaicmktadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/stage.mosaicmkt.com\/the-power-of-database-functions-in-google-sheets-dsum-dcount-dget-daverage-and-more-with-example\/\",\"url\":\"https:\/\/stage.mosaicmkt.com\/the-power-of-database-functions-in-google-sheets-dsum-dcount-dget-daverage-and-more-with-example\/\",\"name\":\"The Power of Database Functions in Google Sheets: DSUM, DCOUNT, DGET, DAVERAGE and more...(with example) - Mosaic Growth Solutions - B2B SaaS Marketing Agency for High-Growth Businesses Serving Private Equity, VCs and Start-Ups\",\"isPartOf\":{\"@id\":\"https:\/\/stage.mosaicmkt.com\/#website\"},\"datePublished\":\"2022-02-16T03:58:11+00:00\",\"dateModified\":\"2022-02-16T03:58:20+00:00\",\"author\":{\"@id\":\"https:\/\/stage.mosaicmkt.com\/#\/schema\/person\/46c7fc8058a9ce83ee50b3457a30c613\"},\"breadcrumb\":{\"@id\":\"https:\/\/stage.mosaicmkt.com\/the-power-of-database-functions-in-google-sheets-dsum-dcount-dget-daverage-and-more-with-example\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/stage.mosaicmkt.com\/the-power-of-database-functions-in-google-sheets-dsum-dcount-dget-daverage-and-more-with-example\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/stage.mosaicmkt.com\/the-power-of-database-functions-in-google-sheets-dsum-dcount-dget-daverage-and-more-with-example\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/stage.mosaicmkt.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Power of Database Functions in Google Sheets: DSUM, DCOUNT, DGET, DAVERAGE and more&#8230;(with example)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/stage.mosaicmkt.com\/#website\",\"url\":\"https:\/\/stage.mosaicmkt.com\/\",\"name\":\"Mosaic Growth Solutions - B2B SaaS Marketing Agency for High-Growth Businesses Serving Private Equity, VCs and Start-Ups\",\"description\":\"Leading Marketing Agency for High Growth Businesses Serving Private Equity, VCs and Start-Ups\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/stage.mosaicmkt.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/stage.mosaicmkt.com\/#\/schema\/person\/46c7fc8058a9ce83ee50b3457a30c613\",\"name\":\"mosaicmktadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/stage.mosaicmkt.com\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/0.gravatar.com\/avatar\/f8be81a2cb99babb5eb086cbc4ce50b4?s=96&d=mm&r=g\",\"contentUrl\":\"http:\/\/0.gravatar.com\/avatar\/f8be81a2cb99babb5eb086cbc4ce50b4?s=96&d=mm&r=g\",\"caption\":\"mosaicmktadmin\"},\"url\":\"http:\/\/stage.mosaicmkt.com\/author\/mosaicmktadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The Power of Database Functions in Google Sheets: DSUM, DCOUNT, DGET, DAVERAGE and more...(with example) - Mosaic Growth Solutions - B2B SaaS Marketing Agency for High-Growth Businesses Serving Private Equity, VCs and Start-Ups","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:\/\/stage.mosaicmkt.com\/the-power-of-database-functions-in-google-sheets-dsum-dcount-dget-daverage-and-more-with-example\/","og_locale":"en_US","og_type":"article","og_title":"The Power of Database Functions in Google Sheets: DSUM, DCOUNT, DGET, DAVERAGE and more...(with example) - Mosaic Growth Solutions - B2B SaaS Marketing Agency for High-Growth Businesses Serving Private Equity, VCs and Start-Ups","og_description":"If you haven&#8217;t used the database functions in Google Sheets you haven&#8217;t truly lived&#8230;well that may be a slight exaggeration, but the power of the database function is truly impressive. The formula is a little hard to get used to, but once you get comfortable with the functionality you will wonder how you lived without [&hellip;]","og_url":"https:\/\/stage.mosaicmkt.com\/the-power-of-database-functions-in-google-sheets-dsum-dcount-dget-daverage-and-more-with-example\/","og_site_name":"Mosaic Growth Solutions - B2B SaaS Marketing Agency for High-Growth Businesses Serving Private Equity, VCs and Start-Ups","article_published_time":"2022-02-16T03:58:11+00:00","article_modified_time":"2022-02-16T03:58:20+00:00","author":"mosaicmktadmin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"mosaicmktadmin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/stage.mosaicmkt.com\/the-power-of-database-functions-in-google-sheets-dsum-dcount-dget-daverage-and-more-with-example\/","url":"https:\/\/stage.mosaicmkt.com\/the-power-of-database-functions-in-google-sheets-dsum-dcount-dget-daverage-and-more-with-example\/","name":"The Power of Database Functions in Google Sheets: DSUM, DCOUNT, DGET, DAVERAGE and more...(with example) - Mosaic Growth Solutions - B2B SaaS Marketing Agency for High-Growth Businesses Serving Private Equity, VCs and Start-Ups","isPartOf":{"@id":"https:\/\/stage.mosaicmkt.com\/#website"},"datePublished":"2022-02-16T03:58:11+00:00","dateModified":"2022-02-16T03:58:20+00:00","author":{"@id":"https:\/\/stage.mosaicmkt.com\/#\/schema\/person\/46c7fc8058a9ce83ee50b3457a30c613"},"breadcrumb":{"@id":"https:\/\/stage.mosaicmkt.com\/the-power-of-database-functions-in-google-sheets-dsum-dcount-dget-daverage-and-more-with-example\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/stage.mosaicmkt.com\/the-power-of-database-functions-in-google-sheets-dsum-dcount-dget-daverage-and-more-with-example\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/stage.mosaicmkt.com\/the-power-of-database-functions-in-google-sheets-dsum-dcount-dget-daverage-and-more-with-example\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/stage.mosaicmkt.com\/"},{"@type":"ListItem","position":2,"name":"The Power of Database Functions in Google Sheets: DSUM, DCOUNT, DGET, DAVERAGE and more&#8230;(with example)"}]},{"@type":"WebSite","@id":"https:\/\/stage.mosaicmkt.com\/#website","url":"https:\/\/stage.mosaicmkt.com\/","name":"Mosaic Growth Solutions - B2B SaaS Marketing Agency for High-Growth Businesses Serving Private Equity, VCs and Start-Ups","description":"Leading Marketing Agency for High Growth Businesses Serving Private Equity, VCs and Start-Ups","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/stage.mosaicmkt.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/stage.mosaicmkt.com\/#\/schema\/person\/46c7fc8058a9ce83ee50b3457a30c613","name":"mosaicmktadmin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/stage.mosaicmkt.com\/#\/schema\/person\/image\/","url":"http:\/\/0.gravatar.com\/avatar\/f8be81a2cb99babb5eb086cbc4ce50b4?s=96&d=mm&r=g","contentUrl":"http:\/\/0.gravatar.com\/avatar\/f8be81a2cb99babb5eb086cbc4ce50b4?s=96&d=mm&r=g","caption":"mosaicmktadmin"},"url":"http:\/\/stage.mosaicmkt.com\/author\/mosaicmktadmin\/"}]}},"_links":{"self":[{"href":"http:\/\/stage.mosaicmkt.com\/wp-json\/wp\/v2\/posts\/79854"}],"collection":[{"href":"http:\/\/stage.mosaicmkt.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/stage.mosaicmkt.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/stage.mosaicmkt.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/stage.mosaicmkt.com\/wp-json\/wp\/v2\/comments?post=79854"}],"version-history":[{"count":1,"href":"http:\/\/stage.mosaicmkt.com\/wp-json\/wp\/v2\/posts\/79854\/revisions"}],"predecessor-version":[{"id":79855,"href":"http:\/\/stage.mosaicmkt.com\/wp-json\/wp\/v2\/posts\/79854\/revisions\/79855"}],"wp:attachment":[{"href":"http:\/\/stage.mosaicmkt.com\/wp-json\/wp\/v2\/media?parent=79854"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/stage.mosaicmkt.com\/wp-json\/wp\/v2\/categories?post=79854"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/stage.mosaicmkt.com\/wp-json\/wp\/v2\/tags?post=79854"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}