Keeping your feeds up-to-date is vital when running Google Shopping ads for your Shopify store. Here are some of the most important metrics you need:
- Accurate, detailed product titles that include brand, model, key features, and specifications - directly impact click-through rates and relevance.
- High-quality product images showing items clearly from multiple angles on white backgrounds.
- Inventory accuracy - prevent showing out-of-stock items or incorrect availability.
- Price competitiveness - maintain accurate pricing as market conditions change.
- Feed quality score - Google rewards frequently updated, accurate product data with better visibility.
- Compliance - ensure adherence to Google’s policies and category-specific requirements.
Outdated Shopping feeds risk account suspension, lost sales, and poor ad performance. Daily updates are recommended for most merchants, something you can maintain easily with Mixtable’s Google Shopping template in a spreadsheet format.
- After installing the Mixtable Spreadsheet Editor app, click the Create a Workbook button.
- Select the Google Shopping pre-built template from the list that appears in the dialog.
The Google Shopping template contains the following default columns:
- Product Title
- Age
- Google product category
- Condition
- This is a custom product
- Manufacturer Part Number (MPN)
- Gender
- Color
- Material
- Size, Size system, and Size type
- Unit pricing measure and Unit pricing measure unit
- Unit pricing base measure and Unit pricing base measure unit
- Custom Label (0-4)
- If there are fields with missing data in the worksheet, make sure you fill them in and keep them up to date.
- This will ensure your Google Shopping ads run uninterrupted and generate the traffic you need.
- Click on the (+) button in the worksheet ribbon at your screen’s bottom.
- From the 1. What type of worksheet would you like to add? window, choose Shopify data worksheet.
- Then select the Products - Complete (with Variants) option.
- This worksheet will load Product variant details, including Pricing information and Inventory data for the different warehouses you have in Shopify:
- From this worksheet, you can make sure your price is competitive and your inventory is accurate.
- In a similar way, you can pull the Product Images worksheet and check if your images are compatible with Google’s requirements.
Operating in the Mixtable Spreadsheet Editor app allows you to use any spreadsheet function to analyze and manage your data, such as:
Find out more about the Mixtable suite of products here.
