Upload custom ROI Cost or CAC data
Uploading custom ROI Cost (including impressions and clicks) data is typically used by customers who have spend data from advertisement platforms Dreamdata does not yet support example DV360 or Demandbase etc.
Uploading CAC data is typically used by customers who have customer acquisition cost data in an external system such as their own Data Warehouse.
Customer Acquisition Cost
Fields | Type | Required | Data Examples | Comment |
date | DATE | TRUE | 2021-01-01 | The month where the cost happened (format YYYY-MM-DD). Only the month part of the date will be used. |
type | STRING | TRUE | salary, commission, services | Type of the cost (any type names are accepted and there is no limit for how many types can be added). This is used to further classify and filter the cost. |
cost | FLOAT | TRUE | 12.23 | Cost in the specified currency . |
currency | STRING | FALSE | USD, EUR | Currency associated with the cost (if no currency is chosen, it is assumed to be the same as the overall currency setting of the Dreamdata platform). |
ROI Cost
Fields | Type | Required | Data Examples | Comment |
date | DATE | TRUE | 2021-01-22 | The date where the spend happened (format YYYY-MM-DD). Spend can be aggregated onto a specific date (like first of the month) and will be connected to activities according to the aggregation of the report. |
channel | STRING | TRUE | Paid Search, Paid Social | Channel of the activity associated with the spend. This should match a channel shown in the Dreamdata platform (case sensitive). |
source | STRING | TRUE | Google, 6Sense | Source of the activity associated with the spend. This should match a source shown in the Dreamdata platform (case sensitive). |
cost | FLOAT | TRUE | USD, EUR | Cost in the specified currency (if no currency is chosen, it is assumed to be the same as the overall currency setting of the Dreamdata platform. |
type | STRING | TRUE | advertisement, outreach, tradeshow, webinar | Type of the spend. This is used to further classify and filter the cost. |
currency | STRING | FALSE | USD, EUR | Currency associated with the cost (if no currency is chosen, it is assumed to be the same as the overall currency setting of the Dreamdata platform). |
campaign | STRING | FALSE | Social-Selling, Conference-2025 | Campaign of the activity associated with the spend. This should match a campaign shown in the Dreamdata platform (case sensitive). |
impressions | INTEGER | FALSE | 12.000 | Impressions associated with the spend. This is only used for type 'advertisement'. |
clicks | INTEGER | FLASE | 235 | Clicks associated with the spend. This is only used for type 'advertisement'. |
