3 Resources to Help You Build Outstanding Online Courses

By Stefanie Flaxman

“Choosy moms choose Jif” is one of my favorite taglines, for peanut butter or otherwise.

The product’s message stands for more than just peanut butter.

Jif paints a subtle picture of an elite group: choosy moms. Choosy moms only buy the best food for their children.

Any mom who aspires to be part of a group of selective moms would value what Jif represents and feel good about purchasing the brand of peanut butter.

When you turn your educational content into an online course or membership site, how can you communicate to your potential students or members that you have the knowledge that will help them become the people they want to be?

This week’s Copyblogger Collection is a series of three handpicked articles that will show you:

  • How to structure and sell your natural expertise
  • How to attract students who want to learn from you
  • How to create a valuable lesson plan that sells your online course and motivates your students

How to Structure and Sell Your Natural Expertise

Chances are, you’re extremely knowledgeable about a certain topic.

Whether you know a ton about an industry you’ve worked in for years or a fun hobby you’ve mastered, at some point you might want to document your expertise and teach others.

But how do you organize your ideas and find the right technology solutions that help you distribute your lessons to students?

In How to Structure and Sell Your Natural Expertise, Pamela Wilson shares the first steps you need to take, so you realize that building an online course isn’t just a lofty dream — it can easily become a reality.

5 Reasons Why It’s Practical and Profitable to Share Your Expertise Online


If you’re still not convinced about the benefits of teaching an online course, Amy Harrison is here to guide you with 5 Reasons Why It’s Practical and Profitable to Share Your Expertise Online.

Amy tells a juicy story about her own experiences teaching in-person classes and teaching online.

I won’t spoil it for you, but here’s a snippet of her wisdom:

Until they master cloning, you can’t scale your live workshops and profit.

I’ve had the pleasure of running many workshops that I absolutely loved. Even so, I was capped at the number of training days I could physically do each month.

Anyone who trades time for money has this limit, and in addition to limiting your revenue, it can also make you susceptible to the small business ‘feast or famine’ cycle.

How to Create a Valuable Lesson Plan that Sells Your Online Course and Motivates Your Students


It’s time to get down to business.

Fortunately for you, Henneke has outlined How to Create a Valuable Lesson Plan that Sells Your Online Course and Motivates Your Students.

If your lesson plan describes unparalleled value for your students, it naturally sells your course for you.

Thought-provoking stuff here.

Check out Henneke’s article to find out exactly how to craft a remarkable lesson plan.

Smarter ways to create and sell profitable digital products and services

Ready to create your own online course or membership site, but you need more educational resources?

Our brand-new Digital Commerce Institute is designed to give you the in-depth education you need to build a profitable digital company.

Until November 6, 2015, we’re offering Charter Membership access to our online Academy and our live 2016 Digital Commerce Summit at an exceptional price.

Head over to Digital Commerce Institute to learn more about our special limited-time deal!

About the author

Stefanie Flaxman

Stefanie Flaxman is Rainmaker Digital’s Editor-in-Chief.

The post 3 Resources to Help You Build Outstanding Online Courses appeared first on Copyblogger.

Source: Copy Blogger


Mirror, Mirror: Reflecting on Your Personal Brand

By Risa Goldberg Last blog I asked the question: Are you FAMOUS!?! Maybe you are, maybe you aren’t. It doesn’t matter because people are on different journeys when to comes to personal brand. When I speak about it, it’s mostly on who are you and how you want to be seen. Now I’m changing my tune a bit and focusing on whether you want to be active or passive when it comes to branding. As I enter the next phase of my journey, I’m exploring if how I’m seen is how I want to be seen.

Source: Social Media Today


Stroed procedures

By Collin H.

Please help me with the syntax of this stored procedure? This is being done inside oracle’s SQL developer.

The purpose of the stored procedure is to allow the CALL function to insert a new record into the CLASS table (which was created using the syntax below):

class_number NUMBER(8),
teacher_name VARCHAR2(50),

