How to use PageSpeed Insights reports in your Pitchlane videos
PageSpeed Insights can be a very useful page background to use for SEO and Web Development campaigns.
To use PageSpeed Insights, you'll need to add a columns to the CSV you upload to Pitchlane, that contains the PageSpeed Insights URL. It should have the following format:
https://pagespeed.web.dev/analysis?url=<urlencoded website URL>
Formula
You can use the following formula to create the URLs in your lead list spreadsheets.
If you're using Google Sheets:
=CONCATENATE("https://pagespeed.web.dev/analysis?url=", ENCODEURI(A2))
If you're using Excel:
=CONCATENATE("https://pagespeed.web.dev/analysis?url=", ENCODEURL(A2))
You just need to replace A2
with the cell that has your prospects' Website URLs.
When importing your leads into Pitchlane, select the new column with the PageSpeed Insights URLs for the page where you want PageSpeed Insights pages to show up.