Wednesday, 15 January 2025

Moz DA not increased despite spammy backlinks disavowed in GSC

Disavowing spammy backlinks in Google Search Console is a great step in maintaining a healthy backlink profile. However, it's essential to understand that disavowing links doesn't directly impact Moz DA (Domain Authority).


Moz DA is a metric calculated by Moz, an independent SEO tool provider. It's based on their own algorithm, which assesses various link equity and ranking factors.


Here are a few possible reasons why your Moz DA might not have increased despite disavowing spammy backlinks:


1. Disavow file processing time: Google needs time to process the disavow file. It may take several weeks or even months for the changes to be reflected in Google's index.

2. Moz's data update cycle: Moz updates its link index and DA scores periodically. It may take some time for Moz to recrawl and reindex your site, reflecting the changes in your backlink profile.

3. Link equity redistribution: When you disavow spammy links, the link equity associated with those links is not immediately redistributed to other links. This process can take time, and Moz may not immediately reflect these changes in their DA score.

4. Other ranking factors: Moz DA is influenced by various factors, including link equity, content quality, and technical SEO. Improving your backlink profile is just one aspect of SEO. Focus on creating high-quality content, optimizing your site's structure, and improving user experience to increase your Moz DA.

5. DA score fluctuations: Moz DA scores can fluctuate due to various reasons, such as changes in Moz's algorithm, updates in their link index, or shifts in your site's ranking factors.


To better understand the impact of disavowing spammy links on your Moz DA, monitor your site's performance using tools like Google Search Console, Google Analytics, and Moz's own tools, such as Moz Pro or Moz Link Explorer. Focus on creating high-quality content, improving your site's technical SEO, and building a strong, authoritative backlink profile.

Tuesday, 19 March 2019

Dropbox Bulk Images link in Excel

Sagar Guide - How to Get Dropbox Bulk-Multiple-Individual Images Link in Excel



All E-Commerce users don't know how to get Dropbox individual / bulk or multiple images links in Excel, Dropbox is most important part of E-commerce Sector for Image link listing on respective e-commerce sites like Jabong, Flipkar, Amazon, Paytm etc.

In 2013 Firstly I am working from E-commerce online selling company as Product Listing Executive, while preparing product listing sheet I need to add more than 100 plus dropbox images links in template sheet and i'm taking single image link copy and paste in product listing template sheet, it's taking more hours to work complete.

And I'm continues this process few months, I get an Idea "it's Possible to get Dropbox images links in excel", then I'm decided to search in Google but Many times i'm searching in google "How to get dropbox images link in excel unfortunately i'm not getting exact result that's i want, after few months I'm finding in google "how to get hyperlink links in excel" finally I'm find the exact search result in google, after that site open, I'm read the process and i'm find to get the Module macro coding,  immediately I'm trying in excel it's done then I'm feeling greatly.

Sagar Gone - Who was first person in the world find the process of Dropbox bulk images links in excel in the year 2015.

In this video you can watch how to get Dropbox bulk images and files links in excel, let's watch step by step instructions : -


Terms and Conditions:

Don't Upload this Video Any Social Media Facebook, Twitter, WhatsApp or Sharing Service Like YouTube, Dailymotion, www.Vimeo.com etc, if You Upload You will get Copyright.

Don't Re-Create this video Completely Different  to My Video, if i found re-created video any Sharing Service you will get copyright.

Thursday, 6 July 2017

How to Add GST in WooCommerce (Wordpress)

Sagar Guide - How to Add GST in WooCommerce (Wordpress)

Goods and Service Tax (GST) is an indirect tax (or consumption tax) imposed in India on the supply of goods and services. It is a comprehensive multistage, destination based tax. Comprehensive because it has subsumed almost all the indirect taxes except few. Multi-Staged as it is imposed at every step in the production process, but is meant to be refunded to all parties in the various stages of production other than the final consumer. And destination based tax, as it is collected from point of consumption and not point of origin like previous taxes.


