RankMath Data Import and Export

CSV-Importer-Logo

 

Rank Math is a free plugin that covers most of the features provided in the Yoast SEO premium version. To write high-quality content for a website then Rank Math is the best choice of SEO plugin. Rank Math plugin scans your content, and retrieves data from Search Console and Analytics to form performance reports. Rank math has a number of modules and features when compared to other SEO plugins. We can easily customize the important settings in SEO, which helps to get a good ranking for the custom posts and pages of our website to display in google results. With the help of the Rank Math SEO plugin, we can easily track and identify the low-ranking post, pages, and content on our website.

Supported Modules

Posts Pages Custom Posts Event
Recurring Events Location WooCommerce MarketPress
Wp eCommerce eShop Taxonomies Categories
Tags WooCommerce Tags
WooCommerce Attributes
 

Rank Math Setup

First, we need to download and install the Rank Math plugin in WordPress.  Then activate the plugin to set up. Rank Math Setup Wizard Step 1 – Select any one of the modes (Easy/Advanced/Custom) to Start Wizard Step 2 – Import data from Yoast SEO (optional) Step 3 – Your Website: Fill required fields with our website information Step 4 – Analytics: Connect with your Google account or Skip this one. Step 5 – Sitemap: Setup indexes for post /page. Step 6 – Optimization: Setup SEO tweaks. Step 7 – Continue by clicking on Ready. Step 8 – We are directed to Advanced Settings. Enable Role Manager and other options. Step 9 – Enable redirection. Step 10 – Schema Markup: It is enabled by default. Step 11 – Finally, Click on ‘Save and Continue. Rankmath How to create CSV files for Rank Math? WP core Fields The post title is a mandatory field in WP core fields. We can also provide Post Content, Postdate, Post Author, etc.

Rank Math SEO Pro Fields

Focus Keyword We can get a ranking for post/page by adding a focus keyword in SEO. By default, Rank Math allows adding 5 keywords per post. Rank math Focus Keyword Pillar Content Pillar content is a unique Rank Math feature. This helps to attract extra SEO recommendations. If you want to enable this option in WordPress, mention the value as “on” in the CSV file. Rank Math robots Meta In this section, we have custom Meta like Index, No Index, Nofollow, No Archive, No Image Index, and No Snippet. For this option, first, we have to enable post robots meta. index: This is a default one. Instruct the search engine to include the page in the index. noindex: Instruct the search engine to not include the page in the index. nofollow: Instruct the search engine to not follow any links on the page. noarchive: Not allowing a cached copy of this page on search results. noimageindex: Instruct to not allow any images on a page. nosnippet: not allowing snippet (Meta description) on the search result of the page. If you want to enable this option, mention the value as 1 is a CSV file. Advanced Robots Meta This helps us to determine our content in search results. Here we have three options to configure. Snippet – We can set the maximum length in text characters for a page. The default value is “-1”. Video Preview – Set the maximum duration (in seconds) for a preview. The default value is “-1”. Image Preview – We have three choices to set the image preview on the page. “Large, Standard, and None”. We have to mention these values with a comma separator in the CSV file. (Eg: -1,-1,large) Canonical URL This option helps to direct to the main page if we have duplicate content. Redirect This option is disabled by default. This option helps us in various ways like updating the URL, moving the website to a new domain, creating temporary redirect URLs, and redirecting to a new URL from the old one. There are two things we need to mention in our CSV file while setting up the Rank Math Redirect Option.

  1. Redirection Type

Select any one of the following types based on our use.

  • 301 for Permanent Move
  • 302 for Temporary Move
  • 307 for temporary Redirect
  • 410 for Content Deleted
  • 451 for Content unavailable for Legal Reasons
  1. Destination URL

Mention the URL where we want to redirect our visitors. Schema We can select any one of the options from more schema types.  Headline – Set an SEO headline for a page/post Description – Set a default description for a page/post. Article Type – Prefer any one of the article types from these three (Article/ Blog Post/ News Article) Speakable Schema – This option lets our article be speech-friendly. When enabling this option, have to fill the cssSelector field by providing any particular content value in the CSV file. General Title Give the SEO title of the post in the rank_math_title field. Permalink In this field mention the permanent link of a post/page in the CSV file under wp_old_slug. In this, the first part is the domain name and the second one is a slug. General description field   Provide any text characters as a description of a post in Rank Math. Social media in Rank Math This option helps to notify the followers about new posts/pages. We can also control how our content is displayed. Facebook – We can give a specific “Facebook Title”, “Facebook Description” and “Facebook Image”. We also leave this blank, by default it will assign the post title, description, and image. Also, add an icon overlay to the thumbnail, here we have two options: “Play Icon” & “GIF Icon”. Twitter – By default, it will copy the relevant data from Facebook. We can disable this option and can give a specific “Twitter Title”, “Twitter Description” and “Twitter Image”. Also, add an icon overlay to the thumbnail, here we have two options: “Play Icon” & “GIF Icon”. Specify any Card Type from “Summary Card with Large Image”, “Summary Card”, “App Card”, and “Player Card”.

