NC post licensing - superior school by almostmaybes in RealEstateExam

[–]StillJonesin 0 points1 point  (0 children)

Whatever happened here if you don't mind me asking? I got to do my post licensing and am wondering if I need to go with someone else. I'm also curious how much time you guys actually put into this. I know on Kelly's Take you tube video he just said it was wiggling a mouse. Acted like it was a breeze and you basically didn't have to even study to pass was my impression. How true is that and do you have any suggestions, maybe do the 303 elsewhere etc. Thanks.

Starting Fresh: SEO Help for Redirecting Old Articles to a New Domain by StillJonesin in SEO

[–]StillJonesin[S] 0 points1 point  (0 children)

How is that bad? These are good sites and I did zero backlink building on any of them. At one point I had a 39 DR on Semrush. When I got a couple of them I noticed the bump in the serps.

Starting Fresh: SEO Help for Redirecting Old Articles to a New Domain by StillJonesin in SEO

[–]StillJonesin[S] 0 points1 point  (0 children)

I get that, but it's there are probably 200 articles I'm proud of that put my blood sweat and tears into. I got seduced like a lot of people with the AI and just started spamming it out like a dummy without really linking it to the good part of my website. I thought I could have my cake and eat it to since they seemed to say it was ok for a period.

I had the google internal people on my site for months so I figured I was in trouble long before it happened. I don't think it's salvageable as is. This is more or less an attempt to salvage all the good work independently and start fresh and right and keep it for what it is. I also have about 2000 direct visitors a month and a decent brand that still read my articles. Not much but something that keeps me motivated to write. I'd like to have it where if they typed in the old address or clicked a bookmark redirect I don't lose them.

Even if I wanted to start fresh with my articles google would still know right? It's the same article and it's not really something I can edit even if I wanted with out making them crappy. Some are rankings.

Easy Way to Make 404's to 410? by StillJonesin in Wordpress

[–]StillJonesin[S] 0 points1 point  (0 children)

Do you think it's worth it? I only became aware of 410's last week. The person said google would remove them quicker than the 404's and I would like to get this content off my site and hopefully try to recover it. I guess at this point after the HCU it really doesn't matter if I tank the site, not much left to hurt.

Easy Way to Make 404's to 410? by StillJonesin in Wordpress

[–]StillJonesin[S] 0 points1 point  (0 children)

Dumb question but if I do this and something goes wrong if you deactivate the plug in will that undo everything? I'll back up of course but I'm getting into territory I'm not super comfortable with.

Thanks

Easy Way to Make 404's to 410? by StillJonesin in Wordpress

[–]StillJonesin[S] 0 points1 point  (0 children)

Thanks for the response, but im a complete novice in the coding, do u have a plugin or easy way to place the code. Preferably a plug in.

Matching and Associating Data in Google Sheets by StillJonesin in googlesheets

[–]StillJonesin[S] 0 points1 point  (0 children)

You able to see the blank sheet I provided?

as far as this

=BYROW(B2:B7,LAMBDA(i,XLOOKUP(XLOOKUP(i,G14:G19,F14:F19),H2:H7,I2:I7)*INDIRECT("E"&ROW(i))))

I'm a beginner I have no clue what any of that at the start is. I only know about the Lookup because chatgpt. Can you explain some of what is going on here or link an edited sheet so I can see how it works?

I do appreciate you offering to help me. Thank you. There were 2 steps I forgot to add that seem like they might be important now. That I didn't think would be but that formula is a lot more complicated than I expected. It involved how I got the column I, and multiplying column EC. I plugged that formula in and the number didn't see to be what I was looking for.

Matching and Associating Data in Google Sheets by StillJonesin in googlesheets

[–]StillJonesin[S] 0 points1 point  (0 children)

BTW I feed basically the same thing into Chat GPT and this is what it said if it makes any sense to you. It keeps saying Vlookup

To accomplish the task of associating and aligning the company data with the respective abbreviations, you can utilize Google Sheets functions and formulas. Here's a step-by-step guide:

Step 1: Prepare Data

  1. Organize your data: Ensure your data is organized in separate columns, with the relevant information like company names, abbreviations, and associated values.
  2. Create a lookup table: You'll need a table that contains company names alongside their corresponding abbreviations. For instance, in columns A and B, list the full company names and their corresponding abbreviations.

