Creating a GSheets Source

On the Conversionomics homepage, 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 "Google Sheets" and hit "CONTINUE" once complete

You should see this screen once you select "CONTINUE"

On your GSheet page, go to "SHARE" in the top right corner

In the "Add people and groups" type in  google@net-conversion.com and conversionomics-5-production@appspot.gserviceaccount.com

Make sure to give them editorial permission and hit "Send" in the bottom right corner

Copy the URL link from your GSheet 
and paste it onto the Conversionomics "Sheet" box 

Our GSheet connection enables direct sheet connection or a customizes SQL statement to manage specific data transformation during ingestion 

If you want the file to "Auto load", select the button as shown below and there you can choose to auto 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 turned your GSheet into a Conversionomics Source!

Additional Information can be found within the official Google Search Ads 360 Documentation

Still need help? Contact Us Contact Us