I've accomplished this in two ways:
A google workbook that has multiple sheets. Tab 1 - Program Name. Listed the components of the name and concatenated them when all were completed. The generated name is used when cloning the Marketo program template and creating the corresponding Salesforce campaign.
Tab 2 - All the token fields that populate the emails and landing pages. The marketing folks were thrown back at first until they realized how much time savings they got from the token sheet.
Tab 3 - Campaign Meta Data Details: Campaign Start, Campaign End, First invite out Second invite out, etc.
Tab 4 - Add to Calendar link generator. Works like Tab 1 but translates the date and times and timezone correctly
Tab 5 - Local UTM generator. Once completed they use a macro to post them to the master list of UTMs
Option 2: Ticketing Request System
I'm now at an organization that uses Microsoft products so I'm implementing the above as Sharepoint lists which can be populated from forms in Teams. It's not the same tabbed, self-contained book but it's easy enough. I could build it in Excel and then have the request ticket open the Excel workbook with the same tabs. I haven't had time to work on this yet. I'll update you as I move forward.
Dennis
Giraffe goes where?
... View more