Dataddo Use cases

SAT-7 streamlines data operations with Dataddo

SAT-7, a satellite television network, extensively uses Facebook as a communication channel to reach its viewers across many countries in the region of the Middle East and North Africa. With over 50 different Facebook pages, getting the right insights and managing all the data required a lot of manual tasks. Also, because Facebook Insights have certain limitations, when it comes to reaching historic data and combining metrics, a service capable of automatically collecting and storing SAT-7’s data was required.

After Dataddo was deployed, data from all SAT-7 Facebook accounts are automatically collected and transformed on daily basis, saving many man-hours of laborious and boring work.  Moreover, because SAT-7 reporting requirements go far beyond standard Facebook Insights capabilities, Dataddo integrates the data across all the accounts and combines them with other offline data into one consolidated dataset. Such output is provided via the Dataddo API to SAT-7 business intelligence and dashboard software.

According to Andrew Hart, SAT-7’s Chief Operations Officer, “working with Dataddo has greatly simplified our reporting and given us access to trend data and insights that we were previously unable to generate. The team was helpful in accommodating our specific requirements to make this project a success and the pricing model was much more competitive that other offerings.”

SAT-7 is a Christian satellite television network broadcasting in Arabic, Persian and Turkish across 22 countries in the Middle East and North Africa, along with 50 countries in Europe. SAT-7 was founded as a non-profit organization in 1995 with support from Middle Eastern churches. SAT-7 is the first, oldest and largest Christian satellite organization operating in the Middle East and North Africa. According to 2016 data, the annual audience of its channels is estimated to be in the region of 25 million viewers.

Dataddo is a provider of cloud-based data platform allowing automation of the whole chain of operations ranging from extraction, integration to transformation and analytics. The platform works well with data from various web services, SaaS applications, offline business data or data from smart meters and sensors. With HQ in Prague, Czech Republic, Dataddo is currently serving more than 1200 clients from 85 different countries with state-of-the-art software.

Dataddo Use cases, Social media analytics, Strategy, Web analytics

Data analytics, the next big challenge for businesses

In today`s world, businesses are increasingly data driven. In fact, it is not uncommon that average business is using CRM for clients and leads management, some business intelligence tool to dig deeper into financial perspective, services like Google Analytics for tracking websites, Google AdWords for on-line campaign management or perhaps some social network management tool as well. Having immediate information about the performance of various part of the business is always great, however, it has a dark side too. With more and more data pouring from such services and more new services and tools being used, orchestrating the whole system is becoming a rather unbearable burden. Just imagine, if you really want to get the most of each data source and service, how many experts you would need. To make it even worse, many such services naturally do not talk with each other, therefore getting big picture is a rather laborious task. Usually, someone on regular basis does have to manually get all the datasets and somehow make any good use of it.

Solution? Automation of data-handling processes!

In Dataddo, we are all data-freaks. Having such mindset is giving us the opportunity to understand the importance of being effective when it comes to working with the data. Our mission is to transfer this knowledge to our clients and to help them to transform the liability of ever-growing amount of data into their advantage. As an example, our client, one of the largest marketing agencies in the CEE region, is managing hundreds on Facebook campaigns on behalf of its customers. At the beginning of each month, they had to report performance figures of each campaign – a dead-boring job that originally took 4 business days and required an assignment of two analysts. The whole chain of tasks, from obtaining the data itself, through data transformation to delivery to client`s endpoints, was automated by Dataddo. After the deployment of our software, the client can now dedicate 8 man-days for further development of its business.

Dataddo is a provider of out-of-the-box solution that directly connects to services like Google Analytics, Facebook Ads Insights or Twitter Analytics, automatically in given period downloads the desired datasets, can apply various transformations such as currency conversion, formula computation, text concatenation, integrates datasets from various sources, and even encrypts the data and deliver them to your server via SFTP, email, API or directly push them to your database. Besides that, part of the package is an integrated data visualisation framework that will help you to distill complex data into easily-digestible business dashboards. And the best part is that Dataddo provides a FREE account with full functionality, so feel free to try it!


Dataddo Use cases, Social media analytics, Uncategorized, Web analytics

Dataddo 1.5 is live!

In first days of December 2016, we have successfully launched version 1.5 of Dataddo Web & Social analytics platform. Besides adding new features we took a particular focus upon improving user interface. Here is a shortlist of all new features and improvements available in the new version:

New data explorer

The most visible step forward is the complete revamp of Data explorer, particularly the ability to directly pin data from Data explorer to Dashboard is something our users have been long calling for. Moreover, we have added new filtering options, so from now on you can use relative date expressions to filter out your data (such as “last month” or “yesterday”) or complex reqular expressions for strings.

New structures

Though the upgrade of structures might not be directly visible, the sources within structure can be in version 1.5 binded together by indexes containing more than one column (as opossed to strict one-column indexes in prior versions). Also, we have upgraded virtual columns (AKA calculated metrics in Google Analytics’ language), so from now on, you can add if … else … statements inside virtual column definitions.

Exports & data excryption

For security-aware users we have added an option of data encryption for data exports (both automatic and on-demand) using OpenPGP standard. Moreover, ability to export your data as JSON string was added.


Dataddo Use cases, Social media analytics, Web analytics

Calculated metrics for Google Analytics, Facebook Insights or Twitter Analytics using Dataddo

