Documentation

Tableau

To use a Tableau visualization platform you should visit https://report.improvado.io/visualizations/tableau and generate your connection credentials (or get already generated ones). As you can see here, Improvado use PostgreSQL for sending data to Tableau.

Once you connect PostgreSQL to Tableau, you will then see a list of Tables available to and start building your dashboards:

The most common table to connect to is the campaigns_mapped_table as that will contain metrics standardized (mapped) across all different ad platforms at the campaign level. All dimension level tables will be raw, unmapped data. You can add a raw table to a report as an additional data source as well.

In fact, there are two types of mapped campaign tables, with different data structure:

  • campaigns_mapped_table is set up like a traditional table with metric on one line at the top of the table and the corresponding values in the rows below.
  • campaigns_mapped_key_value table is set up in the MetricID : MetricValue format. For example:

222 : $101

201 : 1000 Imps

222 : $202

Some clients prefer the Key Value format, but campaigns_mapped_table is easier to use and much more popular.

For more granular, dimension level data, you can use one of the many other tables available. They all follow the format of granularity first, followed by the data connector. Facebook Ad level data table (ads_raw_table_facebook) may serve as an excellent example and a training yard for you to become more familiar with Improvado-Tableau tandem.

At the Templates tab on the same page https://report.improvado.io/visualizations/tableau pre-defined templates, showing how to use Tableau visualization capabilities with improvado report data. Feel free also to look at our video tutorial.