1. Home
2. Templates
3. Advertising Platforms

Advertising Platforms

• Entity Relationship Diagram
• Table Description
• Data Sources
• Data Destinations
• How to Use Template
  • Use Data App with Template
• Authorizing Data Sources
  • Facebook Ads
  • Bing Ads
  • LinkedIn Ads
  • Google Ads
  • Google Analytics
• Authorizing Data Destinations
  • BigQuery Database
  • Google Sheets
  • Snowflake Database Provided by Keboola
  • Snowflake Database
• Most Common Errors
  • Missing Credentials to Snowflake Database

Using one of the advertising platform templates will give you an overview of the costs of all of your campaigns in the marketing channels you use. All data will be stored in one table and one location. That means that you won’t have to go to multiple systems and collect data manually anymore. Keboola will do it for you.

With this end-to-end flow you can bring into Keboola data from one or more marketing channels of your choice (Facebook Ads, LinkedIn Ads, Google Ads, and Bing Ads). After all the necessary tasks are performed on the data, you load the results into Snowflake, Google BigQuery or Google Sheets. You can also enrich the data with Google Analytics.

The flow, in a nutshell:

• First, you will select one or multiple data source connectors that will provide all your available data about your campaigns.

• To enrich the marketing model with keywords, ad groups, and marketing transactions, you can also bring in your Google Analytics data (data about basic sessions and transactions).

• The data extracted from the ad platform or platforms will be placed into one output table containing basic information about campaigns, impressions, clicks, costs, and cost conversions.

• Then, optionally, Google Analytics session (new and returns), page views, and bounces will be added to the output table, and two new tables will be created for transactions and keyword ad groups.

• The data will be written into a selected destination, for example, your Google Sheets account via the Google Sheets data destination connector.

• Finally, you will schedule and run the entire flow (i.e., the sequence of all the prepared, above mentioned steps, in the correct order). All your selected data source connectors, all data manipulations, and the Google Sheets data destination connector, will be processed.

Entity Relationship Diagram

An entity-relationship diagram is a specialized graphic that illustrates the relationships between entities in a data destination.

Table Description

Name	Description
ONLINE MARKETING	contains data about impressions, clicks, costs per clicks, and costs per conversions
ONLINE MARKETING TRANSACTIONS	contains a list of campaigns of each account
ONLINE MARKETING TRAFFIC	contains data about sessions, pageviews, bounces, and cpc of each campaign per day
KEYWORDS ADGROUP	contains a list of keywords and ad groups

Data Sources

These data sources are available in Public Beta:

• Bing Ads
• LinkedIn Ads
• Facebook Ads
• Google Analytics
• Google Ads

Data Destinations

These data destinations are available in Public Beta:

• Snowflake database provided by Keboola
• Snowflake database
• Google BigQuery database
• Google Sheets

How to Use Template

The process is simple. We will guide you through it, and, when needed, ask you to provide your credentials and authorize the data destination connector.

First decide which data source and which data destination you want to use. Then select the corresponding template from the Templates tab in your Keboola project. When you are done, click + Use Template.

This page contains information about the template. Click + Use Template again.

You’ll be asked to write a name for the template instance you are about to create. You can use the template as many times as you want and still keep everything organized.

After clicking Next Step, you will see the template builder. Fill in all needed credentials and perform the required OAuth authorizations.

Important: Make sure to follow all the steps very carefully to prevent the newly created flow from failing because of any user authorization problems. If you are struggling with this part, go to the section Authorizing Data Destinations below.

Follow the steps one by one and authorize at least one data source from the list. Finally, the destination must be authorized as well.

When you are finished, click Save in the top right corner. The template builder will create your new configuration, and when it is done, you will see the newly created flow.

Click Run Template and start building your visualizations a few minutes later.

Use Data App with Template

If you want to vizualize the data from this template via a predefined data app, simply select this template from the list, and then click Use Template. This will guide you to a page where all the details related to this template are described. From here, click Use Template once more, give it a name, and click Next Step.

This will take you to the page where you can set up the template containing the data app configuration. Here, you will need to provide credentials for the data source and destination connectors you want to use.

Once you have completed this step, you can launch your data app. To do so, select the checkbox Let’s do it in the Online Marketing Report application and save the configuration.

A data app has been created. You can also find its details in the section Components – Data Apps, where you can always edit the data apps you have created.

Below, you can see a screenshot of the data app created from the Advertising Platforms template.

Authorizing Data Sources

To use a selected data source connector, you must first authorize the data source. You need to use at least one of the following marketing data sources. In addition, Google Analytics can be used to enrich the data.

Facebook Ads

Log into Facebook with redirection from this step and allow Keboola to access the data.

From the list of accounts select the accounts from which you want to download data.

Bing Ads

First, authorize your Google account. To configure this source connector, you must also have a Microsoft account, where you can find the Developer Token (Developer Account).

The Account ID (aid) and Customer ID (cid) can be found in the URL of your campaign https://ui.ads.microsoft.com/campaign/vnext/campaigns?aid=XXXXXXXXX&cid=XXXXXXXXX&uid=XXXXXXXXX.

LinkedIn Ads

Authorize your LinkedIn account and then fill in the start and end dates following the example.

Google Ads

Authorize your Google account and select the period for extracting the data.

Google Analytics

Authorize your Google account and select the period for extracting the data.

Authorizing Data Destinations

To create a working flow, you must select at least one data destination.

BigQuery Database

To configure the data destination connector, you need to set up a Google Service Account and create a new JSON key.

A detailed guide is available here.

Google Sheets

Authorize your Google account.

Duplicate the sheet into your Google Drive and paste the file ID back to Keboola. It is needed for correct mapping in your duplicated Google sheet.

Snowflake Database Provided by Keboola

If you do not have your own data warehouse, follow the instructions and we will create a database for you:

1. After clicking Save, the template will be used in your project. You will see a flow.
2. Go there and click on Snowflake Data Destination to configure it. You will be redirected to the data destination configuration and asked to set up credentials.
3. Select Keboola Snowflake database.
4. Then go back to the flow and click Run.

Everything is set up.

Snowflake Database

If you want to use your own Snowflake database, you must provide the host name (account name), user name, password, database name, schema, and a warehouse.

We highly recommend that you create a dedicated user for the data destination connector in your Snowflake database. Then you must provide the user with access to the Snowflake Warehouse.

Warning: Keep in mind that Snowflake is case sensitive and if identifiers are not quoted, they are converted to upper case. So if you run, for example, a query CREATE SCHEMA john.doe;, you must enter the schema name as DOE in the data destination connector configuration.

More info here.

Most Common Errors

Before turning to the Keboola support team for help, make sure your error is not a common problem that can be solved without our help.

Missing Credentials to Snowflake Database

If you see the error pictured below, you have probably forgotten to set up the Snowflake database.

Click on the text under Configuration in the top left corner. This will redirect you to the Snowflake Database connector. Now follow the Snowflake Database provided by Keboola on the page Authorizations/destinations.

Then go to the Flows tab and Run the flow again.