class_name VARCHAR2(50) NOT NULL,
start_date DATE,
end_date DATE,
class_category VARCHAR2(20),
topic VARCHAR2(20),
teacher_credential VARCHAR2(40),


With the stored procedure and sequence coded below, a new class is supposed to be created and if the end date is before the start date, then the end date is supposed to be the start date + two weeks by default.

CREATE SEQUENCE class_number_seq;

Teacher_name_param class.teacher_name%TYPE,
class_name_param class.class_name%type,
start_date_param class.start_date%TYPE ,
end_date_param class.end_date%TYPE,
class_category_param class.class_category%TYPE,
topic_param class.topic%TYPE,
end_date_param class.end_date%TYPE
class_number_var class.class_number%TYPE;
end_date_var class.end_number%TYPE;

SELECT class_number_seq.NEXTVAL INTO class_number_var FROM dual;

IF end_date_param < start_date_param OR end_date_param IS NULL THEN
end_date_param := start_date_param + 14;

end_date_var := end_date_param;
VALUES(class_number_var, teacher_name_param, class_name_param,
start_date_param, end_date_param, class_category_param, topic_param);

the error I’m getting is: PL/SQL complilation unit analysis terminated
and: duplicated fields in RECORD, TABLE or argument listed are not permitted. I

I’m not sure if there is anything wrong with my logic — or where the duplicate fields are.

Help please!

Source: Stack Overflow


If then for href URL to load different templates in opencart

By user3851589

I need an If then statement that will load a different template in opencart product.tpl file depending on the URL

If URL = domain.com/product1 or product_id use

<?php require( PAVO_THEME_DIR."/template/product/product_detail_product1.tpl" );  ?>


<?php require( PAVO_THEME_DIR."/template/product/product_detail_default.tpl" );  ?>

Any help would be appreciated.
Thank you

Source: Stack Overflow


Beyond The Media List: Pro-Active Prospecting for Pitching Creative Content

By Beverley Reinemann

It’s sometimes hard to know where to start with prospecting.

If, like me, part of your job is to get your clients coverage using creative content, you’re likely using a media database like Gorkana to find publications and journalists to pitch to.

There are other ways to find a journalist’s email address (and, let’s face it, we’ve all done our fair share of internet stalking to try to get our creative pieces into the right hands) but media databases, I think, are the most effective way to easily pull up a list of relevant journalists and publications.

I use Gorkana, a media database with contact details of journalists all over the world, but my prospecting process doesn’t start and end with pulling up a ready-made media list. For one, sometimes using a list can leave you with a bunch of irrelevant people and publishers, and secondly, if you really want to target the right journalists and gain coverage for your clients with creative content, it’s almost always worth going the extra mile.

So instead of relying on media lists, I use a variety of different prospecting methods to find the best possible people to pitch to, even if it does take a little longer.

Prospecting on Twitter

I’m going to assume that, unless you’ve been living under a rock up until this point and only resurfaced to read this blog post, that you have a Twitter account. I mean, every good digital marketer does, right?


When it comes to prospecting Twitter is a winner for a few reasons. One, it’s completely free; two, you can stalk journalists without them knowing (yes, LinkedIn, I’m looking at you); three, there’s more than one way to use it to find what you’re looking for.

Let’s dig into those right now.

Building Twitter lists

Step one: find some journalists on Twitter and follow them

You could just follow anyone and everyone but, if this process is going to help you on an ongoing basis, your best bet is to follow the ones you think might be relevant to any creative content you’re going to be promoting in the future.

Step two: create a Twitter list and add those journalists to it

The beauty of this step is that, if you don’t want journalists to know you’ve added them to a list, you can just make it private, meaning you (and only you) will be able to see it. Also, if you’ve got several projects in the pipeline, you can make a list of journalists for each one.

Step three: set yourself up on Hootsuite or Tweetdeck

I’m not saying you have to leave Twitter’s desktop site altogether, because we’ll be coming back to using that in a second, but if you want to use Twitter for prospecting you need to set yourself up on either Hootsuite or Tweetdeck.

