Once Liberis has received both the partner clients file and revenue claims file, we will process the data and return a file containing offers for eligible merchants. These offers can be used for partner reporting, marketing, journey control etc.
File fields
*Note, this table has been flipped vertically to allow for all fields to be visible in the table
| Column Name | Row 1 | Row 2 |
|---|---|---|
| Campaign_Name | PartnerName_2024September | PartnerName_2024September |
| Date_Processed | 20/09/2024 | 20/09/2024 |
| Offer_Expiry_Date | 17/12/2024 | 17/12/2024 |
| Company_ID | ABC123 | ABC124 |
| Reference_ID | Ref1234 | Ref1235 |
| Country_Code | CAN | CAN |
| Currency_Code | CAD | CAD |
| Offer_Amount | 5000 | 6000 |
| Segment_Name | 2024September_ELI | 2024September_PRE |
Definitions
Campaign_Name – This is an automatically generated identifying name for each campaign produced. Enables both Liberis and the partner to easily identify datasets and join across relevant datasets too.
Date_Processed – This is the date this campaign dataset was produced.
Offer_Expiry_Date – This is the date the offer, as it stands, is valid until. It means that the offer mustn’t be used after this date. We would be sharing updated offers however, before the expiry date.
Company_ID - This is the agreed Company ID that is used (see the Partner Client & Revenue Claims file explanations for more detail)
Reference_ID – This field is for the ID agreed between Liberis & the Partner for incoming companies to identify themselves. If same as ‘Company ID’ then this field will remain blank. Please use Company ID field as reference. This must be an easily repeatable number/code/reference for the company. This should either by the Company_ID/Merchant_ID received from the Partner – especially if known to the company – or Liberis can create a unique reference for each incoming customer.
Country_Code - This is the ISO 3166 alpha 3 codes of the company record that has been processed. Comes from the Business Snapshots file received from the Partner.
Currency_Code - This is the ISO 4217 3 letter currency code, that the below offers will be expressed in. Comes from the Revenue Claims file received from the Partner.
Offer_Amount – This is the amount available to the company in this month, that they can be targeted with via any campaign channels. All values will be unformatted, whole rounded number, where possible but if building automated systems please allow for decimals. Must allow NULLs on all fields.
Segment_Name – This is the name identifying the segment a company is in. This is dictated by the marketing teams and will be pre-agreed before the file is returned.