How to pull any dimension into a table to join it with other data

[niklaskolster]

1. Create database connection to ad platforms.
If the connection to the connectors have not been setup already it has to be created.
a. give the database a name with your username
b. as connection string put connectors:///?api_key=<api_key>&user_name=<username>
c. test that the connection works
d. check "Allow CREATE TABLE"
e. check ALLOW DML

Screenshot from 2020-10-09 09-46-17.png (65.73 KiB) Viewed 1785 times

2. Go to SQL lab and create your query
You can query any dimension from the platforms you have connected.

Screenshot from 2020-10-09 11-17-26.png (117.96 KiB) Viewed 1785 times

3. Set the table to be updated

This is done by adding:
-create table as
-and keep updated
That means it will create a table in your database and keep it updated with new data.




4. Analyze and join the data with other data.
If you for example want to join the data with the attributed revenue you can create an SQL view that joins the the with the table <clientname>_attributions_and_costs