1. Help Center
  2. SETUP
  3. Connecting Your CRM and Leads

How to Import Historical Lead Attribution Data from Klaviyo into Wicked Reports

Klaviyo has "How They First Found You" data fields for profiles that can be used to see Wicked New Lead LTV tracking with information....here's how.

  1. Create & export a custom list from Klaviyo

  2. Prep the fields for import into Wicked Reports

  3. Import the data using the Wicked Reports Clicks CSV Uploader

  4. [Optional] - Add costs for the unique UTM sets identified by Klaviyo

This is a one-time, optional step to provide additional Klaviyo value.  Wicked Reports tracking and attribution will take this over much more efficiently once you have completed your setup process.

Data is only as good as the quality of the data.  The "How they first found you" utm values aren't always optimal - look at your values and decide if it is worth having this data inside of Wicked Reports - it very well might be valuable, just make sure first.

Let's do this.

Create & export a custom list from Klaviyo

  1. Head on over to Klaviyo's Lists & Segments menu option and choose to create list/segment.How to Import Historical Lead Attribution Data from Klaviyo into Wicked Reports
  2. Select Segment 
  3. Give the segment a name, set the property filter as shown below, and click create segmentHow to Import Historical Lead Attribution Data from Klaviyo into Wicked Reports
  4. When the segment is done populating, choose the export to CSV option How to Import Historical Lead Attribution Data from Klaviyo into Wicked Reports
  5. Select the following fields:
    Email
    Profile Created
    Initial Source
    Initial Source Term
    Initial Source Medium
    Initial, Source Campaign
    Initial Source Content

    How to Import Historical Lead Attribution Data from Klaviyo into Wicked ReportsHow to Import Historical Lead Attribution Data from Klaviyo into Wicked Reports
  6. Start Export - It's super fast, hat's off to the Klaviyo tech team.
  7. Save the file.  You're ready to move on to file prep. How to Import Historical Lead Attribution Data from Klaviyo into Wicked Reports

Prep the fields for import into Wicked Reports

  1. Open up your CSV.  Filter the Source field for blanks. How to Import Historical Lead Attribution Data from Klaviyo into Wicked Reports

  2. Now, delete these Blank rows
  3. Download the Clicks CSV Import template file. and delete the 3 sample data rows How to Import Historical Lead Attribution Data from Klaviyo into Wicked Reports
  4. Cut & paste the data from the Klaviyo csv name on the left-hand column to the Clicks CSV template file right-hand column name in the table below:

    Klaviyo Export column name pre-formatting Column header name for import success
    Email EMAIL
    Profile Created CLICK TIME
    Initial Source SOURCE
    Initial Source Term TERM
    Initial Source Medium MEDIUM
    Initial Source Campaign CAMPAIGN
    Initial Source Content CONTENT
  5. Set the TIMEZONE field in UTC to be the same value for every row.  The Timezone should match the timezone of your Klaviyo account. For example, Eastern time is UTC-5 or UTC-4, depending on current Daylight Savings Time.
    How to Import Historical Lead Attribution Data from Klaviyo into Wicked Reports
  6. Set the TIME OFFSET field to 30 for every row. This ensures the click timestamp is imported prior to the contact create date


  7. Set the CONVERSION TYPE field to NEW_LEAD for every row.
 How to Import Historical Lead Attribution Data from Klaviyo into Wicked Reports
The file is ready for import!
 
 

Import the data using the Wicked Reports Clicks CSV Uploader

  1. Go to the Clicks Importer screen How to Import Historical Lead Attribution Data from Klaviyo into Wicked Reports
  2. Click on the box in the "Upload New Clicks" tab and pick your file.
  3. The file will import...this is a dramatic moment.  There are 3 outcomes:
    1. Success!
    2. Column header issue - they must be in the exact order and case as indicated in this document.
    3. Mostly success - there might be an issue with a few rows, such as belowHow to Import Historical Lead Attribution Data from Klaviyo into Wicked ReportsIn this case, say "yes", because we can import all the rows except the 1 errant row.
  4. the next screen will show all your rows in a review state - in the "pending" status How to Import Historical Lead Attribution Data from Klaviyo into Wicked Reports
  5. Click submit at the bottom of that grid to receive this message How to Import Historical Lead Attribution Data from Klaviyo into Wicked Reports
  6. Upload status will show, and the clicks will be in the ROI report using New Lead attribution, with customer lifetime value, the next day!  How to Import Historical Lead Attribution Data from Klaviyo into Wicked Reports

 

[Optional] - Add costs for the unique UTM sets identified by Klaviyo


Wicked is able to detect and attribute ad spend automatically for Google and Facebook after you have integrated with those platforms.

For this manual import, you have to assign the costs manually -> here's how.