Hello!
I have a request that I want to track how many contacts opened or not the e-mail, I'm reading that I need to create a query to populate a boolean field in DE 'IsOpened'.
As I'm a beginner in MKT Cloud I really appreciate it if you have some examples of links that helps me get this request with success!
PS.: My DE has 4 fields:
- Name;
- Phone;
- Email (Primary Key);
- CEP;
Thank you so much!
Hey, Brunão!
Sorry for the delay, but it was crazy today!
My approach for that solution would be something like that:
Your sent email will generate a JobId, right?!
With that said, you could have an automation that would flag your data extension according to the openings in your email.
The data view would be Click and your query may seem like:
SELECT
URL
, count(*) as [Clicks]
from _Click with (nolock)
where JobID = 1234
https://help.salesforce.com/articleView?id=mc_as_data_view_click.htm&type=0You will have SubscriberId, as well as SubscriberKey that you could use to link who has opened your link on this table.
For instance: Gui has opened link 1.
Once you have identified it and have performed the exact query, you could use your data extension to get data from there and send it elsewhere (maybe by using JavaScript to send it through an API).