Goods and services are divided into five different tax slabs for collection of tax - 0%, 5%, 12%, 18% and 28%. However, petroleum productsalcoholic drinks, and electricity are not taxed under GST and instead are taxed separately by the individual state governments, as per the previous tax regime.

There is a special rate of 0.25% on rough precious and semi-precious stones and 3% on gold. In addition a cess of 22% or other rates on top of 28% GST applies on few items like aerated drinks, luxury cars and tobacco products. Pre-GST, the statutory tax rate for most goods was about 26.5%, Post-GST, most goods are expected to be in the 18% tax range.

The tax came into effect from July 1, 2017 through the implementation of One Hundred and First Amendment of the Constitution of India by the Indian government. The tax replaced existing multiple flowing taxes levied by the central and state governments.
The tax rates, rules and regulations are governed by the GST Council which consists of the finance ministers of centre and all the states. GST is meant to replace a slew of indirect taxes with a federated tax and is therefore expected to reshape the country's 2.4 trillion dollar economy, but not without criticism.[3] Trucks' travel time in interstate movement dropped by 20%, because of no interstate check posts.

Let's watch the How to Add Goods and Service Tax (GST)  in WooCommerce (Wordpress) and WooCommerce Product Export CSV Excel Sheet.





Monday, 1 May 2017

How to Earn Money From YouTube Videos

Sagar Guide - How to Earn Money From Your Videos : -


Dated on 16th January 2018, Youtube have recently implemented a new review process for all channels applying to join the YouTube Monetization Partner Program. Get more information on the review process and eligibility requirements below : -

All YouTube users can apply to join as long as the Youtube Monetization Partner program is available in your country. Once a your channel reaches 4,000 watch hours in the previous 12 months and 1,000 subscribers it will be reviewed to join the program.

You can check your channel's view count at Creator Studio > Channel > Monetization If you don’t have enough views, Subscribers keep working to make original content and build your audience. You can get tips from top creators in the YouTube Creator Academy This view count threshold gives us enough information to determine the validity of a channel.

It also allows us to confirm if a channel is following Youtube community guidelines and advertiser policies.   This is part of an effort to strengthen our requirements for monetization so spammers, impersonators, and other bad actors can’t hurt our ecosystem or take advantage of creators, while continuing to reward those who make our platform great. Get more details on the YouTube Creator Blog.

When you apply : 

You can apply to join the YouTube Monetization Partner Program and Once a your channel reaches 4,000 watch hours in the previous 12 months and 1,000 subscribers, This requirement allows us to property evaluate new channels and helps protect creator content, your channel activity is reviewed to make sure your content adheres to the YouTube Monetization Partner Program policies, YouTube’s Terms of Service, and  Community Guidelines.

Youtube will email you to let you know as soon as the process is complete. You can also check the status of your application at Creator Studio > Channel > Monetization. The process may take up to several weeks.
  
If your channel approved: You will start earning money on YouTube right away if you've already chosen the videos you want to monetize.
  
If your channel not approved: If your channel isn't approved to join the program, it's likely because youtube cannot determine whether your channel's activity complies with the YouTube Monetization Partner Program policies and Community Guidelines.

You can keep uploading original content and building your audience on YouTube even if you're not in the partner program—and you can reapply again in 30 days.
 

How to Enable Youtube Monetization  Partner Program With Step by Step with New Implemented Process : -

Login to your channel Right Side Click on User Icon - Click on Creator Studio - Click on Channel Menu- Status and Features - Click on Enable Monetization - Monetization Page Open : 
Apply for Monetization : 

1) Read and Agree to the Youtube Partner Programs Terms
Click on Start  
Next Tick on Three Boxes and Click on Accept
 
2)  Next Sign up for Adsense 
Click on Start - Click on Next

Next Sign in Your Google Account Next Click on Accept association Next Fill the Your Information and Submit Application
Now Page Redirecting back to Youtube Monetization Page

3) Set Monetization preferences 
Click on Start Next Ad Format Page Open And Now Click on Save