In October 2015 Google announced the availability of calculated metrics. Although it is a really powerful feature, there are some drawbacks as well, especially when you need to define more than 5 metrics per view or you need to work with other than numeric-type data.

Dataddo contains a great feature called Structures that besides merging the data from multiple sources together allows you to define almost unlimited number of calculated metrics based on the any data available within the structure. Therefore using Dataddo your calculated metrics definition is not just limited to Google Analytics, but also available for Facebook Insights as well as for Twitter analytics (or any other data ingested to Dataddo).

Please find more information about Dataddo Web & Social data analytics platform.


Dataddo Use cases, Social media analytics, Web analytics

Google Analytics and Facebook Ads Insights currency conversions

Both Google Analytics and Facebook Ads Insights have superb ability to track performance of your ecommerce site or cost of marketing activity respectively. But, when you need to report the activity in multiple currencies or to compute specific financial metrics, the usual approach of most users is to export the data to some spreadsheet editor and do the computations / transformations manually. This advance is rather clunky, especially when performed in regular manner. Fortunately, Dataddo offers a solution enabling you to automate extraction of the data from both Google Analytics and Facebook Ads, transformation of such data, definition of computed / concatenated metrics and final data delivery in the form of visual dashboards or even raw data. This set-up can completely offload boring and labour-intensive tasks to completely automatic system. Following lines will give a brief introduction of how this can be achieved.

Obtaining the data

In Dataddo, data from various services are stored in Sources. In this example we load data from Google Analytics representing daily break-up of revenues (USD) in April 2016 (ga:date as dimension and ga:revenue as metric). Data can be also automatically synced or incrementally stored.

Google analytics connectorGA source explorer

Defining the structure

Structures in Dataddo are data transformation facility. It can contain one or multiple source. For our case of currency transformation, we will add just Google Analytics source to the structure.

GA data transformation

Transforming the data

For currency transformation we need to define computed column with simple formula that will transform the values in USD to values in EUR and GBP. And voila, we are done!

GA currency transformationGa transformed currencies

Dataddo Use cases, Social media analytics, Web analytics

Dataddo Web and Social analytics platform 1.4

I am proud to announce the immediate availability of Dataddo Web and Social analytics platform version 1.4. Besides further improvements of the system performance and few bug fixes we have added many great features that enhance capabilities of the whole platform. Here is a shortlist of them:

Facebook Ads Insights connector

Besides standard Facebook Insights we have added the capability to extract the data from Facebook Ad Insights as well. Similarly to other connectors, we provide full graphic UI requiring absolutely no knowledge of Graph API. Moreover, full automation capabilities are available for this connector as well, therefore you can easily automate extraction and exporting of Facebook Ads Insights data.

Computed columns

We have re-worked the structures and added to possibility to define you own computed or concatenated columns. This feature is particularly useful when you need to construct you own metrics based on existing data or for currency conversions.

Data formatting

Another great enhancement of the structures is the ability to define output format of the data. We currently support various currencies, percentage, decimals and date & time formats. We will be gradually the new formats in the future.

Automation management

In order to give our users better control of all automated actions, we have created a dedicated interface with the ability to track, test and debug each automated action.

Beyond new feature and enhancements I would like to promote our new explainer video, hope you gonna like it 🙂

Dataddo Use cases, Social media analytics

Retrieve Facebook Insights data using Dataddo

When managing Facebook pages or running campaigns you are probably using Facebook Insights to gather some information about the performance and effectiveness of your activities. Although it provides some valuable information (and for free!), in some areas, particularly when you need long term data series or customized data-sets, the functionality is not sufficient enough. Of course, you can use some paid social analytics tools, but they are usually rather overpriced, offering pre-fabricated reports with self-constructed metrics and questionable meaning (see my previous blog post about common misinterpretation of engagement rate).

Going beyond Facebook Insights

Beside Insights, Facebook provides robust Graph API allowing you to extract complex raw-data, but exploiting its full potential requires a certain level of knowledge in programing as well as in database technologies, therefore building your custom reporting solution consumes considerable amount of man-hours in development. Fortunatelly, we have developed Facebook connector for Dataddo, allowing you to fully leverage Facebook Graph API without coding.

Track page, post or video performance

Dataddo Facebook Insights connector allows you to retrieve multiple metrics, covering your FB page, posts and videos performace. Utilizing full features of Facebook Graph API, Dataddo can offer much more metrics than those available within standard Insights interface, plus you can leverage Dataddo platform for alteration, integration and visualization of the data.


Do you want to track total views of each video on your Facebook page or their engagement? Need to monitor consumption, impressions or likes of each of your post? Do you have self-constructed KPIs for your Facebook activities? All this and much more can be covered by Dataddo.

Automated data collection

One of the great drawbacks of Facebook Insights is the lack of historic data and limited export capabilities. Dataddo Facebook Insights connector allows you to automatically retrieve defined metrics-set in given periods. All the data incrementally built-up in Dataddo allowing you to get vital business insights in greater granuality and much deeper detail as well as to long-term track you Facebook activities.

GA data sync

Advanced analytics

Once your data are successfully loaded in Dataddo, you can enjoy the great analytics capabilities of the platform such as automated data profiling, data visualization or advanced data filtering. Also you can mash facebook insights data with others using data structures. To have all your business insights easily accessible, you can utilize business dashboards and shortscuts. Moreover, data-sexuals would embrace the ability to access the data in mobile devices 🙂

New Data explorer

More information about advanced extraction of Facebook data.