Google Adwords Dashboard

High Level Design

Overview

Google Ads, is Google's advertising system in which advertisers bid on certain keywords in order for their clickable ads to appear in Google's search results. As such, it is very often used as a data source to understand your site and app users to better evaluate the performance of your marketing, content, products, and more. Data can be brought to our ElastiCube and upon presenting it on a dashboard, it can empower us in taking online marketing related business decisions.

Goals

Increase the website traffic, conversion rate and ROI of different online marketing campaigns.

Objectives

  • Understanding the current state of online marketing campaigns through high-level KPIs.
  • Increase traffic stream and CTR.
  • Decrease CPC.

KPIs Architecture

Objectives

KPIs

Measures

Data Source

Understanding the current state of online marketing campaigns through high-level KPIs

Impressions

sum([Impressions])

GoogleAds

Clicks

sum([Clicks])

GoogleAds

CTR (click-through rate)

sum([Clicks])

/

sum([Impressions])

GoogleAds

Decrease CPC

Cost per click

[TotalCost]

/

sum([Clicks])

GoogleAds

Increase  CTR

 

 

Conversion rate

[Total Conversions]

/

sum([Impressions])

GoogleAds

Cost per conversion

[Total Cost]

/

[Total Conversions]

GoogleAds

Plugins & Script

  1. Funnel Widget

Implementation
Kit

The following resources will enable you to design your dashboard and data model with sample data and then apply it to your own data. Note that you will need to have a previously installed version of Sisense (you can use the free trial version if you’re not a customer).

Sample data and dashboard examples (direct download)

Documentation