Y42

Speed: The tool is incredibly fast, since it is running on BigQuery Data and Data previews are calculated with a sample. Most previews are ready in less than 10 seconds. I was also able to build the above flow while traveling by train, using only my iPhone hotspot.

Quality of Data: The Data I am getting for Facebook Ads is exactly what Facebook provides. So I can just use the Facebook documentation and also got access to a lot of information that Supermetrics e.g. does not provide. Although this information is not critical, it is quite nice.

Really easy handling of JSON Objects: They even got an integrated JSON visualizer so you don’t need to copy and paste the Objects somewhere. Also there is a JSON flattening option for the Import and a really handy way of extracting and transforming Information from JSON Objects.

Since the software is being developed so fast, there are some minor bugs from time to time. However, none of those caused the data to be off, because most of them were only happening in the user interface. This makes y42 one of the most reliable tools that I have ever used in this area.

Easy to set up data connectors and import various sources. As a total beginner to modelling and ETLs it was super easy to create the first joins and multiple transformations. The support is helpful and responding quickly.

Some nodes and features still need some finetuning when it comes to namings and how to's (eg. unpivot). Really looking forward to more alerting options for data quality checks and auto exports to email or gdrive. This is so far still rather manual.