Mark_Price

Mark_Price · ‎02-26-2019

If you have the date in a field like Sanford says (recommended), you can use 2 filters to get the data. The first one grabs everyone in the last 90 days and the second one ensures you are including records with a date that was 89 days ago- giving you only the 90th. Without that, it would include yesterday, 2 days ago etc. (hope that makes sense) The 'in past before' is a headache to work out, but should work once you dial it in.

Mark_Price · ‎02-26-2019

I would add that there is a pretty terrible bug with Campaign Run Id when Triggering Campaigns via the API. It will use it's lowest value when the campaign is triggered instead of incrementing. It works this way if you Request Campaign as well as update a lead field in the API. For this reason, I had to abandon using Campaign Run Id in extracted data.

Mark_Price · ‎02-25-2019

welcome to the land of the JSON parsers. glad it's working.

Mark_Price · ‎02-22-2019

^^ Came here to say this. Harish Gupta did you just add the escape slashes yourself? If an escape function was run, it would have escaped the line breaks (which aren't needed). If you're new to escaping in this way, you can use an online tool such as: https://codebeautify.org/json-escape-unescape

Mark_Price · ‎02-21-2019

Hi Harish, It seems like you have a JSON object as the value for "sampleJSON" in the API call. Perhaps Marketo is formatting the data writing to the text area. The last time I did this setup, I want to say I passed an escaped string as the field value in the API call: "sampleJSON" : "[{\"recommendation1\":{\"resultCount\":\"3\",\"product1url\":\"https://website.com/product-1\"}}]" hope you get it sorted!

Mark_Price · ‎02-21-2019

This is not possible with the current features. What you can do is use a webhook to send the lead info to some code, do the processing/transformation and then map the response to lead fields. You would need the ability to host a script to send the lead info to, but other than that it's usually feasible for most users. If you don't have the staff to host the script, there's a tool called FlowBoost that should be able to do this Create a Webhook - Marketo Docs - Product Documentation

Mark_Price · ‎02-20-2019

ahh, I see. I had gone off your screenshot / missed your spec on the triggered campaign. In any case, glad you have it sorted!

Mark_Price · ‎02-19-2019

Hi Marek, Looks like you are using an Email Program type. The option is within the program 'control panel' when setting it up (below for reference)

Mark_Price · ‎02-19-2019

In my opinion, Marketo isn't very strong with logic like this. You could build smart campaigns / smart lists or score fields to maybe get something kinda close but I don't think that would be optimal. This seems like a good use case for AI or a data model external to the system. I have a few campaigns that work this way and they call a webhook to get product recommendations in ways you just can't do from the UI. hope it helps!

Mark_Price · ‎02-18-2019

I haven't run into this, but also haven't had the need to build something with 400 editable elements and 300 variables. If there is no javascript running, I suspect the system is timing out before it can render all of the items but this is speculation w/o the logs. Maybe try support to see if they can help out.

Mark_Price · ‎02-12-2019

^ This is the best way. Found the strategy on the Teknkl blog and now have 10-15 JSON fields. https://blog.teknkl.com/marketo-json-fields-in-velocity/ The only thing I would add is Marketo webhooks can be pretty slow if you need to backfill or update a lot of records. You prob. don't need to worry about this unless you have a large system, but might be worth monitoring. If you have bulk data needs, the API might be another option. Same JSON / Velocity approach in both setups.

Mark_Price · ‎02-12-2019

+1 for what Sanford says with the variables. This makes it a lot easier to remember to update / change them. Out of the box, Marketo has the option when editing the page - edit a landing page - click landing page actions - click edit page meta tags ^ This should be in the same spot for free-form and guided pages

Mark_Price · ‎02-12-2019

You can automate the merging process with an API script. There's a filter for 'possible duplicates' you can leverage to have a campaign add leads to a list. From there you could send a webhook or have a batch job run. With all that said, creating duplicates and merging after the fact will work, but is not ideal. Sometimes it is unavoidable in complex situations though. Is the whole point of the double insert to send the Marketo email faster without waiting for the sync from SFDC -> MKTO ?

Mark_Price · ‎02-08-2019

Hi Will, I've had a similar need in the past when running tests in Optimizely. I did a virtual 'Webpage View' rather than click but same concept- pushing an event and attributes via javascript and then using the data in Marketo. You could use a smartlist to find the audiences or use a campaign to change add to a list etc. Depending on your setup you could potentially use programs to track each experiment as well. Unless you're extracting data out of the system, you'll have to keep the retention policy for activities in mind: Marketo Activities Data Retention Policy - Under the Hood Hope it helps!

Mark_Price · ‎02-06-2019

If I'm understanding correctly, you're making 1 API call to insert into Marketo and shortly after 1 API call to insert into SalesForce. This will result in: 1 'Marketo only' record (should have the webpage activity) 1 SalesForce / Marketo record (the activity log will start at 'person created: source salesforce.com') To combine the records, you can try the Merge Lead API Call: http://developers.marketo.com/rest-api/endpoint-reference/lead-database-endpoint-reference/#!/Leads/mergeLeadsUsingPOST hope it helps

Mark_Price · ‎02-02-2019

I would do option 2 and just double check the logic / make sure someone can only qualify to be on one of the five smart lists.

Mark_Price · ‎01-31-2019

Tokens are set in the Marketing Activities section of the system. You could put them in a folder there.

Mark_Price · ‎01-28-2019

If this is the only thing you have connected to Marketo, it seems like Power BI does not respect Marketo's API limitations. Maybe try working with the vendor's support. Haven't used Power BI, but I've been successful in extracting the data via custom code and the API: http://developers.marketo.com/rest-api/bulk-extract/ http://developers.marketo.com/rest-api/lead-database/activities/#query There may be solutions in launchpoint for the data extract.

Mark_Price · ‎01-26-2019

Hi Jimmy, I would perhaps look at Zapier, Workato or Microsoft Flow to connect the spreadsheet or Google Sheet data to Marketo. This could help remove the manual import step and save some work, but you would still need to figure out campaigns / best trigger logic.

Mark_Price · ‎01-25-2019

It seems like you have the right idea but I'm confused on how you are figuring out who is on the list or not. A webhook is generally used to send a particular lead's attributes to an external webservice that then does something and potentially gives a response that maps back to a field on that same Marketo lead. For example, your webhook could call your webservice which then does a query in Azure to see if the person is on your list and returns true/false which is then mapped to a lead field in Marketo when the webhook completes. At this point, you can use the value for filtering / campaign logic. It's most effective when used as a trigger because bulks updates via a webhook are rather slowww. If your goal is to push a list of leads daily or in batch, I would suggest looking at another set of endpoints: http://developers.marketo.com/rest-api/endpoint-reference/lead-database-endpoint-reference/#/Static_Lists If you can provide more details around data requirements and if it's to be triggered vs. batch there might be other suggestions. hope it helps!

Mark_Price · ‎01-11-2019

Happy to hear it's solved and was a quick fix!

Mark_Price · ‎01-09-2019

It would appear at some point, someone clicked 'Edit Code' on the 'Email' which then dis-associates it from the 'Template' code which is used for the layout / modules function. I would try creating a fresh email that uses the template to see if the Modules work. If the Modules do work in the new Email - The template code is ok and the issue is with that particular email and caused from bad process for code changes If the Modules do not work in the new Email - There may be an existing issue with the template code that needs to be remedied (this could be why someone edited the code in the email to begin with) hope it helps!

Mark_Price · ‎01-09-2019

Kind of hard to troubleshoot with the details provided. - If you click on the email within the Marketo UI, does it say it's connected to a template still? - Other than that, maybe scan the code and ensure: mktoName, mktoModule, are set / unique and look for missing quotes / coding errors.

Mark_Price · ‎01-08-2019

What happens if you make a new email from the template? If the new email works, than it could be that new mktoModules were added to the template which can cause this error on emails that were approved with the old layout..

Mark_Price · ‎01-07-2019

I would try: - removing the formal notation aside from output - double check that the custom object field is selected in the field tree where you input the script

Mark_Price · ‎12-27-2018

You mentioned the url contained ' https:// '. I would strip that and insert the URL like so and see what happens: <a href=" https://$ {url}">Register Here</a> Maybe check email link performance report and see if there are any links that are: 'malformed link' or your variable.

Mark_Price · ‎12-18-2018

Hi Michael, As others have said there are a few ways to get this done, most using custom code. To allow the registration on-page you would need code. If you are ok confirming / denying registration via email, you can do this with just a Marketo campaign and 2 emails. Setup: - Add your 'allowed' segment to a static list or smart list - Build 2 emails, one for allowed registrations and one for denied registrations - Setup your confirmation campaign so that there is a choice: - If member of 'Allowed' list send Registration Complete email - If not member of 'Allowed' list send Registration Denied email This might be an ok setup in the interim until moving on to a fancier one. hope it helps!

Mark_Price · ‎12-10-2018

Results of running the test script: API-based send results: Flow step-based resuls: The campaignRunId being recording in the activity log is the same that is being used at run-time

Mark_Price · ‎12-06-2018

Ok, will do! Thanks for the help. I spot checked the campaigns that trigger on a data value change from the API and they also re-distribute the campaignRunId. Sort of surprised this isn't giving anyone else problems but to even notice you would need to have: 1. A recurring campaign triggered via API call 2. Extracted Bulk Data 3. Reports that leverage the extracted data (or try to at least) Have one potential workaround, will send via email

Mark_Price · ‎12-05-2018

Ran the tests on 2 records, results are below. Results are not what I was expecting- the Flow Step Request Campaign has a similar system behavior of re-issuing the campaignRunId after it's generated. API-based Request Campaign Call #1: This is the first person in the campaign, so it created a campaignRunId Flow Step-based Request Campaign #1: Incremented by 1, generated another campaignRunId API-based Request Campaign Call #2: re-used campaignRunId from 1st API call Flow Step-based Request Campaign #2: re-used campaignRunId from previous Request Campaign flow step API-based Request Campaign Call #3: Using a different test lead, re-issued original API-based campaignRunId Flow Step-based Request Campaign #3 Using a different test lead, re-issued flow step campaignRunId

Online Status	Offline
Date Last Visited	‎09-20-2021 03:30 PM

Date Registered	‎02-10-2017 08:02 AM
Date Last Visited	‎09-20-2021 03:30 PM
Total Messages Posted	158
Likes Received	131

Top Badges Earned

Re: Find users exactly 90 days ago

Re: Need unique id for individual email send for w...

Re: JSON Parser

Re: JSON Parser

Re: JSON Parser

Re: Update Lead object field using Velocity Script

Re: Missing option to run AB testing in smart camp...

Re: Missing option to run AB testing in smart camp...

Re: Defining Product Interest based on Pages Visit...

Re: Maximum Editable Elements on Guided LPs

Re: Personal recomendations for lead from webhook

Re: LP META Title and Descriptions

Re: Merge a lead from Marketo with a Contact in SF...

Re: Tracking website A/B tests into Marketo & CRM

Re: Merge a lead from Marketo with a Contact in SF...

Re: Mutually Exclusive Smart List

Re: Tokens - where can we keep centralized tokens...

Re: Marketo Analytics with Power BI Reporting?

Re: How to simplify list import for program member...

Re: Calling custom webhooks

Re: Modules Tab Grayed out

Re: Modules Tab Grayed out

Re: Modules Tab Grayed out

Re: 2.0 Email Template Corrupted

Re: Token prints out velocity variable instead of ...

Re: New to velocity script - questions

Re: Private Event with Restricted Guest List

Re: multiple Request Campaign API calls result in ...

Re: multiple Request Campaign API calls result in ...

Re: multiple Request Campaign API calls result in ...