These social media dashboards allow you to create columns, one of which I’d recommend you use to display tweets from the list of journalists you created in Step 2. That way, you can monitor what those journalists are tweeting about and, provided you take a glance at it once in a while, be on hand straight away if they’re working on a story that’s relevant to your client and tweeting about it.

Prospecting using Twitter search

Back on the Twitter desktop site, the next step to finding relevant journalists for specific creative campaigns and building out your prospect list is by using the search bar within Twitter itself.

Think about the piece of content you’re going to be promoting: will it appeal to lifestyle journalists, tech journalists, finance reporters? A great way to find journalists in these fields, aside from using your preferred media database, is to search for them on Twitter by using, surprise surprise, the search bar.

Look, no-one said getting out of the prospect list rut had to be overly complicated.

So, say you’ve got a piece of content launching which will appeal to writers who focus on personal finance, search ‘personal finance journalist’ on Twitter and your results should look something like this:

These results will not only give you a list of journalists to add to your prospect list (and if they haven’t included their email address in their profile you can always search for them by name in Gorkana) but it may also give you some ideas on which publications to target.

Prospecting with link analysis tools

Most digital PRs will know their way around link analysis tools like Majestic, Open Site Explorer, and Ahrefs which we use to establish how many inbound links a piece of coverage has gained over the course of a campaign.

These tools are normally used to find out the results of a project once it’s over, but you can also use them to your advantage even before your piece of content has launched.

Step one: find similar pieces of content

Here at Distilled the content we produce is, for the most part, interactive. We visualise data so that’s it’s easy to digest and appealing to general consumers. Sometimes this content is inspired by something we’ve seen that uses similar data but isn’t so widely appealing, isn’t interactive, or doesn’t have the strong angles we need to get the attention of journalists

I say ‘inspired by’ because, of course, we’re not rehashing something that’s been done before, that would be pointless. But other pieces of content can definitely act as a starting point during the ideation process, something that all PRs should take part in.

This content, often launched years beforehand, can be useful when it comes to building out your own prospect list.

Step two: copy the URL into a link analysis tool (I used Open Site Explorer)

From this, you can quickly pull up a list of publications who covered it.

The list of publications can be helpful, but it’s the name of the journalist who wrote the article that you really want to get your hands on: sort the results by Domain Authority so you’ve got the highest quality coverage at the top of your results and start opening those articles. This will enable you to find sites and journalists who could be interested in your new piece of content based on the fact that they covered something similar before.

Just Googling it

As PRs, we’re used to being able to reel off a bunch of publication names off the top of our heads and we’ll often also have an idea of specific journalists who’d be interested in a piece of content, especially if we already have a good relationship with them.

This can be harder, though, if you’re launching a piece focussed on a subject you’ve never pitched around before.

This is when Google can be the a good starting point.

Before we launched this piece, I wanted to find out which sites had produced articles on a similar subject. I wasn’t looking for similar pieces of content, just articles with stats about Instagram. I figured that, if journalists had written about how many photos are uploaded to Instagram then they’d be interested in an interactive piece that made those stats meaningful and created a sense of how huge those numbers are just in the way it was designed.

So I started Googling:

Searchers are clearly interested in how many photos are uploaded to Instagram

Which brought up a bunch of relevant articles written by a range of journalists: tech, social media, marketing, those who focus on reporting on digital trends. And even though I knew I’d also want to target other journalists, this was a great starting point. Pairing this method with the Moz Bar (which I leave open almost constantly) I was also able to see the quality of the sites who’d covered similar subjects which helped me establish whether or not I wanted to target them at all.

Of course, prospecting isn’t rocket science but, having run training sessions with client’s in-house outreach teams, I know that simple tactics like this are often overlooked. For time-stretched PRs and outreachers, pulling a media list from Gorkana and sending out mass emails is the norm and, while I’m often pushed for time as well, I’ve seen better results from pro-active prospecting – thinking ‘outside the media list’ – than when I’ve just relied on databases to do the work for me.

Source: Distilled