Creating a BigQuery Source

There are two different ways to pull your BigQuery data into Conversionomics. You can either: (1) use a SELECT FROM statement OR (2) manually input the project info. We'll show you how to do both.

On the home Conversionomics page, you will see a screen with all of your projects; select the project you will be working on. If you need to create a new project, select the orange button that says "New Project" and follow the instructions

Once you select the project you want to work on, you will see a similar screen as shown below. Select the orange button that says " + New Source"

After selecting the orange button that says " + New Source" you should see this screen

in the "Source Name" input the name of your file and select "Bigquery" and hit "CONTINUE" once complete

This screen should appear once you select "CONTINUE". Go to "Settings"

this screen should appear once you select "Settings".

Option 1: How to use a SQL SELECT FROM statement:

In Big Query console, select the project you wish to query.

Under "Resources" scroll down to your project and table or search for it in the search bar

Once you have selected the table you will be using, go to "Details".

The Table ID will be displayed, but you also have the option of clicking the magnifying glass to query the table.

The following SQL query will populate: copy and paste into Conversionomics Query

Option 2: To manually find and input the IDs:

In Big Query console, select the project you wish to query.

Under "Resources" scroll down to your project and table or search for it in the search bar

Go to the Details page.

If you want to manually input each Ids, the full table Id as shown below contains all three elements needed. 1st is the Project Id then a period, then the Dataset Id with a period, lastly the Table Id.

If you decide to autoload, select if you want it to load 'Daily'. 'Weekly' or 'Monthly' and whether you want it to "Full Reload"

hit "SAVE" once complete

If you have pre-existing data in this Source and want to supplement those with the new data, please DO NOT select "Overwrite data". Not selecting the "Overwrite data", Conversionomics will APPEND, joining the datas
If you are creating a new Source or want to overwrite the pre-existing ones, please SELECT "Overwrite data". By selecting the "Overwrite data" button, Conversionomics will replace the pre-existing datas with the new one you're about to input

In our situation, we are creating a new source with no prior datas; we are going to select "Overwrite data" and save it by selecting "LOAD"

A screen will popup asking you if you are sure you want to overwrite existing data, select "YES"

Congratulations! You have successfully created your BigQuery Source!