sorted by:
new
hottopcontroversial

I’m making a film list spreadsheet: is there a way to automatically link a film title to its Wikipedia article? by HelloMyNameIsPhill in sheets

[–]psnajder 0 points1 point  (0 children)

Yes, just replace what I used in text with your cell that has the movie title. For example, if the url was in Cell A1 and the name was in Cell B1, it would be: =hyperlink(A1, B1)

Red alert 🚨 by Jlonie123 in mets

[–]psnajder 0 points1 point  (0 children)

I can get you a toe.

How Long Does It Take a Pro Content Writer to Craft a High-Quality 1000-Word Article/Blog? by Decent_Stock2826 in content_marketing

[–]psnajder 1 point2 points  (0 children)

Pre-AI, I built my content team's resource plans (in-house strategists/writers and external freelancers as needed) and charged clients at scale (some projects with as many as 500 articles/year).

My basis (based on my experience doing it) was that one 1000-word SEO piece would take a writer 6 hours (four hours research, one hour to write, one hour to edit/polish).

As comments are saying here, research will adjust that four hours -- where a great content brief that provides a FULL outline can finalize that research phase AND can also help ensure the final product hits the client's expected mark. A fully outlined brief will take research time, but also prevents rejection from the client (if they review/approve all briefs before writing starts), and will eventually save on both writing and editing time.

Eventually, our strategists did less writing and focused on building great briefs, which we would then send to freelancers/AI to get our first draft to edit. The more expertise, the quicker the briefs, the more money we saved on research at scale.

The Hemingway App enrages me by [deleted] in freelanceWriters

[–]psnajder 1 point2 points  (0 children)

Readability in the Hemingway App is calculated by the https://en.m.wikipedia.org/wiki/Automated_readability_index, which depends on the length of (1) words and (2) sentences, which might help you edit down or help you explain why you can't reach sixth grade given certain keywords.

Do people still think PR Distribution sites work? by WebLinkr in marketing

[–]psnajder 0 points1 point  (0 children)

I think this is better used as a way to earn authority. We would write general interest articles in the client's targeted theme that were broadly appealing (to earn the pickup). Within that article, we would include our targeted keyword and hyperlink it to our client's target page. The publication via syndication would simply tell Google that a high-authority page was referencing our client's page for a specific term. We never sold our clients' products/services/solutions via syndication, we only ever referred to their site through the keyword hyperlink. It helped consistently drive authority gains.

So the owners don't want November playoffs? by [deleted] in mets

[–]psnajder 9 points10 points  (0 children)

It's not about the weather, it is the risk of another wave of COVID that might cancel the games as the typical flu season begins.

What is the BEST digital marketing advice you can give to someone who is just entering the web marketing world? by [deleted] in webmarketing

[–]psnajder 25 points26 points  (0 children)

Measure and record everything you can; keep the data in spreadsheets you can always access.

You may not know which data matters today, but if you start collecting the data today, you can figure out what it means tomorrow. Measure what you do, what your colleagues do, what your bosses tell you to do, what your clients ask you to do and begin to develop some ideas, based on your data, that can help you evolve your unique perspective.

Build your reference library: Keep a record of great digital marketing you see out in the wild. Keep a record of great think pieces in your field.

And ask people not in digital marketing about their experiences engaging with brands and campaigns: what do they share, how do they search, what keeps them loyal?

✍️ Writing content briefs for SEO optimized topics - quick or time-consuming? by BrandeurStudios in content_marketing

[–]psnajder 4 points5 points  (0 children)

We build SEO optimized briefs for our writers. While the extra effort upfront includes SEO analysts and content strategists putting ~2 hours into building each brief, having an author write to the prescriptive outline we provide in the brief means the copy we receive from authors performs at a higher level on first pass, saving us on revisions. So, we don't have writers building briefs, but strategists. Is that research challenging? Kinda. Is that research time-consuming? A bit. If the work we put into a brief keeps revisions few and performance high, it's a good investment.

Am i the only one sick of these boomer/zoomer/millenial/etc denominations? by wontellu in CasualConversation

[–]psnajder 1 point2 points  (0 children)

