How to Integrate Attribution Segmentation between ProfitWell and Wicked Reports

The fast process to connect Wicked Reports Lead and Sale attribution into ProfitWell for advanced segmentation insights.

ProfitWell has a feature that allows you to slice and dice many subscription data points by custom segmentation.  One of their most popular requests is to apply marketing attribution data to Profitwell's subscription metrics. This document shows you how to do that.

The Steps

1. Export the Wicked Reports attribution data

2. Prep the file for import to ProfitWell

3. Import the file

Export the Wicked Reports attribution data

1. Go to the Customer LTV Report
   '
2. Set the attribution model filter to "First Optin" and the date range to "Since 1st Tracking" .
   and run the report
3. Change the tab to   "Order / UTMSEARCH"   
4. Click on the "Export to Excel" link in the bottom right corner of the grid
5. Save the file

Prep the file for import to ProfitWell

There are some important considerations:

• Customer email must be the first column.
• If the customer emails in Wicked do not match the ProfitWell customer emails, you are out of luck. They should match, but if not, it's a non-starter.
• Any blank fields will be extrapolated by ProfitWell.
• Wicked's export from Customer LTV has some fields that aren't valuable for this exercise and should be deleted as instructed below.
• no empty rows
• sheet must be delimited by commas

Here are the file prep steps.

1. Open the file exported out from above
2. Delete the following columns:
   1. DataDate
   2. orderTotal
   3. orderID
   4. firstName
   5. LastName
   6. All fields after UTM_term!
3. Save your file again.  This how it should look at this point:
4. Now you have a decision to make on extrapolation. To err on the side of caution, let's remove all blanks. In Excel, my tool of choice, you eliminate blanks in the following way:
   1. Highlight your entire sheet of data.
   2. Click on the Filter button.
   3. Go the UTM_Source_first field.
   4. Select only the blanks 

Put N/A into all the blanks

5. Save the file in CSV format - you are ready to import.

Import the file

1. Login to ProfitWell.
2. Click on the gear icon and then the Data Settings menu option
3. Click on Manage My Data
4. Click on Import Data
5. Choose Upload CSV
6. Very helpful video from Neel you can watch, then click next.
7. Find your file, select it, and click next: