3
Columns that contain space or use reserved SQL keyword needs to be wrapped in the square brackets so that the query knows it is a single Column.
Use [Communication Key], and all should work.
1
You have to specify if you only want unique opens -- otherwise, _Opens reflects every open of an email by a subscriber:
select
o.SubscriberKey as 'EMAIL'
, o.eventdate as 'Data_abertura'
, o.jobid
, o.ListID
, o.BatchID
, o.TriggererSendDefinitionObjectID
, j.EmailName
, j.EmailSubject
, j.DeliveredTime
, j2.JourneyName
, j2.VersionNumber
, j2....
1
You would need to find the foreign key(s) that correctly matches each row in the two DEs for this task.
As @MateuszDabrowski stated, INSERT INTO, etc. are not acceptable, only queries via SELECT. To this extent you need to use a JOIN in your SQL Query to accomplish this.
To that extent, you would want something like the following:
SELECT a.primarykey,
b.[...
1
Marketing Cloud doesn't support INSERT INTO, just standard SELECT.
Use SELECT with JOIN in a Query Activity of the Automation Studio and output to the desired Data Extension.
1
As you want to use a query for that, you can do it with a simple join:
SELECT
de2.EmailName
, de2.TotalSent
, de2.UniqueClicks
, de2.UniqueOpens
, de1.SourceCode
FROM DataExtension2 AS de2
LEFT JOIN DataExtension1 AS de1
ON de1.EmailName = de2.EmailName
However, I wouldn't recommend doing it that way, as it would require ...
Only top voted, non community-wiki answers of a minimum length are eligible
