Google Sheets reports

One of our most useful tools of late has been Google Sheets which lets us easily manipulate data and build reports on the fly.
A special add-on exports data from Google analytics and merges it with CRM, third party API or table data allowing us to generate unique reports calibrated to an exact set of requirements.

Google Sheets works best when you know the exact report you need, such as:
What CostPerOrder value do we have per ad channel, only for paid orders?
CRM

OrderID
Revenue
Profit
Order Status
Google Analytics

OrderID
CampaignKey
Source
Medium
Campaign
Table

CampaignKey
Ad Cost
API vk.com

CampaignKey
Shares
Likes
Examples of reports:
Here, each campaign is a paid post in social media. We collated some data from analytics like users and source; some from API, likes and shares; order status and profit from CRM; and this was added to the adCost data already present in the spreadsheet.

As you can see, bringing all this data together into one report has allowed us to effortlessly pinpoint the most successful campaigns and further manipulation of this table would allow us to sort and compare these using all of the metrics present.
Here we can see another example of a Google Sheets report. We can visualise historical data from Analytics — a function which is unable to be performed in Google Analytics. This output shows us at a glance the funnel of page visits.
Pros

They are regular tables and all data is visible so you can modify formulae,
Reports are updated daily,
There are report templates — just copy and paste in your data,
Easily to import third party data,
Allows you to work with retroactive data,
It's free!
Cons

If you want to make new reports, you need to have some knowledge,
It's not suited to experimenting or trial and error, you have to know what report you need.
Cell limit — it can be hard to work with thousands of rows.
Best practice is to slice and dice data in Google Analytics searching for some insights, and then make focussed reports based on mixed data.

Book your consultation