Integration: Talkable

This article will help you learn about how Daasity replicates data from Talkable, limitations to the data we can extract and where the data is stored in the Talkable schema.

Key Topics

Click on the links below to take you to the section where you can learn more about this Integration

Integration Overview

Talkable is a referral marketing platform that helps e-commerce businesses with sustainable growth, user acquisition and retention through their referral programs.

This document provides context on what kind of data is being gathered through this extractor, which endpoints that data is coming from, and how the extracted tables relate to each other. 

Integration Availability

This integration is available for:

  • Pro (V1 and V2)

NOTE: You are considered V2 if...

  • Your account says Pro V2 in the Daasity App

Not sure? Reach out to

API Endpoints

The Daasity Talkable extractor is built based on this Talkable API Documentation. The following endpoint is used by Daasity to replicate data from Talkable:


The Daasity Talkable extractor is also built based on this Talkable Webhooks Documentation. The following Webhooks are used by Daasity to replicate data from Talkable:

Entity Relationship Diagram (ERD)

The embedded diagram houses the ERD for the Daasity Talkable integration illustrating the different tables and keys to join across tables. Hover over the embedded diagram to reveal controls to zoom and scroll.

Talkable Schema

The Daasity Talkable extractor creates these tables using the endpoints and replication methods listed. The data is mapped from source API endpoint to the table based on the mapping logic outlined in each table.

Advocate Campaigns

  • Webhook: Reward
  • Update Method: UPSERT
  • Table Name: talkable.advocate_campaigns
JSON Element Database Column
MD5(advocates::id + advocates::campaign::id + timestamp) key
advocates::campaign::id campaign_id
advocates::id advocate_id
Daasity: current timestamp date


  • Webhook: Advocate Signup
  • Update Method: UPSERT
  • Table Name: talkable.advocates
JSON Element Database Column
offer_signups::id id
offer_signups::username username
offer_signups::first_name first_name
offer_signups::last_name last_name
offer_signups::gender gender
offer_signups::opted_in_at opted_in_at
offer_signups::subscribed_at subscribed_at
offer_signups::unsubscribed_at unsubscribed_at


  • Endpoint: Campaigns
  • Update Method: UPSERT
  • Table Name: talkable.campaigns
JSON Element Database Column
campaigns::id id
campaigns::name name
campaigns::type type
campaigns::slud slud
campaigns::tag_names tag_names
campaigns::is_active is_active


  • Webhook: Post Share
  • Update Method: UPSERT
  • Table Name: talkable.shares
JSON Element Database Column
shares::origin::id id
shares::share_type type
shares::origin::email advocate_email
campaign::id campaign_id
shares::origin::type origin_type
shares::share_info::recipient_emails recipient_emails
Daasity: timestamp date


  • Webhook: Reward
  • Update Method: UPSERT
  • Table Name: talkable.rewards
JSON Element Database Column
reward::id id
campaign::id campaign_id
friend_origin::id friend_id
advocate_origin::id advocate_id
reward::reason reason
reward::incentive_type incentive_type
reward::incentive_description incentive_description
reward::amount amount
Daasity: timestamp date


JSON Element Database Column
claim_signup::id id
claim_signup::email email
claim_signup::offer::email referrer_email
claim_signup::username username
claim_signup::first_name first_name
claim_signup::last_name last_name
claim_signup::campaign::id campaign_id
claim_signup::offer::short_url_code offer_short_url_code
claim_signup::gender gender
claim_signup::opted_in_at opted_in_at
claim_signup::subscribed_at subscribed_at
claim_signup::unsubscribed_at unsubscribed_at

Friend Purchases

  • Webhook: Reward
  • Update Method: UPSERT
  • Table Name: talkable.friend_purchases
JSON Element Database Column
friend_origin::id + friend_origin::order_number id
advocate_origin::id advocate_id
friend_origin::id friend_id
reward::id reward_id
reward::amount amount
friend_origin::order_number order_number
friend_origin::order_date order_date
friend_origin::coupon_cide coupon_code

Related Resources