Once Liberis has received both the business snapshot and transaction snapshot files, 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 | PTNR_2021Jan_Core_1 | PTNR_2021Jan_Core_1 |
| Date_Processed | 2021-01-06 | 2021-01-06 |
| Offer_Expiry_Date | 2021-02-06 | 2021-02-06 |
| Company_ID | ABC123 | ABC124 |
| Reference_ID | Ref1234 | Ref1235 |
| SubBrand | Partner | Partner |
| Country_Code | CAN | CAN |
| Currency_Code | CAD | CAD |
| Offer1_Amount | 5000 | 6000 |
| Offer1_Price | 20 | 19 |
| Offer1_Repayable | 6000 | 7140 |
| Offer1_Term | 9 | 8 |
| Offer1_Split | 15 | 16 |
| Offer2_Amount | 5000 | 6000 |
| Offer2_Price | 20 | 19 |
| Offer2_Repayable | 6000 | 7140 |
| Offer2_Term | 9 | 8 |
| Offer2_Split | 15 | 16 |
| Offer3_Amount | 5000 | 6000 |
| Offer3_Price | 20 | 19 |
| Offer3_Repayable | 6000 | 7140 |
| Offer3_Term | 9 | 8 |
| Offer3_Split | 15 | 16 |
| Segment_Name | Newly Eligible | Newly Eligible |
| DM_Reference_Code | NE.DM.1 | NE.DM.1 |
| eDM_Reference_Code | ND.eDM.1 | ND.eDM.1 |
| eDM_CTA_URL | partnerjourney.liberis.com/ABC123Ref12 | partnerjourney.liberis.com/ABC124Ref12 |
| Selection_ID | ABC123Ref1234PTNR_2021Jan_Core_1 | ABC124Ref1235PTNR_2021Jan_Core_1 |
| Assigned_Drop | 1 | 1 |
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.
Company_ID - This is the agreed Company ID that is used (see the Transactions & Snapshots file explanations for more detail)
Reference_ID – This field is for the ID agreed between Liberis & the Partner for incoming companies to identify themselves. 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.
SubBrand - This is the SubBrand of the company in this record – naming conventions for SubBrands to be agreed with partner in accordance with requirements for Business Snapshots and Transaction data receipt.
Country_Code - This is the ISO alpha-3 country code of the company record that has been processed. Comes from the Business Snapshots file received from the Partner.
Currency_Code - This is currency that the below offers will be expressed in. Comes from the Transactions file received from the Partner.
Offer[1/2/3]_Amount –This is the amount available to the company in this offer. The standardised file structure will allow for up to 3 offers per customer to be sent. By default, Offer1 will always be the primary offer. 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.
Offer[1/2/3]_Price – This is the price to the company of this offer. With the BCA this is a % fee but the value will be expressed as a whole number (EG 20% would be shown as “20” in this field).
Offer[1/2/3]_Repayable - This is the amount the company would need to repay from this offer.
Offer[1/2/3]_Term – This is the expected term of this offer.
Offer[1/2/3]_Split - This is the split required by the company to achieve this offer. With the BCA this is a % amount but the value will be expressed as a whole number (EG 20% would be shown as “20” in this field).
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.
DM_Reference_Code – This is the reference code idenfitying which DM or chain of DMs this company will receive – typically as a result of the segment they’re in. This is dictated by the marketing teams and will be pre-agreed before the file is returned.
eDM_ Reference _Code - This is the reference code idenfitying which Email or chain of Email this company will receive – typically as a result of the segment they’re in. This is dictated by the marketing teams and will be pre-agreed before the file is returned.
eDM_CTA_URL – Where applicable, this is a Liberis generated URL for a specific company within a specific campaign. This should be used as the CTA clickthrough link and will enable Liberis to identify the customer.
Selection_ID – This is a Liberis generated unique reference for each company within each campaign.
Assigned_Drop – Where applicable, if customers need to be spread out over multiple drops, or given a rank-order preference of mailing – a drop number of rank value will be used here. Methodology agreed with partner