Uploading your advertising spend data will allow you to measure campaign ROI by marrying your advertising cost and the customer lifetime value (CLV) of users acquired from your campaigns.
The first step in analyzing ad spend data is getting the data. Since most advertising platforms allow you to export reports, we recommend you export the raw data from your ad platform and directly upload it to Magento BI without any manipulation. You can perform operations on the data in your data warehouse, so there's no need to double your efforts.
Once you've exported the ad spend data, use the File Upload feature to bring the data into your data warehouse. You can upload new data to the same Magento BI table over time.
In addition to your online campaigns, you may also have advertisements offline, such as on the radio or a billboard. To account for these cases, you can manually upload a spreadsheet with the cost data to Magento BI.
The table structure explored below is recommended when creating a CSV file to record ad spend data. A template file is also attached at the bottom of this article to serve as example. Recommended columns are: