Audience Audit completes more work in half the time
To make its unique research accessible to a wider range of agencies and their clients, Audience Audit wanted to lower the cost of its projects and deliver results more quickly, without deteriorating the quality of the research.
Using Tableau, Audience Audit has lowered fees by up to two-thirds, reduced project timelines by 50 percent and substantially increased work capacityâall while improving profit margin, increasing customer satisfaction and driving new project sales by a factor of four.

Making market research faster, easier--and prettier, too.
20 Hours Working with Data Before Chart-Building Begins
Susan Baier, the owner of Audience Audit, had a unique product that agencies lovedâbut she wanted to make it accessible to a greater portion of their clients. Doing so would require shortening the timeframe and lowering the cost of her custom segmentation projects.
Audience Audit projects follow a common process: Baier designs and delivers a targeted online survey. When the results are in, the company performs statistical analysis of the data; the output is rendered in Excel.
This Excel file is the foundation from which Baier creates customer-facing presentations to communicate her findings.
âI spent, easily, 20 hours just working with the data before I could start building chartsâand Iâm fast with Excel! But every project is different, and you have to build every one of those little pivot tables to get the data that you need to build the chart you want.â
This time-intensive, manual process had to be replicated any time there was a change to the data. âIf something changed, then I had to go update everything individually!â Baier says.
After this process was complete, Baier would build her charts in presentation software, which took more time.
âThese are big studies, and I need to report a lot of findings to people who aren't research peopleâor not even marketing people, sometimes. The presentations would be hundreds of slides long because I had all this data I had to share with them,â she says.
And simply outsourcing this time-intensive work wasnât an option. Susanâs years of experience in marketing and business strategy are the âsecret sauceâ that allows her to parse out key insights in the data, and share its story with her clients. She simply has to work through the data herself, evaluating results and determining how best to show them.
"The Output Has to Look Great"
âIâve been doing marketing strategy for 25 years. It's not value-added for my client to have me building charts. What's value-added for my clients is the data, my interpretation of it and my assistance in helping them understand it. Building the charts is only one step in the process, but it has to happen for me to see what the data says, and for my clients to see it too.â
A self-described âdata nerd,â Baier admits that capturing her customersâ attention could be challenging.
After all the investment and effort involved, expectations were high. âClients donât want to pay thousands of dollars and see their results in an Excel file. The output has to look great.â
Baier recognizes that not everyone gets as excited about market research as she does.
âWhen I share results with clients, there are always people in the audience thinking, âSigh. Here we go. Two-hour market research presentation,â Baier says, laughing. âIâm always excited about what weâve found, and I try to bring that energy to the client presentation. Having visually interesting charts helps a lot.â
Light Bulb Moment
Making her work more accessible to agency clients would require some major changes. âI knew what agencies could do with this data,â she says. âBut in order for them to use it for the majority of their clients, I had to develop a project with a lower price point, and a faster schedule.â
In the spring of 2012, Baier realized she already had a tool that might helpâTableau. Baier first heard about Tableau in the mid-2000s, and had lobbied previous employers to use it. When she opened Audience Audit, she purchased a Tableau Desktop license.
Baier had played around with Tableau in a PC environment on her Mac, but hadnât had time to work with it extensively.
âI was trying to figure out how to make this major shift in the business, and all of a sudden it was like the light bulb went onââOh, wait a minute. I have Tableau, maybe this would help,ââ she says.
She wanted to get up and running quickly, so Baier decided to ask for help. Baier had been following Michael Cristiani of Powerhouse Factories, a leading Tableau Community member, on Twitter, so she contacted him and offered to hire him to build an initial workbook.
âHe was great. We went through a few rounds, and I came out with a small workbook, four or five worksheets that he built to show the data the way I wanted to show it.â
Baier then tried to replicate the workbook herself. âI basically reverse-engineered it and figured out how he built it, and he was great about answering questions when I was stumped. Before I knew it I was doing stuff on my own, adapting, incorporating different views and finding new ways to explore my data.â
Baier now uses Tableau exclusively for presenting results to clients. âI hardly ever do any kind of a Keynote presentation anymore. Sometimes I have clients who want that for executives, but 90 percent of my projects just go out in Tableau.â
She appreciates the ability to allow her clients to dig into their own data through using packaged workbooks and the free Tableau Reader application.
âI can add filters and give them a workbook that allows them to look at their data in different ways, export chart images for their own presentations, or download crosstabs for their own needs. Some of my clients donât want to do that, so I send them a PDF of the workbookâor if they want specific images of particular slides for their own presentations to their client, I can export those.â
With Tableau I can see things that I couldnât see before, because I didnât have the ability to look at data in all the amazing ways that Tableau has built-in.
âI Hit That Sweet Spotâ
While the advanced statistical analysis portion of Baierâs services remain the same, she estimates that using Tableau allows her to complete the rest of the analytics and deliver results 90 percent faster than before.
âSince incorporating Tableau into our work, weâve increased our project load by a factor of eight, our timelines have reduced by 50 percent and our revenue has increased by a factor of four,â Baier says.
âTableau has taken a tremendous amount of time out of the process.â
While Audience Audit projects are customized for each client, the surveys and results files frequently share similar formats. This has allowed Baier to create some standard visualizations.