4) Get reviewed after reaching 10,000 views 
Upon reaching 4,000 watch hours in the previous 12 months and 1,000 subscribers, your channel is automatically reviewed to make sure it complies with the YouTube Monetization Partner Program terms and our Community Guidelines. Youtube will email you a decision, usually within a 6 to 12 Months. 

Saturday, 22 April 2017

How to Search Bulk Images in Computer - Laptop

Sagar Guide -  How to Search Bulk Images in Computer - Laptop


How to Search Bulk or Multiple Images and How to Search Multiple Files Folder in Computer / Laptop


In this days many computer user, computer operator or job employees don't know how to search bulk / multiple images / files in their personal computer or laptop, so here the step by step to follow : - 

* First search images name and add in excel
* Now type the 1, 2 in Column B, Select the 1 and 2 Row and Drug or Left side then double click on mouse
* Now copy and paste in same down column
* Now select the all numbers
*Right click on mouse>select the sort>Click on sort smallest to largest 
* In Sort warning
* Select the Expand the selection click on "Sort"
* Now select the images name 
* Press Ctrl+H ( Find and Replace)
Find What "Leave the Blank" Replace with Type the "OR"
"Click on "Replace All".

"Copy and Select the Blank Row click the right click>click on paste special>paste special dialogue box appear>Tick the "Transpose"
* Click on "OK"
* Now Images Name will appearing horizontally
* Copy the maximum 160 count row
* Now Paste in my computer
* It's Completed Bulk / Multiple Images or files will be appearing.






Saturday, 18 February 2017

Apply for Driving-Learning Licence

How to Apply for Driving Licence | Learning Licence Online in India

In India, a driving licence is an official document that authorises its holder to operate various types of motor vehicles on highways and some other roads to which the public have access. In various Indian states, they are administered by the Regional Transport Authorities/Offices (RTA/RTO). A driving licence is required in India by any person driving a vehicle on any highway or other road defined in the Motor Vehicles Act, 1988.

