Integration

Step 1

Navigate to Settings -> Connections to create a new Card-Linked Transactions SFTP connection.

Step 2

Prepare to send transaction-level data to impact.com.

  • Data upload frequency: There are no limitations on frequency. You can upload transactions as often as you want.
  • File format: Plain/text CSV format. Each row in the file represents a transaction.
    • Data for multiple programs can be sent within the same or within separate files.
  • SFTP Folder: Used to add new card-linked transaction files. The connection name determines the SFTP folder location name using the following format:
    • Connection name: Russel Sprout
    • Folder name: russel_sprout/add
  • File Name: We recommend using a unique and descriptive file name that includes your company name, data type, and timestamp.
    • partnername_card_linked_transactions_YYYYMMDDHHMMSS.csv.gz

Step 3

Confirm you have the necessary information from the brand.

  • Program ID (formerly Campaign ID) specific to Card-Linked Offers. This is provided with each transaction. See the example below.
  • Event Type ID specific to Card-Linked Offers. This is provided with each transaction. See the example below.
  • Active terms with the brand's program that include the new CLO event. View your terms.
  • The Merchant IDs (MIDs) of the brand's locations to identify transactions.

Step 4

Work with your Partner Development Manager or submit a support ticket to test the integration. Our team will set up a contract with a test brand account and provide the Program ID (formerly Campaign ID) and an Event Type ID for the setup. You can then send a small number of test transactions to confirm that all results are tracked as expected.

Step 5

Once you send the first batch of transaction data, the impact.com support team will confirm that the data shows within the Pending Actions screen for the brand account. Confirm with the brand that the Action Cost and Revenue data are populated as expected.

Sample Schema

The below schema is representative of a subset of supported fields most commonly used for Card-Linked Offer programs. The data ingest also supports additional fields consistent with the brand's conversion object.

Card-Linked Transaction FieldsDescriptionExample
MediaPartnerIdRequired. Your impact.com Account ID.123456
CampaignIdRequired. The impact.com Program ID of the brand.12345
EventTypeIdRequired. The impact.com Event Type Id is the merchant created for CardLinkedOffer transactions. This should be a separate Event Type from regular online sale transactions.78901
EventTypeCodeThe brand's impact.com Event Type Code (if EventTypeId is not provided).clo_transaction
AmountRequired. Transaction Amount.
We do not currently support returns or negative amounts being submitted, and doing this will result in an error.
156.11
EventDateRequired. Time and date when the conversion event actually took place, in ISO 8601 format.2022-10-12T05:41:04+0000
CurrencyCodeRequired. Three-letter ISO 4217 alpha code representing the currency. If not sent, your account's default currency will be used.USD
CardLinkedTransactionIdRequired. Unique identifier of the transaction.854edc88-10c7-4c1f-aadc-d64f30c415af
CustomerPostCodeOptional. Billing Zipl.11101
CustomerCountryOptional. Billing Country.US
CustomerCityOptional. Billing City.New York
CardBinOptional. Card Bin.401159
CardLastFourOptional. The last 4 digits of the card relevant to the transaction.1234
LocationIDOptional. Merchant ID (MID) or similar.12345
LocationNameOptional. Merchant Location Name (e.g. name of physical location or website).company.com
PayoutAmountThe payout amount as calculated by the card-linking platform. This amount is not used, but is captured for information purposes only. All payouts are calculated based on the impact.com terms between the partner and the brand.15.6
SharedIdA free-form field that accepts any value that can be used by brands to create custom payouts to partners. Maximum length: 255 characters.Recurring
SubId1 - 3Custom text field typically used by partners to segment traffic.Card-Linked
Numeric1 - 3General numeral field that accepts any numeric data you want to send. Appears in brand reports. Format: Decimal (18,2).15.6
Money1 - 3General numeral field that accepts any money or financial numeric data you want to send. Appears in brand reports. Format: Decimal (18,2).173.11

What’s Next