Connect with us

MARKETING

Adding STAT Reports to Google Sheets Using App Scripts

Published

on

Adding STAT Reports to Google Sheets Using App Scripts


The author’s views are entirely his or her own (excluding the unlikely event of hypnosis) and may not always reflect the views of Moz.

The team at MacMillan Search has generated a lot of value by combining automated STAT reports with Google Sheets. From adding ranking details to other tool’s outputs, to giving the content teams up-to-date “People Also Ask” reports, the end result has proven to be a great time-saver in our week-to-week SEO workflows by reducing manual work and providing standard outputs that easily integrate with any spreadsheet.

Why did we create this script?

STAT’s wealth of keyword rankings details is very useful for enterprise SEOs to understand both the macro and micro details of their rankings. Google Sheets is one of the most common cloud-based spreadsheets platforms, and is easy to share between teams and organizations. That’s why SEOs use both of these tools regularly when analyzing keyword data.

Despite this, documentation on how to integrate STAT into Google Sheets is limited. To address this gap, we created our own script!

It’s proven useful for several reasons:

  1. Not everyone likes CSVs: We leverage the STAT reports to provide clients with direction. Having to download a CSV and open it every week isn’t for everyone. With this script, you can set a weekly ticket with a link to the spreadsheet, and review the output regularly.

  2. It saved us time: SEO is a marathon, not a sprint. When we identify an opportunity, there is ongoing work that will have us reviewing reports regularly. The weekly ticket approach to review a spreadsheet shaves some time off of each task, and over the course of the engagement, this saved time adds up.

  3. Cleaner output: Using Vlookups, Uniques, etc., you can create a summary page of this information, highlighting what clients and/or readers care about. You can also integrate this information with other data sources.

  4. Create automation without using an API: Automation, when done correctly, saves time. Using this script with triggers opens the door to automation.

How to implement this script

1) Create a report in STAT

The STAT knowledge base has a great resource on reports. The only thing we would get specific on is the naming of the report and the recipient email.

Naming

What you name your report is not as important as keeping it clear and concise. This makes scaling to other projects with similar reports cleaner and easier. You will also use this report name as one of the variables in the scripts.

We also suggest placing the company or project name at the end of the report name in parentheses (e.g. “(MacMillan Search)”). This makes it easier to find the report in your email.

Recipient email

It’s important to use a Gmail-enabled email for the account where you’ll be building the sheet. This way, Google has an easier time getting the app script to extract the CSV from the email.

Scheduling

For our clients, weekly data is the most useful — enough detail to spot trends, but not so much that it becomes just noise to be ignored. For reports with limited fluctuations (e.g. People Also Ask), monthly might be satisfactory.

Timing

Select “Run this report immediately” to confirm that your report works, right after creating the script. This way, you’re ready to set your triggers and let the data flow.

The rest of the settings are specific to what details you want from your report.

2) Create a Google Sheet and add the script

Create a new sheet in Google Drive under the account associated with your report’s recipient email. Then you’re ready to add the script:

1. Under the menu “Tools”, select “<> Script editor”

2. Paste the script below into the “Script editor”.

3. A few things will need to be edited to work with your data:

  • var COMPANY_NAME updated to the company or project name you used while creating the STAT Report

  • var REPORT_NAME updated to the name of your report minus the company name and parentheses

  • var SHEET_NAME updated to the name of the sheet in the spreadsheet

4. Confirm the Script works by saving it, refreshing the sheet, and when the menu “Manual Update” loads, select “Import Keywords”.

5. The first time you run this you will get an “Authorization Required” pop-up:

Select “Continue”, follow the steps, and select “Import Keywords” under the menu again.

Your spreadsheet should now be populated with all of the details from your CSV.

3) Automate the population with triggers

Setting this sheet up to automatically update as the report comes out is very easy using Apps Script “Triggers”. To set up the triggers:

1. Go back into the “Script Editor”

2. Select the “alarm” icon “Triggers”

    3. Select “Add Trigger”

    4. Select the function “importKws”

    5. Select event source “Time-driven”

    6. Select type of time-based trigger “Week Timer” for weekly reports, “Month Timer” for monthly reports, etc.

    7. In our time zone, our reports usually come out late Sunday, so we pick early Monday morning:

    8. Click “Save”

      The result is a spreadsheet that regularly updates, populated by an emailed STAT report.

      We’ve found many uses for this script — anywhere we reference rank. And, since a project might take time to get implemented, we can provide current ranking information without leveraging the API.

      We’re curious to learn how you leverage it as well. If you find the script useful, reach out to us on LinkedIn and let us know what you’re using it for.



