A question I get asked a lot is how do I manage my mailing campaigns in Podio. Up until recently I never had my campaigns in Podio as I still used SI Lead Manager to do all of that on my own computer. It never bothered me not having access to it over the web.
The more and more I use Podio though, I realize that I’m missing out on not having a web based solution for my campaigns. One such drawback was not being able to keep track of responses as I got them. As you can imagine, remembering to do this when I got home was a challenge…I’d forget all the time!
So over the past two month, I set out to create a Direct Mail Campaign Manager in Podio. I really like how SI Lead Manager works, so I did my best to model that approach with in Podio. I think it came out quite well!
What I Wanted to Accomplish
When creating a Podio App (or any project for the matter) it’s important to write down a list of wants. That list gives you direction and a clear idea of what your apps will need. Some people break that list up even further to Wants, Needs and Could live With Outs. I don’t worry about going into that much detail because I hate making those decisions…haha
Here is my list of Wants…
Import Lead Lists From Excel
We typically get our lead lists in an Excel (or CSV) format. I want to be able to take that Excel file and import it directly into my Direct Mail Campaign Podio Workspace.
Assign Lead Lists to a Campaign
For simplicity the system must allow me to assign a pre-existing campaign template to my leads and lead lists. Doing so will automatically create the mailing schedule for my new list.
Mark Leads as Responded (or Dead)
I need to be able to tell the system that a lead has Responded or is Dead. Doing so will prevent future mailings in that campaign from being sent to that lead.
Auto Create Leads in my Funnel when Motivated
When a lead is marked as Motivated, I would like to have a new App record created in my Podio Lead Funnel Workspace. Additionally I want that new item to reference back to this lead.
Have Letter Templates
Some of my different campaigns use the same letters. I want to be able to store my letter templates with-in podio so I can reuse them in as many campaigns as I want.
Create Campaign Templates
These templates should layout all the letters in a campaign and at what intervals to send them out. This is a critical feature! It will allow me to create and schedule an entire mailing campaign in one click.
Set Interval Between Mailings
Related to the previous Want, I need to be able to set the intervals between when letters are sent for a mailing campaign. This must be specific to each campaign template.
Print Mailings With Once Click
I always want to reduce the steps in any process. So being able to click a button and have my letters delivered would be ideal. But I'll settle for autocreating a PDF that contains all the letters for a campaign mailing.
Mail Merging
Another MUST feature! I need to be able to mail merge my lead's information into my letter templates without having to use Microsoft Word. I want a one stop shop here :O)
Advancing Campaign
Once I print a mailing for a campaign, I want the system to setup and schedule the next mailing. I don't want to have to think about this and manually do it.
Create Tasks to Keep me on Schedule
Would be nice to have tasks auto-created for me and added to my calendar to let me know when I have mailings that need to go out.
Extensive list I know, but when you don’t have time it is important to systematize as much as you can. You’ll save hours each month for every button click you can eliminate. Plus it’ll be easier to hire out the tasks in the future.
Podio App Setup and Reasons
What Apps you will have and how they relate is the backbone of any good system. It has to be simple, allow for the minimal of data entry as well as be able to grow with your business.
A couple of weeks ago I wrote about property lead flow that really dives into the best way to setup a system. If you want to understand more about how I came up with my setup, definitely go back and read that article.
For my Direct Mail Campaign Podio system, I have setup 5 Apps. These Apps are Leads, Campaigns, Campaign Templates, Mailings and Letters. I will go over each’s reason for being and how they were setup below.
Leads App
The Leads App is where you import all your lead lists into. It is also where you will keep track of leads that have responded and leads that you don’t want to mail to anymore. I keep track of those two things in a Category field called Status.
This App is very straight forward and can be expanded to include more information if needed. These are the required fields for my Podio Setup.
Address (text)
This is the property's address field. So 123 Main St
City (text)
Property's City/Town name. Trenton
State (text)
Property's State name. NJ
Zip Code (text)
Property's Zip Code. 07601
Status (category)
This is the Lead's Status. I use Mail, Responded and Dead as my options. This status will be used to determine if my process prints a letter for this lead or not.
Map (map)
Populate this field with the full property address (123 Main St, Trenton NJ 07601) and Podio will show the location of the property on a map.
Last Name (text)
Contact's Last Name. Costello
First Name (text)
Contact's First Name. Scott
Phone (phone)
Contact's Phone Number. (999) 555-1000
Email (email)
Contact's Email Address. scott@email.com
Mailing Address (text)
Contact's Mailing Address. 51 Mailtome St
Mailing City (text)
Contact's Mailing City. Bronx
Mailing State (text)
Contact's Mailing State. NY
Mailing Zip Code (text)
Contact's Mailing Zip Code. 00000
Campaign Relationship (relationship)
This field is used to select the campaign that the lead belongs too. Probate Mailing #1
List Relationship (relationship)
This field is used to assign the lead to a list. You'll use the list so you can later pull refer back to all the leads in a particular list. Probate List #1.
Like I said, you can add more fields if you want. Podio automatically tacks on a Files (upload and attach files) and Tasks (create item related tasks) to the App Template as well.
Campaigns App
The Campaigns App is where everything comes together. It controls the campaign by associating the leads to the template; says when the campaign will start; when the next mailing is; and handles the printing of the letters.
What makes this all work are the Globiflow Processes behind it. Those processes are in charge of setting the mailing dates and sequence number; assigning the template; and printing out the letters.
Here is a look at the fields in this App…
Name (text)
This is Name that you give the Campaign. You can put anything you want here, but it's a good idea to come up with some naming methodology to help you keep things organized. Yankees #1
Campaign Template to Use (text)
This field holds the Name of the Campaign Template that you want to use. Globiflow will use this value to look up which Template to attach to the campaign.
Campaign Template (Relationship Field)
This is the actual link to what Template is being used for the campaign. It controls what letters are to be sent out and at what interval they will be sent.
Status (Category Field)
Status of the Campaign. My process uses the statuses Not Started, Active, Paused, Finished.
Print (Category Field)
Here are your Action Buttons so to speak. In Podio you can use Category Fields as buttons to trigger Globiflow Processes. Here I have options to Print Letters,Print Envelopes plus resting place option called Do Nothing. My process flips the value of this field back to Do Nothing after printing is complete.
Start Date (date)
The date I have set to start this campaign. Each Mailing has a value called Days From Start and combining that with the Start Date the process can determine when the next mailing should be sent.
Next Mailing Date (date)
The date the next mailing should go out. The value is determined by the Globiflow process that takes the start date and adds the next mailings Days From Start value to get this date.
Next Mailing Seq (number)
This is the Mailing Sequence number of when letter will be going out next. Globiflow uses this value to determine which letter to print and what the next mailing will be.
Files
Stores the Mail Merged Letters that Globflow created for a mailing.
Campaign Templates App
The Campaign Template App is the top level of the template. This is where I group my mailings together in one package to keep things organized. There are only 3 fields in this app, but it makes it possible for you to quickly schedule your campaigns.
You can add as many or as few templates as you want. There are no Globiflow processes behind this, you just set it and forget it.
Here are the fields…
Name (text)
The name of the template. Nothing special about this field, just give it a simple name to help you tell what it is for. Probate Template #1
Mailings (relationship)
This is a relationship field where you will select which Mailings are to be included in this campaign. You can have 1 mailing or you can link 10 mailings.
Type (category)
A category field where you can select what type of campaign this will be. Typical options would be Yellow Letter, Email, Text, Postcards. Just another informational field in the end.
Mailings
The Mailings App is sorta your middle man app. You’ll use it to define each of the separate mailings withing a campaign template. I’ll create a mailing record for each mailing I want to have in my template.
For each mailing, I’ll set the Letter to use, the Sequence Number in which this letter will go out and finally when (Days From Start) this letter will be sent.
Here are the fields…
Description (text)
The name of the mailing. Nothing special about this field, just give it a simple name to help you tell what it is for. Probate Mailing #2
Letter (relationship)
With this field I select the Letter that I want to send out for this particular mailing. I can select any letter that I want, even use the same letter for all mailings.
Sequence Number (number)
This is where I will set the order in which this mailing will go out. If this is going to be the second mailing in my template, then I'll put a 2 here.
Days From Start (number)
Here will be where I set when this mailing will be sent. All I have to do is enter in the Number of Days from the start of the campaign that I want to send this letter. If I'm sending a letter every 30 days and have 3 mailings, the value in this field for each mailing will be 0, 30 & 60 respectively.
Letters App
The Letters App is where I put all my letter templates. The reason I have this as a separate app then my mailings is that it gives me the opportunity to reuse the same letter in different campaigns.
I like this setup because If I want to update the content of a letter I only have to do it in one spot for all my campaigns.
Taking a look at the fields…
Name (text)
The name of the letter. Nothing special about this field, just give it a simple name to help you tell what it is for. Probate Letter #1
Type (category)
I like to have a field where I can categorize the letter. Gives me an easy to way group and filter to see all my Probate letters or my Absentee letters. Typical options would be Probate, Absentee, Foreclosure, Other.
Content (text)
The Letter's Content. This holds the entire letters content and formatting. You can use basic HTML tags like < b >, < i >,< p > and more. The HTML will be read by Globiflow when it converts the content to a PDF. Additionally you place your merge markers here as well...##first name##
Notes (text)
Just a place to add any additional notes or comments about this letter. Say you have another version, you can refer to it here.
Linking the Apps
Breaking the Apps up into Leads, Campaigns, Templates, Mailings and Letters is just the base for this app. What really brings it all together is being able to link each of the apps to another. The Linking creates a complete system and reduces the need for having to repeat the same data in multiple places.
Leads App -> Campaigns App -> Templates App -> Mailings App -> Letters App
Setting Up Campaigns with Globiflow
As part of my efforts to make this process as automated as possible I setup a GlobiFlow process to run when a new campaign has been created. This is not a complex process at all. What it does is the following….
Assigns the Campaign Template to Use. When I import leads from Excel, I’m only able to populate the Campaign Template to Use field. So what GlobiFlow does is, takes the value in that field, finds the Template with the matching name and links it to the Campaign that was just created.
Sets the Next Mailing Sequence value to 1. Nothing special going on here, just telling the campaign we want to start with the first mailing.
Sets the Next Mailing Date to Start Date + Days from Start of first Mailing. Basically, GlobiFlow will take a look at the first Mailing to get the Days From Start value then adds it to the Campaign’s Start Date that you set.
Sets the Status value to Not Started. Just the initial status of a campaign. Once the start date comes, or you print your first mailing, it will be changed to Acitve.
Sets the Print value to Do Nothing. Do Nothing is the resting value for this Action field. When it’s time to print a mailing you’ll click Print Letters.
Printing Mailings with Globiflow
They toughest Globiflow process I have created so far hands down! There are 36 steps to this process flow. While GlobiFlow is powerful, it took me a while to figure out what each type of Action can do and how it does it.
I learned how to use variables to store info, iterate (loop) through multiple app relationships and then come up with a way to mail merge. It took me a good 2 weeks to figure it all out.
For general purposes, here are the steps that need to be done in order to print a batch of letters…
Access the Mailings for a Campaign Template
Find the Mailing that is the Current Mailing
Get the Letter That is Associated with the Current Mailing
Loop Through the Linked Leads and manually Mail Merge
Create a PDF of the Letters
Create a Task to print the next Mailing
Update the Campaign to Reflect when the next Mailing Is
At the end of the day (or at least the tutorial) you will have a good feel for the capabilities of GlobiFlow. Regardless of whether you can actually do something or not, knowing that a tool can do something can be just as valuable. This Flow will definitely help you there.
Automating the Entire Campaign!
How does it get even better you may ask? How about the fact that you can easily automate the entire campaign printing process for all your campaigns!
GlobiFlow has a feature where you can setup a flow that is triggered by a date field. The flow runs everyday and checks a specified date field in the Campaigns’ App. If the date is equal to the current date, you can trigger the Print Mailings Flow. INSTANT AUTOMATION!
I show you how to do this in the Tutorial and it’s dead simple once you have everything else set up. Just imagine having a system with a dozen campaigns running and you don’t have to do a thing once you import your lead lists.
Excel Import Files
The final piece to the puzzle is the Excel Import File. This is nothing special, but by adding a few fields and some information to your leads you can setup, schedule and print a campaign in under 4 minutes (see the video below!). I just want to say that Podio has some smart developers working for them.
For my Direct Mail Campaign Podio setup, my excel file has these below fields. It pretty much matches my Leads App with a few key additions.
Address
This is the property's address field. So 123 Main St
City
Property's City/Town name. Trenton
State
Property's State name. NJ
Zip Code
Property's Zip Code. 07601
Last Name
Contact's Last Name. Costello
First Name
Contact's First Name. Scott
Phone
Contact's Phone Number. (999) 555-1000
Email
Contact's Email Address. scott@email.com
Mailing Address
Contact's Mailing Address. 51 Mailtome St
Mailing City
Contact's Mailing City. Bronx
Mailing State
Contact's Mailing State. NY
Mailing Zip Code
Contact's Mailing Zip Code. 00000
Lead Status
Add this Column and give the lead a status of Mail
Map
Since you can't combine fields or use a field twice during the import process, you'll need to create a new column in Excel for the Full Address.
Campaign Name
This will be the Name of the Campaign that you want to create. Podio will create a new Campaign based off this name. If a campaign already exists with this name, Podio will add the leads to that Campaign.
Campaign Template to Use
This will be the Template that the newly created campaign will use.
Campaign Start Date
Create a Column for the Campaign Start Date.
The great part about Podio’s import process is that it allows you to assign values to a relationship field. This means that it’s possible to upload your leads and create the campaign at the same time! That saves you a ton of time. Combine this will a GlobiFlow process and the campaign can be started up with no extra work.
Additional Thoughts
With any system I setup there are a TON of features I’d like to include. Unfortunately it’s too easy to get trapped by adding to many features in the beginning. You need to get your core perfected before adding new features.
With that said I wanted to list a few features that I wanted to add but deemed them to be “future features” instead.
Automatically Sending Mailings to a Printer
Doing this would completely automate the entire process. Letters being mailed all in the background. All you do is take phone calls and status your leads. How much time would that save me??
Link my Podio CRM
My idea is that if I click on a category field that has an option Send to CRM, GlobiFlow would grab the lead information and create a new record in my Property's App in my CRM Workspace.
Move Leads to a Followup System
There are many times were a lead isn't motivated enough yet but has responded. Sending them the mailers from the original campaign might not work. But it would be great to send these leads into an forever follow up campaign.
Want This System for Yourself?
To go along with this blog post, I put together a 12 module Video Tutorial on how to create this exact system. It’s totally FREE and all I ask is that you share this post on Twitter, Facebook and any where else you can think of.
Watch the Video below to see the Podio Direct Mail Manager in action. Then Click the Button Below to get access to the tutorial.
Share this Post
FREE Step by Step Video Tutorial
Podio – Direct Mail Campaign Manager
Not only did I develop this Podio Direct Mail Campaign Manager for myself to use, but I documented every step of the setup for you! I put together a FREE 10 part Video Tutorial on creating my exact setup. Just click the button below to get access.
- Suspended From YouTube – for no reason - April 11, 2022
- Make Calls and Send Texts in Podio using smrtPhone - April 26, 2019
- Email Marketing with Podio and ConvertKit: Dealing with Unsubscribes - February 27, 2019
Comments 46
Hey, Scott. Your email completely intrigues me. I will be studying it. Admittedly, I haven’t done more than skimmed it yet. But at the very bottom under “Additional thoughts” you list automating the printing. That’s what we do. We make using the USPS drag-and-drop simple. Is there a potential here for us to partner on your efforts?
Also, I need to implement a scheduling system into Postalocity. I don’t yet know the format you’re using, and if it’s able to be built in. But if what you’ve done can shorten my I.T. guys’ efforts, I’m all over it.
We should talk soon.
–Bryan Pulliam
316-247-5361 direct
Author
Your service would definitely be what is need to complete the full automation of this process. So basically how would it work? If I had my process send you a PDF of all the letters that need to go out, would that work? Additionally how would it work if the letters are specific to each lead? Could the process also send you a list of the mailing addresses in the same order as the letters where in and you’d be able to match them up? Lot’s of questions LOL
Shoot me an email sometime and we can setup a time to talk. scott@strugglinginvestor.com
Great and useful post as always, Scott. I’ll be tinkering around with implementing it this weekend.
Author
Hope it goes smoothly for you George. I tried to be as thorough as possible but I’m sure I left some questions unanswered.
Nice and thanks alot, this will help cut the learning curve for me with Podio, thank you Scott
Author
You’re welcome Robert
Scott, this looks like it would save a lot of time and I’ll definitely give it a shot. One question I have, what do you do for envelopes with this system? Does your printer handle those or do you hand-address them?
Author
In the past I always printed envelopes myself using my laser printer…complete pain in the As*! The services(lob.com, Clic2Mail and Postalocity) I’m looking at to completely automate this process would handle the envelopes. The only downside is that the mailings will look more bill/junk mailish. Not sure how that will affect response rate but is worth testing. You have to weigh the balance of time/money/effectiveness.
Yeah, the idea of having it look more bill-looking is the one thing I’m concerned about. I do mostly probate properties and so I already print the “Personal representative of the estate of {Deceased}” on the envelope, I’m worried that losing that and the “real” stamp may adversely affect my open/response rate. That being said, having it look more official might actually increase the rate. Might be worth a shot, just for one mailing. Also, (TECHNICAL LANGUAGE ALERT) It might be possible to find or build a web service to generate a PDF of envelopes that you can send a request to through Globiflow to generate the envelopes.
Great stuff as usual Scott! I really appreciate the attention-to-detail, and time you spent to set this up! Is there a way to send this to the already established Mailhouse within Podio?
Cheers,
Arnell
Author
There are a number of possible solutions like trypaper.com and lob.com. Also you then have the options like YellowLetters.com and MarketLikeAWholesaler.com. I’ve experimented with a couple of them and came way with some hurdles that need to be overcome before it would actually work. It’s not as easy as I once thought it would be. I do plan on coming back to this at some point in the future as it’s something I want as well.
Hello Scott! Amazing website! Thank you very much for all your hard work. I have a question regarding the Direct Mail Campaign System. I followed your step-by-step setup and even did a test print on a small list. The PDF printout did work. The one issue I have is that the name of the seller shows up, but the remaining list items do not, i.e. ##address##, ##city##,##my-name##, etc.
Where are these items defined so that I may correct this issue?
Thanks again!
Michael
Author
Hi Michael,
There is an error in the video tutorial where I put the wrong variable name into the “merge” fields.
There are 8 Variable Actions (7 Body & 1 Letter). The 7 Body variables are used to build (mail merge) the letter content. The first Body Variable is correct…
Body = str_replace(“##address##”, [(ref Lead) Property Address],[(Variable) LetterContent])
Now each subsequent Body variable must build off the previous one so instead of using the [(Variable) LetterContent], you need to use the Body variable [(Variable) Body] or you are just ignoring the previous step.
So this is how each of the Body Variables should look like…
Body = str_replace(“##address##”, [(ref Lead) Property Address],[(Variable) LetterContent])
Body = str_replace(“##city##”, [(ref Lead) Property City],[(Variable) Body])
Body = str_replace(“##state##”, [(ref Lead) Property State],[(Variable) Body])
Body = str_replace(“##zip##”, [(ref Lead) Property Zip],[(Variable) Body])
Body = str_replace(“##my-name##”, “Daniel Fisher”,[(Variable) Body])
Body = str_replace(“##my-phone##”, “(484)367-4995”,[(Variable) Body])
Body = str_replace(“##name##”, [(ref Lead) First Name],[(Variable) Body])
Letter = [(Variable) Letter].”
”
Make those changes and everything should work.
Wow! Thank you so much for taking your time to help me out with that. It works now!
I’m just getting started with Podio, and the tutorials/articles you put out have been incredibly helpful! One question I have is since you listed “link my Podio CRM” as an additional thought, how are you currently taking the info from your mailing lists and creating the item in the properties app if you have someone who responds to your mailing? Is this a manual process right now?
Author
Linda,
I have a globiflow process that transfers the lead information over to my Leadflow(CRM) Workspace. Basically I have a category field that says “Transfer to CRM”. When I click that on a lead, it pushes all the information over to a Lead App in the LeadFlow workspace. The Leads App has a relationship field that links back to the Direct Mail Lead table Item where it originated from.
-Scott
Hey Scott,
Phenomenal work! You’re a huge help!
Wanted to see where you stand with click2mail integration? … I was thanking a great way to do it would be to change the output from a single mail merged document to multiple PDFs which are then individually emailed to click2mail with their required subject headers and the PDF attached to the email. All automated of course.
Is this something that you think is possible?
Author
Hey Mark,
I’m currently working on another project (Podio CRM), but will get back to the Direct Mail system after that and I will be digging into some integrations for lob and click2mail.
Mark,
I am going down the same path with Lob.com or click2 mail. Were you able to figure out the coding to make this happen.
Hi Scott,
I am just getting started with podio and your writeup is fantastic! Unfortunately I was not one of the early adopters of globiflow and am kicking myself now.
As I have seen in your other posts you mentioned fusion mint, but after trying this it seems very limited. Have you looked at cloudpipes? I started a trial and it seems to have the options that are needed, however it works very different and I am having a hard time setting this up. Do you have any experience with cloudpipes?
Thanks!
Ed
Author
Hi Ed,
I took a look at what Cloudpipes was all about. It looks to be a competitor to Zapier and IFTT. Those services are quite different the Globiflow because they basically just take information from one place and put them some place else. You can hook into many different services using them. Globiflow on the other hand is strictly for Podio. You can setup automations to manipulate the data within Podio, move it around and much much more.
I haven’t tried Fusion Mint myself, but I will in the future just to see what it can do. There was someone who sent me an email saying they were able to get my Direct Mail Campaign working with FusionMint, but I’m not sure what he did to make it work. Though he did say it wasn’t easy.
Scott, thank you so much for providing this info! Dude you are a genius.
Have you made any progress towards linking it with click2mail or Lob?
Author
I have not, but it’s more a matter of me building up REIFLOW to the point where a link to click2mail and Lob would be workable. That time is coming very near!
Hi Scott! Thank you SO much for such a great tutorial! The attention to detail is superb and it has been so very helpful to us!
Author
Thanks Kim
Hey Scott,
I’m wondering if you have ever had a problem with the globiflow where it stops working? I have been loving this but as I went to use it this month, suddenly I am returning a blank page. From what I can tell, it appears like when it searches in the letter app for the letter content it is returning empty, despite the content that is in there. So when it runs the merge, instead of stringing everything together, it ends each step returning an empty field. Just wondering if you have ever run into this or have any suggestions?
Author
Hi Kim,
I haven’t experienced a problem like you described before. Can you see anything odd in the GF Log for your Flow? On a side note, do you have a legacy GF account directly from GlobiFlow or a Podio GF account? I ask because sometime this month, they are discontinuing all legacy accounts and forcing you to migrate over to Podio GF. F’d up move by Podio and perhaps has something to do with it.
Have you made any changes to anything since the last time you know it worked? perhaps there are some invalid characters in the letter or the search term is exactly matching the campaign name.
Thanks for the quick reply Scott.
After I commented, I decided as a last resort, I would delete the letter and create it again. For whatever reason, that fixed it. We have been “tweaking” several mailings lately, so I’m not sure if that had something to do with it.
At any rate, I just finished printing so I’m good to go! Thanks again!
Scott,
Good morning. I just completed integrating this podio system into my business based off of the information you have put together for us.
Quickly, what is the best way to trigger the mailing address to be printed on tabs (print envelope). It doesnt look like there is a globiflow created to trigger the print envelope button.
Look forward to hearing back from you.
Author
Daniel,
You basically have to copy the exact same flow for printing the letters. Just trigger it off the “print envelope” category value and adjust the part of the flow that builds the letters PDF. Instead of pulling into the flow the letter template, you can create an envelope template and pull that in instead.
Hey Scott,
First of all, thanks for sharing your direct mail system. It’s a huge time saver. Have you had any issues with running this on approx 700 records? I’ve used it a few time to target smaller subsets of less than 200 leads with no issues; however, today I setup a campaign for a group of 749 leads and had trouble. The Globiflows ran fine with no errors reported in the logs, but the finished PDF only contained 249 results. Any thoughts or ideas?
Author
I’ve not had a test case of that many records so it’s tough to say. The usual culprits are…
(1) The get records action in globiflow might be capped at ~250 records. see if you can do a record count after pulling the records.
(2) There is a size limit on a variable. Meaning that it can hold only so many characters. Though this might lead to an error
Other issues that I can think of would most likely cause an error to show up.
Thanks for the reply, Scott. I appreciate the feedback.
I ran into the same problem when I attempted this with our larger lists. The folks at Globiflow told me I was trying to run too many at a time. I had to create a category field to batch them and split up the leads among them. Then I ended up having to copy the original flow and add an if statement so that it would run one batch at a time.
Because we are running so many larger lists like this, I set up a similar flow that pulls an excel spreadsheet and now I just do a mail merge with the spreadsheet information instead. It became difficult to keep up with the batches within our leads.
I love this for our smaller lists though 🙂
Thanks for the input, Kim. I appreciate you sharing your experience. It’s good to know that I’m not the only one seeing this issue. Before I started using Scott’s system, I was exporting to Google Sheets and doing mail merges, but I haven’t found a great solution for mail merge using Sheets yet. The one I was using would fail if I tried to merge more than 150 to 200 records at a time. It became difficult to manage.
Did Globiflow provide any specifics on limits to determine how many records can be merged at one time?
I really can’t remember what they said but I started batching them in groups of 150-200, before I switched to the mail merge.
Thanks Kim.
Author
I did a little bit more checking and there are 2 limiting factors here. First, Podio’s API for getting records (Filter) has a max of 500 items per request.
Additionally this max amount can be limited more by the system calling the Podio API Filter request. So my guess is that Globiflow limits these to 250 records.
Like Kim said, the only way around this is to batch the calls using some sort of category field method. Or perhaps you can do it on a date range.
I can think of other ideas, but they would require a staging database and would get much more complicated.
Thanks for looking into this more, Scott. I really appreciate your help. Now that I have a much better idea on the max size, I should be able to implement the batch method you and Kim mentioned. I’ll give that a shot. Thanks again for sharing your system!
Hi Scott,
I just wanted to thank you very much for sharing your Direct Mail System. Your generosity and knowledge are amazing.
I have just finalised putting it into our Podio and Globiflow systems, and although I did run into the variable.content vs variable.body issue, it is now working great.
I can’t thank you enough, it is truly appreciated.
All the best
Harvey
I love the video series. I was able to create the podio and globifow system and it is working great. I do have one question on creating the letters. The formatting seams to be very plain. Is there any way to make format the letter better like change paper size, fonts, spacing. Just trying to make the letters look a little better. Thanks again for the great videos.
Author
Formatting is a bit tough when it comes to converting HTML into a PDF. I know you can change the font, margins and some other things. Take a look at this Globiflow help doc as it might give you some ideas on what you can do.
http://www.globiflow.com/help/advanced-formating-of-pdf-and-detail-table.php
Thanks, Scott this really helps me out a lot. Can Click2Mail be added to this system? I asking cause now I am interested in seeing if I can add it somehow.
Are you just printing the letters at home or office? Or you using a third-party printing service to print the PDF’s
Author
Hi Patrick,
I was printing them by myself. I looked into using services like Click-to-Mail back when I put this tutorial together a couple years ago. It just wouldn’t work because of trying to synchronize the mailing address for the envelopes with the customized letters. Perhaps Click-to-Mail has improved since that time, but I haven’t checked.
Scott,
Thanks for putting this information together. Under the Leads App section, you mention a List relationship and indicate this as a way to keep discreet lists; however I don’t see a List App anywhere else in the article. Currently I am using multiple excel files that collectively are my lists. Ideally I want to transition to Podio to manage this moving forward.
Author
Hi Jarrod,
If memory serves me (I wrote this article a couple years ago), it was because the list app was redundant. Meaning that the Campaigns App basically acted in the same manner to separate different lists. At least this was the case for how I had my mailings set up. Each campaign had a single list. If this is not the case for you, then you can easily add a List App and then a field in the Leads app to link to the List in the List App.
Hope that helps