Hi Jess,
So let's say you had 50 accounts that a task is associated to....
Call the start of that list
Acme Company
Beta Company
Gamma Company
You have a task where the "related to" field in SFDC is ONLY the account?
Now, if there are 0 contacts associated to these accounts, then there is nothing you can do to add these records to a campaign (right now at least).
If it is the case that these accounts have 0 contacts, maybe you're cold calling in and trying to find the decision maker?...There is something that we can do, but answer the above first before we get into that.
If its the case that the task was associated to Acme, Beta, Gamma, etc. and you want to add the contacts that are associated to these accounts into a campaign...its a bit complicated, but there's a solution you can do.
I'll caveat this by saying...I definitely would not add ALL records to the campaign...cause chances are you're not following up with all of them. What if Acme had 1000 contacts, you don't want to add all of them to the campaign, but that's another story.
Ok if you want to do the above...Run this report first in SFDC:
>>Reports
>>New Report
>>Activities
>>>>Activities with Accounts
Maybe add a filter on subject line to narrow it down to the right accounts.
Ok so here is the list of all of your accounts that have people...Now take those names in a smart list in Marketo...Account Name = (One of those names)...If its a HUGE number, you'll have to split it up.
But that will query all records associated to these accounts. Then at least you can do a bit more manipulation and maybe say...only the Primary Contact or only certain profiles.
Let me know if that'll work for you.
Again, if you're looking to add new contacts to these accounts then there's another option, but let me know