Source link

MARKETING

What to Consider When Choosing a Brand Ambassador for Your Social Media Campaign

Published

on

What to Consider When Choosing a Brand Ambassador for Your Social Media Campaign

Want to maximize the potential of your social media campaign? Then you must ensure to choose the right brand ambassador for the job. Having a good ambassador will increase your social media reach and boost sales. But, selecting the best ambassador can be tricky.

This guide will show you the key steps to consider when selecting the perfect brand ambassador for your social media campaign. From assessing their influence to ensuring their content matches your brand’s mission. This guide will give you the insights you need to make the right decision.

Understanding the role of a brand ambassador

A brand ambassador acts as a company representative, promoting the brand’s products to a specific audience. They are selected for their influence and ability to communicate the brand’s message. Their primary goal is to increase brand awareness and engagement with the audience.

To achieve this, an ambassador shares the brand’s message and builds connections with the target audience. They help to establish trust and credibility for the brand by personally endorsing it through their own experiences. Also, they provide valuable feedback to the company, allowing for product improvements.

Tips for choosing the right ambassador for your social media campaign

1) Assess the credibility and influence of potential ambassadors.

One of the first steps is to ensure they have a very active social media presence. Make sure they have many followers and a high engagement rate. Check the number of followers they have and the type of posts they share. This will give you a good idea of the content they generate and let you know if they are a good fit for your campaign.

Make sure their posts are relevant and appropriate for your brand. If their content is not a good fit, you may want to reconsider hiring them for your campaign. This is important if your brand has a particular message you wish to convey to your audience. If their content is not in line with your brand’s values, it could have a negative effect on your brand’s image.

2) Analyze the compatibility between the ambassador’s content and your brand’s mission.

It’s common to think that a famous ambassador would be a good fit for your campaign. But if their content is not in line with your brand, they are not an option. You may want to go further and check the interaction between their posts and followers. If the interaction is very high and followers actively participate, this is a good indicator of the quality of the ambassador. This will show how much impact the ambassador has among their followers. The interaction of the followers with the ambassador’s posts is important, as it is a good way for them to get to know your brand better.

3) Make sure the ambassador is present on the right social networks.

If your brand uses more than one type of social media, you should ensure the ambassador is present on them. You can choose an ambassador who is active on most of the major social networks. But, you must ensure they have an appropriate presence on each platform.

For example, it may not be a good idea to select an ambassador who is primarily active on Instagram for a Facebook-centric campaign. Remember that followers on each platform are different, and it’s important to reach your desired audience. If the ambassador you choose is present on the right social media platform, it will be easier for them to reach your audience.

4) Set expectations and establish the terms of the partnership.

Once you have selected an ambassador and they have agreed to collaborate with your brand, set the terms of the collaboration. Set clear expectations and tell the ambassador precisely what you want them to do. This includes specifying the type of content that should be posted. It is also important to outline the kind of connection that should be fostered between their followers and your company.

Also, be sure to establish payment terms and any other essential partnership details. For example, if you want the ambassador to promote your brand at a specific event, let them know so they can prepare.

5) Consider brand ambassadors who have experience participating in events.

A brand ambassador with experience working at events and comfortable interacting with customers can be a valuable asset to your campaign. They will be able to promote your brand and products at events and help to build a positive image for your company.

Find a brand ambassador who is professional and comfortable in a high-energy environment. This will ensure they can effectively represent your brand and engage with customers at events. Hire an event staffing agency to ensure the event runs smoothly and let brand ambassadors focus on promoting the brand and connecting with the audience.

6) Complete the selection and onboarding process

Make sure you select an available ambassador with the right skills for your campaign. Verify that the ambassador’s availability matches your campaign schedule.

It’s a good idea to start interacting with the ambassador on social media. It will help you establish a strong relationship, making promoting your brand more accessible. Show the audience that they have rallied behind your brand and thank them for their support.

7) Follow-up and evaluation of the ambassador’s success

Once the campaign is over, follow up with the ambassador to test its success. Ask the ambassador if your promotion has been effective and get their feedback on the campaign. This is an excellent way to improve your campaign the next time you run it. It will also help you identify areas where you can improve your social media strategy.

You can test the success of your social media campaign by looking at three main factors: reach, engagement, and conversions. By considering these factors, you can determine the success of your social media campaign. Also, you can identify any areas that need improvement.

Conclusion

Brands use brand ambassadors to increase engagement and sales of their products. An ambassador has a large following and regularly interacts with your audience. When selecting an ambassador, consider factors such as their social media presence and the ability to communicate your brand’s message. Taking the time to choose the proper brand ambassador will ensure the success of your social media campaign.

