Kassia_Wilhelm
Level 2
Seattle, WA
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
08-24-2020
05:11 PM
|
17
Posts
6
Likes
2
Solutions
07-28-2020
04:49 PM
Hi Amy,
I have 2 RCM stages that I want to pass back into Google Ads as offline conversions. The stages have hundreds of thousands of members, many who we know came through an ad, and yet almost no one is mapping back to Google Ads. I say almost no one because there are a few random stragglers coming through which makes it that much stranger. Google Ads conversion screen is shown below.
This is the Revenue Cycle Model in Marketo:
The "Smartscored" and "Opportunity" are the offline conversions I want to pass back to Google Ads, and so they have offline conversion metrics associated with them. The "nothing" step at the end is added to met the 6-stage threshold that seems to be required to approve the phases and the model.
For example 162 people moved into the Smartscored stage in the last week who have a GCLID value, and yet I don't see those offline conversions sync over to Google Ads.
Do you have any ideas for why the offline conversions might not be syncing over?
... View more
07-09-2020
06:30 PM
1 Like
I think I have read ALL the discussions and documents about the Marketo / Google AdWords integration and am at a loss for how to get it to work. I want offline conversions to get pushed back into Google Ads.
I have:
Connected AdWords account to Marketo in Admin section.
Created a Revenue Cycle Model with stages as the offline conversions I want. Approved RCM. Confirmed leads are populating in the model.
Mapped the stages to new offline conversion metrics in Google Ads. The new conversion fields DID appear in Google Ads when I created them in Marketo, but no actual conversions are coming through.
Confirmed auto-tagging is enabled in Google Ads.
Started capturing GCLID in a Marketo field called "GCLID". Successfully populating.
And yet, it's still not working. Has anyone had success with this? Any ideas of what I'm missing?
... View more
11-02-2015
05:05 PM
UPDATE: It appears that Marketo did some kind of update that made my previous solution no longer work. Now in order to get the Javascript to work I had to change the syntax from the encoded values back to the normal text values - so as follows: <script type="text/javascript"> window.onload = function() { var tz = "10:00 AM - 10:45 AM PDT"; if ("{{lead.Time Zone}}" == "Pacific/Tongatapu") { tz = "6:00 AM - 6:45 AM TOT"; } else if ("{{lead.Time Zone}}" == "US/Samoa") { tz = "6:00 AM - 6:45 AM SST"; } else if ("{{lead.Time Zone}}" == "US/Hawaii") { tz = "7:00 AM - 7:45 AM HAST"; } else if ("{{lead.Time Zone}}" == "US/Aleutian") { tz = "8:00 AM - 8:45 AM HADT"; } else if ("{{lead.Time Zone}}" == "US/Alaska") { tz = "9:00 AM - 9:45 AM AKDT"; } else if ("{{lead.Time Zone}}" == "US/Pacific") { tz = "10:00 AM - 10:45 AM PDT"; } else if ("{{lead.Time Zone}}" == "US/Arizona") { tz = "10:00 AM - 10:45 AM MST"; } else if ("{{lead.Time Zone}}" == "US/Central") { tz = "12:00 PM - 12:45 PM CDT"; ... } else { tz = "10:00 AM - 10:45 AM PDT"; } document.getElementById("timeZone").innerHTML = tz; } </script>
... View more
05-26-2015
11:36 AM
2 Likes
I also had this issue, as did everyone on my team - any HTML editor would appear blank. We were all using Chrome and logged a Marketo support ticket about it. They told us to clear our browser caches and that did the trick for all 3 of us.
... View more
10-09-2014
03:25 PM
Yeah, that's how I set it up and with comments. I'll just have to create a thorough process document when I pass on the ownership of the webinars.
... View more
10-09-2014
01:20 PM
I have an example. I have a weekly webinar that I want to tokenize entirely so that I can have my support team clone the program and replace the tokens and not have to go into any of the assets beyond that. Additionally this is a global webinar and I want the time zone to change depending on the user's time zone (which we take from browser use from all users). Depending on if the webinar is in the US or in Australia it will take place on a different day (Wednesday 4PM Pacific is Thursday 9AM in some parts of Australia). I want to be able to say if the user is in a certain set of time zones, show one custom token, if they're in another, show a different custom token (dates). I would need to be able to put a custom token in an email script token to do this. In the meantime I'll have to find a work around.
... View more
10-09-2014
01:08 PM
1 Like
Wanted to update this post in case anyone experiences a similar issue. This is what eventually worked for me to use a parseInt-type function:
<tools>
<toolbox scope="application">
<tool class="org.apache.velocity.tools.generic.ConversionTool" dateFormat="yyyy-MM-dd"/>
</toolbox>
</tools>
#set( $DomainCount = $math.toInteger(${lead.Domain_Use_in_Past_Year__c}) )
#if( $DomainCount > 9 )
<table align="center" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="40">
</td>
</tr>
<tr>
<td align="center" style="font-size:18px; color: #A5A9AC; font-weight:100;">
${lead.Domain_Use_in_Past_Year__c}
</td>
</tr>
</table>
#end
... View more
09-05-2014
10:28 AM
1 Like
Just in case anyone experiences this issue or one similar, what I ended up having to do (since I couldn't find a good decoding javascript function - there is probably one out there) is ampersand encoding all of my time zones and then putting them in my javascript function: Europe/Lisbon --> Europe/Lisbon I used this tool: http://coderstoolbox.net/string/#!encoding=xml&action=encode&charset=none with 'XML', 'Encode' and 'None' checked. And this is the syntax that worked:
<script type="text/javascript">
window.onload = function() {
var tz = "10:00 AM - 10:45 AM PDT";
if ("{{lead.Time Zone}}" == "Pacific/Tongatapu") {
tz = "6:00 AM - 6:45 AM TOT";
} else if ("{{lead.Time Zone}}" == "US/Samoa") {
tz = "6:00 AM - 6:45 AM SST";
} else if ("{{lead.Time Zone}}" == "US/Hawaii") {
tz = "7:00 AM - 7:45 AM HAST";
} else if ("{{lead.Time Zone}}" == "US/Aleutian") {
tz = "8:00 AM - 8:45 AM HADT";
} else if ("{{lead.Time Zone}}" == "US/Alaska") {
tz = "9:00 AM - 9:45 AM AKDT";
} else if ("{{lead.Time Zone}}" == "US/Pacific") {
tz = "10:00 AM - 10:45 AM PDT";
} else if ("{{lead.Time Zone}}" == "US/Arizona") {
tz = "10:00 AM - 10:45 AM MST";
} else if ("{{lead.Time Zone}}" == "US/Central") {
tz = "12:00 PM - 12:45 PM CDT";
} else if ("{{lead.Time Zone}}" == "US/Mountain") {
tz = "11:00 AM - 11:45 AM MDT";
} else if ("{{lead.Time Zone}}" == "Canada/Saskatchewan") {
tz = "11:00 AM - 11:45 AM CST";
} else if ("{{lead.Time Zone}}" == "America/Guatemala") {
tz = "11:00 AM - 11:45 AM CST";
} else if ("{{lead.Time Zone}}" == "America/Bogota") {
tz = "12:00 PM - 12:45 PM COT";
} else if ("{{lead.Time Zone}}" == "America/Mexico_City") {
tz = "12:00 PM - 12:45 PM CDT";
} else if ("{{lead.Time Zone}}" == "America/Caracas") {
tz = "12:30 PM - 1:15 PM VET";
} else if ("{{lead.Time Zone}}" == "US/Eastern") {
tz = "1:00 PM - 1:45 PM EDT";
} else if ("{{lead.Time Zone}}" == "America/Santiago") {
tz = "1:00 PM - 1:45 PM CLT";
} else if ("{{lead.Time Zone}}" == "America/La_Paz") {
tz = "1:00 PM - 1:45 PM BOT";
} else if ("{{lead.Time Zone}}" == "Brazil/East") {
tz = "2:00 PM - 2:45 PM BRT";
} else if ("{{lead.Time Zone}}" == "America/Halifax") {
tz = "2:00 PM - 2:45 PM ADT";
} else if ("{{lead.Time Zone}}" == "America/Buenos_Aires") {
tz = "2:00 PM - 2:45 PM ART";
} else if ("{{lead.Time Zone}}" == "America/Montevideo") {
tz = "2:00 PM - 2:45 PM UYT";
} else if ("{{lead.Time Zone}}" == "America/St_Johns") {
tz = "2:30 PM - 3:15 PM NDT";
} else if ("{{lead.Time Zone}}" == "Atlantic/South_Georgia") {
tz = "3:00 PM - 3:45 PM GST";
} else if ("{{lead.Time Zone}}" == "America/Godthab") {
tz = "3:00 PM - 3:45 PM WGST";
} else if ("{{lead.Time Zone}}" == "Atlantic/Cape_Verde") {
tz = "4:00 PM - 4:45 PM CVT";
} else if ("{{lead.Time Zone}}" == "Greenwich") {
tz = "5:00 PM - 5:45 PM GMT";
} else if ("{{lead.Time Zone}}" == "Atlantic/Azores") {
tz = "5:00 PM - 5:45 PM AZOST";
} else if ("{{lead.Time Zone}}" == "Europe/Lisbon") {
tz = "6:00 PM - 6:45 PM WEST";
} else {
tz = "10:00 AM - 10:45 AM PDT";
}
document.getElementById("timeZone").innerHTML = tz;
}
</script>
... View more
09-02-2014
04:18 PM
If I take off the quotes it doesn't even try to run the Javascript. The closest I've gotten is using {{lead.Time Zone}}, but the value needs to be decoded - I'm not sure how to do that. Thanks for the quick responses!
... View more
09-02-2014
04:05 PM
I tried referencing the field as {{lead.Time Zone}} in the Javascript and didn't have any luck - it get's encoded (looks like this "US/Pacific") so it doesn't match the "US/Pacific" format. Is there a way to decode this before making the comparison?
... View more
09-02-2014
03:18 PM
I am setting up a webinar that I want to show in the user's time zone - everyone seeing the landing page is already in Marketo and has a Time Zone field populated for them. I wrote an email script token to change the time zone in emails, now I want the landing page to also change the time zone displayed but there is nothing like an email script token for landing pages. I wrote some javascript to try to populate a <span> that I put an ID on based on the lead's Time Zone field. However, the Javascript isn't working. I think what's breaking is the way I'm referencing the lead field - how do you reference a specific lead field in Javascript to populate on a landing page? I've tried a handful of things, this is where I left off with the HTML element I put on the landing page:
<script language="Javascript" src="/js/public/jquery-latest.min.js" type="text/javascript"></script>
<script src="/js/public/jQueryString-2.0.2-Min.js" type="text/javascript" ></script>
<script type="text/javascript">
window.onload = function () {
var userTimeZone = "[user:TimeZone]";
var tz = "10:00 AM - 10:45 AM PDT";
if ("userTimeZone" == "Pacific/Tongatapu") {
tz = "6:00 AM - 6:45 AM TOT";
} else if ("userTimeZone" == "US/Samoa") {
tz = "6:00 AM - 6:45 AM SST";
} else if ("userTimeZone" == "US/Hawaii") {
tz = "7:00 AM - 7:45 AM HAST";
} else if ("userTimeZone" == "US/Aleutian") {
tz = "8:00 AM - 8:45 AM HADT";
} else if ("userTimeZone" == "US/Alaska") {
tz = "9:00 AM - 9:45 AM AKDT";
} else if ("userTimeZone" == "US/Pacific") {
tz = "10:00 AM - 10:45 AM PDT";
} else if ("userTimeZone" == "US/Arizona") {
tz = "10:00 AM - 10:45 AM MST";
} else if ("userTimeZone" == "US/Central") {
tz = "12:00 PM - 12:45 PM CDT";
} else if ("userTimeZone" == "US/Mountain") {
tz = "11:00 AM - 11:45 AM MDT";
} else if ("userTimeZone" == "Canada/Saskatchewan") {
tz = "11:00 AM - 11:45 AM CST";
} else if ("userTimeZone" == "America/Guatemala") {
tz = "11:00 AM - 11:45 AM CST";
} else if ("userTimeZone" == "America/Bogota") {
tz = "12:00 PM - 12:45 PM COT";
} else if ("userTimeZone" == "America/Mexico_City") {
tz = "12:00 PM - 12:45 PM CDT";
} else if ("userTimeZone" == "America/Caracas") {
tz = "12:30 PM - 1:15 PM VET";
} else if ("userTimeZone" == "US/Eastern") {
tz = "1:00 PM - 1:45 PM EDT";
} else if ("userTimeZone" == "America/Santiago") {
tz = "1:00 PM - 1:45 PM CLT";
} else if ("userTimeZone" == "America/La_Paz") {
tz = "1:00 PM - 1:45 PM BOT";
} else if ("userTimeZone" == "Brazil/East") {
tz = "2:00 PM - 2:45 PM BRT";
} else if ("userTimeZone" == "America/Halifax") {
tz = "2:00 PM - 2:45 PM ADT";
} else if ("userTimeZone" == "America/Buenos_Aires") {
tz = "2:00 PM - 2:45 PM ART";
} else if ("userTimeZone" == "America/Montevideo") {
tz = "2:00 PM - 2:45 PM UYT";
} else if ("userTimeZone" == "America/St_Johns") {
tz = "2:30 PM - 3:15 PM NDT";
} else if ("userTimeZone" == "Atlantic/South_Georgia") {
tz = "3:00 PM - 3:45 PM GST";
} else if ("userTimeZone" == "America/Godthab") {
tz = "3:00 PM - 3:45 PM WGST";
} else if ("userTimeZone" == "Atlantic/Cape_Verde") {
tz = "4:00 PM - 4:45 PM CVT";
} else if ("userTimeZone" == "Greenwich") {
tz = "5:00 PM - 5:45 PM GMT";
} else if ("userTimeZone" == "Atlantic/Azores") {
tz = "5:00 PM - 5:45 PM AZOST";
} else if ("userTimeZone" == "Europe/Lisbon") {
tz = "6:00 PM - 6:45 PM WEST";
} else {
tz = "10:00 AM - 10:45 AM PDT - default result";
}
document.getElementById("timeZone").innerHTML = tz;
}
</script>
... View more
- Tags:
- advanced techniques
08-26-2014
09:45 AM
Yes! I've made that mistake in the past, not this time!
... View more
08-25-2014
05:46 PM
1 Like
I have a script token that checks to see if one of our integer fields is over 9; if it is over 9, I want the html in the token to display, if it's less than 9 I want no html to display in that area. I wrote the velocity script correctly syntax-wise, but the "#if FIELD > 9" comparison is not working. I created an integer variable and added a parseInt function and it works, but then the email that it's used in won't Approve - it throws up this error message: Does anyone have any idea how I can get the token to satisfy Marketo? Is there another function that can be used rather than parseInt to make the comparison valid? Here is the token code:
#set($Integer = 0)
#if (($Integer.parseInt(${lead.Domain_Use_in_Past_Year__c})) > 9)
<table align="center" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="40">
</td>
</tr>
<tr>
<td align="center" style="font-size:18px; color: #A5A9AC; font-weight:100;">
${lead.Domain_Use_in_Past_Year__c}
</td>
</tr>
</table>
#end
Any help is appreciated!
... View more
- Tags:
- advanced techniques
08-07-2014
12:24 PM
That information is available to you to in GoToWebinar under each webinar. Thd dial in info will be the same for all members - unlike the url which is unique. So you can just grab that information and either put it in the confirmation email yourself or put it into your own program tokens to change with each webinar. I don't know of any easier way. Hope that helps!
... View more
08-04-2014
03:11 PM
Diederik, I would love to get in on this as well if you'd be so generous: kassia.wilhelm@smartsheet.com. Thanks!
... View more
07-02-2014
12:40 PM
I know this is months after your issue, but I am having the same issue on a live campaign that just caused some pretty significant problems for us. I had two nearly identical campaigns listening for form fill out and sending a confirmation email in response. One campaign had a "Date of Activity" constraint and one didn't, the one without the date constraint worked perfectly and the one with the constraint did NOT work (and I am 100% positive that the dates were right and that there were form fill-outs). Either this is a buggy area of Marketo OR it's possible that when you set a "Date of Activity" it's a date field, but the date of the activity in the lead record would be a date time field and that's why it's not working. If anyone can confirm this that would be helpful. But I know I'm definitely going to avoid using it from now on.
... View more
Public Statistics
| Date Registered | 02-05-2014 09:38 AM |
| Date Last Visited | 08-24-2020 05:11 PM |
| Total Messages Posted | 17 |
| Likes Received | 6 |
.png)