Impressive speed, scaling abilities and reliability
We are using y42 to handle the Data of over one hundred sources. The probability of errors and failures happening in our processes of transforming and cleaning data is relatively high and there have been many issues with other tools we used for this task before. With y42, there were no system issues or bugs that stopped our pipelines from working. This is really the game-changer for us.
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.
Reasons for choosing Y42
Descriptive Analytics, Filters and Grouping: Whenever you are inspecting the data inputs or outputs, you get descriptive analytics (huge advantage compared to google sheets solutions), filter options, the ability to only show certain columns (quite handy) and the option to group by a certain column. The last one really helps when extracting information from a json object when you don’t know, what keys are available for example. So working with the Data is really easy. Ease of use: Although you can do some pretty complex stuff with y42, it is quite self explaining for users, that don’t have a coding or analytics background. Also: Being able to visualize every connection makes it really easy to explain, what was built.
Reasons for switching to Y42
Stability: With Supermetrics my main problem was, that queries took so long that they did not finish some times. This happened especially when pulling ad level data on a daily basis for multiple accounts. With y42 I just pulled this data from 01.01.2019 until mid 2021 with two clicks, it ran successfully and now it is updating incrementally every 12 hours. This is a huge deal.