Source link

Continue Reading

MARKETING

Content Operations Framework: How To Build One

Published

on

Content Operations Framework: How To Build One

More and more marketers of all ilk – inbound, outbound, social, digital, content, brand – are asked to add content operations to their list of responsibilities.

You must get your arms around:

  • Who is involved (and, I mean, every who) in content creation
  • How content is created
  • What content is created by whom
  • Where content is conceived, created, and stored
  • When and how long it takes for content to happen
  • Why content is created (the driving forces behind content creation)
  • What kinds of content does the audience want
  • How to build a framework to bring order and structure to all of this

The evolving expectations mean content marketers can no longer focus only on the output of their efforts. They must now also consider, construct, implement, and administer the framework for content operations within their organizations.

#Content marketers can no longer focus solely on the output. It’s time to add content ops to the mix, says @CathyMcKnight via @CMIContent. Click To Tweet

What exactly are content operations?

Content operations are the big-picture view of everything content-related within your organization, from strategy to creation, governance to effectiveness measurement, and ideation to content management. All too frequently at the companies – large and small – we consult with at The Content Advisory, content operations are left to evolve/happen in an organic fashion.

Teams say formal content operations aren’t necessary because “things are working just fine.”

Translation: Nobody wants the task of getting everyone aligned. No one wants to deal with multiple teams’ rationale for why the way they do things is the right/best/only way to do it. So, content teams just go on saying everything is fine.

News flash – it’s not.

It’s not just about who does what when with content.

Done right, content operations enable efficacy and efficiency of processes, people, technologies, and cost. Content ops are essential for strategic planning, creation, management, and analysis for all content types across all channels (paid, earned, owned) and across the enterprise from ideation to archive.

A formal, documented, enforced content operation framework powers and empowers a brand’s ability to deliver the best possible customer experiences throughout the audiences’ journeys.

A documented, enforced #ContentOperations framework powers a brand’s ability to deliver the best possible experiences, says @CathyMcKnight via @CMIContent. Click To Tweet

It doesn’t have to be as daunting as it sounds.

What holds many content, administrative, and marketing teams back from embracing a formal content operations strategy and framework is one of the biggest, most challenging questions for anything new: “Where do we start?”

Here’s some help in high-level, easy-to-follow steps.

1. Articulate the purpose of content

Purpose is why the team does what it does. It’s the raison d’etre and inspiration for everything that follows. In terms of content, it drives all content efforts and should be the first question asked every time content is created or updated. Think of it as the guiding star for all content efforts.

In Start With Why, author Simon Sinek says it succinctly: “All organizations start with WHY, but only the great ones keep their WHY clear year after year.”

All organizations start with WHY, but only the great ones keep their WHY clear year after year, says @SimonSinek via @CathyMcKnight and @CMIContent. Click To Tweet

2. Define the content mission

Once the purpose of the teams’ content efforts is clear (and approved), it’s time to define your content mission. Is your content’s mission to attract recruits? Build brand advocacy? Deepen relationships with customers? Do you have buy-in from the organization, particularly the C-suite? This is not about identifying what assets will be created.

Can you talk about your mission with clarity? Have you created a unique voice or value proposition? Does it align with or directly support a higher, corporate-level objective and/or message? Hint: It should.

Answering all those questions solidifies your content mission.


ADVERTISEMENT

The marketer’s field manual to content operations

A hands-on primer for marketers to upgrade their content production process – by completing a self-audit and following our step-by-step best practices. Get the e-book.


3. Set and monitor a few core objectives and key results

Once your content mission is in place, it is time to set out how to determine success.

Content assets are called assets for a reason; they possess real value and contribute to the profitability of your business. Accordingly, you need to measure their efficacy. One of the best ways is to set OKRs – objectives and key results. OKRs are an effective goal-setting and leadership tool for communicating objectives and milestones to achieve them.

OKRs typically identify the objective – an overall business goal to achieve – and three to five key quantifiable, objective, measurable outcomes. Finally, establish checkpoints to ensure the ultimate objective is reached.

Let’s say you set an objective to implement an enterprise content calendar and collaboration tool. Key results to track might include:

  • Documenting user and technical requirements
  • Researching, demonstrating, and selecting a tool
  • Implementing and rolling out the tool.

You would keep tabs on elements/initiatives, such as securing budget and approvals, defining requirements, working through procurement, and so on.

One more thing: Make sure OKRs are verifiable by defining the source and metric that will provide the quantifiable, measurable result.

Make sure objectives and key results are verifiable by defining source and metric, says @CathyMcKnight via @CMIContent. Click To Tweet

