Hello Chris.

If you're going through the siteaudit, you can't add a URL there - it requires a domain (no http or https, just the domain). In your case ampetronic.com

Hi again Chris

I can't get a lot of data using the free plan on semrush. Can you please send us a screenshot, or a video? wpDataTables that appear on front-end pages are crawlable by search engines, and the URLs of those pages are definitely visible, so I don't quite understand why semrush sees this as a malformed link.

Does it see the links of the PDF files as malformed?

If it does, it may be true - look at the link below:

How is this table created? Can you edit the links?

Hi again Chris

Please note that this tool is not an ultimate query generator. It simply constructs a suggestion of a query. We are constantly working to improve it, but SQL is such a complicated and flexible language that full automation for constructing queries is next to impossible. Consequently, the more complicated the query, the higher the probability that it will not return exactly what you need. So, you will often need to play around with the resulting query.

Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. 

We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties. 

You can write credentials here just check PRIVATE Reply so nobody can see them except us.

Hi again Chris.

The issue here is because you saved the "Link" column as "URL Link" type column. Those columns accept URLs only, so having this before:

<a href="

And this after the link:

</a>

Makes it appear as this:

<a href="https://www.ampetronic.com/wp-content/uploads/UP4AA02-1-C14-2-Outline-drwg.pdf">C Series 3D models.TCW</a>

This works well if the column is saved as "String", but in that case it is a hyperlink (no button option). The "URL Link" column type expects to see this:

https://www.ampetronic.com/wp-content/uploads/UP4AA02-1-C14-2-Outline-drwg.pdf

Since it sees an anchor tag, it's adding the URL of your site before it, like this:

https://www.ampetronic.com/wp-admin/<a href="https://www.ampetronic.com/wp-content/uploads/UP4AA02-1-C14-2-Outline-drwg.pdf"></a>

This is why it breaks when the column is set to be a URL Link column.

I created a SUPPORT table, where you can see a better query:

SELECT post_title AS resources_post_title,
       CONCAT(am_posts.guid,'||',am_posts.post_title) AS resources_title_with_link_to_post
FROM am_posts
WHERE 1=1 
   AND post_title LIKE '%drawing%'
   AND post_type = 'resources'

It is also saved as a "URL Link" column, and is showing the "Download" button, but since it's structured like this:

https://www.ampetronic.com/wp-content/uploads/UP4AA02-1-C14-2-Outline-drwg.pdf||UP4AA02-1-C14-2-Outline-drwg

The column sees the URL and doesn't add the URL of your site before it.

I made the change to the original table as well, so please run the test on semrush again, and let me know if it reports malformed URLs again (it shouldn't).