Blue Visuals API Connector

Did you ever count the number of source systems you rely on in order to track results and performance in various aspects of your business? Maybe not – but we bet there will be a lot! The Blue Visuals API Connector Platform will automatically connect to all your source systems and collect your data into one unified database. From here it’s simply a matter of connecting your preferred dashboard or BI application to a single source.

Automation of data collection

Collecting data from all of your systems manually is a hideous task and automating the process usually involves studying a lot of API documentation and setting up a large number of connections and extraction routines – not to mention maintaining them all. Our API Connector is designed to free you of this job and let you focus on using your data.

The API Connector will automatically fetch your data from all of the source systems at a given frequency and store them in an internal database. Based on this extracted data set new calculated values can be added in the database – ready to use in your front-end application (dashboard, BI system etc.). The API Connector Platform will keep all past data in the internal database and hence over time build a historic dimension that typically cannot be extracted directly from social media API’s.

Use any dashboard or BI application

Once your data has been collected or calculated, it’s time to enjoy the benefits of working with a single source. Almost any dashboard or BI application can be used to access your data in the Blue Visuals API Connector database. Or your data could simply be exported to a spreadsheet format.

Blue Visuals offers complete data visualization solutions based on our own platform or on Klipfolio. Should you prefer a different dashboard or BI application we will help you connect it to the API Connector Platform.

Standard sources and data types

The Blue Visuals API Connector supports a number of widely used source systems and data types out of the box (raw data as well as calculated). This selection of sources and data will be sufficient for many dashboard and reporting solutions and will speed up such projects significantly. We will add new sources and data types frequently to make the API Connector gradually more comprehensive.

The Blue Visuals API Connector Platform can be used out of the box to easily aggregate data from many common sources – or it can be customized to include data from sources of your choosing.

Customizing the API Connector

However, should you wish to include additional data from either the standard sources or from other systems, the API Connector can be customized for your specific needs. No matter the source system, the extracted data will be added to the unified database to maintain a single source for your front-end application and to allow for cross referencing of data from different systems.

  Contact us for information about the Blue Visuals API Connector.

The API Connector with front-end application and example source systems

Current list of supported sources and data types

The list will be updated regularly.

 Source  Dimension  Metric  Update Frequency
Page page_fans, page_fan_adds, page_posts_impressions_unique, page_engaged_users, page_views_total, page_storytellers_by_story_type Daily
Post message, likes, comments, shares, full_picture, created_time Daily
All All Daily
Search Analytics Query rank, keyword, clicks, impressions, ctr, position Daily
Site list site url Daily
Url Crawl Errors url, category, counts, platform, timestamp Daily
Site list site url Daily
Get sheet data Your data (e.g. targets) Daily
Channel subscribersGained, subscribersLost, views, likes, comments, shares,estimatedMinutesWatched Daily
Video list of videos Daily
User user, feed, media, media liked, follows users, followed users, user relationship Daily
Media media popular, media info, media likes, media comments Daily
Companies company info, time, share-count, comment-count, like-count, impression-count, click-count, historical-follow-statistics Daily
User username,first_name,last_name,image,counts,bio,created_at Daily
Board name, description, url, image, pins, collaborators, followers, created_at Daily
Pin id, link, url, creator, board, created_at, note, color, counts, media, attribution, image, metadata Daily
User id, screen_name, profile_image_url, statuses_count, followers_count Daily
Tweet id, text, media, retweet_count, favorite_count, created_at Daily
Projects domain_name Daily
Rankings keywords, position, date Daily
Products app_name Daily
Sale report downloads, date Daily
Usage report opens, date Daily
Lists No. of subscribers, Subscriber list, Open rate, Click rate Daily
Page Total pages, List of pages, Page created date Daily
Post Total posts, List of posts, Post created date  Daily
 Source


Dimension : Page
Metric : page_fans, page_fan_adds, page_posts_impressions_unique, page_engaged_users, page_views_total, page_storytellers_by_story_type
Update Frequency : Daily


Dimension : Post
Metric : message, likes, comments, shares, full_picture, created_time
Update Frequency : Daily

 Source

Dimension : All
Metric : All
Update Frequency : Daily
 Source


Dimension : Search Analytics Query
Metric : rank, keyword, clicks, impressions, ctr, position
Update Frequency : Daily


Dimension : Site
Metric : list site url
Update Frequency : Daily


Dimension : Url Crawl Errors
Metric : list site url, category, counts, platform, timestamp
Update Frequency : Daily

 Source

Dimension : Site
Metric : list site url
Update Frequency : Daily
 Source

Dimension : Get sheet data
Metric : Your data (e.g. targets)
Update Frequency : Daily
 Source


Dimension : Channel
Metric : subscribersGained, subscribersLost, views, likes, comments, shares,estimatedMinutesWatched
Update Frequency : Daily


Dimension : Video
Metric : list of videos
Update Frequency : Daily

 Source


Dimension : User
Metric : user, feed, media, media liked, follows users, followed users, user relationship
Update Frequency : Daily


Dimension : Media
Metric : media popular, media info, media likes, media comments
Update Frequency : Daily

 Source

Dimension : Companies
Metric : company info, time, share-count, comment-count, like-count, impression-count, click-count, historical-follow-statistics
Update Frequency : Daily
 Source


Dimension : User
Metric : username, first_name, last_name, image, counts, bio, created_at
Update Frequency : Daily


Dimension : Board
Metric : name, description, url, image, pins, collaborators, followers, created_at
Update Frequency : Daily


Dimension : Pin
Metric : id, link, url, creator, board, created_at, note, color, counts, media, attribution, image, metadata

 Source


Dimension : User
Metric : id, screen_name, profile_image_url, statuses_count, followers_count
Update Frequency : Daily


Dimension : Tweet
Metric : id, text, media, retweet_count, favorite_count, created_at
Update Frequency : Daily

 Source


Dimension : Projects
Metric : domain_name
Update Frequency : Daily


Dimension : Rankings
Metric : keywords, position, date
Update Frequency : Daily

 Source


Dimension : Products
Metric : app_name
Update Frequency : Daily


Dimension : Sale report
Metric : downloads, date
Update Frequency : Daily


Dimension : Usage report
Metric : opens, date
Update Frequency : Daily

 Source

Dimension : Lists
Metric : No. of subscribers, Subscriber list, Open rate, Click rate
Update Frequency : Daily
 Source


Dimension : Page
Metric : Total pages, List of pages, Page created date
Update Frequency : Daily


Dimension : Post
Metric : Total posts, List of posts, Post created date
Update Frequency : Daily

Contact us

and let us help you to a better overview