How to bulk export Merchant Listings data from Google Search Console via Analytics Edge in Excel

Don’t settee for the 1 1000 enactment bounds successful GSC. In this tutorial, I explicate however to get each of your Merchant Listings information from GSC, portion covering immoderate different ideas for moving with the information via Analytics Edge.

Merchant Listings tin beryllium incredibly almighty for ecommerce retailers. They are escaped merchandise listings that amusement up often successful a ‘product grid’ successful the SERPs. Clicking each merchant listing triggers a merchandise paper and enables you to presumption photos, reviews, and different accusation related to a product. And of course, you tin click done to presumption and acquisition the merchandise from a website. You tin work much astir Merchant Listings from Google successful their documentation.

Here is an illustration of Merchant Listings successful the SERPs:

And erstwhile you click a Merchant Listing, it triggers a merchandise paper with much information:

How to find the close hunt quality code:

1. Fire up Excel, click the Analytics Edge tab successful the apical menu.

2. Then click Connector Wizards, prime Google Search, and past Search Analytics.

3. Then take the spot you privation to export information from successful the Accounts tab. Note, you tin enactment with domain properties via Analytics Edge. You volition spot them astatine the bottommost of your spot list.

4. Click the Fields tab and adhd searchAppearance to the “Selected Dimensions”.

5. Then click the Dates tab and prime the day scope you privation to review. Again, we are conscionable getting the Search Appearance codes successful this step, truthful prime a day scope wherever you privation to spot the assorted hunt quality options during that time. You tin prime the past 3 oregon 6 months.

6. Then click OK. Once you tin spot the information held successful representation (in green), you tin constitute that to a worksheet to presumption the hunt quality codes.

7. If you’re an ecommerce retailer, and had products ranking successful Merchant Listings, you volition spot the codification MERCHANT_LISTINGS successful the list. That’s what we privation to usage for consequent queries successful Analytics Edge.

Now that we person the hunt quality codification for Merchant Listings, let’s bulk export the information from GSC utilizing that code. For this example, let’s export Merchant Listings information for the past 3 months.

How to bulk export Merchant Listings information with the hunt quality codification you conscionable discovered:

1. In Excel, archetypal click the Analytics Edge menu. Next, make a caller macro truthful you tin prevention this query (or bid of queries) for aboriginal use. Click the dropdown arrow and prime “new macro”. Then sanction it immoderate you want.

2. Next, click Connector Wizards, prime Google Search, and past Search Analytics.

2. Then prime a spot successful the Accounts tab successful bid to export Merchant Listings information for that property. Again, you tin usage a domain spot (it’s conscionable astatine the bottommost of the database successful Analytics Edge).

3. Then click the Fields tab and adhd the leafage magnitude truthful you tin export each landing pages that are showing up arsenic Merchant Listings successful the SERPs.

4. Click the Filters tab and find the Appearance field. This is wherever you privation to participate MERCHANT_LISTINGS, which is the hunt quality codification we discovered earlier.

5. Then click the Dates tab and prime the day range, which is “Last 3 Months” for this tutorial.

6. I similar to benignant the information by clicks oregon impressions successful descending order. For this example, usage the driblet down and prime “Clicks” and past click “Descending” for the order.

7. Then click OK to export the data. Analytics Edge volition export the information and amusement a illustration successful greenish (the information is held successful memory). To constitute each of the information to a worksheet, click “File” and the “Write to Worksheet”.  

Congratulations! You person exported each of the landing pages that were ranking successful Merchant Listings successful the SERPs (and you went beyond the 1 1000 enactment bounds from the GSC UI). Also, you created a macro that tin beryllium reused astatine immoderate clip to rapidly export Merchant Listings information for that property. This is wherefore the API is truthful important and wherefore Analytics Edge is specified a large tool. You tin conscionable reopen the spreadsheet, unfastened the Task Pane, and tally the query again.

Getting Creative: More Analytics Edge reports you tin tally for Merchant Listings:
It’s large you exported each of the merchandise pages that were ranking successful Merchant Listings, but there’s much you tin bash with Analytics Edge. Below are a fewer ideas:

• Segment the landing leafage information connected the alert by class oregon directory. You tin work my tutorial for creating smart delta reports to recognize however to bash that via Analytics Edge.
• Export the queries yielding Merchant Listings for your site.
• Export some the queries and landing pages unneurotic for Merchant Listings. Note, much information whitethorn beryllium filtered erstwhile you tally this query, but it’s a large study showing some the queries and landing pages together. Just usage a pivot array to signifier the information better.
• Run a delta report aft a large algorithm update to spot the assistance oregon driblet by landing leafage oregon query. Since you are utilizing the hunt quality for Merchant Listings, you volition lone spot that information (isolating however an algorithm update mightiness person impacted Merchant Listings.)
• Check the indexing presumption for important merchandise pages! You tin travel my tutorial for creating an indexing monitoring system to cheque the scale presumption for pages that were ranking successful Merchant Listings. You decidedly privation to cognize if immoderate get deindexed for immoderate crushed (either by mistake, oregon by Google’s choice).