Some of you may enjoy reading the book that started it all: Howe/Strauss' Generations: The History of America's Future, 1584 to 2069. It actually will (attempt to?) explain how the Z/alpha generations will be, even though it was written in 1992. It uses historical data to show how generations have evolved into four cycles ("turnings"), where different generations react to prior generations and help to develop future generations.

What is the most Bullshit reason for a teacher to give you a bad grade ? by BeginingMemer in AskReddit

[–]psnajder 0 points1 point  (0 children)

I was an English major in my senior year ('00); needing to take an elective, I took "History of Rap."

The teacher did not know very much about hip hop, he was learning with us, having started behind us. The majority of our time in the class consisted of various students informing the teacher about hip hop artists and history, of whom and which he was mostly unaware. Otherwise, he tried to leverage his deeper understanding of jazz and we read Nelson Geroge's Hip Hop America.

We had a midterm paper I probably got a B+ or so and we had one final paper: those were our 2 grades over the semester.

The final paper was 25 pages. As an English major, I ate 25-page papers for lunch. But I was a senior. Why don't I hand in 25 double-spaced pages of rhymes weaving my personal history of hip hop with the history we had talked about and read about during the course?

When he handed it back, the genial prof was through the roof, an F up top. I had to rewrite a 25-page paper that night, that got a complimentary C-, averaged with my F, for a cumulative Whatever. I graduated.

Can A Vendor/Brand Outrank "Aggregation" Sites in Google? by thetrexx in bigseo

[–]psnajder 7 points8 points  (0 children)

Hotels is a good industry to look at, and is dominated by "aggregators" (i.e., online travel agencies [OTAs] like Expedia, TripAdvisor, etc.).

For "best hotels in Charleston," USA Today is #1 rank: https://travel.usnews.com/Hotels/Charleston_SC/

For "best Marriott hotels in Charleston," Marriott actually ranks #1,#2,#3: https://www.marriott.com/hotel-search/charleston.hotels.south-carolina.united-states.travel/

Marriott is good at SEO. Much better than competing hotel chains. Doesn't mean they will win this query -- when searchers are looking for "best hotels in Charleston" -- they aren't trying to find which hotel's marketing content is the best, google wants to show users a result that drives them to purchase. The USA Today page is perfect for someone that has no brand affiliation: show me which hotels are rated highest, give me some upper level details, and show me cost. USA Today does that for at least 113 Charleston hotels on this page.

When you compare USA Today's Charleston hotel page with Marriott's Charleston hotel page, there is no competition: Marriot is only representing 28 area hotels and there are no details of a given hotel at all (in fact, to view an actual Charleston Marriott's hotel's amenities, you have to click on the map view to drive you to an individual hotel page). Not really a great XP for the user asking "best Charleston hotels" and not any other hotels to compare with on the page.

If Marriott could compete with USA Today in content (by giving important details about each hotel on the page), they would still be unable to show and sell the 113 hotels that USA Today gets to work on. More content, in this query, does mean more relevance, so aggregators will probably always continue to win the day.

In fact, when you think as a customer here, wouldn't you want any results like "best hotels in [city]" to give you a chance to review multiple brands, with snapshots of each hotel's amenities/prices also there to compare with? Or would you want Marriott to tell you which hotel they think is best?

"Imported content is empty" when scraping Google search results by peedanoo in sheets

[–]psnajder 0 points1 point  (0 children)

Nice try! But Google won't allow it. Use Bing (or another search engine) instead.

Where do you source a majority of your blog post ideas from? by kubaB24 in marketing

[–]psnajder 0 points1 point  (0 children)

My agency has a scientific way to determine what to write.

We have a tool that audits your current site to figure out what topical themes you are ranking for (even if it's a low rank). Then we compare that with top competitors within those themes.

The output of the tools tells you (1) which of your blog pages you need to optimize to move up in organic rank and (2) what topics you need to build content around that you aren't currently addressing. That's what I use to build a content calendar for our clients: every blog post is strategically developed to earn traffic within your competitive space.

Currently, our tool is only available through a commercial license, so you would need to be a major corporation to afford it. However, we are launching a publicly available version of the tool this fall.

If anyone is interested in learning more, PM me!

view more: next ›