âWhen I have a new project, I pull up that workbook, switch out that data source to the new one, and I'm 80 percent of the way to a completed visualization for that set of data. So thatâs hugely time-saving,â she says.
This has allowed her to meet client needs at a speed simply not possible previously.
âFor example, we have a client with a big conference coming up, and they want this data,â Baier says. âWe just closed down the survey and dumped the data on Monday, ran the analytics like a bat out of hell, and Iâm in Tableau todayâThursdayâvisualizing it for the client. I'm going to be able to show that to the client a week after the survey closed. Before Tableau, there's no way we could have delivered on that deadline.â
And now if there is a change to the underlying data, Baier easily makes updates through Tableau. âNow I donât have to go and change each one of those darned pivot tables!â she says. âEither there's already a calculation in Tableau to do it, or I can build one to do it automatically.â
While Baierâs productivity has gone up significantly, she is proud to point out that quality has gone up, too.
âMy favorite part is digging into the data weâve collected. With Tableau I can see things that I couldn't see beforeâbecause I didn't have the ability to look at data in all the amazing ways that Tableau has built-in. So our work is betterâin addition to being way more fun!â
Baier has saved so much time using Tableau that she has been able to make a better profit margin despite lowering her project rates.
âSince I started using Tableau, I've been able to reduce the fees on my projects by up to two-thirds with a higher margin per hour,â she says.
âOnce Iâd tested this new process incorporating Tableau, I rebuilt my website, launched new pricing, new timelines, and we're off and running,â Baier says. âI hit the sweet spot where I could give my clients exactly what they wanted at a highly competitive rate, very quickly, very efficiently, and take on more projects.â
âMy Clients Love It!â
Now that Baier is using Tableau visualizations to present her findings, she is seeing more enthusiastic client reactions.
âInevitably, my clients love itâthey love it! Honestly, if I can get clients excited about looking at research data, that's a win. Nobody does that. And it's definitely easier with Tableau than it was before,â Baier says.
She attributes some of that enthusiasm to her new ability to answer customer questions on the fly. âIt's not a static chart. It's linked to underlying data, so it's a conversation we can have and explore together as we go through it,â she says. âThat âlet me show youâ part of TableauââLetâs click on this and look at the differences.â The immediacy is great. I can watch my clientsâ jaws drop when they see the charts change with a click. And I simply can't do that any other way,â Baier says.
Her agency relationships have become far stronger in the year since she has implemented Tableau. âThe most telling statement is that I have agencies incorporating our research into the work they sell to every client. To me, that's a huge vote of confidence. They see our work as a critical step in what they do.â

âIf I Didnât Have Tableau, Iâd Be a Wreck.â
Another, more personal, benefit for Baier is that Tableau has helped her to keep her business small while meeting her business growth goals.
âTableau has given me a way to grow dramatically without having to take on folks to do repetitive Excel work. There will come a time when I may need to hire, but Tableau has pushed my bandwidth problem off substantiallyâand when I do, I can hire people who will add value and find the work as interesting as I do.â
Baier canât imagine going back to her old way of doing business. âTableau has become such a seamless part of what I do now. It really is responsible for what my business looks like today,â she says. âI started incorporating Tableau in this way just a year ago, and it has transformed what I've been able to do with my business just in that year . And a Mac version on the way? I canât wait!â
She continues, âIf I didnât have Tableau anymore? Iâd be a wreck. And youâd have a lot of unhappy agencies âand one very unhappy husbandâto answer to!â