4. Organize your content operations team

With the OKRs set, you need people to get the work done. What does the structure look like? Who reports to whom?

Will you use a centralized command-and-control approach, a decentralized but-supported structure, or something in between? The team structure and organization must work within the construct and culture of the larger organization.

Here’s a sample organizational chart we at TCA developed for a Fortune 50 firm. At the top is the content function before it diverges into two paths – one for brand communications and one for a content center of excellence.

Under brand communications is each brand or line of business followed by these jointly connected teams: content – marcom, social/digital content development and management, center of excellence content – creative leader, center of excellence PR/media relations, customer relationship management, and social advertising.

Under the content center of excellence is the director of content strategy, manager of content traffic, projects, and planning, digital asset operations manager, audience manager, social channel and content specialist, creative manager, content performance and agility specialist, and program specialist.

Click to enlarge

5. Formalize a governance model

No matter how the operational framework is built, you need a governance model. Governance ensures your content operations follow agreed-upon goals, objectives, and standards.

Get a senior-management advocate – ideally someone from the C-suite – to preside over setting up your governance structure. That’s the only way to get recognition and budget.

To stay connected to the organization and its content needs, you should have an editorial advisory group – also called an editorial board, content committee, or keeper of the content keys. This group should include representatives from all the functional groups in the business that use the content as well as those intricately involved in delivering the content. The group should provide input and oversight and act as touchpoints to the rest of the organization.

Pointing to Simon Sinek again for wisdom here: “Passion alone can’t cut it. For passion to survive, it needs structure. A why without how has little probability of success.”

6. Create efficient processes and workflows

Adherence to the governance model requires a line of sight into all content processes.

How is content generated from start to finish? You may find 27 ways of doing it today. Ideally, your goal would be to have the majority (70% or more) of your content – infographic, advertisement, speech for the CEO, etc. – created the same or in a similar way.

You may need to do some leg work to understand how many ways content is created and published today, including:

  • Who is involved (internal and external resources)
  • How progress is tracked
  • Who the doers and approvers are
  • What happens to the content after it’s completed

Once documented, you can streamline and align these processes into a core workflow, with allowances for outlier and ad-hoc content needs and requests.

This example of a simple approval process for social content (developed for a global, multi-brand CPG company) includes three tiers. The first tier covers the process for a social content request. Tier two shows the process for producing and scheduling the content, and tier three shows the storage and success measurement for that content:

Click to enlarge

7. Deploy the best-fit technology stack

How many tools are you using? Many organizations grow through acquisitions, so they inherit duplicate or overlapping functionality within their content stacks. There might be two or three content management systems (CMS) and several marketing automation platforms.

Do a technology audit, eliminate redundancies, and simplify where possible. Use the inherent capabilities within the content stack to automate where you can. For example, if you run a campaign on the first Monday of every month, deploy technology to automate that process.

The technology to support your content operations framework doesn’t have to be fancy. An Excel spreadsheet is an acceptable starting place and can be one of your most important tools.

The goal is to simplify how content happens. What that looks like can vary greatly between organizations or even between teams within an organization.

Adopting a robust content operations framework requires cultural, technological, and organizational changes. It requires sponsorship from the very top of the organization and adherence to corporate goals at all levels of the organization.

None of it is easy – but the payoff is more than worth it.

Updated from a November 2021 post.

Want more content marketing tips, insights, and examples? Subscribe to workday or weekly emails from CMI.

HANDPICKED RELATED CONTENT:

Cover image by Joseph Kalinowski/Content Marketing Institute



Source link

Continue Reading

MARKETING

SEO Recap: ChatGPT – Moz

Published

on

SEO Recap: ChatGPT - Moz

The author’s views are entirely his or her own (excluding the unlikely event of hypnosis) and may not always reflect the views of Moz.

We’re back with another SEO recap with Tom Capper! As you’ve probably noticed, ChatGPT has taken the search world by storm. But does GPT-3 mean the end of SEO as we know it, or are there ways to incorporate the AI model into our daily work?

Tom tries to tackle this question by demonstrating how he plans to use ChatGPT, along with other natural language processing systems, in his own work.

Be sure to check out the commentary on ChatGPT from our other Moz subject matter experts, Dr. Pete Meyers and Miriam Ellis:

Video Transcription

Hello, I’m Tom Capper from Moz, and today I want to talk about how I’m going to use ChatGPT and NLP, natural language processing apps in general in my day-to-day SEO tasks. This has been a big topic recently. I’ve seen a lot of people tweeting about this. Some people saying SEO is dead. This is the beginning of the end. As always, I think that’s maybe a bit too dramatic, but there are some big ways that this can be useful and that this will affect SEOs in their industry I think.

