Download Raw Matches
If you've shared Transactional Data with Poplar, a record of raw matches will be available for download on both a campaign and an account-wide level. It may take up to 24 hours for order data to be processed into matches.
After clicking the link you'll receive an email with the record for download, depending on the amount of data you have stored the email could take up to 20 minutes to arrive. The CSV file will contain all matches and attributions. If you only need attributions, please ensure you filter out matches. Under the column match_type:
A | Indicates the order was attributed to that particular mailing |
M | Indicates the order simply matched to that particular mailing, but was not attributed to that mailing |
Poplar reporting follows a last-touch attribution model across campaigns, so it could be that the mail piece was not the last one that the specific customer received. Use the order_id column to trace an attribution back to a specific order.
Data Key
match_id | ID unique to that match |
campaign_id | Poplar campaign ID |
campaign_name | name of campaign that matched |
creative_id | unique ID for the creative that matched |
mailing_id | unique ID for the mailer that matched |
order_id | external order ID for the match (can be used to trace specific purchase) |
customer_id | external customer ID |
order_date | date the order was placed |
order_total | total cost of the order (occasionally a 0 can appear, this is likely caused by a return or customer service comp) |
order_currency | payment currency |
mailing_cost | per piece cost of the single mailer |
mailing_state | delivered or holdout |
send_date | date the mailer was launched |
in_home_date | date the mailer was delivered |
match_type | A if the mailer was attributed to a conversion, M if the mailer simply matched an address in the mailed group |
unique | True/False a customer (mailing recipient) has placed 1 or more orders |
new_buyer | True/False if orders attributed to a mailer came from a new buyers - New Buyer flag is passed to the platform via Shopify App integration or in the metadata when sending to the Orders API |
email_match | True/False if customer email matches an email provided with mailing data during launch |
billing_address_match | True/False if customer's billing address matched the provided mailing address |
shipping_address_match | True/False if customer's shipping address matched the provided mailing address |