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:

• List Benchmark Questions

• List Responses

• List Surveys

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
• Response Values
• Responses
• Survey Questions
• Surveys

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