You generally have to purchase zipcode data that contains latitude and longitude values.
Once you have it, you can calculate the X, Y, and Z-Axis values you need to utilize it using Query Activities:
, cos(radians(latitude)) * cos(radians(longitude)) xaxis
, cos(radians(latitude)) * sin(radians(longitude)) yaxis
, sin(radians(latitude)) zaxis
I would like to shed some light here since it has been a couple of days without any comments or answers.
I went through the documentation and help pages and found nothing regarding blackout period specifically for SMS sends using Transactional API, however, there is a little note in the blackout period doc:
Any send blackout time specified in the ...
The workaround is to replace ';' with CHAR(59).
I found the available character codes here:
The SQL Server CHAR String Function converts any of 256 integer ASCII
codes to a character value.
Given that a subscriber key (123) exists in All Subscribers with email address (email@example.com) it will take priority over the email address in your sendable data extension. Assuming your sendable data extension or triggered send API call holds same subscriber key (123) with different email address (firstname.lastname@example.org), the email will still be sent to me@...
When you make a RetrieveRequest where the response indicates there are further pages of results that may be retrieved, you'll receive an OverallStatus of "MoreDataAvailable" similar to this response:
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" ...
You can fetch the content of the personalised email, retrieving it from VAWP URL, using following code:
IF _messagecontext == "SEND" AND jobid > 0 THEN
set @HTML = HTTPGet(view_email_url)
You could try using Data Extract SendJobs. This has a field 'PreviewURL' which can show you the preview of the message sent to the subscriber. However, it will not render personalization. So if you have too much personalization in your content, this might not be very useful.
I created a workaround to bypass this problem.
First Query gives me the info on the customer via the AccountID.
Second Query updates the Data Extension of the first Query, with supplementary info based on the Partner ID matched with AccountID.
Thanks for taking the time to try and solve it Jonas.
The reason there is no Reporting available for Publication Lists is that they are not actually "Lists", as they do not hold Attribute data as the Lists do, just subscriber identifying information such as Email Address, Subscriber Key if used in the account, and Status. Normal Reports for Lists will not work on a Publication List.
To get data about ...
For the second point:
When a new contact enters the journey and receives an email, it is then inserted in 'All Subscribers'. If you are using OOB Profile Center and if the user updates the language preference, this will sync back to Salesforce. Hope this helps. :)
There is a hidden field _CustomObjectKey which is used in AmpScript, this field may also be requested for DataExtensionObject:
Thanks to Jonas Lamberty for a hint!
You are starting off the quote. I would approach this the opposite way.
get all accounts with their quotes (simple inner join)
get all partners with their quotes (simple inner join)
make them all a big list (UNION)
In case you work off different base DEs, it's important that you align all fields before the UNION. Since both of your queries are from ...
If I understand correctly, you are posting parameters to the form page itself. And upon reload of the page you want to prefill values which you have retrieved through RequestParameter().
In this case, you don't need a data extension lookup. You can just display the variable value in the html input element using value attribute in combination with using ...
I understood that you would like to know if there is any standard report that can be generated for the publication list.
I would like to inform you that, at present, we do not have a standard report on the publication list at SFMC.
The reason there is no Reporting available for Publication Lists is that they are not actually "Lists", as they do not ...
Yes, but not as simply as it sounds.
Basically, you would have to use the REST API to send an email test send based off subscriber data.
So to do this, you would need to either have a default 'test data' DE that you use, or you would have to have this as a field in your form for the Brand team to add in.
See this article from my blog for detailed info on ...
Assuming that in each of the phone numbers, what you are looking for is prepending the part you want to keep, the following should work:
Replace all spaces inside of string via REPLACE()
Cut off all 'extra' characters from the left side of the string via RIGHT()
This should then leave you with your phone number without the unnecessary prepends or the ...
Unfortunately you cannot upload the videos longer than 60 seconds duration or 100 MB size.
The below article will assist you in how to upload Image,
There are limitations for both ...
This is not an uncommon scenario in large enterprise system landscapes, where Sales Cloud isn't system of record for customer identity. This is not very optimal, but can be solved while maintaining a close-to-standard scope of features.
First of all, as you correctly state, Synchronised Data Extensions (leads, contacts, users) automatically count towards ...
You're not selecting Country in your subquery. Assuming it's present in the [Master DB] data extension:
WHEN x.Country IN ('US', 'CA') THEN 'NA'
WHEN x.Country IN ('DE', 'FR', 'GB', 'DK', 'FI', 'SE', 'AT', 'PL', 'PT', 'NO', 'NL', 'IE', 'BE') THEN 'EU'
You could potentially discuss feasibility of building a Custom Extract for getting historic Journey entry data out of Marketing Cloud with Salesforce's Services Team ($$$).
On your own, it's not possible to get long term historic data on who passed through your Journey Builder Interactions. There is an undocumented and unsupported REST endpoint you can use. ...
There are vendors that have products that do this. One that comes to mind is https://levdigital.com/what-we-do/campaign-studio/
This is pretty much what you would have to do on your own via APIs, but turned into a product.
If you plan to do it on your own I would recommend looking at this amazing postman collection
The 200+ calls ...
in order to be prepolated, the value of your hidden field needs to be the value of the variable- You might be confusing it with the SET statement of a variable:
assuming this code is above your hidden field:
set @contactid = Lookup("Test Extension", "Contact ID", "Contact ID", @contactid)
, this is how you would enter the value ...
l.Email AS Email
,l.et4ae5__HasOptedOutOfMobile__c AS SubscribeSMS
,l.HasOptedOutOfEmail AS SubscribeEmail
,NULL AS FirstName
,NULL AS LastName
,l.Subscriber_ID__c AS SubscriberKey
,'Lead' as Source
,NULL AS MobilePhone
FROM Lead_Salesforce AS l
WHERE ISNULL(l.Subscriber_ID__c, '') <> ''
AND NOT EXISTS (SELECT 1 FROM Contact_Salesforce AS c ...
If you don’t set up your journey to have paths that can go into day 7, there’s no way to inject them directly into day 7. You’ll need to either use data attributes and a Decision Split to put them there.
For example, if you have a column name with day and a numerical value of 7. Then at the beginning of the journey have a Decision Split that puts them before ...
You can try setting a variable to show/hide the footer in account settings. Then define that variable in the email where you want to hide it. For example, in your account settings footer:
%%[ if @hideFooter == “true” then ]%%
%%[ else ]%%
[HTML Footer goes here]
%%[ ending ]%%
In your email:
%%[ set @hideFooter = “true” ]%%
For the action of your form, you need to state the stack you're on. The docos assume S1. For posting/getting all other stacks, you need to state the stack. Salesforce should improve the documentation, but DEManager's not an area of focus:
Unfortunately, there are no specific permissions for Synchronized Data Extensions - you would have to disable overall access to all Data Extensions.
And yes, you are correct, you need to restrict access to Contact Builder to make sure your users don't have access to Synchronized Data Sources.
You're not retrieving any rows from the Data Extension you've initialized, so there's nothing to loop around. See the top of the SSJS Core code below for an example of getting "data" from your Data Extension that you could iterate through.
If this is part of something you're doing regularly, although you can do this with WSProxy, I'd recommend ...
I believe the issue is because in your HTTPPost2 function itself.
Based on the documentation the parameters are as followed:
Please pay attention to parameter 5 and 6 in your code:
SET @req = HTTPPost2(@url, "application/json", @payload, false, "Authorization", @auth, @response)
You have moved your @response variable to #7
The correct ...
I think what you are outputting is correct in what is coded, but that is not the output you actually intended to code for. I am assuming you just want the output to be once per label/value combination.
To achieve that, I would adjust your code to include some conditionals to only output on even iterative numbers and to clear the label/value after output.
As @Macca suggested, a try/catch will give you an insight as to the exact error. I tend to just use a debug flag variable and some outputs before conditionals and operations on external data. Most of the time you can narrow down the offending code or value just by stepping through.
When it comes to the troubleshooting SF Object functions, I'd start with ...
In the benefit of others, after reaching out to Salesforce, it was understood that the payload needs to be modified in such a way that it either passes the culture code which is required to be 'US' only, or we can pass the created date or modified date in the payload. This is a know issue in Salesforce.
Also, the value for Opt In needs to be passed as '2', ...
Lightning Experience is not supported for Marketing Cloud Connect features. Those using Lightning Experience with Salesforce are automatically redirected to Salesforce Classic when any Marketing Cloud Connect tabs are clicked.
I think your sub-queries should include the same columns to satisfy the UNION ALL syntax. You can use a partition to deduplicate and comply with your target DEs primary key.
I'd recommend selecting a date column (modified or created) in your sub-queries and using that value pick the row to return in your partition:
Select top 1 with ties
This error is due to your query returning duplicate values for your primary key column. I assume your primary key column is SubscriberKey. When applying DISTINCT, you will get distinct values across both SubscriberKey and Source. Hence if one SubscriberKey is present on multiple sources, your query will fail. You can solve it by making both SubscriberKey and ...
The following is based on the assumption that you want the extracted data to land on your Marketing Cloud FTP.
Firstly, you'll need to ask Marketing Cloud Support to provision the data extract type you require (data extension), if you haven't already.
Then, after your SQL activity, drag in a data extract activity as your second step. You should now be able ...
Depending on the complexity of the information regarding classes, the easiest way to solve this, if you only want to include e.g. class name, is to use BuildRowsetFromString function. Assuming you pass the names into parameter classnames as pipe delimited values:
First class|Second class|Different class|A whole other class|Working class
You can use ...
You can achieve this very easily in Automation Studio by creating a Data Filter activity and scheduling it to run on a time interval, eg. daily, hourly, etc.
Here’s all the steps:
Create a Data Filter
Log in to the Marketing Cloud application.
Go to Email Studio | Email | Subscribers | Data Filters. Click Create.
Select the Data Source from the picklist. ...
You can not use REST for deleting records in data extension, as only SOAP supports delete. You can follow the example provided in the documentation, utilising following SOAP payload:
<s:Envelope xmlns:s="http://www.w3.org/2003/05/soap-envelope" xmlns:a="http://schemas.xmlsoap.org/ws/2004/08/addressing" xmlns:u="http://docs.oasis-...
Yes, you need to configure Parameter Manager as described in these docs. The default string which will be automatically appended to all the links is:
You can use majority of the personalisation strings ...
When you send to a Salesforce Report, Marketing Cloud only cares about one of four fields ("ContactID", "Contact ID", "LeadID" or "Lead ID"). All the other fields in your report are ignored and are unavailable for personalization.
The high-level workflow of a send to a Report (or Campaign) is as follows:
It doesn't appear it is accessible anywhere:
Here is the Idea to make it accessible through a personalization string
Here is a similar question on the community where it also states this isn't accessible anywhere.
If you are looking to pass attributes for an email in UTM stings you could enable Parameter manage and use q of the 5 Additional Email Attrbiutes ...