How to Use Your Data in the Kondado Dashboard Template
Accessing Kondado
- The first step to using your own data in the Facebook Ads dashboard on Looker Studio is to create a free trial account at Kondado. To do this, simply visit https://app.kondado.com.br/signup and register with your email.
Connecting Your Data to the Facebook Ads Template in Looker Studio
- Once your Kondado account is created, just follow the first steps tutorial and add a data source for Facebook Ads.
- When your data source for Facebook Ads has been created, you will be presented with the option to follow the tutorial to create your dashboard.
- After choosing this option, the platform will create the pipelines and at the end of all the steps, it will present the link to access the dashboard with your own data!
Pipelines and Models
Listed below are the pipelines and models required to use the Report template. Incremental integrations can have the savepoint changed to fetch historical data.
Pipelines:
- Campaign performance (incremental)
Dashboard Features
General Metrics Page
This page provides an overview of the key information from Facebook Ads, making it easier to understand metrics such as clicks, cost, impressions, CTR, and others.
Components of the Page
Filters
| Filter | Description | Source Tables | Source Columns |
|---|---|---|---|
| Date | Date selection according to "Date Filter Reference" for each chart | facebook_campaign_insights | According to "Date Filter Reference" for each chart |
Charts
| Chart | Type | Description | Date Filter Reference | Source Tables | Source Columns |
|---|---|---|---|---|---|
| Clicks | Overview with mini-chart | Sum of the number of clicks all campaigns have received during the selected period in the date filter | Metric date | facebook_campaign_insights | facebook_campaign_insights: metric_date, clicks |
| Impressions | Overview with mini-chart | Sum of the number of impressions all campaigns have received during the selected period in the date filter | Metric date | facebook_campaign_insights | facebook_campaign_insights: metric_date, impressions |
| Cost | Overview with mini-chart | Sum of the total cost of all campaigns during the selected period in the date filter | Metric date | facebook_campaign_insights | facebook_campaign_insights: metric_date, spend |
Facebook Campaigns Page
This page provides a detailed view of the key metrics related to Facebook Ads campaigns, broken down by day.
Components of the Page
Filters
| Filter | Description | Source Tables | Source Columns |
|---|---|---|---|
| Ad Account | Selection of ad account ID | facebook_campaign_insights | account_id |
| Campaign | Selection of campaign name | facebook_campaign_insights | campaign_name |
| Date | Date selection according to "Date Filter Reference" for each chart | facebook_campaign_insights | According to "Date Filter Reference" for each chart |
Charts
| Chart | Type | Description | Date Filter Reference | Source Tables | Source Columns |
|---|---|---|---|---|---|
| Clicks | Overview | Sum of the number of clicks all campaigns obtained during the selected period in the date filter | Metric date | facebook_campaign_insights | metric_date, clicks |
| Impressions | Overview | Sum of the number of impressions all campaigns obtained during the selected period in the date filter | Metric date | facebook_campaign_insights | metric_date, impressions |
| Cost | Overview | Sum of the total cost of all campaigns during the selected period in the date filter | Metric date | facebook_campaign_insights | metric_date, spend |
| CTR (Click-Through Rate) | Overview | Division of the total number of clicks by the total number of impressions, resulting in a percentage for the selected period | Metric date | facebook_campaign_insights | metric_date, impressions, clicks |
| CPM (Cost Per Mille) | Overview | Total cost divided by the total number of impressions divided by a thousand (cost per thousand impressions) for the selected period | Metric date | facebook_campaign_insights | metric_date, impressions, spend |
| CPC (Cost Per Click) | Overview | Total cost divided by the total number of clicks (cost per click) for the selected period | Metric date | facebook_campaign_insights | metric_date, spend, clicks |
| Campaign List | Table | - Date: metric date - Ad Account ID: ID of the ad account to which the campaign belongs - Campaign ID: campaign ID - Campaign Name: campaign name - Clicks: sum of clicks on the date for the specified campaign, according to selected filters - Impressions: sum of impressions on the date for the specified campaign, according to selected filters - Cost: sum of the total cost of the specified campaign on the date, according to selected filters - CTR (Click-Through Rate): division of the total sum of clicks by the total sum of impressions of the specified campaign on the date, according to selected filters - CPM (Cost Per Mille): total cost divided by the total sum of impressions divided by a thousand (cost per thousand impressions) of the specified campaign on the date, according to selected filters - CPC (Cost Per Click): total cost divided by the total sum of clicks (cost per click) of the specified campaign on the date, according to selected filters | Metric Date | facebook_campaign_insights | metric_date spend impressions clicks |