
Customer Segmentation Analysis: RFM Example With Data
Follow a customer segmentation analysis example using RFM. Download the dataset, check refunds and duplicates, and build a customer review list.
Marketing Analytics — Comparison · 2026
Client reporting tools for agencies, tested on the same sample client data: what each tool produced, what it costs for your number of clients, and which ones we could not get into.
Which client reporting tool fits your agency?
Each tool is scored out of 25 on five checks, explained below.
Client reporting is the recurring report an agency sends each client, usually once a month: what you spent, what it produced, what changed and what you will do next. A client reporting tool, often sold as agency reporting software, pulls each client's data, builds that report and delivers it. Building the first client's report is rarely the problem. Doing it again for client #2 to client #30, every month, is.
The first table is the verdict: who each tool suits, what it costs and what happened in our test. The second shows how each tool handles the five checks explained below. Tools are grouped by kind, and Anomaly AI is listed last so it gets no positional advantage.
| Tool | Best for | Price (verified 8 Oct 2026) | Our test |
|---|---|---|---|
| AgencyAnalytics | A branded portal for every client, priced per client | $20 per client/mo billed yearly; $25 monthly | 19/25 |
| Swydo | Many small clients, priced per data source | $62/mo billed yearly with 10 sources; +$4.50 per extra source | Not tested: the trial needs a request to support |
| DashThis | Simple templated dashboards for a small number of clients | $44 to $429/mo billed yearly | 18/25 |
| Whatagraph | Larger teams blending many sources | Max from $1,118/mo billed yearly | Not tested: sign-up goes through a demo or sales |
| Databox | KPI dashboards with goals across clients | Free; Agency from $79/mo billed yearly + $20 per account pack | Not scored: our files never loaded |
| Data Studio | Do-it-yourself reports on Google data | Free; Pro $9 per user per project/mo | 18/25 |
| ChatGPT | A one-off check of a client's exports | Free; Go $8; Plus $20; Pro from $100/mo (US) | 17/25 |
| Anomaly AI | Rebuilding reports from exports and defending the numbers | Free; Pro $25/mo; Analyst $90/mo; Team $45 per seat/mo | 20/25 |
| Tool | Intake and refresh | Next-client setup | Trace a number | Delivery |
|---|---|---|---|---|
| AgencyAnalytics | 92 connectors in our trial but no CSV source, so files could only go in as AI chat attachments | Templates, bulk operations and roll-ups; in our test, we reran the AI prompt | Its AI showed the formula, the totals and equivalent SQL | White-label portal, scheduled reports, custom domain and sender |
| Swydo | 38+ integrations, plus Google Sheets import | Dynamic templates linked to reports | Not tested | White-label reports, a client portal and password-protected links |
| DashThis | Every plan includes all integrations; CSV files go in through one template per file layout | We built it by hand; it also has preset and custom templates | The formula sits in a calculated widget, with the totals beside it | White-label dashboards, your own domain and sender email, and PDF export |
| Whatagraph | Integrations, data groups and blends | Linked report templates | Not tested | White-label reports, and emails with a PDF attached |
| Databox | Native integrations, with Sheets, Excel and SQL from the Analyst plan up; its AI chat takes images, not CSV files | Custom templates and bulk actions on the Agency plan | Not tested (files never loaded) | Sharing on the Team and Agency plans; white-label is a paid add-on |
| Data Studio | Native Google connectors; CSV uploads need one data source per file layout | We built it by hand in our test | It shows the formula and both totals in one table | A share link, or a PDF emailed on a schedule |
| ChatGPT | You attach the files to each chat | A new chat with the same prompt took 1.8 min | It showed the formula, the daily rows and equivalent SQL | An HTML file you download and send yourself |
| Anomaly AI | Connectors for GA4, Google Ads, Search Console, Meta and TikTok Ads, Sheets and databases; files up to 1 GB | A new project with the same prompt took 2.3 min | View calculation shows the formula and the SQL | A PDF on a schedule by email or Slack, and share links; not white-label |
We tested that repeat job. We built one synthetic file for two clients, client A (an ecommerce store) and client B (a lead-generation business), each with 90 days of GA4, Google Ads and Search Console exports. We worked out every correct number in advance, our answer key, and built in one problem on purpose: a gap between Google Ads conversions and GA4 key events. We ran the same second-client test in every tool we could open, checked every price on the vendor's own page, and priced each tool for three mixes of client count and data sources. You can download the six test files and check our answers yourself.
What we found
Feature lists look alike. These five checks are where agency reporting tools actually differ. They are the columns of the comparison and the checks we scored.
The file. We generated six synthetic CSV files from a fixed random seed. Client A is an ecommerce store and client B a lead-generation business. Each client has a GA4-style daily channel report, a Google Ads daily campaign report and a Search Console daily query report, from 3 July to 30 September 2026. We planted one problem a careful report must catch: Google Ads counts more conversions than GA4 records as Paid Search key events.
The test. Build client A's monthly report, then produce client B's. Then trace one number: client B's September cost per key event = Google Ads cost ÷ GA4 key events from the Paid Search channel. Anomaly AI, ChatGPT and AgencyAnalytics' assistant got the same two prompts; Data Studio and DashThis were built by hand. Every tool except Anomaly AI ran client B only, and we timed or counted the steps for client B from the start of setup to a finished report.
| Answer key (fixed before testing) | Client A, Sep | Client B, Sep | Client B, Aug |
|---|---|---|---|
| Google Ads cost | 19,961.56 | 40,564.29 | 38,800.09 |
| GA4 Paid Search key events | 697 (purchases) | 320 (leads) | 278 |
| Cost per key event | 28.64 | 126.76 | 139.57 |
| Google Ads conversions | 793.57 | 402.80 | 349.23 |
| Ads vs GA4 gap | +13.9% | +25.9% | +25.6% |
Download the test files: client A GA4 channels, Google Ads, Search Console; client B GA4 channels, Google Ads, Search Console. All six are synthetic sample data, and "client a" and "client b" stand in for brand names. SHA-256 checksums (first 12 characters), in the same order: client A d791d2a61914, 5b5e1faf20b8, 75b4162cd95d; client B d6307bcc63e4, 1bce50e09fda, 5c1500b70906.
Scoring. Each check scores 0 to 5, for 25 in total. The checks and thresholds are our policy, not a prediction of rankings. Intake points for connectors come from vendor documentation, because we tested with the CSV files only.
Who and when. Anomaly's marketing team ran every test on 8 and 9 October 2026, with AI agents operating the browser and timing each step. Anomaly AI ran on a trial workspace, ChatGPT on the Free plan and Data Studio on a free Google account. AgencyAnalytics, DashThis and Databox ran on their trials. The tester could see the answer key, so the runs were not blinded. Every screenshot comes from a 1440-pixel browser window in light theme. Each attempt has a run record: Anomaly AI, ChatGPT, Data Studio, AgencyAnalytics, Swydo, DashThis and Databox.
What is different here. Most client reporting lists describe tools from vendor pages. This one runs every tool we could open on the same two-client file, publishes the answer key and the files, times how long the second client takes and prices each tool for three mixes of client count and data sources.
Also considered. We left out tools that do a different job or that we could not reach without a sales call. Supermetrics and Coupler.io mainly move data into Data Studio, sheets or other destinations rather than build the report. Porter Metrics charges $12.50 per data-source account a month, billed yearly, and centres on connectors and AI chat. TapClicks quotes prices through an appointment, and Improvado prices its full plans by quote. NinjaCat sells an enterprise marketing data platform with no public price. Raven Tools is built mainly for SEO. Claude is another AI chat tool like ChatGPT, and we tested only one of the two: ChatGPT.
Disclosure. Anomaly AI is our product. We scored it on the same five checks and say below where other tools do better: white-label delivery, client portals and the price of a single seat.
In our test, AgencyAnalytics' AI assistant, AgencyAI, built client B's report from our three files: cost per key event 126.76 on 40,564.29 of Google Ads cost and 320 Paid Search key events, with the 25.9% conversion gap flagged. All match the answer key. It made one mistake: its report says an August cost per key event "cannot be calculated" because August Google Ads cost was "not included". Our Google Ads file does include August (38,800.09 of cost, which gives 139.57), so the month-on-month comparison was missing for no reason. Evidence: run record.
Getting the files in was the hard part. Its data sources are connectors: 92 were listed in our trial, and a search for "csv" found none. Google Sheets, the route for custom data, failed at Google's file picker in our test browser. What worked was attaching the CSVs to an AgencyAI chat. It then asked four setup questions and built the page in about two minutes.
When we asked where the number came from, it gave the formula, both totals, the rows behind each total and equivalent SQL. The report was incomplete: it left the campaign and channel tables empty and missed the Search Console file. It scored 4 for intake and refresh, 3 for next-client setup, 5 for tracing a number, 5 for delivery and 2 for roster cost: 19 of 25 in total.
If your clients' data is in connected accounts, you pay per client and each client gets 85+ integrations, automated reports, a white-labeled portal, a custom domain and sender email, and AI summaries. Templates, bulk operations and roll-ups speed up the next client. A client with two sources costs as much as one with twelve.
Price: $20 per client per month billed yearly, $25 billed monthly; a 14-day trial without a card. Annual plans carry a one-year commitment. Best for: agencies whose clients expect a branded login and whose data lives in connected accounts.
We could not test Swydo. It created our account, then showed "To start a free trial please contact support". It still did on a second try on 9 October, so we stopped there. Evidence: run record. This section reflects its pricing page, checked 8 October 2026.
Swydo prices by data source, not by client. One plan includes every feature, unlimited clients, users, dashboards and reports, and your first 10 connected sources. That makes it cheap for many clients with one or two accounts each, and less so for a few clients with a dozen sources each.
For the next client, Swydo's dynamic templates are the main tool: update a template once and the linked reports change with it. Delivery covers white-labeling, a client portal, password-protected sharing, custom domain hosting and branded PDF exports. It lists 38+ integrations and a Google Sheets import for other data.
Price: $69 a month, or $62 billed yearly, with 10 data sources included. Sources 11 to 100 cost $4.50 each, then $3.00 and $2.00 at higher tiers. Best for: rosters of many small, single-channel clients.
In our test, DashThis returned client B's September cost per key event as 126.76 (40,564.29 ÷ 320), matching the answer key. Getting there took about 60 manual steps on the 14-day trial. Evidence: run record.
Files go in through CSV templates, one per file layout, where you mark the date column, dimensions and metrics. Each file also needs a customer ID; our exports had none, so we pointed it at a header cell. The widgets stayed empty until we uploaded the files again after creating them, as DashThis's help explains.
The formula sits in the calculated widget, with both totals beside it; daily rows need a table widget. Every plan includes every integration, so a connected client refreshes without exports. Paid plans include white-label dashboards, a custom domain and sender email, scheduled emails and PDF export.
It scored 4 for intake and refresh, 2 for next-client setup (we built it by hand and did not test its templates), 4 for tracing a number, 5 for delivery and 3 for roster cost: 18 of 25 in total. Plans are capped by dashboards and sources, so the price climbs as you add clients.
Price, billed yearly: Individual $44 a month (3 dashboards, 15 sources), Professional $139 (10 dashboards, 40 sources), Business $279 (25 dashboards, 100 sources) and Standard $429 (50 dashboards, 200 sources). Monthly billing costs more. Best for: small agencies that want branded dashboards without a big platform.
We could not test Whatagraph. Its pricing page offers demos. Its sign-up page asks for a work email, phone number and current tools, and Google sign-in with our test account did not open an account. We did not book a demo. This section reflects the pricing page on 8 October 2026.
Whatagraph now sells two plans. Max covers the core agency job: advanced integrations, data groups and blends across sources, and custom metrics and dimensions. It adds KPI overviews with goals and alerts, its IQ Agents AI features and linked report templates for reuse across clients. Delivery is white-label reports and automated emails with a PDF.
Prime adds premium integrations, a custom report domain, public API access and data transfers to BigQuery and Data Studio. The trade-off is the size of the commitment. Max is sized in credits, one per connected source, starting at 50. For an agency with five clients, it is more tool than the job needs.
Price: Max from $1,118 a month, billed yearly (€999 in its euro display); Prime is custom. Best for: larger agencies consolidating many sources into heavily branded reports.
Databox ran, but our files never reached it. We signed up and started a Google Sheets connection, but Google's file picker never handed the client B sheet back to Databox, including when a person picked the file by hand. The same picker failed in AgencyAnalytics in our test browser. The trial has no file upload, a new dataset needs a connected source, and its AI chat accepted images only. It has no score. Evidence: run record. This section is from its pricing page, checked 8 October 2026.
Databox is a dashboard-and-goals product with a separate Agency plan. That plan includes unlimited users, bulk actions, custom templates and cross-account reporting through its AI analyst. It grows by "account packs": each pack adds one client account, five data sources and 50 AI credits. Branding and white-labeling is an $80-a-month add-on.
Watch the plan limits. The Free plan includes one user, three data sources and one dashboard. Its comparison table shows no custom data integrations and no sharing, so it cannot load files like ours or send a client anything. Custom data comes with the Analyst plan ($71 a month billed yearly) and sharing on the Team plans ($199 or $319 billed yearly).
Price: Agency from $79 a month billed yearly, plus $20 a month per account pack; white-label add-on $80 a month. Paid plans have a 14-day trial without a card. Best for: agencies that report against goals across many client accounts.
In our test, Data Studio returned client B's September cost per key event as 126.76 (40,564.29 ÷ 320) on the free plan, matching the answer key. Getting there took a manual build: about 15 actions to upload the three files and about 40 more to blend, filter and calculate. Evidence: run record.
Data Studio was renamed from Looker Studio in April 2026. It is free and flexible, but you build everything yourself. Its CSV upload connector combines files only when headers match, so three exports became three data sources. The date column arrived as text and would not convert to a date. We blended the two sources on date, filtered GA4 to Paid Search and divided the totals in a calculated field.
It scored 4 for intake and refresh, because native GA4, Google Ads and Search Console connectors exist but we used files. It scored 2 for next-client setup: we built client B by hand, and copying the report and swapping its data sources is the documented shortcut, which we did not test. It scored 4 for tracing a number, because the formula and both totals sit side by side but daily rows need another table. With 3 for delivery and 5 for roster cost, that makes 18 of 25.
The cost is time, because building and maintaining a report per client is unbilled work. Our guide to alternatives to Data Studio for GA4 reporting covers lighter options. Price: free; Data Studio Pro costs $9 per user per project per month. Best for: teams that work in Google's tools and will build and maintain their own reports.
In our test, ChatGPT on the Free plan took about 1.8 minutes from attaching client B's three files to an answer. It reported cost per key event 126.76, down 9.2% on August, and an 82.80 gap between Ads conversions and GA4 key events. Both match the answer key. Evidence: run record.
When we asked where the number came from, it showed the formula (40,564.29 ÷ 320) and the cost of each campaign. It listed all 30 daily Paid Search rows that add up to 320, plus equivalent SQL, and it produced a standalone HTML report file.
What it does not do is the agency part. Each month you start again: attach the new exports and ask again. ChatGPT's plan page lists limited uploads and no scheduled tasks on Free; Plus adds scheduled tasks. There is no white-label branding or client login. We ran client B only, because a chat keeps no per-client template.
It scored 2 for intake and refresh, 4 for next-client setup, 5 for tracing a number, 1 for delivery and 5 for roster cost: 17 of 25 in total. Price (US): Free; Go $8 and Plus $20 a month; Pro from $100. Best for: checking a client's exports before a call, or a one-off analysis.
In our test, Anomaly AI produced client B's report in 2.3 minutes from a new project, with six actions including three file uploads. Cost per key event came out at 126.76, down 9.2% on August, and the 25.9% conversion gap was flagged. Both match the answer key, as did client A's 28.64 and 13.9%. Evidence: run record.
Anomaly AI is an AI data analyst for large datasets and spreadsheets. You upload or connect a client's data, ask for the report in plain words, and get a dashboard you can export or schedule. Intake and refresh scored 4: it connects to GA4, Google Ads, Search Console and Meta and TikTok Ads, but we tested with files. Next-client setup scored 4: client B was a rerun of client A's prompt, with no cross-project template to clone.
Trace a number scored 5. The "View calculation" panel on the cost per key event card explains the measure in plain terms and, on its Code tab, shows the SQL behind it. When we asked where the number came from, it returned 40,564.29 ÷ 320 = 126.76 with both source queries in 32 seconds.
Delivery is where other tools do better, and it scored 3. On Pro and up, Anomaly sends the report as a PDF on a schedule, by email or to Slack, and shares by link with an optional access code. There is no white-label branding, client portal or custom domain. The weekly marketing report tutorial shows that setup step by step.
Roster cost scored 4: two Team seats cost $90 a month ($72 billed yearly), whatever the client count. That makes 20 of 25 in total.
Price: Free (50 credits every 30 days, no scheduling), Pro $25 a month ($20 billed yearly), Analyst $90, Team $45 per seat (2-seat minimum). Best for: agencies whose slow part is building and defending the numbers, not branding the report.
The headline price can mislead you, because marketing agency reporting tools charge for different things: clients, data sources, dashboards or seats. Here is the monthly licence cost for three mixes of client count and data sources. We used prices billed yearly where offered, and the table shows the formula for each tool.
| Tool | How it charges | 10 clients × 3 sources | 25 clients × 2 sources | 5 clients × 10 sources |
|---|---|---|---|---|
| AgencyAnalytics | $20 × clients | $200 | $500 (volume pricing offered at 25+) | $100 |
| Swydo | $62 incl. 10 sources + $4.50 × extra sources | $152 | $242 | $242 |
| DashThis | Smallest plan that fits dashboards and sources | $139 (Professional) | $279 (Business) | $279 (Business; 50 sources) |
| Whatagraph | Max, from 50 credits | From $1,118 | From $1,118 | From $1,118 |
| Databox | Agency $79 (4 accounts, 20 sources) + $20 per pack | $199 | $499 | $199 |
| Data Studio | Free; Pro $9 per user per project | $0 + build time | $0 + build time | $0 + build time |
| ChatGPT | Per user, not per client | $0 to $20 per user | $0 to $20 per user | $0 to $20 per user |
| Anomaly AI | Per plan or seat, not per client, with monthly credits | $20 to $25 (Pro, 1 user); $72 to $90 (Team, 2 seats) | $20 to $25 (Pro, 1 user); $72 to $90 (Team, 2 seats) | $20 to $25 (Pro, 1 user); $72 to $90 (Team, 2 seats) |
Two notes on the AI tools. ChatGPT and Anomaly do not charge per client, but your usage counts against a plan allowance. Anomaly's plans include monthly credits (1,000 on Pro), and its pricing page puts a 10-card dashboard at about 7.5 credits, so check your monthly report count against the allowance. Per-client platforms also buy you things the AI tools do not include, such as a branded portal for each client.
Automated client reporting means the report pulls fresh data and sends itself. Two details decide whether yours really does. First, the source: a connector re-reads GA4 or Google Ads on each run, while an uploaded export is a snapshot. When we scheduled the client B report in Anomaly, it asked us to confirm scheduling "static uploaded data". A dashboard built on uploaded files does not change until you replace them.
Second, the date range: a report fixed to "September vs August" will not move to October by itself. Anomaly flagged that too and offered to make the period roll monthly. An Anomaly schedule can also be set to "Only when something happens": it checks on every run and sends by email or Slack only when, say, cost per key event passes a threshold. The agency platforms schedule reports from live connectors as their core feature, and Data Studio can email a PDF on a schedule.
Whichever tool runs your automated reporting for clients, test one scheduled send with next month's data before you promise it. Whether a client should get a live dashboard or a reviewed report is its own question. We cover it in send clients a dashboard or a report.
AgencyAnalytics alternatives come up most when the per-client bill grows faster than revenue. If you are weighing an agency analytics alternative, check four things before you switch.
| If your situation is | Start with |
|---|---|
| Every client expects a branded login and a white-label PDF, and their data sits in connected accounts | AgencyAnalytics (19/25), priced per client |
| Many small clients with one or two ad accounts each | DashThis (18/25) on a plan that fits your dashboards and sources; price Swydo's per-source plan against it |
| You work in Google's tools and will build every report yourself | Data Studio (18/25 in our test), and budget the build hours |
| The slow part is rebuilding each report from exports and defending the numbers | Anomaly AI (20/25), if you can accept that it is not white-label |
| You need a quick answer from a client's exports before a call | ChatGPT (17/25) on the files, then check the numbers |
| A large team blending many sources into heavily branded reports | Whatagraph, after a demo and a price quote for your clients |
If your clients' data is in Google's tools, Anomaly can connect Google Ads and Search Console or analyze GA4 data directly instead of reading exports. Its connectors page lists every source it reads.
Part of the problem may be your workflow rather than your tool. If you already know your tool, these guides cover the steps: build a repeatable client dashboard from messy CSVs and turn an upload into a client-ready PDF. For GA4, see how to turn a GA4 Exploration export into a client report and what belongs on a marketing dashboard.
A client report is the recurring summary an agency sends each client, usually monthly: spend, results, what changed and what happens next. It pulls from the client's accounts, such as GA4, Google Ads and Search Console. A good one lets you explain any number the client asks about.
Monthly is the usual cadence for a full report, with weekly updates for fast-moving paid campaigns. Match the cadence to how often the client makes decisions. A schedule only helps if the data refreshes: a report built on uploaded exports resends old numbers until you replace the files.
Use five checks: intake and refresh, next-client setup, trace a number, delivery and roster cost. Intake covers how each client's data gets in and updates. Delivery covers white-label, a portal and scheduled email. Roster cost is the price at your real client count.
It depends on your roster's shape. For 10 clients with 3 sources each, monthly licence costs were DashThis $139, Swydo $152, Databox $199 and AgencyAnalytics $200, billed yearly. Data Studio has no licence fee but costs build time. ChatGPT and Anomaly charge per user or plan, not per client.
For simple branded dashboards, DashThis reached the right number in our test after a manual build. For many small clients, price Swydo's per-source plan; for large teams, Whatagraph, which we could not test. Data Studio has no licence fee. If your pain is analysis, Anomaly AI traced the number but is not white-label.
Partly. In our test, Anomaly AI analyzed the files, traced cost per key event and scheduled a PDF email, without white-label branding. AgencyAnalytics' AI also traced the number, and its portal delivers branded reports from connected accounts. ChatGPT got the numbers right but, on the Free plan, does not schedule anything.
Pick the client reporting tool that removes your slowest step. If that step is branding and delivery at scale, the agency platforms are built for it: AgencyAnalytics' assistant built and traced client B's report from our files, and DashThis got there with a manual build. Price them for your number of clients first. If the slow step is rebuilding each client's report from exports, Anomaly AI built client B's report in 2.3 minutes and showed how it got the number. Data Studio reached the same number for free with more manual work, and ChatGPT did for a one-off check. Use the six test files to hold every trial to the same standard.
Create an Anomaly account and build a client report you can trace
Continue exploring AI data analysis with these related insights and guides.

Follow a customer segmentation analysis example using RFM. Download the dataset, check refunds and duplicates, and build a customer review list.

Export the report you need, refresh it when necessary, and check the numbers before turning it into a weekly traffic update.

One weekly marketing question, asked from Claude Code through Anomaly’s MCP server and traced to its SQL and rows, with the daily-users trap worked out in the open.
