- 66
- 32 073
TheWorkflowPro
United States
เข้าร่วมเมื่อ 9 ส.ค. 2020
Log to Google Sheets from Marketo without Zapier
theworkflowpro.com/marketo-google-sheets-integration/
Check out an easy way that you can send Marketo data directly to a Google Sheet without needing a middleman like Zapier and without needing to use the Google Sheets API, all in under 15 minutes.
Check out an easy way that you can send Marketo data directly to a Google Sheet without needing a middleman like Zapier and without needing to use the Google Sheets API, all in under 15 minutes.
มุมมอง: 78
วีดีโอ
Marketo Clearbit Integration in 20 Minutes
มุมมอง 83ปีที่แล้ว
theworkflowpro.com/clearbit-marketo/ This video will show you everything you need to know to set up Clearbit enrichment with Marketo.
Custom Marketo Lead Nurturing
มุมมอง 294ปีที่แล้ว
theworkflowpro.com/marketo-lead-nurturing/ Do you want to be able to customize your send times for your nurture programs so that you can do something like send email 1, send email 2 X days later, and send email 3 Y days after email 2? Also learn how you can create an email funnel so that people with multiple use cases can receive emails from multiple use case streams.
Identifying Bot Formfills in Marketo Using ChatGPT
มุมมอง 172ปีที่แล้ว
theworkflowpro.com/marketo-chatgpt-lead-classification Take a look at how you can use Marketo webhooks to send form fill information to ChatGPT to determine whether the form fill was made by a bot.
Great Use Cases for Marketo Tokens
มุมมอง 478ปีที่แล้ว
theworkflowpro.com/marketo-tokens/ Take a look at all the creative ways you can use Marketo tokens for saving time when building emails, webhooks, and smart campaigns.
Today's Date in Zapier Using Code & AI
มุมมอง 463ปีที่แล้ว
theworkflowpro.com/zapier-todays-date/ Check out how to use ChatGPT and Zapier's own "Generate with AI" function to generate code for a "Code by Zapier" action to do something simple like getting today's date.
Testing Marketo Custom Activities in Segment
มุมมอง 112ปีที่แล้ว
theworkflowpro.com/segment-marketo-integration/ See how you can use the Segment Schema and the Marketo Bulk Extract API to make sure that the counts for an event arriving in Segment match the counts you are getting in Marketo for the corresponding custom activity.
Person is Pushed to Marketo Trigger Explained
มุมมอง 167ปีที่แล้ว
theworkflowpro.com/person-pushed-marketo-trigger/ Demystify the "Person is Pushed to Marketo" trigger by seeing what it is, when to use it, and how to run this trigger from Postman and code.
ChatGPT API using Marketo Webhooks
มุมมอง 421ปีที่แล้ว
theworkflowpro.com/marketo-chatgpt-lead-classification See how to make requests to the ChatGPT API from within Marketo using webhooks and how you can update a lead with the information returned from ChatGPT.
Marketo Lead Scoring
มุมมอง 627ปีที่แล้ว
theworkflowpro.com/marketo-lead-scoring/ Take a look at 3 different models to assess lead quality, 1 model to score lead activities, and how you can use these models to power your MQL mechanism 00:00 Introduction 00:49 Demo & Firmo Model 1 06:33 Demo & Firmo Model 2 18:47 Demo & Firmo Model 3 30:54 Activity Model 35:07 MQL Model 39:23 Next Up
Marketo Lead Classification with ChatGPT
มุมมอง 468ปีที่แล้ว
theworkflowpro.com/marketo-lead-scoring/#Demo_Firmo_Marketo_Lead_Scoring_Model_3 See how you can classify leads created in Marketo by using Zapier to make requests to ChatGPT and then update the Marketo lead with the ChatGPT classification.
Marketo ICP Matching
มุมมอง 112ปีที่แล้ว
theworkflowpro.com/marketo-lead-scoring/#Demo_Firmo_Marketo_Lead_Scoring_Model_1 See how to translate customer profiles into corresponding Marketo fields and build smart campaigns that assess newly created leads to see how good a fit they are for your company.
Marketo Demo & Firmo Grading
มุมมอง 95ปีที่แล้ว
theworkflowpro.com/marketo-lead-scoring/#Demo_Firmo_Marketo_Lead_Scoring_Model_2 Learn how to grade the values a person has for different demographic and firmographic fields in Marketo to yield a single output grade that you can use for your marketing qualification mechanism.
Marketo Activity Tracking
มุมมอง 165ปีที่แล้ว
theworkflowpro.com/marketo-lead-scoring/#Marketo_Lead_Scoring_for_Activity See how we can score the different activities we have in Marketo and add these scores together over a certain time period to gauge a person’s level of intent.
Marketo MQL Mechanism
มุมมอง 105ปีที่แล้ว
theworkflowpro.com/marketo-lead-scoring/#MQL_Model_Outline Learn how to build an MQL mechanism in Marketo to alert sales and provide them with the context about why a lead was deemed to be marketing qualified.
Nested Looping in Zapier using Code by Zapier
มุมมอง 285ปีที่แล้ว
Nested Looping in Zapier using Code by Zapier
Edit More Than 500 Rows in Google Sheets Using Nested Looping in Zapier
มุมมอง 191ปีที่แล้ว
Edit More Than 500 Rows in Google Sheets Using Nested Looping in Zapier
Nested Looping in Zapier using Google Scripts
มุมมอง 67ปีที่แล้ว
Nested Looping in Zapier using Google Scripts
Import more than 10MB in Zapier from Google Sheets
มุมมอง 126ปีที่แล้ว
Import more than 10MB in Zapier from Google Sheets
Import More Than 500 Rows from Google Sheets to Zapier
มุมมอง 363ปีที่แล้ว
Import More Than 500 Rows from Google Sheets to Zapier
Hey hi bro your videos are good please help me out with one requirement I have on requirement: Ziflow and Asana automation When a New proof is created in Ziflow with multiple reviewers based on that reviewers count tasks need to be created in asana and assignees as reviewers in the proof each task should assign each reviewer
Great vid. Can you use tokens anywhere in Smartlist logic? I've a feeling I can't and I'm completely blocked by it
Hi great video, I filled out the form but didn’t get the postman collection. My name is Robin
Hi Robin, nice to meet you. There is a small charge for the API collection now. Once you pay this you should receive an email with a link to download the collection. All the best
Can you clone an executable campaign, via API (and keep it executable)?
Yes, if you set the "isExecutable" parameter in the body to "True" it will keep it as executable. Same for when creating smart campaigns you can make them executable using the same parameter
quick question: does mktoNumber have to have a unit assigned? I can envision using that to assign an image width or height attribute which assumes pixels but does not include it as part of the attribute value.
Hi Paul, specifying a unit is optional: experienceleague.adobe.com/en/docs/marketo/using/product-docs/email-marketing/general/email-editor-2/email-template-syntax#number
I love your thorough walkthrough. Were the ZoomInfo phone numbers selectively verified by Sales as valid phone numbers or simply based on the three-way comparison logic table?
Thanks @MrAbstractj. The ZoomInfo phone numbers were not verified by Sales, only by the comparison in the Google sheet
is there any way achieve this without looping
Hi there, theworkflowpro.com/zapier-google-sheets/ you can check out this blog post. It depends on how much data/rows you are trying to bring into Zapier
Thank you:)
This information is GOLD! Thanks for this! Subscribed!
Thanks Carlo, I'm glad it's useful!
I want to lock a file using my local dropbox path. But it didn.t work.
how practice if i dont have my own website
Can you do a lookup that is fuzzy? Or at least that is based more off a "contains" approach than an exact match?
Hi Brandon, you can't do this within Zapier natively but there is a workaround in this community post: community.zapier.com/show-tell-5/finding-rows-in-google-sheets-that-contain-a-lookup-value-no-code-8460
Hello, I am getting an error on line 31 of the send nesting TypeError: Cannot read properties of undefined (reading '0'). i have a 3 column spreadsheet, i tried only removing references to the phone/4th column, but i continue to get this error, please assist
Hi Kyle, please send your contact info by filling out this form: theworkflowpro.com/workflow-pro-bio/
Have you ever used Stripo's Marketo export function, not the HTML? If so, does it reduce the marketofy coding when you set it up?
I imagine so but I have never used the Marketo export function since we do not pay for that feature. This would be a good question to ask their sales team/support or in the marketo community. Post back here if you get an answer please!
@@theworkflowpro I have the paid version, which can export and "marketofy" the template to some extent. But if I want to have some local variables available, I have to be more specific in the marketo tags and still adjust the template.
@@gabrielaruelas1628 got it thanks for sharing!
Thank you! One of the only videos I found that actually explain this well.
Thank you for this video!
really cool content Tyron! I know variables make it simple for users to manage items like button text in the editor but I just started stripping our all our text string variable as they are not picked up automatically by the plain text editor (which forces you to uncheck the "automatically update from HTML" box and can sometimes lead to discrepancies between the HTML and the plain text). For this reason, I have using rich text for all text output variables (where leaving styling values such as colors, numbers, etc as variables). Just wanted to call it our as a consideration (pro or con) of things like using variables to append utms to the end of URLs. Cheers!
Thanks for sharing that, I didn't know the impact of variables on plain text emails, hopefully others will see this comment and it can help them too
Is it possible to create global "modules" that can be used in different email templates in Marketo? For instance, a two-column layout with an image on one side, and text on the other.
Hi Megan, no it is not possible to have global modules across templates. You will have to copy the module code from one template to another. Email building tools like Stripo do have global modules that you can use when building your templates so I build in Stripo and then import the code into Marketo
@@theworkflowpro Thank you for the quick response! I'm just starting to learn the ins and outs of Marketo. Watched a few tutorials, consulted Google - I was surprised when I couldn't find anything on the topic. I guess that's why; You can't do it!
@@meganorsi8591 I have lots of blogs on Marketo to help you on your learning journey: theworkflowpro.com/category/marketo/ Here is also a Marketo Fundamentals playlist: th-cam.com/video/RmrIsIEugx0/w-d-xo.html&pp=gAQBiAQB And here are all my Marketo videos: th-cam.com/video/moY2Z0dUm4A/w-d-xo.html&pp=gAQBiAQB
Hey is there a way where you could help me with that??
Nice to meet you Jan. Submit your information here and we can talk about this project: theworkflowpro.com/workflow-pro-bio/
Hello, just trying my luck with something similar. I'd love if you could help me. I am trying to loop the my Sheets rows that has "NO" and zap them automatically until there's none left. I was thinking about going through all YES/NO once the zap is initiated, add all NO's to the array, and initialize the zap on the rows that were added to the array but I cant figure out how to successfully achieve. If you can help it'd be great. love your content, learnt so much
Hi there, nice to meet you. If you fill out this form: theworkflowpro.com/workflow-pro-bio/ I can get your details and take a look. Please share a loom video or other screen recording so I can see what you are trying to achieve
Hey, Do you write in LinkedIn?
This was a really helpful video. Thanks! Subscribed and bookmarked.
Thank you, I'm glad it was helpful. Happy holidays!
Amazing you helped me a lot
No worries I'm glad you found it helpful Frederic!
Great video! Very helpful!
Thank you, I'm glad you found it helpful!
Do you have a video on Dynamic content within Marketo Emails using the variable Html Block Data-type?
theworkflowpro.com/marketo-dynamic-email-content/ In this blog post I share how to update the dynamic content HTML email blocks via API
Has anyone found another place to get the unique webinar ID besides the zoom confirmations? Ideally we wouldn’t want to have the emails turned on and then off again.
Super helpful, thanks!
I'm glad you liked it Anne!
😜 *Promo SM*
Your tutorials are fantastic!
Thanks Chris, I'm glad you found it useful!
While I am using Google Scripts here you can apply the same logic I use to any system external to Zapier e.g. scheduled scripts in any programming language, your marketing automation platform, your customer data platform, etc, where you can do the nested looping outside of Zapier to send a maximum of 500 rows at a time to Zapier for processing
🔥🔥🔥
Thanks Eric!
very informative. Tnx for sharing your knowledge.
Thanks Madhav, I'm glad you found it helpful!
You are the best! Saved me a ton of time!!
I am so glad you found this useful Fabian!
Superb explaination, thank you so much !!
I'm glad this was helpful for you @mahakmundra2617
This was Wonderful. Thank you !
You are very welcome @mahakmundra2617
Love it! Great work man 💪
Thanks Brotha!
Great content, thank you for sharing!
Thanks for the positive vibes @nursenkadakal4366!
This is awesome, thank you so much for sharing! Quick question, how are you able to group your tokens?
@TheVideosofJulien I presume you mean the grouping between Local and Inherited tokens (if not then please let me know the time in the video where you see the grouping). The local tokens section contains all the tokens you create at the program level, whereas if you have a folder containing a bunch of programs and you create tokens at this folder level then all the programs within this folder will inherit these tokens and they will appear in the inherited section. If you change any of the inherited tokens then they will appear in the "Overridden" section. Does this answer the question?
Thank you. This is very clear and helpful.
thanks @iLearnTrain, I'm glad you found it helpful!
Thanks for the kind words Jessie, I love it when people find my content helpful and it gives me the drive to keep producing more content!
One thing to consider for the analysis is Crunchbase does have firmographic and demographic information now. I'm not sure if it wasn't present at the time of doing this
@@JessieObeng thanks for sharing this Jessie, I wasn’t aware that Crunchbase now has demographic information!
This was such a thorough and detailed analysis, Tyron. I was literally about to begin my own analysis and then stumbled on your blog post. Excellent work!
hi there, is there a way to extract the custom object data only through Marketo API
Hi Revanth, you should be able to use the Bulk Custom Object Extract api for this: developers.marketo.com/rest-api/bulk-extract/bulk-custom-object-extract/
@@theworkflowpro Thank you , but this bulk custom object extract will extract the data present in those custom objects or will it only extract the custom objects
@@daAdiYogi I have never used the Bulk Custom Object Extract api before so you will have to do some testing with the api to find out the answer to your question. If you do find the answer please comment here so others can learn from this in future
🌺 𝕡𝕣𝕠𝕞𝕠𝕤𝕞
I was a bit under the weather for this one (and beaten down by these frustrating issues haha) so sorry for the lack of enthusiasm!
Hey Tyron, did you managed to find what the issue was? This is a massive concern if data gets nulled or campaign does not complete due to the merge I'd say. Attribution results is what the business wants to see and has to be accurate.
@@pierreflovie6165 check out this blog post: theworkflowpro.com/marketo-attribution-model/
@@theworkflowpro thanks Tyron for this.
While what I show in the video above was intended to delay the organic social, referral, and search campaigns by different amounts, it turns out that people who qualify for smart campaigns while anonymous will not go through wait steps in these campaigns when they become known (see nation.marketo.com/t5/product-documents/anonymous-lead-promotion-to-known-lead-munchkin-v2-behavior/ta-p/250613). However, the mere presence of these wait steps in the organic campaigns means that they will be deprioritized in Marketo's campaign queue compared to the paid campaigns resulting in the paid campaigns always being processed first and getting the first opportunity to claim attribution on a person (see theworkflowpro.com/marketo-campaign-priority-override). However, beyond this, all organic campaigns will be deprioritized to the same extent so there is no way to prioritize organic social and referral above the hungry organic search campaigns like Google. If you want to be able to set up a priority order for attribution campaigns to run (e.g. Paid then Social then Referral then Search) then you will need to use executable campaigns and a centralized model, which will be explained in a future post.
Really great tips. Insightful video
Thanks Iliyan, comments like these keep me going!
I highly recommend watching the "Automatic Marketo Duplicate Merging with Zapier" video first because this is where I explain a lot of the merging logic and it will also be easier to follow: th-cam.com/video/uW7WN8fn9DQ/w-d-xo.html
Do you still have the postman collection? It says it's binned when I try to subscribe
Hi Sylar, thanks for the heads up. I've fixed the redirect on the form now. I have emailed you the link to download the Postman collection. Happy building!
great video! It helped me a lot. Thanks
Thanks Tomas! I appreciate you letting me know that, feedback like this gives me the motivation to keep making more content