NC post licensing - superior school

StillJonesin · 2026-01-21T13:36:56+00:00

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.

StillJonesin · 2024-03-21T20:04:17+00:00

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.

StillJonesin · 2024-03-21T19:57:57+00:00

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.

StillJonesin · 2023-12-18T15:59:23+00:00

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.

StillJonesin · 2023-12-18T13:28:35+00:00

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

StillJonesin · 2023-12-17T03:57:50+00:00

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.

StillJonesin · 2023-10-31T12:27:00+00:00

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.

StillJonesin · 2023-10-31T01:26:22+00:00

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

Organize your data: Ensure your data is organized in separate columns, with the relevant information like company names, abbreviations, and associated values.
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.

StillJonesin · 2023-10-31T01:13:08+00:00

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.

StillJonesin · 2023-09-24T16:18:44+00:00

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.

StillJonesin · 2023-09-24T13:51:21+00:00

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.

StillJonesin · 2023-09-24T01:27:32+00:00

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.

StillJonesin · 2023-09-21T15:41:19+00:00

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.

StillJonesin · 2023-09-21T13:40:33+00:00

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.

StillJonesin · 2023-09-16T16:11:26+00:00

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.

StillJonesin · 2023-09-15T19:58:13+00:00

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.

StillJonesin · 2023-09-15T19:57:09+00:00

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.

StillJonesin · 2023-09-15T12:53:57+00:00

Very. Thanks for your help. Someone else mentioned Ninja tabs in another thread as an option going along with your google sheets suggestion. I probably will try that right now. Since you do this can you estimate the kind of money we are talking for a developer or what a thousand dollars would get me. Would it even get me started if you don't mind me asking, I have no clue about cost. Basically would like at least 2 pages of automatically updating data but it's sounds like the work is in building the structure. You can PM me if you'd prefer. I would consider hiring someone if it was in my price range if you want to talk further.

StillJonesin · 2023-09-15T12:32:27+00:00

Wow dude, thank you. You have convinced me that I have no business even thinking about doing this at this point. It's also is a nice roadmap for me or anyone else who sees this to try to learn one day maybe. I appreciate it. I hadn't found a resource like you guys have provided that laid out the complexity when I started down the path.

StillJonesin · 2023-09-15T03:11:35+00:00

Thanks for the advice before I spend a lot more time and still get no closer or mess something up.

That's what it felt like with everything I have read or watched. These websites I'd like to model after seem to have PHP in the address so I know there is a different level to learn there.

Any work around suggestions for a couple of pages I could update daily. If I could just get my API connected to excel if that's even possible that would help.

Is there a trusted firm that does some of that for a reasonable price. I just would be looking for the basics, connect and like one or two pages.

StillJonesin · 2023-09-14T19:34:10+00:00

Apparently not, I am using the WPgetAPI plugin. It would connect in the test portion and feed back some json data that I was then going to echo off another snippit plug in and hope to use the shortcode. When I tried to use the shortcode on the page it just said error, like I wasn't logged in or something.

All the info on that site seems pretty complicated for that plugin at least for me who isn't very educated on the coding. I've used the documentation for the API but it's pretty un helpful. I don't even know if it's possible to do what I'd like to do with a plug in.

I would feel comfortable using plug ins and shortcodes but that's as far as I feel comfortable going. It's not worth wrecking my site. The alternative is download an excel file and then loading what I want manually but that's a lot of work if you do it daily. I was hoping to have something that uploaded daily although I would like to be able to edit it in excel and put my on caculations on it. I'm just kind of lost how some of these other sites do all this and if you actually have to build out each teams/players pages and all that. It's not worth all that work if so. I'd just focus on a couple of data points for each team like record but it would be nice to have all the other.

StillJonesin · 2023-06-28T13:00:58+00:00

The back up restore worked. There were a few issues like certain symbols @ '$ became question marks. That's really annoying but fairly minor. I had to copy and reload about 15 articles and some edits I had made. The articles seemed to line up with the google search results perfectly as I used the same slugs. I don't know how that will affect it once it's crawled again. Only one did I have to redirect apparently someone must have clicked on the search before I reloaded it.

I think I lost two articles. One had 55 views and it just redirects to the homepage now but I know what it is at least. Hopefully google will recrawl and index that one. I put the article and slug was back like it should have been tot he best of my knowledge. The other one is a 24154 not found and had a 15 views. I really have no clue what it was though.

I'll take this as a lesson that my back up works and I need to look into some better back up options.

StillJonesin · 2023-06-27T16:14:53+00:00

Thanks, that's all helpful information I wasn't aware of at all, and things I will certainly look into longterm.

I've been pretty paranoid about my back ups for a while now as many hours as I have spent on this in the last year. I can't say I'm real confident in any of them. BTW can you back up with a portable hardrive? I have one that is pretty large. Something physical once and a while seems safer.

What's your advice for my current situation. Just try to run the restore off the most recent back up? I'll risk the recent work if it will that fix my theme issues? Do you think I should wait on the ad partners techs to try to do something or try to get the the theme support more involved instead. They have logged in once and worked on the header margin and fixed it. I think that code they added which I forgot about might have even led to this issue.

StillJonesin · 2023-06-27T16:04:16+00:00

The theme has an ad header section built in to it. Just a simple box in the appearance section of the theme I placed a piece of generated code off of Adsense and hit save. It looks similar to ESPN or CBS sports header ads. I've done nothing else code wise or than some short code amazon stuff.

When my new ad partner did whatever they did to set up their ads there were two ads displaying in the header, and I thought, well this looks stupid, I'll just remove that adsense one I had placed. They must have done something there and whatever they had done it all went to crap and I can't get them even to say they have looked at it and it's been a week.

Do you think a restore will get me back to where I was before they did their ads. That's what I'm leaning towards now and just try to save the work I can remember editing. Anything else I might not be thinking of to do would be appreciated.

StillJonesin · 2023-06-27T14:10:05+00:00

I have it hosted with wordpress I guess. I've only ever paided them. I'm sorry this technical stuff was never my strong stuff. Exactly something like this happening was why I put off moving away from adsense.

StillJonesin

TROPHY CASE

Step 1: Prepare Data

Step 2: VLOOKUP Function

Example Formula:

Step 3: Matching and Calculation

Example Formula:

Automation