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