Omeda

Ever want to get data from another SaaS application into your Omeda database easily, automatically, and cheaply? 👨💻 Keep on reading below... It's Omeda recipe time again! 👨🍳 Though, really, this technique could be used to drive data to any webhook from a Google Sheet. Very very handy. Many applications out there have native Google Sheets integrations that cost zero dollars to use. Which is fantastic because a Google Sheet becomes a powerful data hub when combined with Google Apps Scripts (think VBA Macros in Excel). If you can get data to Google Sheets you can get it to an Omeda Webhook or any Webhook automatically. This is an extremely potent and powerful integration and it does NOT require any expensive middleware or iPaaS solution at all. That's the best part. 🚨 Geek Alert: Coding Ahead. Under 55 lines of code in a Google Apps Script and you've got it. Disclaimer: Of course, this is an EXAMPLE for informational purposes only and anything you do with this, you do at your own risk. You should check with your IT department to make sure you are allowed to do this. The script pictured here will copy any new rows added to a Google Sheet to a Webhook on a nightly basis. Yes, it's a little coding but it's simple, I promise. Let's go through the functions: resetLastCheckedRange(): Use this only as needed to reset the "last row processed" variable, which you may have to do during testing phases. You can modify this to a particular row number too, of course, this function simply obliterates the value. setupTrigger(): You use this one time to set up the recurring trigger in Google Apps Script. You can also create this manually so this is not required but a nice touch. sendNewEntries(): This is the function that the trigger will call nightly. It loops through the rows in your spreadsheet starting at the last row it processed. It stores that last row processed as a system constant for safe keeping. In this example we have 5 columns that we are converting to JSON and sending to our Webhook: Timestamp, FullName, Email, JobTitle, Company. You'd modify this to match your sheet. HOW did I do this? I had ChatGPT write the code for me. I believe this is one of the most powerful uses for ChatGPT these days. Here is the prompt I used, feel free to experiment on your own: "I have a Google sheet with the columns: Timestamp, Full Name,Email ,Job Title , Company. I'd like to create a google apps script that will check for new rows daily and send each new row as JSON in a call to a webhook, let's say that webhook URL is https://foo.com/webhook for now. Could you write that script for me?"

Are your spam rates above 0.3%? Are your delivery rates below 95%? Chances are, your emails are being sent to spam. Deliverability issues keep you from reaching your recipients and hurts your marketing potential. But even small fixes can help you improve your sending reputation and reach your audience. Learn how to improve your email deliverability with these tips from our deliverability team: https://lnkd.in/gNe7ZhPy

Questex's disjointed post-event survey process kept them from collecting feedback from their audience and making the improvements their audiences were asking for. But by combining Omeda’s integrated audience data platform with CredSpark’s interactive content offerings, they created a more targeted, successful survey that gave them the insights they needed to create better audience experiences. See how they did it here: https://lnkd.in/gG35mDTr

Gardner Business Media was doing well enough running standard lead gen campaigns for their customers. But they soon realized also needed to help those customers score and nurture their new leads throughout the buying lifecycle. So they combined Omeda and Zapier to create a better lead scoring model that surfaced the best prospects and maximized data quality. In this webinar, we’ll walk through Gardner’s improved lead scoring model and give you some tips for nurturing and scoring leads (and as a bonus, how they used AI for data appends!). Join us TOMORROW at 11am to see they did it: https://lnkd.in/g9wsNJXS

After nearly 4 decades serving the Virginia business community, Virginia Business wanted to transition to a paid subscription model. But they didn't have the single audience view, integrated communications and forms they needed to create a smooth subscriber experience. So they used Omeda to connect and automate their entire paid subscription lifecycle, from their sign-up forms and meters to their email newsletters, their automated renewal campaigns, and print fulfillment services. Read on to learn how Virginia Business successfully pivoted from a free to paid subscription model — and increased their circulation revenue by 65% in one year. https://lnkd.in/gR_bs-B2

Annex Business Media has millions of audience members across its 60+ publications and channels. But they couldn't give their advertisers a single way to reach that entire audience across every touchpoint. And their campaign performance was suffering as a result. So they used Omeda's audience management solution to create Lead Driver, a cross-channel marketing campaign that gives the Annex audience one consistent message across email, display ads, website targeting, events and more. Since then, the Annex team has done more than 70 Lead Driver campaigns, with many clients coming on for a 2nd, 3rd or even 4th round — and raised important revenue to reinvest back in their content. Learn how they did it here: https://lnkd.in/geNWQTsW

Most media teams say they're investing in their audience, but about two-thirds of them don't have a formal, top-down audience development plan. That's a problem — but in order to address it, we need to understand what's stopping media teams from creating company-wide audience development plans. Some possible reasons include: ⭐ Each individual team is pursuing their own channel-specific audience growth goals at the expense of holistic audience development. ⭐ Everyone feels responsible for the audience — so audience development ideas often fail victim to death by committee. Or companies don't have a chief audience officer or another single stakeholder advocating for audience development. ⭐ Senior leadership may not full understand the work or challenges of audience development. ⭐ Companies may not have access to the cross-channel audience data they need to evaluate their current audience goals accurately, let alone build upon those goals. ⭐ They're overwhelmed by the task of managing millions of audience data points, a growing number of channels, and several verticals under one strategy. For more audience development insights like this, check out our recent State of Audience Report — and stay tuned for more resources soon: https://lnkd.in/g3q7HKFY

Join us 8/22 at 11am for a webinar on how Gardner Business Media, Inc. combined Omeda and Zapier to improve their lead scoring model and increase advertising ROI (and as a bonus, how they used AI for data appends!). Sign up here: https://lnkd.in/g9wsNJXS

Tune in today at 11am CT to learn how Fusable used its audience data to create stronger audience profiles, pursue best-fit ABM opportunities and drive critical revenue for their business. Sign up here: https://lnkd.in/gskfvkcP

You can't reverse engineer your way to audience engagement. But with good first-party data, an organizational commitment to your audience, and (of course) valuable content, you can create experiences that keep your audience coming back for more. Learn how below: