Facebook comments for WordPress – app creation, code integration and moderation

Facebook comments make homepages, blog and online shops much more lively. Users are no longer forced to enter their data or register. By placing or exchanging the WordPress comments with the Facebook code, the interaction, user loyalty and also the visiting hours of your website, blog or shop increase. For embedding there are of course also WordPress plugins. With a little copy & paste you can also do everything yourself. Today not with a video tutorial, but with screenshots, because it is really fast, even without an advertising agency.

Create Facebook App for use

Tip! Here you can find our XXL Guide to the topic Facebook Ads. In this article you learn:

  1. Create Facebook App for use
  2. Comment Generate and embed comment code

If you have not yet created your own application in facebook for developers, this is your first step. Just sign up here and create an app:

Comment Generate and embed comment code

In the next step you generate your own code. It is important that you get it into your header.php. This usually works in two ways with WordPress.

  1. The best way is to include the code in your theme backend. Most themes support embedding directly from the backend. Then you don’t have to make any changes to the theme. You place the code where, for example, the code from Google Analytics is located.
  2. Directly in the theme via your WordPress backend via Design > Editor. Then open the header.php and insert the code cleanly, best directly after the <body> tag.
  3. recommendation! Better go over your Child Theme and change a copy of the header.php, then you will have no problems with the theme update.

Here you can generate your code:

This is what the generated code looks like. The appID is your individual ID.

<div id="fb-root"></div>
<script>(function(d, s, id) {
 var js, fjs = d.getElementsByTagName(s)[0];
 if (d.getElementById(id)) return;
 js = d.createElement(s); js.id = id;
 js.src = "//connect.facebook.net/en_DE/sdk.js#xfbml=1&version=v2.8&appId=1453051238274088";
 fjs.parentNode.insertBefore(js, fjs);
}(document, 'script', 'facebook-jssdk'));</script>

Screenshots of the developers tutorial

Here once again all steps in individual screenshots:

Exchange WordPress and Facebook comment function

Besides the script you will also get a small div box for embedding in the front end of the page. The procedure here is similar to the script. Only that you edit the single.php. If you are working with a theme, the code may also have to be placed in comments.php or similar. Like in my example. You can include the code everywhere in your page or only on single pages. We replace the comment function directly. If you want the comments on single pages, just insert the code directly into the blog posts, etc. This is how you change the comment function globally.

