Connector name:Marketo

Table name:ACTIVITY_VISIT_WEBPAGE 

Column to add:WEBPAGE_URL 

API documentation link:https://developer.adobe.com/marketo-apis/ 

Additional details:

We are writing to request a feature enhancement regarding the Marketo connector, specifically concerning the retrieval of WEBPAGE_URL for the ACTIVITY_CLICK_LINK table.

Problem Description:

Our current Fivetran Marketo connector setup synchronizes ACTIVITY_CLICK_LINK and ACTIVITY_VISIT_WEBPAGE tables. While Marketo's native interface provides "Webpage URL" and "Web ID" for ACTIVITY_CLICK_LINK data, the Fivetran-synced ACTIVITY_CLICK_LINK table only contains WEBPAGE_ID and lacks the corresponding WEBPAGE_URL.

We understand that WEBPAGE_ID from ACTIVITY_CLICK_LINK would ideally be used to join with ACTIVITY_VISIT_WEBPAGE to retrieve the WEBPAGE_URL. However, the ACTIVITY_VISIT_WEBPAGE table, as synced by Fivetran, contains WEBPAGE_URL but lacks a WEBPAGE_ID column. This discrepancy prevents us from accurately joining these two tables to identify the WEBPAGE_URL associated with each link click activity.

We have confirmed with Fivetran support that there is currently no guaranteed method for joining these tables to obtain the WEBPAGE_URL, and that the absence of WEBPAGE_ID in ACTIVITY_VISIT_WEBPAGE is considered the current intended specification, not a bug.

Impact:

The inability to link ACTIVITY_CLICK_LINK to WEBPAGE_URL significantly hinders our ability to perform comprehensive analysis on user engagement and the effectiveness of our marketing campaigns within Marketo. Without this crucial information, it is challenging to understand which specific pages users are clicking on, limiting our data-driven decision-making.

Requested Enhancement:

We kindly request the following improvements to the Marketo connector:

1. Include WEBPAGE_ID in the ACTIVITY_VISIT_WEBPAGE table: This would enable a reliable join with ACTIVITY_CLICK_LINK using WEBPAGE_ID, allowing us to accurately retrieve WEBPAGE_URL for link clicks.
2. Alternatively, provide WEBPAGE_URL directly in the ACTIVITY_CLICK_LINK table: If including WEBPAGE_ID in ACTIVITY_VISIT_WEBPAGE is not feasible, syncing WEBPAGE_URL directly into the ACTIVITY_CLICK_LINK table would resolve the issue.

Implementing this enhancement would greatly improve the utility of the Fivetran Marketo connector for our analytical needs.

Thank you for your time and consideration.

Sincerely,