New answers tagged

3

Currently the data retention policies for Salesforce Data Extension cannot be modified through Email Studio. To update the retention policy so that changes are retained, it should be done through Contact Builder.


1

Regarding Business Units, first tell me this. Can you confirm that you are retrieving Data Extensions from all business units? We thought we were at first, bu it turns out the SDK limits you to one business unit. So one way you could filter is by setting the accountId in your config array here $config = array( 'appsignature' => 'none', '...


2

In order for it to appear in the data designer, it has to finish its synchronization and then complete the "contacts registration". After the first time you sync an object, it will pull in all the data and once it completes, it will attempt to register with your contact model. This will create the data extension under the Synchronized Data Extension ...


2

Add a prefix of "ENT" if running the query from a child Business Unit. "FROM ENT._subscribers"


0

That documentation is for Smart Capture forms for legacy Landing Pages/Microsites within Email Studio. The Cloud Pages Smart Capture documentation is below. https://help.salesforce.com/articleView?id=mc_cp_smart_capture_block.htm&type=5 No upsert option exists in CloudPages currently. The workaround is to create a custom form via HTML on your landing ...


0

I would first create a field called JobID inside your DocCobranca DE (gonna call this DC). Then use an AMPscript Upsert inside the email to insert the JobID and 'SentDate' into the DE. For example: UPSERT("DocCobranca",1,"SubscriberKey",_SubscriberKey,"JobID",jobid,"SentDate",NOW()) Now if you are going to be including multiple iterations of each ...


0

Journey Builder sends are triggered sends. You can utilize the TriggeredSendCustomerKey with the Click Data View to query clicks from a Journey Email Send. You can then join on your data extension to add desired DE fields (Name, Address, DOB, ZIP, etc...) to your query results. https://help.salesforce.com/articleView?id=mc_as_data_view_click.htm&type=5


0

You would need to join the _Click Dataview to the DE that has the information you want to include SQL Joins from W3 School a basic example would be Select a.name, b.click from [DENAME] a join _click b on b.subscriberkey = a.subscriberkey where b.jobid = XXX You can then also join the _Journey dataviews if you want to add where clauses to pull data from a ...


4

I would suggest having a data extension responsible for archiving data older than X months into. The idea here would make something similar to data retention where you maintained a data extension/table that you kept your data of interest in and also silo'd your historical data. Ideally (depending on the age of the data extension) this would be somewhere ...


1

Instead of using measures, which is a legacy feature of Marketing Cloud, you could write an SQL query in Automation Studio to query system Data Views (for example the _Open data view) and automate it to run on a schedule. Here you can read more about Data Views and using SQL in Marketing Cloud.


5

This should be done via query activity as this will result in a non-performant Filter activity being created. This will pull against the full scope of each data view referenced by the query activity. From a "why it doesn't work" perspective of making measures/filters like this the methodology being used here is opposite what is expected. Not open or ...


0

It is to do with the manage policies on the filtered data extension. It appears that by default, when you create a filtered data extension, the checkbox is unchecked ‘Allow users to delete this Data Extension’. Therefore, you have to tick it and then you can delete it.


1

%%[ /* Replace this with your DE lookup */ SET @xml = "<Details><Detail><Status>Current</Status><Membership>Gold</Membership></Detail></Details>" set @status = Field(Row(BuildRowsetFromXML(@xml,"/Details/Detail/Status"), 1), 'Value') set @membership = Field(Row(BuildRowsetFromXML(@xml,"/Details/Detail/...


0

I would recommend to stick with queries. Keep in mind that you can increase dramatically the performance of your queries by using non clustered indexes. Even though that is not something you can do on you own on the data extension properties, you just send a support ticket asking "please add a non clustered index to the column Date of the data extension X" ...


2

I recommend a send log. Ask support to enable the functionality, then create a data extension "from template" / SendLog. Every record that is actually sent from your BU is inserted into this data extension at send time. here is the documentation for this. https://help.salesforce.com/articleView?id=mc_es_send_logging.htm&type=5 Since every one of your ...


4

In order to do this, you will need to contact SFMC Support and request a business rule "Allow Blank File Processing" to be enabled on your instance. This allows the import of empty files without halting the process. By default the settings in the backend force a stop on blank imports, but with this business rule enabled it is changed to continue.


0

As every subscriber has an associated Subscriber Key in all Subscribers List, this field is the only required one for an exclusion data extension.


0

This looks like the expected behavior would be no result. Regardless of "amount" - You are looking for one individual Account with opportunity.closedate 2018 AND 2019 at the same time. This will never match, as the value would always be either 2018 / or 2019 on that same record. You want to combine results, not queries on the same record. I think this ...


1

Use Data Loader or Dataloader.io to export all Leads and Contacts with the email field. Create a single google workbook or excel workbook to cross-check the resulting lists with your Data Extension emails. Here's some instructions on doing this in excel


1

Answered my own question. After you select a DE, then a deduplicate checkbox appears. But not before. As shown in these screenshots (before/after). BEFORE: AFTER:


1

If you are looking at deleting Millions of rows then using a staging table may be the most optimized way, however for smaller volumes SSJS Activities may be able to help - for example using WSProxy (https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-content.meta/mc-programmatic-content/ssjs_WSProxy_delete.htm) would allow you to do ...


0

There’s a SetCookie function that you can set using SSJS to store cookie values. You can also use the UpsertData function to write records to the data extension. Note that you’ll need to uniquely identify these records in your data extension so using the GUID function might help. Since the visitors will be unidentified, the GUID will help to assign a ...


2

The formatDate function does remove the time aspects from the date. Since you have an input type below i believe that you have a form and a submit function which then takes this value and writes the Data to a DataExtension via UpdateData() or InsertData(). You just have to remove the formatDate function. If you not do this salesforce will default the time to ...


1

Nevermind, I found the issue. Instead of this in the subject line: %%[v(@subjectline)]%% I needed to have this %%=v(@subjectline)=%%


1

Using WsProxy, you need to supply the ObjectID for the specific QueryDefinition object you are updating. The ObjectID is not the same as External Key or CustomerKey. It is available by copying the URL link to the Query Activity in the Activities tab within Automation studio interface. It's the GUID at the end of the URL. I'm not sure how else to retrieve ...


3

Use an IF condition statement and assign the colour to a variable then inline the value in the style attribute of your p (or similar) tag. This code assumes your status value from the DE is available as a Data Extension attribute, otherwise use a lookup. %%[ VAR @color, @status, @msg SET @status = AttributeValue("status_field") IF @status == "active" THEN ...


2

You can do it if you just click on the subjectline and the bolt next to it, then you can create dynamic subject lines. But depending on your use case you maybe even want to do it with ampscript. In the subjectline paste %%=v(@subjectline)=%% Code: %%[ VAR @status, @subjectline SET @status = [dataextensioncolumnname] IF @status == 0 THEN SET @...


2

You'd just need to do another retrieve of the DataExtension object using the DataExtensionTarget.Name in your filter. The resulting CategoryID is the ID of the folder. Once you have that, you can retrieve the DataFolder object with that ID. If you want to get fancy, you can build something that traverses all of the parent folder Category IDs and builds ...


0

Since you are using the MC Connector, then you can just use the Salesforce Data Event for your entry. This would allow you to specify your entry criteria (i.e. trigger journey entry based on an event in your Person Account object), and select data from that and related objects in SF to enter with the subscriber in SFMC. Just sync all the objects w/ the data ...


1

'Personalization strings' can only be leveraged from the sending DE. If you want to use a field from another DE you would need to do a lookup() function. Detailed in the dev docs: 'Lookup Function' You could use this inline within the email like %%=lookup('Contacts','referralcode','subscriberkey',_subscrberkey)=%%


1

Are you filtering on a primary key or a non-nullable field? I've tested this and was able to keep the leading zero in the value: Source Data Extension: Filter: Filtered Data Extension:


1

I'm assuming you want to counts of a recent send. You can join on the JobId on _Sent, _Click, and _Open data views. The JobId can be found in the Tracking of recent sends. You can also join on SubscriberKey, but not all records will exist in Open or Click data views. SELECT COUNT (DISTINCT SubscriberKey) AS Number_Of_Records FROM _Sent s INNER JOIN _Open o ...


2

You can use the API to find the query via the name of your target DE. Sample SOAP call: <RetrieveRequestMsg xmlns="http://exacttarget.com/wsdl/partnerAPI"> <RetrieveRequest> <ObjectType>QueryDefinition</ObjectType> <Properties>Name</Properties> <Properties>CustomerKey</Properties&...


3

You can build an Automation with a SQL Query for each Data Extension. If that is not the answer you are looking for, please specify your problem. Regards, Christian


-1

If that DE is being used as a target DE for a query you can go to automation studio > activities > sql query. And in the overview screen you can see the queries and the target DE


Top 50 recent answers are included