Services
Switchboard Partners does three kinds of work for small and mid-sized businesses: deciding what is worth measuring, connecting the systems that hold the answers, and reading what those systems say once they are connected.
Most engagements start with the buildout, because it is difficult to advise on numbers that do not agree yet. All of it is delivered by one senior analyst, start to finish.
Three kinds of work
Consulting services in the field of digital marketing.
Deciding what is worth measuring in the first place. Which channels deserve more budget, and which are being credited for work they did not do. Which of the reports you currently rely on are quietly wrong, and why. This is the part of the work that is judgment rather than plumbing, and it is where fractional analytics leadership sits.
Technical consulting in the field of marketing.
Building the thing that makes the judgment possible. Pipelines from Google Analytics, HubSpot, and your ad accounts into a BigQuery warehouse in your own cloud account. Then the part that matters more than the plumbing: one agreed definition, written as code and version controlled, for every number your marketing and sales teams argue about. What counts as a lead. Which spend belongs to which campaign. Which closed revenue traces back to marketing activity and which does not. Then the reporting on top of it, in Data Studio.
Analyzing and compiling business data.
Reading the result and saying what it means. Reconciling your CRM against your ad platforms so that cost per lead and cost per opportunity stop disagreeing. Working out what acquisition costs you, by channel. Telling you what changed this month, whether it matters, and what to do differently. And underneath all of it, the question that gets asked in the room: how much closed revenue your marketing can be credited with.
What this is not
This is not statistical attribution modeling, and it is not marketing mix modeling. Both need more data and more budget than a company your size should be spending on the question, and anybody selling you one at this scale is selling you a number with a confidence interval they have no intention of showing you.
What you get instead is less clever and, at this size, a great deal more useful. Every system counts the same things the same way. So when you look at the same revenue through first touch and then through last touch and get two different answers, which you will, both are built from the same facts, and the meeting is about the gap instead of about whose spreadsheet is right.
What you do get is attribution you can check. If someone clicks a Google ad and fills in your form, the reporting tells you which campaign and which search term brought them, rather than filing it under "Google" and leaving you to guess.
It also handles the awkward details that quietly misfile leads. HubSpot, for instance, records where a lead came from a moment after the form is submitted rather than at the same time. Read it at the wrong moment and a lead your campaign paid for gets credited to direct traffic. Getting that right is unglamorous and it is most of the job.
And the numbers are counted rather than estimated. Every figure is built from records that exist, so when one looks wrong there is somewhere to go and find out why. That is the difference between a number you can defend in a meeting and a number you have to take on faith.
Warehouse buildout
Fixed fee, from $5,000. Four weeks.
Week one: the questions, and the state of the tracking
Nothing gets built until the questions are written down. We list what you already ask every month and cannot answer quickly, in your words, with the decision each one would change. That list becomes the scope, and it is what the finished work gets measured against.
Then the less comfortable half: checking whether the data needed to answer those questions is being collected at all. Sometimes it is. Often a form is not tracked, a conversion fires twice, campaign names have drifted so far that nothing groups cleanly, or the CRM has three fields that all mean "where did this come from" and disagree.
Connecting systems does not fix any of that. It just moves it into one place where it is easier to see. So you find out in week one rather than week four, and if collection has to be repaired before the reporting means anything, you get told what that costs before anything gets built.
Weeks two and three: the build
Your Google Analytics, CRM, and ad platforms get connected and start landing in the warehouse daily. Then the raw data gets shaped into the things your business talks about, using the definitions agreed in week one, with automated checks that fail loudly when a source stops sending. All of it is built in your Google Cloud project, under your billing account, in a repository you own.
Week four: reporting and handoff
One Data Studio dashboard, built against the week-one list rather than a template. Then documentation, a walkthrough with whoever will be looking at it, and a written note of what would break it and what to do when something does.
What is included
- Discovery and the written question list
- BigQuery warehouse in your own cloud project
- Google Analytics, CRM, and ad platform connections
- A written definition for every metric that appears on the dashboard
- The transformation layer, version controlled, with automated data checks
- One Data Studio dashboard
- Documentation and a handoff session
- Thirty days of fixes after handoff, at no charge
A note on CRMs
HubSpot is where this work is most straightforward, because HubSpot already collects most of what you need and hands it over willingly. Other systems vary more than their vendors suggest. Salesforce with Pardot in particular keeps a lot of what matters in places that do not export cleanly, and assembling a full picture there involves more manual work than anybody would like.
So if that is your setup, say so on the first call. I will tell you what is achievable and what it will cost in effort, which is a better conversation to have in week zero than in week two.
What moves the price above the floor
$5,000 is the floor, and plenty of builds land above it. Three things move the number: how many sources need connecting, what condition your CRM is in, and how many things need agreeing and defining before the numbers mean anything. You get a fixed figure before any work starts, and it does not move afterwards unless you change the scope.
What it costs to run afterwards
Everything runs in your Google Cloud account, on your billing. There is no license fee to me and nothing is marked up through me. It is worth knowing the number before you start rather than discovering it on a statement.
Two things cost money: running the pipeline that pulls your sources on a schedule, and BigQuery storage and queries. The pipeline software itself is open source, so what you pay for is the compute it runs on. Data Studio is free.
For a business your size this is usually tens of dollars a month rather than hundreds. It scales with how many sources you have and how often they refresh. You get the figure for your setup in writing with the quote, before you commit to anything.
Ongoing analysis
From $1,500 a month. Month to month, 30 days notice, no minimum term.
A warehouse nobody maintains is worth less in month six than it was the day it was built, because by then it is wrong in ways nobody has noticed. Platforms change how they hand over data. Google Analytics changes. Somebody renames a campaign and it quietly stops being counted. Your business adds a channel, or sales changes what it calls a qualified opportunity, and the reporting carries on answering last quarter's question.
That is the unglamorous half of what a retainer buys, and it is not optional.
What is covered
- Monitoring, with alerts when a source stops delivering
- Pipeline repairs when a platform changes something
- Definition updates when your business changes what it counts
- A quarterly review where somebody senior reads the numbers out loud
The fuller version
Above the floor, the engagement swaps the quarterly review for a monthly working session, adds questions answered between sessions, and handles definition changes as they arise rather than as a project. Companies that are actively changing something usually land here. What it costs depends on how much of your reporting is moving, and you get a number before you commit to anything.
Fractional analytics leadership
By conversation.
Some companies do not need another dashboard. They need one person who is accountable for what gets measured: someone who decides which questions matter this quarter, who will tell a founder that the attribution model everybody likes is not telling the truth, and who can brief an agency or a contractor without being oversold to.
That is a different engagement to a buildout, and it is priced by conversation because it depends entirely on how much of your measurement thinking you want to hand over. Only a small number of these run at a time.
What this costs, next to the alternatives
Nobody in this category publishes a price, so it is hard to tell whether $5,000 is a lot of money. Here is the choice.
| Option | Cost | What you end up with |
|---|---|---|
| A reporting subscription | $200 to $500 a month | Your data moved into charts. Nothing has decided what counts as a qualified lead in your business, and nothing reconciles your CRM against your ad spend. |
| Hiring a senior analyst | $120,000 to $175,000 a year | A full-time person, if you can find a senior one who wants to be a team of one. |
| An enterprise consultancy | $40,000 to $150,000 to build | The right work, priced as though you were an enterprise. |
| Switchboard Partners | From $5,000, then from $1,500/mo | The same work, sized for a company between $5M and $50M. |
Salary figure is a fully loaded estimate. Chicago base salaries for senior marketing analysts and analytics managers run roughly $97,000 to $147,000 depending on the source; the range above adds payroll taxes and benefits. Enterprise buildout figures are from published vendor guidance rather than quotes.
What these engagements do not include
These engagements are scoped and priced around the measurement work. They do not include media buying, creative, public relations, search engine optimization as a service, event work, recruiting, or building your website. If a project needs one of those, I will tell you what good looks like so you can hire it properly, and then get back to the measurement.
There is a reason to be blunt about that. When reporting is a line item inside a media retainer, it gets whatever attention is left at the end of the month, and it is being produced by the same people whose performance it measures. Here it is the whole engagement.
If you run an agency, the same work is available behind your brand.
Frequently asked questions
What does it cost to run after the buildout?
Everything runs in your own Google Cloud account. Two things cost money: the compute that runs the pipeline pulling your sources on a schedule, and BigQuery storage and queries. Data Studio is free. For a business your size this is usually tens of dollars a month rather than hundreds, and you get the figure for your setup in writing with the quote.
What happens if we stop working together?
You keep everything. The warehouse lives in your Google Cloud project, the transformation code sits in a repository you control, and every definition behind every number is written down. Another analyst can pick it up without calling me. Ongoing work runs month to month with 30 days notice and no minimum term.
Why not just buy a reporting subscription for $200 a month?
A reporting subscription moves your data into charts. It does not decide what counts as a qualified lead in your business, and it does not reconcile your CRM against your ad platforms so that cost per lead and cost per opportunity agree. That reconciliation is the work, and it is specific to how your company operates.
Do you build attribution models?
Not statistical ones, and not marketing mix models. Both need more data and more budget than a company your size should spend on the question. What you get instead is attribution you can check. If someone clicks a Google ad and fills in your form, the reporting tells you which campaign and search term brought them rather than filing it under Google. And the numbers are counted rather than estimated, so when one looks wrong there is somewhere to go and find out why. Worth saying that all of this depends on what is being collected in the first place, which is why week one of a buildout looks at the state of your tracking before anything gets built.
How long does it take, and what do you need from me?
Four weeks. In week one you give me an hour or two to write down the questions you already ask and cannot answer quickly, plus access to Google Analytics, your CRM, and your ad accounts. After that the demand on your time is one check-in and the handoff session in week four.
Send three questions
Send three questions you cannot currently answer. That is enough for me to tell you whether you are looking at a four-week buildout, a smaller audit, or something you should not spend money on at all.