Documentation

Google Data Studio

To use a Google Data Studio visualization platform you should visit https://report.improvado.io/visualizations/google-data-studio/ and generate your connection credentials (or get already generated ones). At the Templates tab on the same page and on our tutorial page http://improvado.io/help/templates/google-data-studio you can see a pre-defined template, showing how to use GDS visualization capabilities with improvado report data. Feel free also to look at our video tutorial.

How to create new GDS report from template

  1. Make a copy from the template report.
../../../../../_images/gdscreate_1.png
  1. Add Data source for overview platforms level and delete data sources which you don’t require.
../../../../../_images/gdscreate_2.png
  1. Change data source for each widget on the sheet.
../../../../../_images/gdscreate_3.png
  1. Change filters by account_id for other sheets and also delete filters which you don’t require on tab manage filters
../../../../../_images/gdscreate_4.png
../../../../../_images/gdscreate_5.png

How to use filter for dimension data in GDS

  1. Create a new data source for example for Adwords Campaign Performance tab, using accordingly database table (adsets_raw_table_adwords)
  • Click on the current data source
../../../../../_images/gdsfilter_1.png
  • Click button create new data source
../../../../../_images/gdsfilter_2.png
  • Select connectors as PostgreSQL
../../../../../_images/gdsfilter_3.png
  • Fill your credentials and connect to your database (click on a button “authenticate”)
../../../../../_images/gdsfilter_4.png
  • Select table which you want to use (in this case we selected table “adsets_raw_table_adwords” )
../../../../../_images/gdsfilter_5.png
  • Click button connect
../../../../../_images/gdsfilter_6.png
  • Rename our new data source
../../../../../_images/gdsfilter_7.png
  • Click button “Add to report”
../../../../../_images/gdsfilter_8.png
  1. Add filter for our widget.
  • You always should use as “Date range dimension” parameter “date_yyyymmdd”
../../../../../_images/gdsfilter_9.png

../../../../../_images/gdsfilter_10.png
  • To add a filter you need to figure out account_id in your Google Adwords and then click on the button “Add a filter”
../../../../../_images/gdsfilter_11.png
  • Click on the button “create filter”
../../../../../_images/gdsfilter_12.png
  • Select account_id as a search field
../../../../../_images/gdsfilter_13.png
  • Select equal to(=) as a condition
../../../../../_images/gdsfilter_14.png
  • Fill example: value as your account_id for the report which you can find in your platform(Adwords, Facebook etc.) account
../../../../../_images/gdsfilter_15.png
  • Also, you can rename filter as you want
../../../../../_images/gdsfilter_16.png
  • To finish creating filter click save