What is it?👇️
A tool that scrapes data from various sources (e.g. Google Analytics, your CRM, ads platforms and many more!) into Google Sheets and Excel.
Who is it for? 💁♀️
Anyone in a startup team, such as founders, marketers and sales reps, who wants to collate raw data in one spreadsheet, making it easier to analyse and use in reporting.
What did we test? 🧪
We tested Coefficient's core functionalities by:
- Connecting our own Google Analytics, Google Search Console and LinkedIn Company Page accounts as three example data sources.
- Importing at least a couple of data sheets from each source, for example: "Channel Metrics by Month” from Google Analytics, showing which channels are driving our web traffic, and “LinkedIn Pages: Post-level Insights” from LinkedIn, summarising our Company Page posts and their performance metrics.
- Creating a Pivot Table and Chart, using the GPT Copilot.
- Setting up Automations to trigger an email and Slack message with screenshots of the Google Sheet data.
What we found 🔎
👍 Setting up the data sources and importing data sheets using the tool's suggested templates was very fast and intuitive.
👌 The Automations feature was our favourite. It sends snapshots of your chosen data to your email or Slack, reminding you to look back at your data regularly so it can actually inform your decisions!
🤔 However, a few things detracted from the overall experience:
- Limitations on native integrations – no Xero integration yet ("coming soon") and integrations with Salesforce, Hubspot, Pipedrive and Zoho but not newer CRMs (such as ConvertKit).
- The GPT Copilot looked promising but required trial and error to achieve an output, possibly making it easier to have done the task manually. A quick test of the AI features within Rows (an alternative tool – see below), showed Coefficient has some work to do here.
Pricing💰️
- Try it out with a free 30-day Pro plan trial (no credit card required).
- Then you’ll have the option to drop down to a Free plan (3 data sources and limited features).
- We’d expect most startups would need Pro ($100 USD/$150 AUD per month) with 6 data sources.
- If you're confident that it’s a tool you'll use ongoing, enquire about Enterprise level as 6 data sources will disappear quickly!
The verdict ✅
Overall, this is a great tool that we will look to use for our own business and with clients.
Although ~$150 AUD per month sounds steep for a fairly simple-sounding tool, we’d expect manually pulling this kind of data together for monthly reporting to take at least an hour so it should pay itself back in time saved. Plus, it should allow you to review data more regularly, driving informed decisions.
The alternatives ⚖️
There are various other tools that could achieve a similar result, such as:
- Rows (by Zapier): Very similar to Coefficient and potentially more powerful as you can connect a huge range of apps via Zapier, but it has its own spreadsheet interface (doesn’t connect with Google Sheets/Excel). Offers a free tier.
- Supermetrics: A marketer-specific tool with similar functionality to Rows but it integrates with other endpoints, including Google Looker Studio, and offers pre-built reporting templates so you don’t have to turn your raw data into a report. It’s significantly more expensive though, especially if you want more than the basic integrations (GA, FB Ads, Google Ads). No free tier.