Important, you have to replace your URL (in my case http://lukinski.com) for the global variant with :

< ?php echo get_permalink(); ?>

  1. Directly in the theme via your WordPress backend via Design > Editor. Now open the single.php and replace the WordPress code or exclude it.
  2. recommendation! Do the same with your Child Theme and change a copy of the single.php.
<div class="fb-comments" data-href="< ?php echo get_permalink(); ?>" data-numposts="5"></div>

Voila.

Screenshots of the code exchange

In my example the comment code was not in the single.php but in a single comments.php. I copied this into my child theme and replaced the whole comment code with the new Facebook comments. If you work in the single.php, make sure to remove only the comment code. In the example the whole comments.php was replaced.

Facebook comment function in the blog

Ready the whole thing looks like this!

Web design test environment: Photoshop tutorial for managers and advertising agencies

Web designers in advertising agencies should always have their finger on the pulse. The reality often looks different. As a consultant in advertising agencies I often see desperate attempts to work fast in Photoshop. For a few icons you can easily lose a whole day of your employee. But screen designs in the basics can be so simple. In my new Photoshop video tutorial I show you in a simple way how you can quickly create screen designs, for example for presentations. If you understand the basics, you can then quickly work your way into more complex Photoshop layers and create mock-ups with hundreds of layers. But first of all it’s all about the basics! The tutorial comes right after the video tutorial.

Photoshop Tutorial: Webdesign or Screendesign

Quick screen design or web design in Photoshop

Screenshot of the screen via print key (Windows), top right

Photoshop, create new project. Photoshop will give you directly the right dimensions, mostly HD 1920×1080. Depending on the screen of course differently. If you have two screens, now comes the intermediate step, you have to cut the graphics. You can do that easily with Ctrl + Alt + C. Here you can find more Photoshop Shortcuts.

<

Create new layer, create group, create mask and off you go!

In the end, you can save everything for web and devices and quickly send it or take it with you to a customer presentation.

[shortcode variables slug=”adsense”]

Editor vs. Composer! Simple WYSIWYG text editor against Drag’n’drop plugin

Visual Composer’ are among the trends at WordPress. If you want to create pages and articles in the content management system WordPress, you need the integrated WP editor. The WP editor is in short a WYSIWYG editor, in long words a “what you see is what you get” editor. That means, similar to the well-known office software Word from Microsoft, you always see changes live. Make a word bold bold is bold. Underline a word it is underlined. This is exactly how the WordPress editor works, what you do is what you see. For smaller online projects, websites and blogs this feature is perfectly sufficient. However, with the increasing popularity of WordPress, larger and larger pages have been implemented with the system. But many web designers and media managers didn’t want to settle for simple text fields and embellish the individual page layouts. With individual icons, custom backgrounds, sliders, large images and much more.

+ Do you know?

+

Classical WordPress Editor or nevertheless Composer?

For a professional this is no problem at all, he writes a few lines of code with HTML and CSS and it’s done. But the principle of a content management system is to manage large amounts of data and ideally to make them easily accessible, editable and deletable for users. Therefore, it is recommended to have a nice user-friendly interface that is easy to work with even without a lot of technical knowledge.

principle, design with shortcodes

In order to style pages relatively simply, the idea of using shortcodes was born. These shortcodes combine more complicated code into simple tags that can be used by the user. A simple example would be to pack a nice headline into a shortcode:

[ headline ]Here is the headline[ /headline ]

… the element is then given a special color, a special position, perhaps a different font, font strength and much more. Before we start typing complicated HTML and CSS properties, it would be wise to just use the term headline. And that’s exactly how the principle of shortcodes works: You pack more complicated, long codes into simple little snippets. The problem with this principle is that you need a lot of visual imagination, because the user sees code, not a nicely formatted headline. And now imagine that we only increase the complexity a little bit and include tables, with exactly the same distances between them, which are then also colored in the background, individually, once blue, once yellow, once orange. This is where shortcodes reach their limits, at least for the non-technician.

+ Do you know?

+

New: Composing in the WordPress Editor

In order that content can be easily placed and is also directly visually visible, in its approximate position, in its approximate form, there have been various alternatives to the standard WP editor for some time now: Composer. You can usually download these, install them in your WordPress system and off you go. All important downloads can be found here and again at the end of the article.

The first step is to install the Composer of your choice like a normal plugin in your WordPress Dashboard. In a further step you activate the plugin as usual. What has changed now? Pages and articles. Let’s take a look at your WordPress Dashboard first. Here you will find all important points for you once again in an overview, from blog posts to media to comments and extensions. Pages and posts are relevant for our task today. Pages and posts differ in principle only in that you categorize and chronologically arrange posts like in a classic blog. Pages are all static pages like your terms and conditions, contact pages or “About us” but also the start page and so on.

The most important WP dashboard elements for your website:

wordpress-dashboard-basic-element explanation

Enable WP Composer

In the following example we use the layout editor in WordPress Themes Enfold (found here). No matter if you use the Layout Editor or the Visual Composer of the WP Bakery, you will find a blue button in every single page or post, which leads you to the Composer or switches the mode from the WP Editor to the Composer.

wordpress-dashboard-theme-editorauswahl-03

Many advantages, much flexibility

Let’s first take a look at the countless advantages that the Composer brings to you. On the one hand we have the responsive compilation of content for computers and for mobile devices. The Composer allows you to view columns and rows as individual elements and to adapt them to the size of your screen, i.e. desktop, tablet or smartphone. Furthermore, you have a visual interface, you do not need HTML, CSS or shortcodes to create strong elements like video backgrounds. All elements within the pages or posts can be moved easily and intuitively via drag and drop. The structure of the individual elements is defined and always the same, this gives your website a uniform look and gives the user orientation and therefore less disturbance during the visit.

Further advantages:

  • Elements are freely positionable – even without HTML, CSS knowledge
  • We can create layouts as templates

  • …<

wordpress-dashboard-theme-editor-drag-n-drop-01

[shortcode variables slug=”adsense”]

columns, cells and structure

Let us now look at picture 4. There you will find the conclusion of the small introduction to working with visual editors in WordPress. This is also the last step in my workshops, because working with a composer is very intuitive and can be learned best by trying. It doesn’t take much time either, because the elements are usually limited to twenty. With an independent training the use of the composer is easier and faster understandable. The results will quickly be very good, because the application is really easy with a little guidance and imagination:

wordpress-dashboard-editor-composer-elements-structure-01

My tip: Keep it simple

Look at the structure in figure 4, often none of the special headings need to be, a text field is sufficient. Set a section or work with a column, place a text element here and see what happens. Via the preview (top right on your editing page), you can see the result in a new browser tab. Now go a small step further and place a line our first text field. Make a headline out of the text field and at the very end position a new text field. Done. You can simply copy these fields in a composer and create three or four or five paragraphs. This way you can quickly create a layout and even new employees can quickly learn and show them how effective content management works

If you have any further questions about content management, content marketing, wordpress or workshops for the training of your employees, then give us a call. We have efficient and strong workshop concepts that we have tested many times in close cooperation with our customers and clients. You can also benefit from our experience and know-how as online entrepreneurs and consultants.

WordPress: Password forgotten or hacked?! Change password via SQL in 3 steps

Today I had an interesting customer project. When I received the SQL file for the WordPress system from the customer, I found out that I had no access to the system. And my customer is on vacation. So I wanted to log in, but I couldn’t. So this morning I had to create an account for the WordPress system via SQL.

+ Do you know?

+

How to reset your WordPress password?

Sometimes you forget your WordPress administration password or need a new one for a customer project. In my case it was the latter. This little tutorial will show you how to change WordPress users and passwords easily. Since I hear about this problem frequently – through searches, friends and customers – I wanted to write a quick post about how you can change your WordPress password in a few seconds, create new users or update your current user account. This little feature even encrypts your password automatically in MD5.

So with just a few clicks and a few inputs you can create or update a new user account within seconds. Let’s get started:

Step 1: Change password via SQL database

All you need is the free PhpMyAdmin SQL database tool. Most providers like one.com or 1und1.de have already integrated the tool into their customer account. If you are working on your notebook (localhost), you will also find PhpMyAdmin preinstalled if you enter http://localhost in your browser. So you can access your database directly. Via SQL command you can easily change the data set.

step1-wordpress-password-database-select

Step 2: Find and edit wp_users

In PHP my Admin open your database for the WordPress system you want to edit, open the table wp_users (wp_ is the default prefix and can vary)

step2-wordpress-passwort-sql-table

Step 3: SQL command for password change

Now click on the tab “SQL” in the upper menu. In the tab “SQL” you can enter commands directly. Therefore click on the menu SQL tab. Now enter the following command in the new window:

update wp_users set user_pass=MD5('newpassword123') where user_login='admin'

Now change two variables, first enter your password where it says “newpassword123”, then add the name of the user where it says “admin”. Confirm the entry by clicking on the “Go” button. In a fraction of a second you should receive a message that the table row has been updated. That’s it – you have changed your password, MD5 encrypted and can now log in directly to your system www.url.de/wp-admin.

step3-wordpress-passwort-sql-befehl

wordpress Password changed!

Congratulations, this little tutorial has shown you how you can easily change your WordPress password. This will save you a lot of time and phone calls for your customer project, your next blog or your friendly, weekend help campaign. This will save you a lot of time and you can update and change users within WordPress using PhpMyAdmin – whether they know the password or not. All you need is the table wp_users and the simple SQL command update.

[shortcode variables slug=”adsense”]

Format HTML table: Template for frames, columns without frames

Formatting HTML tables – Today a small basic from practice. Many customers wanted to create their own texts with their employees in WordPress. So that the text is also optimized for search engines, several small features are added. These can be for example photos from the media library but also Youtube video embeddings. Tables simply with Copy & pasting brings a lot of HTML snippets with it, which you don’t want in your own content management system. Let’s take a look at the example of a simple HTML table that anyone can generate and modify.

+ Do you know?

+

Problem: Simply copying HTML tables is unclean

For employees in companies it is important, they should not copy any tables, otherwise we have, as described, a lot of “trash” in our HTML code. The HTML code is not visible in the “visual” area of the editor. To edit it you have to click on “Text” in WordPress Editor. If code is simply copied, it takes small snippets with it that we don’t want. Here is a direct example from practice:

Example – Bad HTML of a table

There are now many things copied here that are not visible:

<th class=”headerSort” tabindex=”0″ title=”Sort Ascending” role=”columnheader button”>No.</th>
<th class=”headerSort” tabindex=”0″ title=”Sort in ascending order” role=”columnheader button”>district</th&gt
<th class=”headerSort” tabindex=”0″ title=”Sort in ascending order” role=”columnheader button”>area</th>

So we see that Copy & Paste takes a lot of stuff away.

Example – Good HTML of a table

That way it would look clean:

<th>No.</th>
<th>District</th>
<th>area</th>

Solution: HTML table template

You have to use or get to know a little bit of HTML. It is best to save it for a short time and then copy or edit it:

  • Tip1 : <table> and <tbody> only at the beginning </table> </tbody> only at the end
  • Tip 2: <th> use it only in the first line and close it again (th means “Table Headline)
  • Tip 3: <tr> opens a row and </tr> closes it (tr means “Table Row”)
  • Tip 4: <td> opens a value or a box and </td> closes it (td means “Table Data”)

Here is a table with 3 columns and 3 rows:

<table>
<tbody>
<carry>
<th>heading 1</th>
<th>Heading 2</th>
<th>Heading 3</th&gt
</tr>
<tr>
<td>Text 1</td>
<td>Text 2</td>
<td>Text 3</td>
</tr>
<tr>
<td>Text 1</td>
<td>Text 2</td>
<td>Text 3</td>
</tr>
</tbody>
</table>

This is what the finished table looks like:

heading 1 heading 2 heading 3
text 1 text 2 text 3
text 1 text 2 text 3

Another example with 2 columns and 2 rows:

<table>
<tbody>
<carry>
<th>heading 1</th>
<th>Heading 2</th>
</tr>
<carries;
<td>Text 1</td>
<td>Text 2</td>
</tr>
</tbody>
</table>

Another example with 4 columns and 5 rows

<table>
<tbody>
<table>
<th>Heading 1</th>
<th>Heading 2</th>
<th>Heading 3</th>
<th>Heading 4</th&gt
</tr>
<tr>
<td>Text 1</td>
<td>Text 2</td>
<td>Text 3</td>
<td>Text 4</td>
</tr>
<tr>
<td>Text 1</td>
<td>Text 2</td>
<td>Text 3</td>
<td>Text 4</td>
</tr>
<tr>
<td>Text 1</td>
<td>Text 2</td>
<td>Text 3</td>
<td>Text 4</td>
</tr>
<tr>
<td>Text 1</td>
<td>Text 2</td>
<td>Text 3</td>
<td>Text 4</td>
</tr></tbody>
</table>

Add more columns and rows

You get more rows by starting or closing a new table row within your table <table>…</table> each time. This looks like this:

<carry>

</td>

Depending on the number of columns, the “Table Data” must be inserted
<carries;
<td>Text 1</td>
<td>Text 2</td>
<td>Text 3</td>
<td>Text 4</td>
</tr>

+ Do you know?

+

Realtor WordPress Themes: Marketing house and apartment – Recommendation

Anyone who wants to sell his house for a profit needs good properties, but also an Internet site. After I already had a big article last week about selling real estate (advertisements, Photoshop, WordPress and search engine optimization), I wanted to present today good WordPress themes for real estate agents and companies who want to start a platform for real estate search. Thanks to WordPress Themes a lot has changed. In the past you had to build each page individually and of course you had to link to it. Today a content management system does it all. The most popular CMS in the world is WordPress. Millions of pages were built with it and many more will follow. Also a lot of real estate agents and of course online marketing or advertising agencies use WordPress and modern WordPress themes.

+ Do you know?

+

Adverts and presentation with WordPress

WordPress Themes are ready-made internet pages that can be edited and individualized by settings. Important is, if you have never worked with a content management system or WordPress system, you should not start directly with a real estate portal. The functionalities are relatively complex and elaborate. Accordingly, you should have sufficient previous experience. But enough small talk, let’s take a look at the main features of a real estate feed. At the end I have my toplist and recommendation for real estate WordPress themes.

Translation into languages

For many users, it is first of all important that the topic is also translated into several languages. Not everyone is proficient in English and with technical terms, especially in the real estate sector, it can quickly take a lot of time to constantly translate individual words. Therefore, when choosing a theme, you should already make sure that the theme already contains a translation or a translation if you don’t feel so confident with the English language.

Very few themes are translated, usually you have to create this translation yourself. My tip, for all those who are looking for a translation, create an extra language file in your plugin folder, you can edit it with a program like PoEdit.

Pre Made Homepage – Pre made website

The layout of a website, which has different elements and formatting and design can take a lot of time. Therefore, many of the WordPress templates offer directly finished pages as layout. You can easily put these on your own page as a demo with a one click installation. Already you have a nicely designed start page or even a clearly arranged page with all team members.

The pages are usually built with Page Builder.

One Click Importer – insert demo example for learning

For all those who have not yet built 20, 50 or 100 WordPress pages, this demo content is really worth a lot! Here you can see how the author of the team, its structure, the elements and the embedding work. You can also have a look at the extra menu items, for example the new real estate advertisements. Here you can directly see by several examples how the information is structured and where which data is entered or how a finished real estate advertisement would look like on your site.

Real estate management software or plugin

The core of every WordPress installation are the various extensions that extend the content management system with blog function to an online shop, a real estate portal or even a social media platform. Would you have thought that this is possible with WordPress? Exactly that, makes it the most popular CMS in the world! Let’s have a look at which plugin functions are essential for you as a realtor.

Front-End – Property Management

If you like to work directly from the website and don’t want to deal with a purely informative back-end, you should make sure that the topic also has a front-end editing function for the properties. This means that all advertisements can be edited directly on the website with a simple push of a button. This means that you don’t have to switch to the back end first, but can, so to speak, view the results directly live.

Front-End – Submission of new properties

For brokers, the front-end or back-end editing function as administrator of the site is sufficient. However, if you want to build your real estate site into a large real estate portal, you must also give other brokers the opportunity to place their advertisements. For this purpose, there is a user management with which new agents can register. These are accepted and activated automatically or manually. They get the possibility to place their own real estate advertisements, to edit them or to delete them. So you can invite different realtors to present their houses, apartments or plots of land on your platform.

Integrated live news system (communication)

If you think modern, you should also have a functioning messaging system. Do you know websites where you have a small chat window or speech bubble at the bottom left or right? This is exactly the point. Users and visitors can contact our team and our brokers directly. Without detours and without telephone calls, simply via the browser.

Your employees can start communicating immediately or process the request a little later. Likewise, you can create ready-made message modules in this messaging system, e.g. on standard questions. But let’s get back to the basic question, which property much is best for WordPress?

E-Mail notification and saved search

Notifications and saved searches for already registered users are an important tool to get you back on their site. Returning users are very important, not only for search engine optimization, but also for your sales. The more often you can reactivate users, the more traffic you will have on your website and the more sales you will be able to generate. With extensions that allow you to receive e-mail notifications, e.g. when new ads for a certain area in Berlin or even when a property has been taken off the market, you are even more interactive and interesting as a platform. You should also enable your users to save searches, so that useful e-mail notification functions can be directly linked to them. Most real estate themes already have such user management on board.

+ Do you know?

+

Login and real estate comparisons

The purchase of a property is a major investment. But renting an apartment and paying the rent deposit is also a lot of money for most citizens. Therefore it is worthwhile to offer a comparison function as a real estate portal but also as an individual broker. With this function, your users can easily save individual property listings and compare them later. Just like you know it from online shops like Amazon, where you can compare several products with each other.

Payment system for brokers (external)

Directly integrated payment systems make it possible that if you build a portal with several brokers, amounts for real estate advertisements can be collected directly. With different payment providers, from credit card to Paypal and of course the classic bank transfer. Through the integrated payment system, you can save a lot of effort in the invoicing, as well as the administration of customers.

Important functions: Search and localization

In addition to these features, there are of course many other ways to make users a comfortable visit to their properties clean. These include, for example, the auto-complete function in the search field.

Autocomplete in the search field

If you are looking for something, just like with search engines, you need auto-completion. Then you enter e.g. a spelling mistake, if in theory no search result would be available. If you give a suitable suggestion for the search query in advance, we can avoid many mistakes and thus minimize the previously mentioned jump rate.

Search by radius (km) and geolocation

It is particularly important to consider regional aspects when searching for apartments and condominiums, for purchase or rent. Regional aspects are especially important when it comes to investing in a property in which you want to live longer. In order to display only those offers that are relevant, the search should also include a slider for the number of kilometres. This allows you to directly select an urban area and filter only objects in the vicinity. This makes the search process much easier for our users.

Advanced search: construction type, property, etc.

Of course, almost all themes have integrated the additional information, so that I can leave a user in the search directly, whether he wants to see only advertisements with a balcony or with a fitted kitchen. You can set all these filters and parameters in your back-end, depending on the properties of a single property.

Performance: Pagespeed & Search engine optimization

Last but not least you should always think about the performance of your own website. The better and more structured the site is, the faster it loads, the higher it will be ranked in the search engines. In Germany, the search engine Google is most important, followed by Telekom, Yahoo or other platforms. Therefore, pay a little attention to the performance of your potential new website.

SEO and search engine – optimization of the real estate page

The term SEO comes from Search Engine Optimization. Search Engine Optimization is English and means search engine optimization. But why is search engine optimization so important?

Search engine optimization constantly brings new leads, i.e. customers who, for example, buy a product or subscribe to a certain list or newsletter. The more visitors we have on a website, the higher the chance that we will make good deals. Search engine optimization costs in relation to permanent advertising, only a one-time investment. Advertising that is optimized for clicks costs with every single click or sometimes also with every impression. That is why many companies put their money on search engine optimization. You should do the same with your new real estate project!

Pagespeed – loading time of the Internet page

The last important point before we come to the concrete recommendations is the page speed. Pagespeed is the English term for the loading time of an Internet page. The shorter the loading time, especially in relation to the competition and also with application, the better it is for your website and the more positive it is for the search engine ranking. With Pagespeed you can achieve this by optimizing scripts such as HTML, Java but also CSS, as well as by compressing image files.

WordPress Theme recommendation

After you have learned a lot about search engine optimization but also about advertising real estate on WordPress, I would like to recommend some real estate WordPress themes! You can easily buy themes for a very fair price on the biggest platform in the world. With a few clicks you have installed the themes. Have fun and good luck!

Theme 1 – MyHome by TangibleDesign

Rating of MyHome on Themeforest:

  • $59 – price
  • 5 stars (168 ratings)
  • 2,400 Sales
  • WordPress Theme – Download

Theme 2 – Houzez by favethemes

Current rating from Houzez on Themeforest:

  • $59 – price
  • 5 stars (828 ratings)
  • 11,900 Sales
  • WordPress Theme – Download

Theme 3 – Reality by inwavethemesThemes

The reviews of Residence Properties WordPress Theme on Themeforest:

  • $49 – price
  • 5 stars (62 ratings)
  • 781 Sales
  • WordPress Theme – Download

Theme 4 – Residence by WpEstate

Residence reviews on Themeforest:

  • $59 – price
  • 5 stars (1,000+ ratings)
  • 13,100 Sales
  • WordPress Theme – Download

Theme 5 – Realtyspace by codefactory47

The ratings from Realtyspace:

  • $59 – price
  • 5 stars (202 ratings)
  • 3,110 Sales
  • WordPress Theme – Download

Theme 6 – Findeo by purethemes

Current rating from Findeo on Themeforest:

  • $59 – price
  • 5 stars (80 ratings)
  • 870 sales
  • WordPress Theme – Download

Theme 7 – Benaa by G5Themes

Rating of Benaa Real Estate WordPress Theme for brokers on Themeforest:

  • $60 – price
  • 5 stars (20 ratings)
  • 441 Sales
  • WordPress Theme – Download

Theme 8 – casaRoyal by Fantasy

Opinions and reviews on casaRoyal:

Theme 9 – Hometown by LeafThemes

Hometown reviews on Themeforest:

  • $59 – price
  • 4.5 stars (111 ratings)
  • 1,600 Sales
  • WordPress Theme – Download

Theme 10 – Real Estate 7 by contempoinc

Current valuations of Real Estate 7 on Themeforest:

  • $59 – price
  • 5 stars (506 ratings)
  • 6,400 Sales
  • WordPress Theme – Download

Real estate: Helpful links

[shortcode variables slug=”adsense”]

2 hours Influencer Marketing: Free Video Course – Keys of Cooperation

New! Fresh! And 100% free! My new video tutorial about Influencer Marketing. With our new tool Social Analytics we make Influencer Marketing possible for every agency, every company, every online shop and every startup! To make sure everyone knows exactly how to do it and where the important adjustments are, I spent one week, every evening in the studio and recorded this two-hour video course with all the important facts about basics, definition, KPIs, campaign, planning, analysis, monitoring and much more.

+ Do you know?

+

Free online course! Influencer Marketing Basics

Here is an overview of the different topics and focuses of the two-hour tutorial.

Introduction to Influencer Marketing

Definition

Development of social networks / social value

Social Network Ranking, Values of the networks

Classification and categories

Advantages Influencer Marketing

Risks

Software support in social media marketing on Instagram

Hootsuite / Screencast

Social Analytics / Screencast

Instazood / Screencast

Planning and implementation of an Influencer concept

Definition of the objectives

Applications / SA Hashtag Analyser

Qualitative and quantitative attributes of the influencer

Influencer Search / SA Research / SA Manager

Briefing for the Influencer

Contact

Contract

Processing

Offers for agencies / SA campaign planner

Monitoring / SA Monitoring

Conclusion

Introductionstrong> into influencer marketing

Definition: Influencer Marketing

Influence

Especially young people

Recommendation, Evaluation Opinion

High credibility

influence

92% trust recommendations from people
(even if they don’t know her)
also PR:

95% of editors use search engines for their research

development of social networks / social value

Forums and pioneers like Ebay

First communities ( Myspace) and data transfers (Napster)

The Web 2.0: Permanent networking
Social networks have revolutionized the entire world

Bloggers and opinion leaders

Social Commerce: Referral purchases

Social Network Ranking, Values of the networks

Facebook: The giant for paid advertising

31 million users
19 million now active day

Overlay of news, groups, pages

Viral groups as an alternative

Advertising as a must
Even advertising slowly played out, overlay

youtube: Organic traffic with value

4 – 8 million frequently / regularly depending on survey

Long-term placement / calls

high involvement

SEO aspect

Instagram: Trends in seconds

15 million users active every month

People under 15 years over 30 min daily

Daily entertainment

Favourably compare Youtube / FB Ads

Classification and categorization of bloggers

Relevance

5-10k are micro

10-100k

100k+ can become idols

1M+ Stars

are the most popular:

Top Germany (Football, Youtuber, Lisa and Lena)

Normal influencers (fashion, lifestyle, sports)

categories:

Fashion, biggest topic

Music

Food

Travel

Fitness

Beauty

Accessories

Animals, Pets

+ Do you know?

+

w3> advantages Influencer Marketing

advantages in marketing

Desired target group
No Adblock
No control
Exact target group (data influencers)

Influencer marketing is credible
Bridging the distance to the consumer

High ranges
Pamela Reif 3.3 million
Vogue 200K, < 10%
Paola Maria 5.4 million

Promising
In 2017, 50% of 14-19 year olds bought a product by recommendation of an influencer

Purchase decision by age group

50% – 14-19 years

33% – 20-29 years

24% – 30-39 years

10% – 40-49 years

7% – 50-59 years or 3% 60 years +

Risks that arise

Offensive advertising does not work
Solution: product placement or storytelling

Vertigo with reach
Solution: Engagement / Interaction as hard currency

Software support Basics

hotsuite / screencast

Forward planning of content for different networks

Streams facilitate access to posts, scheduled posts, fans, interactions, etc.

Create social networks in seconds

Social Analytics / Screencast

Influencer Research (search by country, city, etc.) and the Influencer Report (profile and analysis)

Influencer List for management, grouping and always up-to-date data

Campaign Manager for fast processing of requests and offers (with forecasts)

Posting monitoring for success analysis and evaluation of campaigns and influencers

Hashtag Analyser examines millions of postings and shows you the most successful influencers and postings for a hashtag

Toplist Creator for trend content and search engine optimization as an extra for our customers!

Instazood / Screencast

Everyone talks about bots: What are bots?

How does a social bot work?

+ Do you know?

+

Influencer concept: How do I create an advertising campaign with bloggers?>/h2>

Definition of objectives as a first step

Strategy at a glance

Definition of the target group / customer needs

Identification of topics, keywords and channels

Identification of the influencers

Goals and KPIs

Influencer analysis

Procedure of a campaign and important questions

What do you want to achieve with your campaign or influencers?

What should the influencers do for your brand?

What does the individual influencer get out of it / in return?

Who should contact the influencers, when and how?

Calculate range (impressions)

Calculate Impressions
Impressions of a posting = number of followers / 1.52
Impressions of a story = number of followers / 27.46

Assessing costs and success by means of ROI (Return of Invest)

ROI = Turnover achieved / investment for sponsored post
2.5 = 250 Turnover / 100 Invest

Heavy on Instagram, only one link

Tracking through codes

possibilities of the bloggers in the campaign

effect and emotionalisation

Reach and attention

Increase of brand awareness

Emotionalization

Interaction

forms of advertising from product presentation to unboxing

Product presentations

Product recommendations

Unboxing

Hashtag setting

Products (clothing) “wear

Direct sales (affiliate marketing)

Competition analysis and creativity process

Channels on IG

or Hashtag Analyser

Qualitative and quantitative attributes of the influencer

Qualitative characteristics of bloggers

Features from “Identification of influencers

Sex, age, look, interests, amount of influencers, min / max Follower

Its target group is A&O

Quantitative characteristics of bloggers

number of followers

Number of comments

Number of Likes and Shares

Focus: engagement and interactions
Engagement Rate = Number of followers / ( Likes + Comments * 2 )

Interactinosrates as a sign of quality and value

Up to 50,000 fans from 8-20% (top 25, 30%; average 8-12%)

50.000 – 100.000 fans from 6-14%

100.000 – 500.000 fans from 5-11%

500.000 – 1.000.000 fans from 4-9%

1,000,000 – 5,000,000 fans from 2 -6

5,000,000 – 10,000,000 fans from 1-4

fluencer search

Find influencers with the research tool from Social Analytics

Cities, countries, categories: Everything in one overview

Influencer Management and Groups

briefing for the influencer before contact

contact details
Company, contact person, e-mail, telephone

Campaign data
Customer, content

Tasks of the Influencer (Digital)
Postings, stories, videos, attendance

Tasks of the Influencer (Offline)
preparation, training, store visits

Frequency
One-time, regular, duration / deletion?

Media usage
Countries, language regions, duration

Contents of the postings
Representation of the mark, marking, mention

Use
influencer, client, PR / press, third party

contact: here we go!

General behaviour and guidelines

Via e-mail, short and sweet

Do not put pressure

take criticism seriously

personal dialog

Include content and ideas

Show interest in contributions

Link, comment on blogger posts

offer added value: exclusivity

exclusive offerings

unpublished information

for profiling in your own community

contract and framework agreement>/h3>
Basis: Briefing of the influencer

processing from booking to payment

Influencer posts photos / videos

Influencer stores media (posts, stories, etc.)

Send media data (monitoring)

Payment

offers for agencies in seconds

Campaign planning and prediction of reach, likes, comments

Price calculation of postings and stories

Monitoring to measure success

Influencer grouping for monitoring

Parameter input (mention, marker in image and hashtags)
/h2>
Desired target group

Influencer marketing is credible

High ranges

Promising
In 2017, 50% of 14-19 year olds bought a product by recommendation of an influencer

Social Analytics supports the entire process

+ Do you know?

+

Import file list into Excel + Word – Export file names: How to do it

Today I needed again a file list in Excel. Importing and exporting takes a long time when you do it manually. You can easily import the file names into Excel and Word. Listing file names and reading them from folders is very important for many – for example – content marketing applications and saves a lot of time. Here is the answer.

More powerful tips for Content Creation & Marketing?

[shortcode variables slug=”adsense”]

Export list from file name or import to Excel

To put many files in a folder in a list (file names), you need to do the following. First, open command to merge the texts, as before. You can do this again with Ctrl+Shift clicks, then right click in the empty area inside the folder. Then open “Command Prompt”. Now enter the following:

dir *.jpg /w

The value *.jpg>/strong> stands for your desired file format (probably image files). /w outputs the file name.

You will now get all file names in the command window one below the other. You can copy and paste them with Ctrl+C. If you want a text file directly, enter the following:

dir *.jpg /w > images.txt

The value > images.txt outputs a text file.

Instructions: Export file names to list

To open your command prompt (Ctrl+Shirt+Right click):

All file names of the folder will appear in an overview:

Or get the names output directly to a text file:

If you have exported a text file, your result will look like this:

SEO content spinning

This feature is often required for text correction (before export) in content spinning for industries such as real estate or insurance. You want to learn more about mass text creation? Then read my tutorial on the topic: SEO Content Spinning.

[shortcode variables slug=”adsense”]

Photoshop batch processing: size, image SEO & compression of photos automatically

Today we take a closer look at the Photoshop batch processing in the video tutorial. Batch processing is always needed if you have a process in Photoshop that needs to be performed frequently. A very classic example, which is also shown in the video tutorial, is trade show photography. Whether at a trade show, at an event, for employee photoshoots or product images, often you have 10, 20 or even 50, 100 or 500 photos available. With all pictures the same process has to be done, usually it is a reduction in size, so the photo can be used for web and mobile devices but also for file compression. In batch processing, the most important thing is to have a process that is exactly the same. So let’s look at our example:

+ Do you know?

+

Automatic image editing in Photoshop: Video Tutorial

The principle is relatively simple: We instruct Photoshop to record an action, save it and reproduce it later. At the end of the video there is a special tip for fast image SEO (search engine optimization).

Open action window to create new batch processes

To open the action window, go to the “Window” menu item in the main menu, there you will find “Actions”. The window will then open in Photoshop, just like you already have layers or characters from the default settings on your screen. The action window is built up in the same way as the layers. You have different groups, here called “set”, that “layer symbol” provides a new “action”. So we can create a new sentence, e.g. for a certain customer or a project, in this sentence we then store different automations.

We open a new sentence, call it customer XY and then start a new action, we call it e.g. “Compress > JPG > w1080”.

In the next step, everything must be in place. To save changes, you should think carefully about the process in advance of automation. For simple animations this is still relatively easy but as I described in my article about the production of jewelry product images for online shops through automation, such automation can become very complex and also require the rewriting of certain Photoshop scripts, e.g. to name images according to article numbers in dependencies of databases. But let’s come back to our simple example!

Howto: Now we start with the action

We create our sentence and start our action. With a click on the “layer symbol”, we start. First a small new window appears in which you have to enter the name of the action. I always recommend a title here, which indicates exactly what happens during the action (as above).

“Compress > JPG > w1080” stands for

  • compression
  • Save as JPG
  • With a width of 1080 pixels

Start action: open photo, resize and save

From now on you should work exactly, we open the first picture in Photoshop. Next, we change the image size, either through the main menu “Image”, “Change Image Size” or through the shortcut Ctrl + Alt + I. The image size is now fixed, e.g. to 1080 pixels in width. Thus our picture is sharp on desktop as well as on tablet and mobile and in addition relatively small.

Next we save the image compressed “For Web and Devices”, here again the reminder for my tutorial for Photoshop image compression. Now we define a folder in which all images from this action are saved each time. Also in the future! For this I have e.g. always an export folder, in which everything comes in again, then I always know where each action goes. All export images of the action and others usually run into one folder. We now go to Save, we set the quality to 40%, and JPG. This way, our images are usually compressed to 5 to 10% of their original size and are therefore much more relevant for search engine optimization than others. For example, if we have an image collection on a homepage, our site will load 10 to 20 times faster than competing sites. A clear market advantage in search engine positioning. Now the image is closed either via “File” and “Close” in the main menu or via the shortcut Ctrl + W. Our image is now not saved. Afterwards we end the action on the “Stop Button” in our action bar.

The batch processing or the action is now saved.

We now delete the one test image from our folder and can start with our automation!

+ Do you know?

+

Done! Now we come to the automatic processing of the photos

To start the automation, we go to the main menu and select “File,” “Automate,” “Batch”. There we now select our respective sentence and the action. Our new action should already be selected automatically. In the next step, we select only our source folder, where do the files come from? In our example, the folder where we have all our press photos, trade fair photos or other. If we now press Okay, all the photos will be processed one by one, completely automatically and saved in the folder.

Extreme time saving with Photoshop!

The batch processing and automation in Photoshop masters, saves extremely much time. From my own experience, I can report that it allows you to beat whole teams at project assignments. As in my article on Photoshop automation for jewelry online images, you can create tens of thousands of files that look ultra realistic, whether they are bronze, silver, or gold. But even the basics are enough, like this batch processing in image size and compression, with 100 images it easily saves an entire working day for an employee. All this with a time investment of 10 minutes. Have fun trying, learning and improving!

Extra tips for batch processing: Watermarks and different formats

  1. Tip! This tutorial also works with watermarks or logos that should be displayed in videos. Just grab a photo, change the image size and insert the logo.  The rest of the process is completely the same. When you start the automation, every single photo gets not only the image resizing but also the logo in the place where you intended it to be placed.
  2. Tip! Make sure to separate portrait and landscape images when placing a logo, for example. Because Photoshop needs the same basics, e.g. if the format of the image changes, as well as in portrait and landscape format, the logos will be placed wrongly, if they are e.g. at the edge. Here you have to make sure that the logo can be used together with both portrait and landscape images.

image SEO after batch processing

At the end of the video there is a special tip for quick picture SEO! After Google has changed its guidelines and images, after the image search, again provide a direct link to your own website, search engine optimization for images and photos plays a more important role again.

+ Do you know?

+

SEO Content Spinning: Online Tools and Content Spinner Alternative – That’s how it works!

In our advertising agency, we naturally deal a lot with the topic of search engine optimization. Content spinning is on your topic, about which we are asked questions. Here it is about security in content spinning but also about the effectiveness in search engine placement. Nowadays search engine placement is the be-all and end-all when it comes to online marketing. Just as there are streets in the city centre where there is more traffic, there are also search terms on the Internet where there is more traffic – i.e. search queries (keywords) that are queried more frequently.

[shortcode variables slug=”adsense”]

These keywords are of course extremely different, depending on their diversity but also depending on the use of geographical or demographic data. Content spinning or content spinner allow for a diverse text creation – out of one, hundreds, thousands of texts are created.

The more you can serve different individual needs of the target group or readers, the longer visitors stay on your website or online shop and the better pages are placed in search engines. The more precise and focused the texts or the larger and more extensive they are, the more successful they will be in search engine rankings. A lot of work lies ahead of us!

Content spinning – what does content spinning software actually do?

Many people hear about content spinning from other people and entrepreneurs and, when they hear about the successes, they immediately think of their own company. Can I get more traffic through content spinning?

Thousands of sites, for every state, city and district. Yes, some spinning on street names. That’s not just thousands of records, but tens of thousands. Thousands of texts would be difficult to produce in your own company, hundreds alone. Why?

Qualitative texts for unique page contents = long retention time of visitors

Employees who are not extremely trained in the texting of search engine content, need for the creation of a relevant search engine text with a minimum length of 1200 words per article easily 3 hours, if the research is intensive – which it usually is, topic: quality.

Depending on the subject area, real estate, sports results, doctors, food, fashion or trend products, the qualitative demand in the texts and of course the amount of text varies.

So if your employee only manages two or three texts a day and you need at least – at least – 500 such individual pages even for a large website or a large online shop, you can quickly see how long such a content marketing project can take.

Content production for online marketing is very time-consuming

Whether with the help of an advertising agency like ours or content marketing in your own company, the creation of content, especially search engine texts is very complex and costly without experts. Even with experts the expenses for a new project are high. Some advertising agencies but also companies therefore resort to experts in content spinning.

Which companies and businesses use content spinning?

Classical industries for the use of mass text production are online shops, the real estate and housing market, travel companies but also private universities and insurance companies (generally often in the context of affiliate marketing). Many generate texts that cover the needs of the target group as well as possible and increase the time spent on their own site.

However, until enough visitors come to the pages, search engine optimization and thus the creation of texts by the own employees is needed. Let’s calculate how long it would take an employee to write a page that is relevant for search engines.

  • 1 employee can produce 3 texts a day with good quality, with practice, rather 2 with extensive research
  • 1 employee works 5 days a week, minus holidays, sick days and public holidays, but only 3-4 days a week on average
  • 500 texts need a whole year

If 500 texts are to be created, a single employee would therefore need 40 weeks – minimum if no other work is involved. For many industries and countries, 500 texts are only the beginning. If you want to build a really large site, you should go for 1,000 texts or 1,500 texts with a respective minimum number of words (1,200). In addition, there are external media, YouTube embeddings or embeddings from other social networks such as Instagram, Facebook, Twitter or Pinterest. In addition, HTML, CSS and other elements such as tables ( <table> )and headings ( <h1>, <h2>, etc. ) are also included.

Content Spinner: syntax, articles and variations

Content spinning is mainly about the variation of basic texts. This involves taking individual phrases, even individual words, and creating several variables from them. Variable by variable, the construct becomes more complex, even though the individual steps are relatively simple and can be understood by everyone. Here is an example from the SEO Content Spinner:

{{{Beauty and elegance|Elegant and beautiful}|Big and representative|Modern and ecological} house

Spinning is therefore concerned with generating many, single, different possibilities from a single text. A big sticking point: grammar. Here is an example sentence, do you recognize the grammar of each sentence? Important: Don’t get discouraged, the explanation goes on!

{House with {modern design and ecological structure|ecological structure and modern design}|{{Beautiful and elegant|Elegant and beautiful}|Big and representative|modern and ecological} house}

By increasing the different variations, as in the example here, the text becomes more and more multi-faceted and with each export also more individual. The more unique a text is, the better it is placed by search engines – keyword: Uniquness of texts. Let’s go one step deeper into the matter:

Spinning words, sentences and paragraphs

The deeper you go into the project, the more extensive the associated spinning project files become. A good spinning project quickly reaches a size of 40 or 50 A4 pages in font size 9. To get an overview here, because the texts are coded as seen before, is a real challenge for everyone who is concerned with the topic of symmatics and grammar in spinning. From the different text parts and sentence elements larger paragraphs are then formed, these form larger sense sections and are placed so that the most important information is always at the top of the page.

+ Do you know?

+

Onpage in search engine optimization

Various studies and also analyses from the major search engine providers such as Google show that very few people deal with the further information when visiting a website or online shop. What does this mean for our Spinning Text? As soon as someone visits a website of a company or an online shop on his notebook, for example, he ends up on the start page or on another single page. This single page usually offers the most important information at first glance. This means that you are not at the end of the page, but directly at the beginning. Many users break off at the very first second, at least in the process of scrolling: Some leave the page again immediately because they cannot find the desired information at first glance, others use the main menu to navigate further and others go straight to the start page. There are many possibilities that lead to a – in our ideal case – abort.

Therefore all relevant information of such a content spinning project must always be available directly at the top of the page. Think also of mobile devices, which now account for a large part of the reach and visitors for many online shops and sites. They have no sidebar, no large display. Everything important must be right at the beginning of the website (unless it is unintentional for strategic reasons).

So in Spinning Text some paragraphs are swapped with each other and others get a fixed position. So only certain paragraphs are swapped with each other. A tip: For weaker traffic pages, with less visitors, you can also swap these places once in a while to keep the general uniqueness of the texts.

How can you strengthen the content (pages) for more visitors?

Content spinning of course does not only deal with text variations, but also with possibilities to integrate external media content. That means to display videos or other media content on individual pages and on others not – variation. For example, one video is embedded on 17% of our pages, another only on 3% of the total pages.

Although each individual text is about a specific industry (real estate, insurance, fashion, etc.), the texts also alternate with videos, photos and links. So we have many possible single pages that change in their text content, length, grammar, manner but also in the media content displayed.

If you have understood the basics in content spinning, you can use tables in the next step. As you can read in the article of SEO Content Spinning, different data can be integrated into the exported texts through a table. This could be, for example, geographical data about the most important capitals or larger cities with 50,000 inhabitants or more. The data can be even more precise, e.g. on streets or certain places and locations. Voila: We have tens of thousands of records.

Tables in the Content Spinner: CSV for geographic and demographic data

A single table consists of columns and rows. For content spinning it is important to have all the information within a single existing database. This database is later exported as a CSV file. This serves as the data basis for the individual pages (e.g. population data of Chicago, Las Vegas, Dallas, etc.), which are then loaded into the spinner software during export. If you now open a variable of the table (first row) in the text with two square brackets and close it with two more, the first row of the table containing the variable is accessed and its data set is dragged. Here is an example, our table contains 3 columns. These are called (first line):

  1. Stat>/li>
  2. inhabitant
  3. square kilometers

In my example set I now use these variables. Here I could write e.g.

  • For every square kilometre in [[city]] there are [[inhabitants]], despite an area of [[square kilometres]].

This text can then be multiplied by variables, the Content Spinner snaps a new line with every text export. The next sentence would then read, for example

  • With 412 inhabitants per square kilometre, more inhabitants live in district XY of city XY than in the rest of the conurbation.
  • A total of 112 people live in district XY2 of city XY2, making it a very quiet area.

“If” functions for evaluation of data in the table

Within tables, certain values can be calculated using “if” functions.

An example: If the average number of inhabitants per square kilometer is below the average of the city, then we can call the district a quiet area. If the average number of inhabitants per square kilometre is above the average of the city, then we know that it is a more crowded district, because there is less green or possibilities for leisure, e.g. for families. How exactly such data is calculated and which statistics and studies are used as a basis can be found in the further explanation of the SEO Content Spinner.

Content Spinning Software, recommendation and experience

Of course, any renowned online marketing expert, nerd or developer who is more often in contact with the subject of search engines will sooner or later try to create masses of text. I have used other software so far. After some practice and a few example projects, a little practice means a few months of training, but in spinning software you reach your limits.

The various offline software tools currently available on the market have all the basic skills but do not have the capabilities that will be needed in 2018 and in the following years 2019 and 2020. For this reason we decided at the beginning of this year to develop our own software, web-based, 128x faster in export and theoretically without database limitations. Let’s have a look at a few examples where you come up against limits in other programs (offline and online).

Database limitation

Spinners usually only create about 40 columns during processing. With larger amounts of data, which are regenerated from studies or statistics, you will reach unnecessary limits. The age structure of a certain city alone, staggered in a 5-year rhythm (0-5 years, 6-10 years, 11-15 years, etc.), already takes up 10 columns of text spinning. This leaves you only 30 more columns.

Error message and wasted time without syntax error

Even without syntax errors, i.e. without brackets set incorrectly, there are often error messages and the text cannot be processed further. Especially if you have already worked for more than 15 or 20 minutes, it is very annoying if an error message is displayed without an actually existing syntax error.

Set rotation and paragraph rotation do not work perfectly

Twisting single sentences with each other or single paragraphs are no problem in the professional software. When combining and linking these possibilities (randoms = random sentences and randomp = random paragraph), however, errors are immediately played out. It should make no difference if, for example, spun sentences are within spun paragraphs.

Publication in WordPress only with corrections

WordPress is the most popular content management system today, in which not only many advertising agencies and Internet agencies work, but also many companies and businesses. However, there are occasional complications when linking and some details are not perfectly adjustable, e.g. the keywords or the categories. In addition, it is not possible to plan the days of the week in the publication, so that one publishes constantly, i.e. does not have a normal weekly rhythm. A circumstance that could of course (in case of extremely mass output) indicate that the texts are not organic, i.e. not created by humans.

Calculation time for the text export

If you create spinning texts on a high level, the calculation times for your texts will be intensive and long. For a complex spinning project the export of a single text easily takes three or four minutes. On web-based systems, the servers calculate a single text within two seconds.

Offline software limits flexible access

If you want to continue working on texts on the road, it is not possible, because most software products are equipped with a special key that only runs on a computer. In today’s world, between cloud computers and constant networking, the presence of software on only one device is of course very disadvantageous. Especially for internet agencies and managers who are often on the road.

Therefore it was important to create a web-based, flexible and powerful solution for a content spinner (link below and at the beginning of the article).

+ Do you know?

+

Export to WordPress and Content Management

If you are still working with a classic offline content spinner, you often have to make an error check at the end of the export. To do this, you export all texts into individual files and then merge the text files. How to do this with a few clicks, I describe here in the tutorials, in the article: join text files.

Also new is our short explanation for filenames: Import file list into Excel.

Web based content spinner, the best software

For those who want to do content spinning on a first-class and high level, we now have the perfect alternative for the common content spinner and many other products. With almost unlimited database processing, fast servers that revolutionize text export in terms of time, constant retrieval from anywhere in the world and, of course, from any device! This makes the SEO Content Spinner the software solution. The full software package is not free of charge but the investment is worth it. Smart features and smooth processes within the software take content spinning to an absolutely new level.

  • Release: SEO Content Spinner November 2018
  • Extremely limited access for experts and agencies
  • li>First info and How To: SEO Content Spinner

[shortcode variables slug=”adsense”]