--000000000000a4c4dd0617577585 Content-Type: multipart/alternative; boundary="000000000000a4c4dc0617577584" --000000000000a4c4dc0617577584 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable This is great, thank you so much! I will review it tomorrow. On Tue, Apr 30, 2024 at 2:14=E2=80=AFPM Arshdeep Brar wrote: > Hey Alexa, > > > The keyword optimization and ramp-up are done. Please use the linked belo= w > google sheet for all the finer details for each keyword market and analys= is > breakdown. > > The full analysis can be segmented into two parts: > > 1.) Search term intent analysis=E2=80=94This is done for all the search t= erms in > the new account for each market that had impressions>3. Here, I have > individually analyzed each search term, looking at its intent and meaning= , > and categorized it into 6 categories based on different colours. > The analysis details can be found in the second last sheet in the shared > spreadsheet. and Based on that the individual results for markets for > keywords to be added can be found in separate tabs/sheets in this > spreadsheet. All the resulting negatives can also be found in the one > sheet titled - "final negatives - all markets" > action level of surety color > to be added as keywords because of the context 100% > Can be added into keywords because lead to a conversion 60 > can be added in keywords 60 > can be added in keywords 30-50 > not sure at all 0 > can be added in to negatives 30-50 > Can be added as negative because of poor performance 60 > Can be added as negative because of context 60 > to be added as negative 100 - red > 2.) Cost analysis:- this is done based on the cut-off rules that we had > for each market during our last analysis. The results of this and details > can be found in the sheet named: "Keyword Cost Analysis and Results". We > are pausing the ones in red and orange and keeping enabled the ones in > green and blue. All the updates are also being labelled as well with Apri= l > labels as detailed for each keyword. > > Impressions clicks cost > Vancouver 175 16 87.7 > Toronto 140 12 85 > Calgary 250 25 115 > Winnipeg 115 16.25 94.9 > Waterloo 364 30.85 170 > Mississauga 467 30.89 163.81 > max CPA after first conv with no opportunity or soc - based on average > cost per conv of status as good, total cost no more than $750 - based on = a > little more than average of the ones in good, 7 conv max cpa for after > 1st opp but not second - here we have a range and will also use other > metrics to support final desision - the main range is based on lower max > values of cpa in values for good status, total liflime cost not more than > $1000 , numbert of conv not more than 5 conv max cpa for multiple opp - > not sure what it should be, of if there should be any ? not decided yet > 200 - 250 200 - 250 > 200 - 250 200 - 250 > 200 - 250 200 - 250 > 200 - 250 200 - 250 > 200 - 250 200 - 250 > 200 - 250 200 - 250 > > > https://docs.google.com/spreadsheet