The first question I want to ask is, “Can we use this instead of Google? Are people going to start using NLP-powered assistants instead of search engines in a big way?”

So just being meta here, I asked ChatGPT to write a song about Google’s search results being ruined by an influx of AI content. This is obviously something that Google themselves is really concerned about, right? They talked about it with the helpful content update. Now I think the fact that we can be concerned about AI content ruining search results suggests there might be some problem with an AI-powered search engine, right?

No, AI powered is maybe the wrong term because, obviously, Google themselves are at some degree AI powered, but I mean pure, AI-written results. So for example, I stole this from a tweet and I’ve credited the account below, but if you ask it, “What is the fastest marine mammal,” the fastest marine mammal is the peregrine falcon. That is not a mammal.

Then it mentions the sailfish, which is not a mammal, and marlin, which is not a mammal. This is a particularly bad result. Whereas if I google this, great, that is an example of a fast mammal. We’re at least on the right track. Similarly, if I’m looking for a specific article on a specific web page, I’ve searched Atlantic article about the declining quality of search results, and even though clearly, if you look at the other information that it surfaces, clearly this has consumed some kind of selection of web pages, it’s refusing to acknowledge that here.

Whereas obviously, if I google that, very easy. I can find what I’m looking for straightaway. So yeah, maybe I’m not going to just replace Google with ChatGPT just yet. What about writing copy though? What about I’m fed up of having to manually write blog posts about content that I want to rank for or that I think my audience want to hear about?

So I’m just going to outsource it to a robot. Well, here’s an example. “Write a blog post about the future of NLP in SEO.” Now, at first glance, this looks okay. But actually, when you look a little bit closer, it’s a bluff. It’s vapid. It doesn’t really use any concrete examples.

It doesn’t really read the room. It doesn’t talk about sort of how our industry might be affected more broadly. It just uses some quick tactical examples. It’s not the worst article you could find. I’m sure if you pulled a teenager off the street who knew nothing about this and asked them to write about it, they would probably produce something worse than this.

But on the other hand, if you saw an article on the Moz blog or on another industry credible source, you’d expect something better than this. So yeah, I don’t think that we’re going to be using ChatGPT as our copywriter right away, but there may be some nuance, which I’ll get to in just a bit. What about writing descriptions though?

I thought this was pretty good. “Write a meta description for my Moz blog post about SEO predictions in 2023.” Now I could do a lot better with the query here. I could tell it what my post is going to be about for starters so that it could write a more specific description. But this is already quite good. It’s the right length for a meta description. It covers the bases.

It’s inviting people to click. It makes it sound exciting. This is pretty good. Now you’d obviously want a human to review these for the factual issues we talked about before. But I think a human plus the AI is going to be more effective here than just the human or at least more time efficient. So that’s a potential use case.

What about ideating copy? So I said that the pure ChatGPT written blog post wasn’t great. But one thing I could do is get it to give me a list of subtopics or subheadings that I might want to include in my own post. So here, although it is not the best blog post in the world, it has covered some topics that I might not have thought about.

So I might want to include those in my own post. So instead of asking it “write a blog post about the future of NLP in SEO,” I could say, “Write a bullet point list of ways NLP might affect SEO.” Then I could steal some of those, if I hadn’t thought of them myself, as potential topics that my own ideation had missed. Similarly you could use that as a copywriter’s brief or something like that, again in addition to human participation.

My favorite use case so far though is coding. So personally, I’m not a developer by trade, but often, like many SEOs, I have to interact with SQL, with JavaScript, with Excel, and these kinds of things. That often results in a lot of googling from first principles for someone less experienced in those areas.

Even experienced coders often find themselves falling back to Stack Overflow and this kind of thing. So here’s an example. “Write an SQL query that extracts all the rows from table2 where column A also exists as a row in table1.” So that’s quite complex. I’ve not really made an effort to make that query very easy to understand, but the result is actually pretty good.

It’s a working piece of SQL with an explanation below. This is much quicker than me figuring this out from first principles, and I can take that myself and work it into something good. So again, this is AI plus human rather than just AI or just human being the most effective. I could get a lot of value out of this, and I definitely will. I think in the future, rather than starting by going to Stack Overflow or googling something where I hope to see a Stack Overflow result, I think I would start just by asking here and then work from there.

That’s all. So that’s how I think I’m going to be using ChatGPT in my day-to-day SEO tasks. I’d love to hear what you’ve got planned. Let me know. Thanks.

Source link

Continue Reading

Trending

en_USEnglish