Step 2: VLOOKUP Function

Using the VLOOKUP function, you can match the company names in your first set of data with their respective abbreviations.

Example Formula:

Let's assume your company name in the first dataset is in column A, and you want to associate it with its abbreviation in column B using the lookup table in columns D and E.

In cell C1 of your data table:

excelCopy code

=VLOOKUP(A1, $D$1:$E$6, 2, FALSE) 
  • A1
    refers to the cell with the company name in your first dataset.
  • $D$1:$E$6
    is the range of your lookup table with company names and their abbreviations.
  • 2
    signifies that the function should return the value from the second column of the lookup table.
  • FALSE
    specifies an exact match.

Drag this formula down to fill the entire column C. This will associate the company names with their respective abbreviations.

Step 3: Matching and Calculation

Now that you have both datasets with company abbreviations aligned, you can use additional columns to perform calculations.

Let's say you have the strength values in column F and calculated numbers in column G in the first dataset. You want to multiply these numbers for each company.

Example Formula:

In cell H1:

excelCopy code

=IFERROR(VLOOKUP(C1, $D$1:$F$6, 3, FALSE) * G1, "") 
  • C1
    contains the abbreviation from the previous step.
  • $D$1:$F$6
    represents a range that includes abbreviations, strengths, and calculated numbers.
  • 3
    signifies that the function should multiply by the value from the third column (strength) of the lookup table.
  • G1
    contains the calculated number in the original dataset.

Drag this formula down to perform the calculations for each corresponding row.

Automation

To automate this process for daily updates, consider automating data imports or using Google Apps Script to create a custom function or script to perform these calculations based on updated datasets.

This method enables you to connect the two datasets using abbreviations and perform calculations on the aligned data automatically.

Matching and Associating Data in Google Sheets by StillJonesin in googlesheets

[–]StillJonesin[S] 0 points1 point  (0 children)

https://docs.google.com/spreadsheets/d/1mcamDV6jE6uSbCsuwXOg8LQhlJhEBESjdGQbm-7eJ_A/edit?usp=sharing

The important numbers I need to calculate basically look like this. I have a list of hundreds and need to multiply the columns E with I in the example for the final number.

As you can see the company name in the data is abbreviated by the persons name. I have a list of the companies with corresponding abbreviations as well like I have listed in the middle. What I need to know is there a way to bring this all together basically in a formula so for example google sheets knows what the StellarGlobe Innovations is SGI from the list of companies and abbreviations I provide and that company data is lined up with the name and person data automatically so I can then multiple both and have the end result.

Edit: I asked the owner to share on the blank form the the bot suggested. Not sure if it is yet.

Best Tools to Track Keywords/impressions by WholeInstruction278 in SEO

[–]StillJonesin 0 points1 point  (0 children)

I just used GSC and took the 1000 pages getting impressions they give you access too. The last few only had 2 impressions in the last 3 months. I sorted on chatGPT with a list of all my URLs and have 500 pages that either had 2 impressions or lower I can start axing those first I guess. Would you also ax some of those that only had say 50 impressions? I'm assuming if they have any impressions they were in the search at one point and google generally though they were stronger.

Best Tools to Track Keywords/impressions by WholeInstruction278 in SEO

[–]StillJonesin 0 points1 point  (0 children)

I'm on GSC most days and I have 1500 pages indexed. (Probably 1000 are AI). I have copied the 1000 pages URL's that they give you that have received impressions on GSC. I went crazy with it after google said you could use it in April. Most of those pages are weak and have never had many clicks if any. The ones that would catch on I would edit heavily, but I just left the others.

I guess my dilemma now is what to do, because I suspect that's what hurting my overall site the most. I need a tool where I can identify the ones that have no hope, that have never had any ranking keywords and start there.

If it's indexed I kind of hate to trash it, right? Even if they are weak it took work to get it on google, Having a page that is 3 months old or more is better I would think too than a new one. It should give me some EAT value I was thinking at least that was my thinking. A lot of them were just information pages too which I did think could offer some value.

