Acquire competitor URLs the use of Moz Site Crawl or a sitemap export. Subsequent, import the URLs into Google Sheets and observe the similar GPT formulation used on your website online.
=GPT("In accordance with the string equipped, assign it to this type of topics:
'Canine Well being',
'Canine Recipes',
'Canine Habits',
'Canine Breed',
'Seasonality/Occasions',
'OTHER',
Use the examples as a information however go back best the theme title in a concise shape, 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 best the theme title, with none prefix or quotes. Now, analyze this string: '" & A2) It labeled each and every competitor web page into topics like Canine Well being, Canine Recipes, and Seasonality/Occasions.
Depend content material by way of theme
While you’ve tagged the competitor’s content material, rely what number of articles they have got for each and every theme the use of this formulation in Google Sheets:
COUNTIF(C:C, G4)
On this formulation:
- C:C is the competitor’s theme column
- G4 is the precise theme you need to rely, like Canine Well being
It gave me a snappy rely of what number of pages each and every competitor had beneath each and every theme, highlighting the place they had been extra energetic than Pooch & Mutt.
Spotlight content material gaps
With each datasets aspect by way of aspect, I may just simply spot content gaps. As an example, tails.com had extra content material on canine diet and seasonal canine care, whilst Pooch & Mutt lacked in the ones spaces.
