Let's talk about some of the common use cases we see for Piped Out.
The larger the website, the harder the data is to work with and more time you spend trying to process it.
Spreadsheets slow down, you hit row limits, sampling becomes more common.
The more data you have the more valuable you'll find Piped Out.
The bigger the site, the more attention you need to pay to crawling and indexing and log files are one of the most useful data sources for fixing these issues.
But on big websites, logs get correspondingly large and require dev work to make them accessible.
We work with your dev team to get logs accessible and easy to work with.
The larger the website, the more valuable it is to register those properties.
We have found customers who got over 250% more search console data by registering sub-folders.
When you need to aggregate those profiles, that's where we come in. We can bring all that data together and make it easy to work with.
The problem here is large and obvious. Each website you work with has its own set of data.
If you work with 5 websites, you have 5x the number of data sources all of which need to be brought together.
We help you pull all those segmented data sources into one place and make switching websites as easy as changing a drop down.
If you have multiple websites the other thing you're familiar with is reptition.
Different teams need their own sets of numbers, reports and analysis have to be repeated over and over again.
We're set-up to make reptition quick and easy, and we'll save you hours of time.
We build everything in a way that allows to aggregate across websites as well.
If you need to build single reports or dashboards to manage/view a portfolio we're set-up to make that easy as well.
We make it easy to combine and segment data sources.
You can easily add on your own filters and segments with a logic builder.
You can also easily aggregate multiple web properties together to show them all on one dashboard/report with just a couple clicks.
We (primarily) use BigQuery for building the data warehouses.
It connects with all of the popular reporting platforms, Data Studio, PowerBI, Tableau etc.
Want to see year on year traffic for a portfolio of sites split by brand and non-brand? We've got a query for that.
Want to report on traffic and crawling across a migration? We've got a query for that.
Want to see traffic over time for a specific list of pages, or each template on your websites? We've got a query for that.
Data Studio is a brilliant free product. People often bump into problems when they start trying to process data in Data Studio.
Default data studio connectors can do the most basic of calculations, but not much more and they're not meant to. Data Studio is primarily about display.
With Piped Out all the data processing will happen in BigQuery and leave you with an easy quick Data Studio experience.