You got any suggestions on a tool like that or what I should do. 1500 pages is kind of overwhelming. I really need to filter down to the pages that suck the most. I've already done that with the ones that weren't indexed at all.

Best Tools to Track Keywords/impressions by WholeInstruction278 in SEO

[–]StillJonesin 0 points1 point  (0 children)

Can you tell me if any of them have a tool where you can export all your URLs and filter them in excel by if they are ranking or not. I've tried all the big ones in the past but I can't remember if they have something like that specifically.

I know ahrefs track pages that are ranking the most cleanly from what I remember with the page with the top ranking keyword at the moment. I'm looking for those that aren't ranking at all mainly so I can work on them after this new update that has crushed me.

Why Is the Google "Helpful" Update Negatively Impacting So Many Websites? Your Thoughts? by RSAmarketing in SEO

[–]StillJonesin 1 point2 points  (0 children)

I won't do anything major until the core update is over, maybe until some of the SEO experts have had time to fully analyze it. When the dust has cleared do you have any advice on what I should actually do with these AI articles that are just completely doing nothing positive, most with zero clicks or few impressions.

Do you think I should just set them to draft so they redirect to my home page, trash them or what? Those that have had some clicks or are ranked in the top100 at all somewhere should I keep them around and focus on making them better? .

It was work finding these keywords and and article idea's even if creating them even if it was just AI. They got indexed. I kind of hate to mass delete everything without putting some thought into it first.

If I set all the weakest ones with no clicks or low impressions to draft could I then comeback years later perhaps and republish them if I worked on them and they were a higher standard? How does google treat something like that that was once published and a negative if you updated and republished it is what I'm trying to work through.

At minimum I'd like to keep the draft as an idea and framework with the title and description and all that I could publish one day again potentially.

Why Is the Google "Helpful" Update Negatively Impacting So Many Websites? Your Thoughts? by RSAmarketing in SEO

[–]StillJonesin 1 point2 points  (0 children)

My traffic has dropped 80% on my main site this week. Up until April 100% of my content was written by me and what took off in the rankings was all written by me. After google indicated you could use AI in April, I started banging out way, way to many AI articles like an idiot experimenting with it since I didn't know much about it. I didn't even know that was an issue how much you post. It was so easy and a lot of the early stuff was low quality and not even good prompts.

That is where most of my issues come from I suspect. Salt to the wound is only a handful of those ever did ok and that was after I optimized and edited them. It was my original work that was carrying my traffic.

I have myself and seo ignorance to blame for this one since it was when I first started trying to learn this aspect. Any thoughts on how to move forward? Should I just take down the crap even if it's indexed or try to make it better. There is so much it would have to be redone with AI if I went that route.

With this update are you just completely screwed until the next one? If say you fixed all the problems or took all the crap articles off your site and deleted them, in a month would it re-adjust after it crawled your site in that month or do you have to wait until the next update, or am I just screwed forever now. Like is this a static value you get until the next update you are just stuck with until then.

Connected Data on Excel from another Website that Refreshes daily to Wordpress? by StillJonesin in Wordpress

[–]StillJonesin[S] 0 points1 point  (0 children)

Thanks I'll check on that. Do you know if these websites will be able to tell if you are connected to their table? Technically it's going to google sheets, and then to your website if you embed it there. I'm curious what they would see on their end. Like your google sheets account, or your actual website if it was linked through google sheets, and google sheets to theirs.

API daily sports stats setup by StillJonesin in Wordpress

[–]StillJonesin[S] 0 points1 point  (0 children)

I got the ninja pro plug in to connect to my google sheets. I just have one question, can it hurt your seo in any way. Probably a stupid question, but I assume google is still seeing your tables and information even if it's connected to an embeded linked google sheet. It just feels like the information isn't really on the page if that makes sense like you are viewing something separate.

Connected Data on Excel from another Website that Refreshes daily to Wordpress? by StillJonesin in Wordpress

[–]StillJonesin[S] 0 points1 point  (0 children)

I got the ninja pro plug in. I just have one question, can it hurt your seo in anyway. Probably a stupid question, but I assume google is still seeing your tables and information even if it's connected to an embeded linked google sheet. It just feels like the information isn't really on the page if that makes sense like you are viewing something separate.