Gather competitor URLs utilizing Moz Web site Crawl or a sitemap export. Subsequent, import the URLs into Google Sheets and apply the identical GPT formulation used to your website.
=GPT("Based mostly on the string supplied, assign it to one among 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 title in a concise type, with none extra 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 title, with none prefix or quotes. Now, analyze this string: '" & A2) It categorized every competitor web page into themes like Canine Well being, Canine Recipes, and Seasonality/Occasions.
Rely content material by theme
When you’ve tagged the competitor’s content material, rely what number of articles they’ve for every theme utilizing 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 wish to rely, like Canine Well being
It gave me a fast rely of what number of pages every competitor had beneath every theme, highlighting the place they have been extra lively than Pooch & Mutt.
Spotlight content material gaps
With each datasets facet by facet, I may simply spot content material gaps. For instance, tails.com had extra content material on canine vitamin and seasonal canine care, whereas Pooch & Mutt lacked in these areas.
Gather competitor URLs utilizing Moz Web site Crawl or a sitemap export. Subsequent, import the URLs into Google Sheets and apply the identical GPT formulation used to your website.
=GPT("Based mostly on the string supplied, assign it to one among 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 title in a concise type, with none extra 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 title, with none prefix or quotes. Now, analyze this string: '" & A2) It categorized every competitor web page into themes like Canine Well being, Canine Recipes, and Seasonality/Occasions.
Rely content material by theme
When you’ve tagged the competitor’s content material, rely what number of articles they’ve for every theme utilizing 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 wish to rely, like Canine Well being
It gave me a fast rely of what number of pages every competitor had beneath every theme, highlighting the place they have been extra lively than Pooch & Mutt.
Spotlight content material gaps
With each datasets facet by facet, I may simply spot content material gaps. For instance, tails.com had extra content material on canine vitamin and seasonal canine care, whereas Pooch & Mutt lacked in these areas.
