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 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]
| JSON Element | Database Column |
|---|---|
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]
| JSON Element | Database Column |
|---|---|
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]
| JSON Element | Database Column |
|---|---|
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]
| JSON Element | Database Column |
|---|---|
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]
| JSON Element | Database Column |
|---|---|
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