Enhanced Signals supports two methods for uploading lookup files: manually uploading a CSV file through the UI or pointing to a Google Sheet. This flexibility allows users to choose the most convenient method for their workflow.
Manual CSV Upload
To manually upload a CSV file, you can do so through the edit flow in Alvie. Whether it’s an existing config or a completely new one, you simply upload the file in the interface where it says “upload file”.
Remember to ensure that the CSV file follows the required schema for the transformation you’ve chosen. If it doesn’t, the site will throw an error and notify you of your issue.
If you are in doubt about the correct schema, you can always refer to the guide for the transformation you are working on.
Connecting a Google Sheet
It can be tedious to manually upload and maintain a CSV file. Therefore, Alvie also allows you to connect a Google Sheet as a datasource to the Enhanced Signals Configuration.
When you do so, we will validate that the sheet follows the correct schema. If it does, we will read the data from that sheet twice a day - at 6AM CEST and 8PM CEST.
Validation and Troubleshooting
After uploading the CSV or linking the Google Sheet, validate that the events are processed correctly.
Use the Enhanced Signals dashboard to monitor the events and ensure they are being transformed and sent to the target platforms as expected.
Regularly check the output to ensure the values reaching the destination platforms are accurate.