{"id":90844,"date":"2026-08-31T09:00:00","date_gmt":"2026-08-31T07:00:00","guid":{"rendered":"https:\/\/churchtools.academy\/help\/non-knowledgebase\/uncategorized\/what-are-ad-hoc-reports\/"},"modified":"2026-09-04T08:53:21","modified_gmt":"2026-09-04T06:53:21","password":"","slug":"what-are-ad-hoc-reports","status":"publish","type":"docs","link":"https:\/\/churchtools.academy\/en\/help\/churchtools-modules\/adhoc-reports-en\/what-are-ad-hoc-reports\/","title":{"rendered":"What are ad hoc reports?"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Ad hoc reports are another way to create reports, in addition to standard reports. Ad hoc reports provide you with a quick overview of a predefined topic. The results are then displayed as <a href=\"https:\/\/de.wikipedia.org\/wiki\/Pivot-Tabelle\">a pivot table<\/a> and reflect the current status as it appears in ChurchTools.  <\/p>\n\n<p class=\"wp-block-paragraph\">The predefined ad hoc reports are stored as SQL queries. This allows you to quickly select and run them. <\/p>\n\n<h2 class=\"wp-block-heading\">Predefined ad hoc reports<\/h2>\n\n<p class=\"wp-block-paragraph\">Every ChurchTools installation comes with preconfigured ad hoc reports:  <\/p>\n\n<ul class=\"wp-block-list\">\n<li><p><strong>Membership and Friends Growth<\/strong> \u2013 A list of individuals in the ChurchTools system over a period of time.<\/p><\/li>\n\n\n\n<li><p><strong>Membership Trends<\/strong> \u2013 Initial Contacts per Month and per Year.<\/p><\/li>\n\n\n\n<li><p><strong>Monthly Group Growth<\/strong> \u2013 Changes in the number of participants in groups (of a specific type), broken down by month.<\/p><\/li>\n\n\n\n<li><p><strong>Weekly Group Development<\/strong> \u2013 Changes in the number of participants in groups (of a specific group type), broken down by calendar week.<\/p><\/li>\n\n\n\n<li><p><strong>Attendance at Group Meetings<\/strong> \u2013 Number of group meetings attended per month, broken down by participant role.<\/p><\/li>\n\n\n\n<li><p><strong>Fact Report<\/strong> \u2013 List of facts (Events module), calculated on a monthly basis.<\/p><\/li>\n\n\n\n<li><strong>Donor Analysis<\/strong> \u2013 Total Donation Amount or Number of Donations<\/li>\n\n\n\n<li><p><strong>Finance<\/strong> \u2013 List of account transactions by account (old Finance Sync module).<\/p><\/li>\n\n\n\n<li><strong>Song Usage<\/strong> \u2013 Song Frequency by Calendar and Campus<\/li>\n\n\n\n<li><p><strong>App Usage<\/strong> \u2013 Number of devices per user that use the ChurchTools app.<\/p><\/li>\n\n\n\n<li><strong>Users without an active app installation<\/strong> \u2013 List of all users who do not have an active app installation<\/li>\n<\/ul>\n\n<aside class=\"wp-block-group ct-artikel-zum-weiterlesen has-background is-layout-constrained wp-container-core-group-is-layout-79a8db7e wp-block-group-is-layout-constrained\" style=\"border-radius:8px;background-color:#f9fafb;margin-top:24px;margin-bottom:24px;padding-top:32px;padding-right:24px;padding-bottom:32px;padding-left:24px\">\n<h2 class=\"wp-block-heading has-medium-font-size\">Read more<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/churchtools.academy\/de\/help\/churchtools-modules\/adhoc-reports\/wie-verwende-ich-einen-adhoc-report\/\" data-type=\"docs\" data-id=\"7607\">How to use an ad hoc report?<\/a><\/li>\n<\/ul>\n<\/aside>\n","protected":false},"excerpt":{"rendered":"<p>Ad hoc reports are another way to create reports, in addition to standard reports. Ad hoc reports provide you with a quick overview of a predefined topic. The results are then displayed as a pivot table and reflect the current status as it appears in ChurchTools. The predefined ad hoc reports are stored as SQL [&hellip;]<\/p>\n","protected":false},"author":43,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"doc_category":[494],"doc_tag":[],"knowledge_base":[224],"class_list":["post-90844","docs","type-docs","status-publish","hentry","doc_category-adhoc-reports-en","knowledge_base-churchtools-modules"],"pp_statuses_selecting_workflow":false,"pp_workflow_action":"current","pp_status_selection":"publish","pp_force_visibility":null,"pp_subpost_visibility":null,"pp_inherited_force_visibility":null,"pp_inherited_subpost_visibility":null,"acf":[],"year_month":"2026-09","word_count":239,"total_views":"8","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"Stefan Krumsdorf","author_nicename":"skrumsdorf","author_url":"https:\/\/churchtools.academy\/en\/author\/skrumsdorf\/"},"doc_category_info":[{"term_name":"AdHoc-Reports","term_url":"https:\/\/churchtools.academy\/en\/help\/churchtools-modules\/adhoc-reports-en\/"}],"doc_tag_info":[],"knowledge_base_info":[{"term_name":"Modules","term_url":"https:\/\/churchtools.academy\/en\/help\/churchtools-modules\/","term_slug":"churchtools-modules"}],"knowledge_base_slug":["churchtools-modules"],"_links":{"self":[{"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/docs\/90844","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/users\/43"}],"replies":[{"embeddable":true,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/comments?post=90844"}],"version-history":[{"count":5,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/docs\/90844\/revisions"}],"predecessor-version":[{"id":90975,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/docs\/90844\/revisions\/90975"}],"wp:attachment":[{"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/media?parent=90844"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/doc_category?post=90844"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/doc_tag?post=90844"},{"taxonomy":"knowledge_base","embeddable":true,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/knowledge_base?post=90844"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}