Integration Specifications
KnoCommerce allows you to show post-purchase surveys on your website. These surveys can unlock powerful insights that are hard to glean from other types of data, such as: where customers most commonly hear about your brand and whether they're buying for themselves or others.
Daasity exposes this raw data for you to do your own analysis. We enable you analyze all of your survey response data and will also will incorporate responses to the standard "How did you first hear about us?" post-purchase question into your attribution reporting.
Refresh Cadence
This extractor pulls the last 2 complete days of data during the nightly refresh.
Availability
This integration is available for:
Enterprise
Growth
API Endpoints
This extractor is based on the KNO REST API. The following endpoints are used to replicate data into Daasity:
Entity Relationship Diagram (ERD)
KnoCommerce Schema
The KnoComerce 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.
Benchmarks
Endpoint: List Benchmark Questions
Update Method: UPSERT
Table Name:
[knocommerce.benchmarks]
questions[].id
BENCHMARK_QUESTION_ID
questions[].label
BENCHMARK_QUESTION_LABEL
questions[].title
BENCHMARK_QUESTION_TITLE
MD5(BENCHMARK_QUESTION_ID + KnoCommerce account ID)
__SYNC_KEY
Response Values
Endpoint: List Responses
Update Method: UPSERT
Table Name:
[knocommerce.response_values]
results[].id
RESPONSE_ID
results[].response[].attribution_type
ATTRIBUTION_TYPE
results[].response[].value
VALUE
results[].response[].type
TYPE
results[].response[].label
LABEL
results[].response[].quesion_id
QUESTION_ID
results[].response[].question_duration
QUESTION_DURATION
results[].response[].other
OTHER
MD5(RESPONSE_ID + QUESTION_ID + KnoCommerce account ID)
__SYNC_KEY
Responses
Endpoint: List Responses
Update Method: UPSERT
Table Name:
[knocommerce.responses]
results[].response[].id
RESPONSE_ID
results[].response[].account_id
ACCOUNT_ID
results[].response[].created_at
CREATED_AT
results[].response[].updated_at
UPDATED_AT
results[].response[].completed_at
COMPLETED_AT
results[].response[].
CUSTOMER_ID
results[].response[].
CUSTOMER_EMAIL
results[].response[].
CUSTOMER_PHONE
results[].response[].
CUSTOMER_SHOP
results[].response[].
CUSTOMER_LIFETIME_SPENT
results[].response[].
CUSTOMER_LIFETIME_ORDERS
results[].response[].
TIME_SPENT
results[].response[].
SURVEY_ID
results[].response[].
RESPONSE_ORDER_RESPONSE_ID
results[].response[].
RESPONSE_ORDER_ORDER_ID
results[].response[].
RESPONSE_ORDER_ORDER_NUMBER
results[].response[].
RESPONSE_ORDER_TOTAL_PRICE
results[].response[].
RESPONSE_ORDER_CURRENCY
results[].response[].
RESPONSE_ORDER_BROWSER_IP
results[].response[].
RESPONSE_ORDER_USER_AGENT
results[].response[].
CUSTOMER_JOURNEY_RESPONSE_ID
results[].response[].
CUSTOMER_JOURNEY_ORDER_ID
results[].response[].
CUSTOMER_JOURNEY_LAST_VISIT_SOURCE
results[].response[].
CUSTOMER_JOURNEY_LAST_VISIT_UTM
results[].response[].
CUSTOMER_JOURNEY_FIRST_VISIT_SOURCE
results[].response[].
CUSTOMER_JOURNEY_FIRST_VISIT_UTM
results[].response[].
CUSTOMER_JOURNEY_DAYS_TO_CONVERSION
results[].response[].
CUSTOMER_JOURNEY_CUSTOMER_ORDER_INDEX
MD5(RESPONSE_ID + KnoCommerce account ID)
__SYNC_KEY
results[].response[].order.id
RESPONSE_ORDER_ID
Survey Questions
Endpoint: List Surveys
Update Method: UPSERT
Table Name:
[knocommerce.survey_questions]
results[].id
SURVEY_ID
results[].questions[].id
QUESTION_ID
results[].questions[].label
LABEL
results[].questions[].type
TYPE
results[].questions[].values
QUESTION_VALUES
MD5(SURVEY_ID + QUESTION_ID + KnoCommerce account ID)
__SYNC_KEY
Surveys
Endpoint: List Surveys
Update Method: UPSERT
Table Name:
[knocommerce.surveys]
results[].id
SURVEY_ID
results[].accountId
ACCOUNT_ID
results[].createdAt
CREATED_AT
results[].updatedAt
UPDATED_AT
results[].title
TITLE
MD5(SURVEY_ID + KnoCommerce account ID)
__SYNC_KEY
Last updated