A modern photo of the driving licence can also serve many of the purposes of an identity card in non-driving contexts (proof of identity (e.g. when opening a bank account) or age (e.g. when applying for a mobile connection).


* First Go to  www.sarathi.nic.in/

Apply Online for : 

Click on "Application Form for New LL and DL"
Click on "Request for services on Licence"

* if You want Learning Licence Tick on "New LL"

OR
                                        
*If  You want Driving Licence Tick on "New DL" 

* Click on "Continue"

* Applicant Details : 

Aadhar Card Number : Enter the 12 Digit Aadhaar Number

Select State : Select the State

Select RTO/DTO :  Select the RTO/DTO

Date of Birth : Enter the your date of Birth

* APPLICANT NAME

First Name : Your Name

Middle Name : Your Father Name First Character

Last Name : Your Surname

Relation : Select the Relation

First Name : Relative Name

Middle Name : Relative Father Name First Character

Last Name : Relative Surname

Gender : Select the Gender

Phone : Enter the Land Line Number or Leave the Blank

Mobile : Enter the your Mobile Number

Place of Birth : Enter the Birth Place

Country of Birth : Select the Birth Country

Citizenship Status By : Select the Citizenship

Blood Group : Select the Blood Group

Email Address : Enter the Your Email ID 
                         youremailid@gmail.com
   
Education Qualification : Select the Qualification

Identification marks : 
Enter the your Body Identification Marks

* If place of birth is out side India, Month & Year when 
migrated to India:

Leave it Blank

* Click on "Continue"

* Address Details :

* if Permanent Address | Present Address is Same

Tick on "Copy Present Address as Permanent Address"

State : Select the State

District : Enter the District Name

Flat Number : Enter the Flat Number

Flat / House Name : Enter the Flat Name or House Name    

House Number/Plot Number : Enter the House / Plot Number

Street : Enter the Street Name

Locality : Enter the Area Name

Village/Town /City : Enter the Village/Town or City Name


Taluka / Mandal : Enter the Taluka or Mandal Name


Pincode : Enter the Pincode Number


* Duration of Stay at this address : 

Enter the How Many Years and Months stay at this address 

* Click on Continue

* Class of Vehicles

*If you want Motor Cycle Without Gear Licence

Tick on "MOTOR CYCLE WITHOUT GEAR(NON TRANSPORT)(MCWOG)"

* If you want Motor Cycle With Gear Licence

Tick on "MOTOR CYCLE WITHOUT GEAR(NON TRANSPORT)(MCWOG)"

and

Tick on "MOTOR CYCLE WITH GEAR (NON TRANSPORT)(MCWG)"

* Click on "Continue"

* Documents :

* List  of  Enclosures ( Applicant  should  produce  the  original
documents  before  the  Licensing Authority at the office)    

Documents List : Select the Documents

Proofs List : Select the Proof

* Click on "Submit"





Note : Application Submit After Slot Booking for Learning Licence Test Exam to Select the Book Slots for Available Dates

Aadhar Card is required while booking LLR Slot,Please keep it ready before going further. 

If You don't have Aadhar Number please approach the nearest RTO office with valid Address proof. Please select District and Test Center to book slot for learner's license test 

You Must Reach the One hour Before Slot Booking Time at Learning Licence Test Exam Center 

Procedure Of Examination


   To obtain Learning License, Knowledge Test through computer is required to be passed.


  • Subject like Rules and Regulations of traffic, and traffic signage’s are included the test.
  • 15 questions are asked in the test at random, out of which 11 questions are required to be answered correctly to pass the test.
  • 48 seconds are allowed to answer each question.
  • A person failing in the test can appear for the re-test after a gap of 24 hours.
  • A person who has learning license or driving license and seeks to apply for an additional category of driving license in the existing driving license, is exempted from the knowledge test on computer.


Take the Mock - Test, just the way you are going to face in the Driving Licence Examination & go with full preparation. Real Exam like feeling. We’ll give you score too. So that you can have the idea. You’ll be given 12 minutes to answer 15 Questions. That is 48 seconds/question. Keep that in mind.
Click here to take the mock test
https://gujaratdrivinglicence.com/all-tests.php?state=1 

 
Driving test is compulsory to obtain permanent driving license : -
  • One can appear for driving test after a gap of 30 days or More than 170 days of obtaining learning license.
  • Driving test is conducted on same kind of vehicle for which application is made for obtaining driving license has been made.
  • Learning license is valid for a period of 6 months only therefore, an applicant is required to appear for driving test within the 6 months validity period.

Learning license is delivered to the applicant in person on the same day when he comes for knowledge test exam.

  • Driving license is sent with speed post at the address mentioned by the applicant in his application. International driving permit is delivered to the applicant in person.

Friday, 17 February 2017

Discount Formula in Excel

Sagar Guide - Discount Formula in Excel


Discount Formula is most important for e-commerce seller, reseller, wholesaler. Discount Formula an original price minus 5 is the same as Calculate to 95 of that value so if you have the Product Price (4585) in A2 use the Discount Formula.

Here the Below Example for Discount Formulas : -

5% Discount formula is =A2*0.95
10% Discount formula is =A2*0.90
15% Discount formula is =A2*0.85
20% Discount formula is =A2*0.80
25% Discount formula is =A2*0.75
30% Discount formula is =A2*0.70
40% Discount formula is =A2*0.60
50% Discount formula is =A2*0.50.

Another Way to Calculate Discount Formula in Excel -

How to Find Discounted Amount in Excel?

Column A is Product Price, Column B is Discount Percentage, Column C is Discounted Amount and Column D is After Discount Amount.

Discounted Amount Formula is  =A2*5%
After Discount Amount Formula is =A2-C2.


Another Easiest Way to Calculate Discount Formula

Column A is Product Price, Column B is Discount Percentage % and C is After Discount Minus Price
After Minus Discount Formula is =A2-(B2*A2%).

Discount formula in excel



Excel Keyboard Shortcuts

Sagar Guide - Excel Keyboard Shortcuts


Microsoft Excel Keyboard shortcuts are typically a means for invoking one or more commands using the keyboard that would otherwise be accessible only through a menu, a pointing device, different levels of a user interface, or via a command-line interface. Keyboard shortcuts are generally used to expedite common operations by reducing input sequences to a few keystrokes, hence the term "shortcut".


Excel Some Useful Keyboard Shortcuts
Shortcut key Action Menu equivalent comments
Alt or F10 Menu Go to Menu bar
Alt+’ Format Style dialog box Format the Style
Alt+= AutoSum Sum Formaula Showing in Cell
Alt+Down arrow Display AutoComplete list Displaying Auto Complete Data List
Alt+F1 Insert Chart Insert the Chart
Alt+F11 Visual Basic Editor Tools, Macro, Visual Basic Editor
Alt+F2 Save As Save File to Save As
Alt+F4 Exit File Exit
Alt+F8 Macro dialog box Macro dialog box Tools
Alt+Shift+F1 New worksheet Insert New Worksheet
Alt+Shift+F2 Save Save the File
Ctrl + Shift + L Filter Filter the Row
Ctrl W Close Close the Open File
Ctrl+- Delete Delete the Rows, Columns and Cells Right or Down Depends on selection
Ctrl+! Format cells dialog box Font Tab Open in Format Cell Tool
Ctrl+# Italic Cell Font Style Change to Italic toggle
Ctrl+$ Underline Cell Font Style Change to Underline toggle
Ctrl+% Strikethrough Cell Font Style Change to Strikethough
Ctrl+( Hide rows Hide the Row
Ctrl+) Hide columns Hide the Coloumns
Ctrl+; Insert Current Date Add the Current Date
Ctrl+@ Bold Cell Font Style Change to Blod toggle
CTRL+[ Select all cells directly referenced by formulas in the selection. Referene Contains Cell Easily Find
CTRL+] Select cells that contain formulas that directly reference the active cell. Referene Formula Cell Easily Find
Ctrl+` Column Widht Coloumn Width Increase Double Size
Ctrl++ Insert Insert the Rows, Columns and Cells Right or Down Depends on selection
Ctrl+A Select All Selecting Entire Sheet
Ctrl+Alt+V Displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program. Purpose Paste and Paste Special
Ctrl+Alt+V, Press A Displays the Paste Special dialog box, Selecting All Purpose Paste and Paste Special
Ctrl+Alt+V, Press V Displays the Paste Special dialog box, Selecting Values Purpose Paste and Paste Special
Ctrl+B Bold Cell Font Style Change to Bold toggle
Ctrl+C Copy As Your Wish to Copy Selected Cells
Ctrl+D Fill Down Copy to Down Cell
Ctrl+F Find Find What you Find
Ctrl+F1 Hide the Menubar Hiding the Menubar
Ctrl+F10 Maximize or restore Down window Maximize and restore Down the window
Ctrl+F11 Macro sheet Inster the Macro Worksheet
Ctrl+F12 File Open Open the File
Ctrl+F2 Format Shape & Print 1st Side to Open Format Shape Tool, Next Immediately Open Print Option
Ctrl+F3 Name Manager New Name add to Refer Cell (Any Cell You Want add New Name)
Ctrl+F4 Close Close the Open File
Ctrl+F5 Restore Down Window Size Change
Ctrl+F6 Next workbook Next Workbook Window Change
Ctrl+F7 Move window 1st Change the Window Size Pressing Ctrl+F5, After Window Move to Any Area
Ctrl+F8 Add to selection Multiple Different Cell Add to Selection
Ctrl+F9 Minimize workbook Minimize the Worksheet
Ctrl+G Go to Type the Reference Cell Numver Want to Go
Ctrl+H Replace Find What you Find to Replace With Another Word
Ctrl+I Italic Cell Font Style Change to Italic toggle
Ctrl+K Insert Hyperlink Hyperlink Insret
Ctrl+N New Workbook New File
Ctrl+O Open Open File
Ctrl+P Print Print File
Ctrl+R Fill Right Copy to Right Cell
Ctrl+S Save Save the Workbook File
Ctrl+Shift+& outline border around selected cells Place outline border around selected cells
Ctrl+Shift+( Unhide rows Unhide the Hided Rows
Ctrl+Shift+) Unhide columns Unhide the Hided Coloumns
Ctrl+Shift+: Insert Current Time Add the Current Time
Ctrl+Shift+_ Remove outline border Remove outline border around selected cells
Ctrl+Shift+A Insert argument names into formula 1 st Type the Formula Name in Cell Next Press the Shortcut
Ctrl+Shift+F1 Full Mode Hide the QuickAccess, Menu and Status bar
Ctrl+Shift+F12 Print Print File
Ctrl+Shift+F3 Create name by using names of row and column labels Insert, Name, Create
Ctrl+Shift+F6 Workbook Switch Last Workbook Switch Between Multiple Sheets
CTRL+SHIFT+SPACEBAR Selects the entire worksheet.  Selecting he entire worksheet. 
Ctrl+Spacebar Select the entire column Selecting the entire column
Ctrl+Tab In the toolbar next toolbar Go to Next Option in Toolbar
Ctrl+Tab In a workbook: next workbook Switch Next Workbook
Ctrl+U Underline Cell Font Style Change to Underline toggle
Ctrl+V Paste 1st Copy the Selected Area, And Next Paste to Anywhere in Workbook
Ctrl+X Cut As Your Wish to Cut Selected Cells
Ctrl+Y Repeat 1st Using Undo After You can use the Repeat
Ctrl+Z Undo Sack to Steps Previous
Enter Move to Down Cell Move to Down Cell
F1 Help Excel Help
F10 Menu Go to Menu bar
F11 New Chart Insert Chart
F12 Save As File Save to Save As
F2 Edit You Can Edit the Word
F4 While typing a formula, switch between absolute/relative refs Change the Formula While you Formula Adding (For Example =Vlookup(a2 Now Press F4)
F5 Go to Type the Reference Cell Numver Want to Go
F6 Menu & Status Bar 1 time Press Go to Status Bar, 2 times Press to Menu Bar
F7 Spell check Spelling Modified
F8 Extend mode Extend Selection
SHIFT+BACKSPACE Cells Selected select only the active cell, With multiple cells selected With Hold Shift+Down Arrow
Shift+Ctrl+F Font Tab Format Cell Font Tab Open in Format Cell Tool
Shift+Ctrl+F6 Previous workbook window Previous Workbook Window Change
Shift+Ctrl+P Font Tab Format Cell Font Tab Open in Format Cell Tool
Shift+Ctrl+Tab In the toolbar: previous toolbar Go to Previous Option in Toolbar
Shift+Ctrl+Tab In a workbook: previous workbook Switch Previous Workbook
Shift+F10 Display Options If you Don't Want Use the Mouse Right, Then Use the Shortcut (And Also Shortcut Available Keyboad)
Shift+F11 New worksheet Insert the New Worksheet
Shift+F12 Save File Save
Shift+F2 Edit cell comment Insert and Edit Comments
Shift+F3 Select a Formula Function Insert a Furmula Function
Shift+F4 Repeat last action Repeat the Last Actions Works while not in Edit mode. (1st Using Find What : What You Find, After You Can Use Previuosly What You Find)
Shift+F5 Find Find What you Find
Shift+F6 Menu & Status Bar 1 time Press Go to Status Bar, 2 times Press to Menu Bar
Shift+F7 Thesaurus Type the words in groups of synonyms and related concepts
Shift+F8 Add to selection Multiple Different Cell Add to Selection, How to Use Press 2 Times, After Add to Selection
Shift+Spacebar Select the entire row Selecting the entire row
Shift+Spacebar and Ctrl+ - Delete Delete the Selected Area Row
Shift+Spacebar and Ctrl+ + Insert Insert the Selected Area Row
Shift+Tab Move to Previous Left Cell Move to Previous Left Cell
Tab Move to Right Cell Move to Right Cell
Esc Escape Stop the Selected Cells Copy
PgUp Page Up Go to Next WorkSheet
PgDn Page Down Go to Previous WorkSheet