Sunburst Visualization

Interactive sunburst visualization of digital attribution data changes.

Visualization

Hover for data summary, click on visualization to reset summary.

Select example:

Sunburst visualization helps track population changes from initial channels over lifecycles e.g. digital channels, sites and publishers.

For custom testing, load up a file conforming to the data schema (see details below) or you can test out the following sample files (fake data):

Details

This is a interactive visualization to measure digital attribution. This App can organize the code base and draw the D3 components from a single HTML div tag, and to dynamically assign color and legend scales.

Another advantage of this App is generalizing and conventionalizing data inputs. The input requires a simple tabular schema of sequence, value (see below) and the program will parse the data into a JSON graph.

The design of the data imput therefore makes the visualization more useable on relational database queries. The CSV data can be unsorted but it must NOT contain a header, and has to conform to the following data column requiorements.

Data Preview

{{ sunburst.data }}

SQL Query Example

SELECT
  path,
  COUNT(user_id) AS num
FROM (
  SELECT
    user_id,
    GROUP_CONCAT(site_dcm, "-") AS path
  FROM (
    SELECT
      Time,
      user_id,
      CASE
        WHEN site_id_dcm = '1041621' THEN 'youtube'
        WHEN site_id_dcm = '1082487' THEN 'complex'
        WHEN site_id_dcm = '1085227' THEN 'pandora'
        WHEN site_id_dcm = '1238275' THEN 'xad'
        WHEN site_id_dcm = '1147830' THEN 'espn'
        WHEN site_id_dcm = '1037640' THEN 'hulu'
        WHEN site_id_dcm = '1240509' THEN 'spotify'
        ELSE 'vice'
      END AS site_dcm
    FROM
      [cookiepoc-139913:nxie_analytics.SM_Q4_ImpJoinAct])
  GROUP BY
    user_id)
GROUP BY
  path
ORDER BY
  num DESC