Uncategorized

CRA & Dataddo to Offer IoT Data Processing Platform

Ceske Radiokomunikace (CRA) is a provider of television, radio and internet infrastructure. CRA announced that they’re entering the business intelligence and big data market segments as part of their IoT services offering in cooperation with Dataddo.

CRA now offers a solution to connect IoT infrastructure and the CRA cloud with the integration of Dataddo. The solution provides data encoding, decoding, transformation and delivery.

The Dataddo platform processes data from LoRaWAN devices transmitted by the CRA network and transforms the datasets into formats digestible by BI tools and Big Data storage platforms. This allows customers to easily tie this new type of IoT data into their existing IT stack very quickly without extensive engineering tasks.

Dataddo is a cloud-based data integration, automation and transformation platform designed to work with almost any online data service such as CRMs, analytics platforms, ERPs, or project management tools. Thanks to a robust automation and data transformation infrastructure, Dataddo can transform and wire the data to a wide range of databases, DWHs, cloud storages, dashboarding and BI applications allowing for smooth interoperability with existing IT and BI stacks.

Social media analytics, Uncategorized

Advanced data analytics for Instagram

Instagram, an increasingly popular social network, is also becoming the channel of choice for online marketers. Up until recently, the service did not provide much analytics capabilities, surely far from the golden standard set by Facebook or Google. Therefore, I am extremely happy to announce that Dataddo is fully integrated with Instagram providing advanced analytics capabilities, especially vital for online marketers and data analyst, such as automated data extraction and delivery, custom metrics definition, data integration of multiple Instagram accounts as well as with other data sources such as Google Analytics, Facebook, Twitter or Pinterest. The service itself is built around recently launched Graph API (indeed the same stack used for Facebook Insights).

Supported metrics

Currently, Dataddo supports requests on following metrics:

Account level

  • Impressions
  • Reach
  • Follower count
  • Email contacts
  • Phone call clicks
  • Text message clicks
  • Get direction clicks
  • Website clicks
  • Profile views
  • Audience gender age
  • Audience locale
  • Audience country
  • Audience city
  • Online followers

Media level

  • Engagement
  • Impressions
  • Reach
  • Saved
  • Video views
  • Carousel album engagement
  • Carousel album impressions
  • Carousel album reach
  • Carousel album saved
  • Carousel album video views
  • Story exits
  • Story impressions
  • Reach
  • Replies
  • Taps forward
  • Taps back

Dataddo Instagram ConnectorInstagram data automation

Dataddo is complex data automation, transformation, integration and analytics platform, build for online marketers, data analysts and others who do not want to waste time by coding and API integration but rather get straight to insights. With Dataddo you can easily deliver Instagram data to your existing data warehouse, define custom metrics, give business value to your Instagram campaign data by integrating them with your financial or e-commerce metrics or simply off-load your data analysts from routine, boring and laborious tasks by automating the data extraction and transformation tasks.

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.

new-data-explorervirtual-column

Tutorials, Uncategorized, Web analytics

How to filter referral spam in Google Analytics

In your Google Analytics reports, you might have came across with traffic coming from sources such as semalt.com, darodar.com or social-buttons.com. Such traffic is commonly know as “referral spam”. Recently, the amount of referral spam in Google Analytics has significantly increased. It might seem your site has a lot of visitors, but in reality none of such visits is real. Although referral spam does not pose a serious threat to your site (except bursts of workload of your server) it might seriously distort your web analytics data, especially when your site does not have tens of thousands visits per month.

Luckily, the solution is quite simple, you just need to define a filter on your view (make sure you have at least one view where unfiltered data are available).

screenshot-www.google.com 2015-04-08 09-42-40 (1)Simply go to “Admin” section of Google Analytics and select a view on which you want to apply the filter. Then select a “Custom” filter type that exclude filter field “Referral”. Set a filter pattern on following regular expression:

 

.*(semalt.com|social-buttons|darodar.com|makemoneyonline|googlsucks|best-seo-solution|best-seo-offer|.*share-buttons|buttons-.*-website|guardlan|buy-cheap-online|seo-success).*

It filters out the referral spam from following domains :

  • semalt.com
  • social-buttons.com
  • darodar.com
  • buttons-for-website.com
  • makemoneyonline.com
  • googlsucks.com
  • best-seo-solutions.com
  • best-seo-offer.com
  • free-share-buttons.com
  • buttons-for-your-website.com
  • guardlan.com
  • buy-cheap-online.info
  • success-seo.com

Make sure you include “.*” on both beginning and end of your expression since Google Analytics always compare the expression to full referral path. There is a great tool called Rubular, which you can use for testing your regular expressions. In case you came across with other spam referrals, simply add the to your regular expression. You can find a full list of referrals used by spammers here.

Tutorials, Uncategorized, Web analytics

Easy data integration with Dataddo

When developing Dataddo, we put a lot of effort to simplify daily routines that our users have to deal with on daily basis. One of the cool examples is the way how you can easily integrate data from various sources together. With user-friendly drag-n-drop interface, you can mash together various information, regardless whether it is a traffic report extracted from Google Analytics, product list in the form of CSV file or social campaign data from Facebook Insights. See the video tutorial below for more details: