Datasource Email Notices Activity+ (SAP App Center leads)
Query(s)
SELECT
[sqlproxy].[Action_Date],
[sqlproxy].[Customer],
[sqlproxy].[Email_Subject],
[sqlproxy].[Number of Records],
[sqlproxy].[Sheet],
[sqlproxy].[Table Name],
[sqlproxy].[User_name],
[sqlproxy].[emailtrack_action],
[sqlproxy].[emailtrack_address],
[sqlproxy].[licensetype_desc],
[sqlproxy].[product_desc],
[sqlproxy].[user_loginid],
[sqlproxy].[user_registrationdate],
[sqlproxy].[userlicense_activationlimit],
[sqlproxy].[userlicense_issuedate]
FROM
[sqlproxy]
Datasource Marketo
Query(s)
SELECT
[Activity - Send Email].[id],
[Activity - Send Email].[Mailing_ID],
[Activity - Send Email].[Campaign_Run_ID],
[Activity - Send Email].[Choice_Number],
[Activity - Send Email].[Has_Predictive],
[Activity - Send Email].[Step_ID],
[Activity - Send Email].[Test_Variant],
[Activity - Send Email].[Lead_ID],
[Activity - Send Email].[Campaign_ID],
[Activity - Send Email].[Activity_Date]
FROM
[activity6] AS [Activity - Send Email]
SELECT
[Campaigns].[id] AS [id (Campaigns)],
[Campaigns].[name],
[Campaigns].[description],
[Campaigns].[programName],
[Campaigns].[programId],
[Campaigns].[workspaceName],
[Campaigns].[createdAt],
[Campaigns].[updatedAt],
[Campaigns].[active]
FROM
[campaignsTable] AS [Campaigns]
SELECT
[Activity - Email Delivered].[id] AS [id (Activity - Email Delivered)],
[Activity - Email Delivered].[Mailing_ID] AS [Mailing_ID (Activity - Email Delivered)],
[Activity - Email Delivered].[Campaign_Run_ID] AS [Campaign_Run_ID (Activity - Email Delivered)],
[Activity - Email Delivered].[Choice_Number] AS [Choice_Number (Activity - Email Delivered)],
[Activity - Email Delivered].[Has_Predictive] AS [Has_Predictive (Activity - Email Delivered)],
[Activity - Email Delivered].[Step_ID] AS [Step_ID (Activity - Email Delivered)],
[Activity - Email Delivered].[Test_Variant] AS [Test_Variant (Activity - Email Delivered)],
[Activity - Email Delivered].[Lead_ID] AS [Lead_ID (Activity - Email Delivered)],
[Activity - Email Delivered].[Campaign_ID] AS [Campaign_ID (Activity - Email Delivered)],
[Activity - Email Delivered].[Activity_Date] AS [Activity_Date (Activity - Email Delivered)]
FROM
[activity7] AS [Activity - Email Delivered]
SELECT
[Activity - Open Email].[id] AS [id (Activity - Open Email)],
[Activity - Open Email].[Mailing_ID] AS [Mailing_ID (Activity - Open Email)],
[Activity - Open Email].[Campaign_Run_ID] AS [Campaign_Run_ID (Activity - Open Email)],
[Activity - Open Email].[Choice_Number] AS [Choice_Number (Activity - Open Email)],
[Activity - Open Email].[Device],
[Activity - Open Email].[Has_Predictive] AS [Has_Predictive (Activity - Open Email)],
[Activity - Open Email].[Is_Mobile_Device],
[Activity - Open Email].[Platform],
[Activity - Open Email].[Step_ID] AS [Step_ID (Activity - Open Email)],
[Activity - Open Email].[Test_Variant] AS [Test_Variant (Activity - Open Email)],
[Activity - Open Email].[User_Agent],
[Activity - Open Email].[Lead_ID] AS [Lead_ID (Activity - Open Email)],
[Activity - Open Email].[Campaign_ID] AS [Campaign_ID (Activity - Open Email)],
[Activity - Open Email].[Activity_Date] AS [Activity_Date (Activity - Open Email)]
FROM
[activity10] AS [Activity - Open Email]
SELECT
[Activity - Click Email].[id] AS [id (Activity - Click Email)],
[Activity - Click Email].[Mailing_ID] AS [Mailing_ID (Activity - Click Email)],
[Activity - Click Email].[Campaign_Run_ID] AS [Campaign_Run_ID (Activity - Click Email)],
[Activity - Click Email].[Choice_Number] AS [Choice_Number (Activity - Click Email)],
[Activity - Click Email].[Device] AS [Device (Activity - Click Email)],
[Activity - Click Email].[Is_Mobile_Device] AS [Is_Mobile_Device (Activity - Click Email)],
[Activity - Click Email].[Is_Predictive],
[Activity - Click Email].[Link],
[Activity - Click Email].[Link_ID],
[Activity - Click Email].[Platform] AS [Platform (Activity - Click Email)],
[Activity - Click Email].[Step_ID] AS [Step_ID (Activity - Click Email)],
[Activity - Click Email].[Test_Variant] AS [Test_Variant (Activity - Click Email)],
[Activity - Click Email].[User_Agent] AS [User_Agent (Activity - Click Email)],
[Activity - Click Email].[Lead_ID] AS [Lead_ID (Activity - Click Email)],
[Activity - Click Email].[Campaign_ID] AS [Campaign_ID (Activity - Click Email)],
[Activity - Click Email].[Activity_Date] AS [Activity_Date (Activity - Click Email)]
FROM
[activity11] AS [Activity - Click Email]
Datasource bnbdatabase1
Query(s)
SELECT
[sqlproxy].[ID],
[sqlproxy].[Number of Records],
[sqlproxy].[SID],
[sqlproxy].[active (Custom SQL Query1)],
[sqlproxy].[active],
[sqlproxy].[address],
[sqlproxy].[address_id (Custom SQL Query1)],
[sqlproxy].[address_id (store)],
[sqlproxy].[address_id],
[sqlproxy].[city],
[sqlproxy].[country (customer_list)],
[sqlproxy].[country],
[sqlproxy].[country_id],
[sqlproxy].[create_date (Custom SQL Query1)],
[sqlproxy].[create_date],
[sqlproxy].[customer_id (Custom SQL Query)],
[sqlproxy].[customer_id (Custom SQL Query1)],
[sqlproxy].[customer_id],
[sqlproxy].[email (Custom SQL Query1)],
[sqlproxy].[email],
[sqlproxy].[first_name (Custom SQL Query1)],
[sqlproxy].[first_name],
[sqlproxy].[inventory_id],
[sqlproxy].[last_name (Custom SQL Query1)],
[sqlproxy].[last_name],
[sqlproxy].[last_update (Custom SQL Query)],
[sqlproxy].[last_update (Custom SQL Query1)],
[sqlproxy].[last_update (country)],
[sqlproxy].[last_update (store)],
[sqlproxy].[last_update],
[sqlproxy].[manager],
[sqlproxy].[manager_staff_id],
[sqlproxy].[name],
[sqlproxy].[notes],
[sqlproxy].[phone],
[sqlproxy].[rental_date],
[sqlproxy].[rental_id],
[sqlproxy].[return_date],
[sqlproxy].[staff_id],
[sqlproxy].[store],
[sqlproxy].[store_id (Custom SQL Query1)],
[sqlproxy].[store_id (store)],
[sqlproxy].[store_id],
[sqlproxy].[total_sales],
[sqlproxy].[zip code]
FROM
[sqlproxy]