Rank Math Pro Fields Description & CSV Values CSV Sample Value
Focus Keyword Add Possible keywords to ranked Search engines, SEO
This Post is Pillar Content To link related articles/posts. To enable mention – On On
Robots Meta Index To include the page in the index To enable mention – 1. Otherwise, leave empty 1
Robots Meta Nofollow Do not follow any links on the page. To enable mention – 1. Otherwise, leave empty 1
Robots Meta No Image Index Do not allow any images on a page. To enable mention – 1. Otherwise, leave empty 1
Robots Meta No Index Not to include the page in the index. To enable mention – 1. Otherwise, leave empty 1
Robots Meta No Archive Not allowing a cached copy. To enable mention – 1. Otherwise, leave empty 1
Robots Meta No Snippet Do not allow snippets. To enable mention – 1. Otherwise, leave empty 1
Advanced Robots Meta Provide the values for the snippet, image preview, and video preview. Each value is selected by using Comma(,) separation E.g.: Snippet – “-1”       Image    – “-1”       Video    –  “large” -1,-1,large
Canonical URl Mention the main page URL. https://www.smackcoders.com/documentation/wp-ultimate-csv-importer-pro
Redirection Type Select any type to redirect the website
  • 301 – Permanent Move
  • 302 -Temporary Move
  • 307 – temporary Redirect
  • 410 – Content Delated
  • 451 – Content unavailable for Legal Reasons
301
Destination URL Mention the URL to redirect https://www.smackcoders.com/documentation/wp-ultimate-csv-importer-pro/seo-import
Headline Mention SEO headline Search engine
Schema Description Mention description for a page/post. With the help of the Rank Math SEO plugin, we can easily track and identify the low-ranking post, pages, and content on our website.
Article Type Specify the type of article. Blog post
General Title Mention SEO title. Search Engine – What is it?
Permalink Specify the permanent link to display below the post title.  Yoast SEO
General Description Specify the description for the post/page.  When you are creating and updating these data on a website manually it will take a lot of time to complete this process.
Facebook Title Specify the title for the Facebook post SEO plugin
Facebook Description Specify the description for the Facebook post How to download Rank Math SEO and customize SEO settings? 
Facebook Image Use media gallery URL or any publicly accessible external URL. https://i.ytimg.com/vi/Bta0km0YlM8/maxresdefault.jpg
Add icon overlay to thumbnail To add overlay, enable this option by entering Value as On. Otherwise, leave it empty. On
Icon overlay To Add icon, we have two options “Play Icon” & “GIF Icon” Play
Use Data from Facebook Tab To collect the data from Facebook to Twitter, enable this option. Enable – On To disable – Off Off
Twitter Title Specify the title for the Twitter post SEO – Rank Math
Twitter Description Specify the description for the Twitter post Rank Math fields Setting
Card Type Specify content by selecting any one of the cards.
  • Summary Card with      Large Image
  • Summary Card
  • App Card
  • Player Card
   
Player
App Description Specify the description for the app IOS/Android version.
iPhone App Name Mention name for App card iPhone App
iPhone App ID Mention the app id from the app store 324561
iPhone App URL Specify the URL scheme https://www.apple.com/in/iphone-12/key-features/
iPad App Name Mention name for App iPad App
iPad App URL Specify the URL scheme https://www.amazon.in/dp/B0932STDMD/ref=fs_a_ip_1
Google Play App Name Mention name for Android app SEO android
Google Play App ID Specify the ID of the app from the App store 6789012
Google Play App URL Specify the URL scheme https://play.google.com/store/apps/details?id=net.seobility.seocheck&hl=en_IN&gl=US
App Country Enter the country code of the app store IN
Player URL Specify the URL to the iFrame player. https://www.youtube.com/watch?v=UPLd0gE1A2A
Player Size Specify width and height of iFrame pixel. 600×400
Stream URL Provide optional URL https://youtu.be/fOg2nvHkfT8 
Stream Content Type Specify the content type contained in Twitter: player: stream. MIME
cssSelector Specify any particular content for headline, summary or any other cssSelector. SEO data import
Image URL Use media gallery URL or any publicly accessible external URL. https://i.ytimg.com/vi/Bta0km0YlM8/maxresdefault.jpg
Author Type Mention the Author Type Admin
Author Name Specify the name of Author Smackcoders
Speakable type    
Enable Speakable To enable this option mention vale as on, to disable mention the value as off On
DateModified Specify the date in DD/Mm/YYYY format 22/08/2022
DatePublished Mention publish date in DD/Mm/YYYY format 24/08/2022

 

CSV import procedure in WordPress:

After creating all the required fields in the CSV file, go to Ultimate CSV Importer Pro in WordPress to Import.

Browse a file Select any one of the modules from the import. We are providing four options to upload the required CSV file. Upload file from desktop, FTP, external URL, and from the server.  Select any one of the above-mentioned options to Import the required CSV file which contains plugin data. Once it is uploaded, select continue. (Note: If you are updating the data, select Existing Items.)  Upload CSV File Mapping Section In the mapping page, map the WP fields with CSV header fields. Check all the necessary fields in WP Core Fields and Rank Math Pro Fields. Click on Continue. Rankmath Mapping Section Media Handling  To download external images in your WP media, Featured Image Handling is used. You can configure this by enabling the ‘Download external images to your media’ button. This option is enabled by default. Feature Image handling option allows you to assign new or existing WP gallery images. Click on Continue. Import Configuration You can import/update Rank Math data either instantly or schedule it to do later. To schedule your importadd the Schedule Date, Frequency, UTC Time, and Zone. We can import instantly by clicking on the import button directly. Press the “Import” button to proceed. To update the existing module, select the “Update” button.

Export Rank Math data

You can export Rank Math field data along with Posts, Pages, or Custom Posts data export. To export,

  • Move to the Export tab and select the post type which can be Pages, Posts, or Custom Posts.
  • If you select Custom Posts, select one Custom Post name from beside the dropdown.
  • Give a name for the file to export and select one file type.
  • Configure the advanced filter if you require. Refer to the export WordPress data with CSV Importer documentation to know more.
  • Click Export.
  • After the file is ready to export. Click download to save the backup on your local desktop.