Acquire competitor URLs utilizing MOZ Sitecrawl or Sitemap Export. Subsequent, import the URL into Google Sheets and apply the identical GPT expression used to your website.
=GPT("Based mostly on the string offered, assign it to one in all these themes:
'Canine Well being',
'Canine Recipes',
'Canine Conduct',
'Canine Breed',
'Seasonality/Occasions',
'OTHER',
Use the examples as a information however return solely the theme identify in a concise type, with none further textual content. Examples:
nString: 'overweight-dogs' - Theme: 'Canine Well being'
nString: 'chihuahua' - Theme: 'Canine Breed'
nString: 'how-to-help-a-hyper-nervous-badly-behaved-dog' Theme: 'Canine Behaviour'
nString: 'how-can-i-encourage-my-fussy-dog-to-eat' - Theme: 'Canine Behaviour'
. Output solely the theme identify, with none prefix or quotes. Now, analyze this string: '" & A2) Every competitor’s web page has been categorized into the next themes Canine Well being, Canine Recipes, and Seasonality/Occasions.
Depend content material by theme
As soon as you’ve got tagged your competitor’s content material, use this method in Google Sheets to depend a number of articles for every theme.
countif (c:c, G4)
With this method:
- C:c Competitor theme column
- G4 It is a particular theme you need to depend Canine well being
Every competitor briefly defined what number of pages below every theme, highlighting extra lively places than Pooch & Mutt.
Spotlight content material gaps
With each datasets lined up, it was simple to seek out content material gaps. For instance, Tails.com had extra content material on canine diet and seasonal canine care, whereas Pooch & Mutt was missing in these areas.
