Prompt Template: Keyword List Categorization for PPC/SEO Objective:
Analyze the provided raw keyword list and categorize the keywords into three distinct groups for a digital marketing campaign: "Branded," "Money/Primary," and "Longtail." The categorization should follow the specific logic and definitions outlined below.
User-Provided Information:
[Business Name]: The name of my company. [Core Services]: A list of the primary products or services my business offers (e.g., digital marketing, SEO, plumbing, roof repair, coffee roasting). [Primary Location]: The main city, state, or region my business serves (e.g., Sydney NSW, Austin TX, London UK). [Confusing Brand Name (if any)]: The name of another well-known company that shares a similar name and causes brand confusion in search results (e.g., a major retailer). If not applicable, state "None." [Raw Keyword List]: The raw, unformatted list of keywords and their search volumes, copied from a tool like PRIMARILY Google Business Profile performance data, Google Keyword Planner, SEMrush, etc.
Your Tasks:
Based on the information above, perform the following steps to create three distinct keyword lists. Create the "Branded" Keyword List:
Definition: These are keywords where the searcher is explicitly looking for [Business Name].
Action:
Identify all keywords from the [Raw Keyword List] that contain [Business Name]. Generate additional variations that are not on the list but are highly likely searches. These should include:
The exact business name ([Business Name]).
Common misspellings or alternative spacing (e.g., "businessname," "business name"). Combinations with the location ([Business Name] [Primary Location]). Combinations with core services ([Business Name] [Core Service]).
Action-oriented queries ([Business Name] reviews, [Business Name] contact).
Create the "Money/Primary" Keyword List:
Definition: These are the most valuable, high-commercial-intent, non-branded keywords. They directly relate to the [Core Services] and indicate a user is ready to purchase or inquire.
Action:
From the [Raw Keyword List], select the top 5-15 keywords that best represent the [Core Services] combined with the [Primary Location]. Prioritize keywords with strong commercial intent (e.g., "agency," "services," "company," "packages," "near me") and significant search volume. Do not include any branded keywords in this list.
Create the "Longtail" Keyword List:
Definition: This is a comprehensive, broad-match category. It serves as a catch-all for lower-intent service queries, discovery campaigns, and keywords to be bid on cautiously or used as negatives. Attempting to create 100 longtail keywords in total.
Action: Compile a single list containing all of the following:
All Service Keywords: Include every non-branded keyword related to your [Core Services], including those already on the "Money/Primary" list. Confusing Brand Keywords: If a [Confusing Brand Name] was provided, include every keyword from the raw list that mentions it, including misspellings and location-based variations. Broad/Vague Terms: Include generic, single-word keywords from the list (e.g., "digital," "google," "fabric").
Irrelevant Local Searches: Include all keywords for unrelated businesses or locations found in the raw list (e.g., "ikea," "woolworths," "glebe markets"). All Remaining Keywords: Include any other keywords from the [Raw Keyword List] that do not fit into the Branded or Money/Primary categories.
Output Format:
Present the final output clearly with the following structure:
Branded [Brief, one-sentence description of the list's purpose.] keyword1, keyword2, keyword3, keyword4
Money/primary keywords [Brief, one-sentence description of the list's purpose.] keyword1, keyword2, keyword3, keyword4
Longtail keywords [Brief, one-sentence description of the list's purpose.] keyword1, keyword2, keyword3, keyword4 All keywords in the final lists must be comma-separated and in lowercase for easy input into marketing platforms.
Keywords for populating prompt: