Improvado’s Blocks make it easy for marketing teams and marketing agencies to build a comprehensive marketing analytics dashboard to understand their performance on a platform, cross-platform and agency levels.

Improvado consolidates all the advertising data you need in a centralized database, so that it can be explored via one convenient Looker block.

You can either download Improvado’s entire blocks from this Github repo directly into your Looker application by following the directions outlined here, or selectively migrate pieces of the blocks by simply copying + pasting the block LookML into your Looker instance.

If you don’t have a Github account, we encourage you to create one for easy access to this block. If you don’t have access to the repo, or cannot make a Github account, please contact with us via email [email protected] and we’d be happy to help.

You can also customize Improvado blocks (change widgets, add measures, filters etc.).

To use this block, you will need to:

• Replace the conneciton name in the model file.
• Replace the schema name in each view file with your Ad integration's schema name.
• Replace the x in the table names at the top of each view file with your Ad account id.
• Ensure any hashed column names included in this block (i.e., spend#xxxxxxx) are replaced with the appropriate column from your schema.

The following is a list of Improvado’s blocks, the dashboards within them, their corresponding template names and views.

Improvado Advertising Analytics Block Dashboard: Platform Dashboard Template Name: template_channel_performance View: campaign_bindings

Dashboard: AdWords Account Dashboard Template Name: template_adwords_account_performance View: adsets_adwords

Dashboard: AdWords Keyword Dashboard Template Name: template_adwords_keywords_performance View: keywords_adwords

Dashboard: Bing AdGroup Dashboard Template Name: template_bing_adgroup_performance View: adsets_bing

Dashboard: Facebook Dashboard Template Name: template_facebook_performance View: ads_facebook

Improvado Agency Analytics Block Dashboard: Agency Executive Dashboard Template Name: template_overview_platforms_level View: campaign_bindings

Improvado Twitter Analytics Block Dashboard: Twitter Analytics Dashboard Template Name: template_twitter_performance View: promoted_tweets_raw_table_twitter, organic_tweets_raw_table_twitter

Improvado Google DCM Analytics Block Dashboard: Google DCM Analytics Template Name: template_dcm_performance View: creatives_raw_table_dcm

Improvado Youtube Analytics Block Dashboard: YouTube Campaign Analytics Dashboard Template Name: template_youtube_campaign View: adsets_youtube

Introduction Blog Post, Blocks Directory, Discourse Post