{"id":951,"date":"2024-06-28T12:23:00","date_gmt":"2024-06-28T10:23:00","guid":{"rendered":"https:\/\/nilsrooijmans.com\/daily\/?p=951"},"modified":"2024-07-02T08:57:35","modified_gmt":"2024-07-02T06:57:35","slug":"reporting-confession","status":"publish","type":"post","link":"https:\/\/nilsrooijmans.com\/daily\/reporting-confession","title":{"rendered":"reporting confession"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">I&#8217;ve got a confession to make.<br><br>In Wednesday&#8217;s mail, I told you I don\u2019t do fancy reporting, and offered you a script to automate the very limited data that I do report. (Email repeated below for your convenience.)<br><br>It&#8217;s true; I <em>do not<\/em> send fancy reports to my clients.<br><br>However&#8230; I <em>do advise<\/em> many of my coaching clients to use a fancy reporting tool!<br><br>What&#8217;s that, Nils? You don&#8217;t eat your own consulting dog food?<br><br>No. And yes.<br><br>Here&#8217;s what happens.<br><br>Many of my coaching clients are small to medium-sized agencies that want to do more with less hands. I help them automate the work so they can\u00a0<strong>increase revenue without increasing headcount.<\/strong><br><br>They typically serve tens if not hundreds of clients.<br><br>One of the main things that takes my clients forever? Sending out monthly, or even weekly, reports to their clients!<br><br>Many agencies have clients that simply expect them to send detailed reports. On time, every time. If they don&#8217;t, the client starts dialing numbers.<br><br>Many agencies use detailed reports as an entry point to start a conversation. That conversation with the client increases client retention.<br><br>Many agencies simply promised it in their initial offering.<br><br>Many reasons. Many hours of tedious, labor-intensive data gathering, number crunching, dashboarding, writing summaries, sending out emails&#8230;<br><br>Many hours of wasted time.<br><br>Wasted?\u00a0<br><br>Yes. Because you can automate almost all of it, and I&#8217;ve got just the solution for you.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">IF&#8230;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>you are swamped with daily reporting tasks and are losing your mind over it<\/li>\n\n\n\n<li>or, you&#8217;ve cobbled together some data source connectors that <em>should<\/em> work, but never do<\/li>\n\n\n\n<li>or, you are fed up with time-consuming setups for each new client<\/li>\n\n\n\n<li>or, you simply do not have the time to learn new complex tooling<\/li>\n\n\n\n<li>or, you don&#8217;t have the money for overpriced reporting solutions<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">THEN&#8230;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">your GO-TO solution is\u00a0<a href=\"https:\/\/www.swydo.com\/?utm_source=nilsrooijmans&amp;utm_medium=newsletter&amp;utm_campaign=jun2024\" target=\"_blank\" rel=\"noreferrer noopener\">Swydo<\/a>.<br><br>I&#8217;ve found Swydo to offer the best price-to-quality ratio when it comes to automated reporting, for these reasons:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>it aggregates data from the major platforms<\/li>\n\n\n\n<li>it has a very small learning curve (easier to implement than Looker Studio)<\/li>\n\n\n\n<li>it offers a free trial with a great onboarding service (get your specific report running in 20 minutes!)<\/li>\n\n\n\n<li>it allows for copy-paste templates you can use for each new client<\/li>\n\n\n\n<li>it&#8217;s the cheapest solution out there unless you want to spend a lot of time on the plumbing and client setups<\/li>\n\n\n\n<li>it is reliable and robust (reports go out on time, every time)<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Don&#8217;t get me wrong, it won&#8217;t give you the flexibility of a custom reporting setup using Supermetrics, Big Query, and Looker Studio. If that&#8217;s what you need, go for it.<br><br>Swydo is low effort, low cost, and just good enough. And good enough is what most agencies need.<br><br>&#8211; Nils<br><br><strong>PS:<\/strong>\u00a0If you want a reliable and affordable solution to automate your performance reporting ->\u00a0<a href=\"https:\/\/www.swydo.com\/?utm_source=nilsrooijmans&amp;utm_medium=newsletter&amp;utm_campaign=jun2024\" target=\"_blank\" rel=\"noreferrer noopener\">sign up for a free trial<\/a>.\u00a0<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">When you are happy with the tool and ready to upgrade, mention &#8220;NilsRooijmans&#8221; during the upgrade to get a $100 discount.\u00a0<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I\u2019d still share these tips without the kickback, but a few extra bucks is nice!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here&#8217;s the link again:\u00a0<a href=\"https:\/\/www.swydo.com\/?utm_source=nilsrooijmans&amp;utm_medium=newsletter&amp;utm_campaign=jun2024\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.swydo.com\/?utm_source=nilsrooijmans&amp;utm_medium=newsletter&amp;utm_campaign=jun2024<\/a>)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Lastly, as promised, here&#8217;s the email from Wednesday: <a href=\"https:\/\/nilsrooijmans.com\/daily\/google-ads-script-monthly-reporting-my-very-basic-version \">https:\/\/nilsrooijmans.com\/daily\/google-ads-script-monthly-reporting-my-very-basic-version<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve got a confession to make. In Wednesday&#8217;s mail, I told you I don\u2019t do fancy reporting, and offered you a script to automate the very limited data that I do report. (Email repeated below for your convenience.) It&#8217;s true; I do not send fancy reports to my clients. However&#8230; I do advise many of &hellip; <a href=\"https:\/\/nilsrooijmans.com\/daily\/reporting-confession\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;reporting confession&#8221;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-951","post","type-post","status-publish","format-standard","hentry","category-google-ads"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>reporting confession - Nils Rooijmans<\/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:\/\/nilsrooijmans.com\/daily\/reporting-confession\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"reporting confession - Nils Rooijmans\" \/>\n<meta property=\"og:description\" content=\"I&#8217;ve got a confession to make. In Wednesday&#8217;s mail, I told you I don\u2019t do fancy reporting, and offered you a script to automate the very limited data that I do report. (Email repeated below for your convenience.) It&#8217;s true; I do not send fancy reports to my clients. However&#8230; I do advise many of &hellip; Continue reading &quot;reporting confession&quot;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/nilsrooijmans.com\/daily\/reporting-confession\" \/>\n<meta property=\"og:site_name\" content=\"Nils Rooijmans\" \/>\n<meta property=\"article:published_time\" content=\"2024-06-28T10:23:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-02T06:57:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/nilsrooijmans.com\/daily\/wp-content\/uploads\/2024\/05\/NilsRooijmans_GreenBG_SQUARE_200x186.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"200\" \/>\n\t<meta property=\"og:image:height\" content=\"186\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Nils Rooijmans\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nils Rooijmans\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/reporting-confession#article\",\"isPartOf\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/reporting-confession\"},\"author\":{\"name\":\"Nils Rooijmans\",\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0\"},\"headline\":\"reporting confession\",\"datePublished\":\"2024-06-28T10:23:00+00:00\",\"dateModified\":\"2024-07-02T06:57:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/reporting-confession\"},\"wordCount\":565,\"publisher\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0\"},\"articleSection\":[\"Google Ads\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/reporting-confession\",\"url\":\"https:\/\/nilsrooijmans.com\/daily\/reporting-confession\",\"name\":\"reporting confession - Nils Rooijmans\",\"isPartOf\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#website\"},\"datePublished\":\"2024-06-28T10:23:00+00:00\",\"dateModified\":\"2024-07-02T06:57:35+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/reporting-confession#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/nilsrooijmans.com\/daily\/reporting-confession\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/reporting-confession#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/nilsrooijmans.com\/daily\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"reporting confession\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#website\",\"url\":\"https:\/\/nilsrooijmans.com\/daily\/\",\"name\":\"Nils Rooijmans Daily Newsletter - Google Ads\",\"description\":\"Daily emails to boost your Google Ads Performance\",\"publisher\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/nilsrooijmans.com\/daily\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0\",\"name\":\"Nils Rooijmans\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/nilsrooijmans.com\/daily\/wp-content\/uploads\/2024\/05\/NilsRooijmans_Green_Background_300x300.jpg\",\"contentUrl\":\"https:\/\/nilsrooijmans.com\/daily\/wp-content\/uploads\/2024\/05\/NilsRooijmans_Green_Background_300x300.jpg\",\"width\":300,\"height\":300,\"caption\":\"Nils Rooijmans\"},\"logo\":{\"@id\":\"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/image\/\"},\"description\":\"Google Ads Performance Architect with a passion for PPC Automation &amp; AI, in particular via Google Ads Scripts.\",\"sameAs\":[\"https:\/\/nilsrooijmans.com\/\",\"https:\/\/www.linkedin.com\/in\/nilsrooijmans\/\"],\"url\":\"https:\/\/nilsrooijmans.com\/daily\/author\/nils\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"reporting confession - Nils Rooijmans","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:\/\/nilsrooijmans.com\/daily\/reporting-confession","og_locale":"en_US","og_type":"article","og_title":"reporting confession - Nils Rooijmans","og_description":"I&#8217;ve got a confession to make. In Wednesday&#8217;s mail, I told you I don\u2019t do fancy reporting, and offered you a script to automate the very limited data that I do report. (Email repeated below for your convenience.) It&#8217;s true; I do not send fancy reports to my clients. However&#8230; I do advise many of &hellip; Continue reading \"reporting confession\"","og_url":"https:\/\/nilsrooijmans.com\/daily\/reporting-confession","og_site_name":"Nils Rooijmans","article_published_time":"2024-06-28T10:23:00+00:00","article_modified_time":"2024-07-02T06:57:35+00:00","og_image":[{"width":200,"height":186,"url":"https:\/\/nilsrooijmans.com\/daily\/wp-content\/uploads\/2024\/05\/NilsRooijmans_GreenBG_SQUARE_200x186.jpg","type":"image\/jpeg"}],"author":"Nils Rooijmans","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Nils Rooijmans","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/nilsrooijmans.com\/daily\/reporting-confession#article","isPartOf":{"@id":"https:\/\/nilsrooijmans.com\/daily\/reporting-confession"},"author":{"name":"Nils Rooijmans","@id":"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0"},"headline":"reporting confession","datePublished":"2024-06-28T10:23:00+00:00","dateModified":"2024-07-02T06:57:35+00:00","mainEntityOfPage":{"@id":"https:\/\/nilsrooijmans.com\/daily\/reporting-confession"},"wordCount":565,"publisher":{"@id":"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0"},"articleSection":["Google Ads"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/nilsrooijmans.com\/daily\/reporting-confession","url":"https:\/\/nilsrooijmans.com\/daily\/reporting-confession","name":"reporting confession - Nils Rooijmans","isPartOf":{"@id":"https:\/\/nilsrooijmans.com\/daily\/#website"},"datePublished":"2024-06-28T10:23:00+00:00","dateModified":"2024-07-02T06:57:35+00:00","breadcrumb":{"@id":"https:\/\/nilsrooijmans.com\/daily\/reporting-confession#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/nilsrooijmans.com\/daily\/reporting-confession"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/nilsrooijmans.com\/daily\/reporting-confession#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/nilsrooijmans.com\/daily"},{"@type":"ListItem","position":2,"name":"reporting confession"}]},{"@type":"WebSite","@id":"https:\/\/nilsrooijmans.com\/daily\/#website","url":"https:\/\/nilsrooijmans.com\/daily\/","name":"Nils Rooijmans Daily Newsletter - Google Ads","description":"Daily emails to boost your Google Ads Performance","publisher":{"@id":"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/nilsrooijmans.com\/daily\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/645ba0bda90c1467f9d23d332d1f3aa0","name":"Nils Rooijmans","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/image\/","url":"https:\/\/nilsrooijmans.com\/daily\/wp-content\/uploads\/2024\/05\/NilsRooijmans_Green_Background_300x300.jpg","contentUrl":"https:\/\/nilsrooijmans.com\/daily\/wp-content\/uploads\/2024\/05\/NilsRooijmans_Green_Background_300x300.jpg","width":300,"height":300,"caption":"Nils Rooijmans"},"logo":{"@id":"https:\/\/nilsrooijmans.com\/daily\/#\/schema\/person\/image\/"},"description":"Google Ads Performance Architect with a passion for PPC Automation &amp; AI, in particular via Google Ads Scripts.","sameAs":["https:\/\/nilsrooijmans.com\/","https:\/\/www.linkedin.com\/in\/nilsrooijmans\/"],"url":"https:\/\/nilsrooijmans.com\/daily\/author\/nils"}]}},"_links":{"self":[{"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/posts\/951","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/comments?post=951"}],"version-history":[{"count":1,"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/posts\/951\/revisions"}],"predecessor-version":[{"id":952,"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/posts\/951\/revisions\/952"}],"wp:attachment":[{"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/media?parent=951"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/categories?post=951"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nilsrooijmans.com\/daily\/wp-json\/wp\/v2\/tags?post=951"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}