LTV Numbers
LTV Numbers
Search
⌃K

ClickBank

Webhook Secret Key

The Secret Key allows LTV Numbers to decrypt your webhook payloads
  1. 1.
    ​Log into ClickBank​
  2. 2.
    In ClickBank's top navigation bar, click on Vendor Settings
  3. 3.
    On the My Site page, scroll down to the Advanced Tools section
  4. 4.
    Copy the Secret Key for later use
    • Note: a ClickBank integration is in the works that will improve this process

Set Up Webhooks

Webhooks pull your sales data in real time and should be set up first before importing historical sales data to avoid gaps in your data
  1. 1.
  2. 2.
    In LTV Numbers' side navigation bar, go to the "Settings" tab
  3. 3.
    Click the "Add ClickBank Integration" button in the "ClickBank Integrations" section
  4. 4.
    Paste the Secret Key from the previous section into LTV Numbers
  5. 5.
    Enter the Account Nickname and click Submit to create the ClickBank integration
  6. 6.
    Within this newly created ClickBank integration, Copy the Instant Notification URL for later use
  7. 7.
    In a separate browser window or tab, log into ClickBank​
  8. 8.
    In ClickBank's top navigation bar, click on Vendor Settings
  9. 9.
    On the My Site page, scroll down to the Advanced Tools section and click Edit
  10. 10.
    Paste the LTV Numbers Instant Notification URL into an empty "Instant Notification URL" field in ClickBank
    • Note: if your account doesn't have any empty "Instant Notification URL" fields, request another slot from ClickBank support
    • Note: if this is the first time setting up instant notification urls for your account, you may have to enable them.
  11. 11.
    Select the latest version (currently version 7.0) in the Version dropdown selector
  12. 12.
    Click the "Test IPN" button to verify the webhook
  13. 13.
    Once verified, click the Save Changes button to finalize webhook setup
  14. 14.
    If you have additional ClickBank accounts, repeat the above steps for each

Historical Sales Data

After setting up webhooks to pull in real time sales data, import your past sales for a complete picture of your data. Note: due to ClickBank's exporting limitations, you may have to subdivide your data and export it in multiple batches. The goal here is to establish a good analysis baseline with at least a year of data. (Older data doesn't necessarily reflect the current state of the business.)

Export Historical Sales Data From ClickBank

  1. 1.
    In the ClickBank’s top navigation, bar go to Reporting, then the Transactions page
  2. 2.
    Export a batch of data by selecting the date range, then scroll to the bottom of the page and click the "Export Options: CSV" link. Save this batch of data to your computer.
    • Note: if there is too much data for ClickBank to export, the "Export Options: CSV" link will not be present. Choose a smaller date range and try again.
    • Note: At the top of the Transactions page, there is usually a link to download all of the previous year’s transactions. If it is present, it's a convenient shortcut to export that data.
  3. 3.
    Repeat the above step as necessary to export the desired data you wish to import and analyze in LTV Numbers.

Import ClickBank Historical Data Into LTV Numbers

  1. 1.
    Follow the instructions for Uploading Data into LTV Numbers to upload your ClickBank Sales

ClickBank Limitations & Notes

  • LTV Numbers does not support analysis for sales made as an affiliate (through another vendor) on ClickBank because ClickBank does not provide customer information to the affiliate. And since we can't assign the revenue to a particular customer, we can't do any analysis like compute their specific LTV.