Links

• Published Works
  • Final Booklet
  • Final Presentation
  • User Manual
  • Technical Docs

What is it?

The STC Data Aggregation dashboard is a web application that aggregates data from various social media platforms and Google Analytics. The dashboard aids in forming data-driven marketing decisions and generating reports for stakeholders.

Why did we make it?

A little bit of context is necessary: As a requirement by WPI, all undergraduate students must complete an IQP (Interactive Qualifying Project). That means, as per WPI's definition, "working in interdisciplinary teams to solve a problem or need that lies at the intersection of science and society." Generally this involves traveling to a project center for a quarter (7-8 Weeks). Simply put, IQP is the WPI version of study abroad, where instead of taking normal courses at a local college, you work with a sponsor in the region to help solve a problem they have.

I chose to go to Hong Kong for my IQP, where myself and three others worked with the Hong Kong Standard and Testing Centre (STC). We helped identify and address their problem of effectively analyzing social media metrics to foster data-driven marketing decisions. We did this by conducting a substantial amount of research and subsequently developing the STC Data Aggregator.

If you're interested in reading more about the background and the immense amount of work we did during our eight weeks in Hong Kong, I recommend reading through our Final Booklet.

Features

Social Dashboard

The social dashboard fetches social media metrics from connected sources. These metrics each have their own section. Metrics include impressions, reach, profile views, likes, comments, and shares. When a metric is selected, all the data for each social media platform is displayed on a stacked line chart, allowing insights to be drawn from the data.

Year Comparison

The year comparison feature is similar to the social dashboard with the added feature of comparing one year's trends to another.

Google Analytics

The Google Analytics dashboard has three main views: a general metrics view showing stats like page views and view time, a list of the most popular pages for each website, and a list of which counties visit each website the most.

Metrics

The metrics page displays the number of page views, active users, average session (seconds), and event count. For each of their pages with Google Analytics connected

By Page

The By Page view displays the page views and active users for each of the top pages visited on their websites.

By Country

By Country displays page views and active users for each of the top counties visiting their websites.

User Management

The settings page allows users with the Admin role to add and delete users, as well as modifying roles.

Internationalization (i18n)

A requirement we received from the STC was internationalization. The dashboard was originally written in English with a requirement to have a Simplified Chinese translation. We shipped the dashboard with language support for:

• English
• German
• Chinese Simplified