• Juliana Hughes

    Super informative. Thank you for your thoroughness!

  • Steven Plimmer

    That’s a good way of doing it. Or you could add the match type column in the UI before downloading then add the “raw” keyword column and use this formula:
    =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C35,””””,””),”[",""),"]“,””),”+”,””),”-”,””)

    Where B2 is the original keyword cell. Then you fill the column with this formula.

    Save this file so you can reuse either the formula or the file (to paste data into).

    If you don’t have the match type column for some reason, this formula will do it (in a column you add for match type):
    =IFERROR(IFERROR(IF(LEFT(B2,1)=”[“,”Exact”,IF(LEFT(B2,1)=CHAR(34),”Phrase”, “Broad”)),IF(LEFT(B2,1)=CHAR(34),”Phrase”, “Broad”)),”Broad”)

    The above is if you don’t want to specify Modified Broad and if you have no negatives.

  • http://www.facebook.com/konradhagemes Konrad Hagemes

    Jep that’s cool but there is a small mistake in the code of the first two functions at the beginning:

    wrong:
    Public Function GetMatchTypeFromPowerPostKeyword

    (ByVal kwd As String) As String
    Dim mt As String
    mt = “”…
    correctly:Public Function GetMatchTypeFromPowerPostKeyword(ByVal kwd As String)
    Dim mt As String
    mt = “”…

    wrong:Public Function GetKeywordFromPowerPostKeyword
    (ByVal kwd As String) As String
    If (0 = Len(kwd)) Then…
    correctly:Public Function GetKeywordFromPowerPostKeyword(ByVal kwd As String)
    If (0 = Len(kwd)) Then…