Help Center Logo Help Center
Contact

Getting Started

Using DataFeedWatch

Accounts and Users

Shops

Internal Fields (Library)

Channels

Mapping Types

Main Mapping Types

Main Mapping Types: Rename

Main Mapping Types: Add static value

Main Mapping Types: Combine

Main Mapping Types: Lookup table (Google Sheets)

Main Mapping Types: Lookup table (Local Drive, CSV)

Main Mapping Types: Extract from (Google Sheets)

Main Mapping Types: Extract from (Local Drive)

Main Mapping Types: Leave empty

Edit Values Types

Conditions

Regular expressions (Regexp)

Mapping Types Overview

Mapping Preview

Feed Review

Marketplaces

Video Tutorials

Other Services

Feed-Based Text Ads

Feed-Based Text Ads FAQ

Feed-Based Text Ads: Why do I still see old data in my campaign?

Feed-Based Text Ads: Can I automate my existing, manual campaigns with Google Text Ads?

Feed-Based Text Ads: Can I combine my existing manual campaigns with Google Text Ads?

Feed-Based Text Ads: How to create better text ads?

Feed-Based Text Ads: What is Permutations & how does it help?

Feed-Based Text Ads: Can I combine different fields into keywords?

Feed-Based Text Ads: Can I set a CPA per product and use that in my Google Search campaign?

Feed-Based Text Ads: What are the campaign limitations?

Feed-Based Text Ads: What are the DSA campaigns based on?

Feed-Based Text Ads: How can I use my pre-existing landing pages in a campaign?

Feed-Based Text Ads: What is the maximum size of the source feed for Google Text Ads?

Feed-Based Text Ads: How does truncating work?

Feed-Based Text Ads: Will Google Text Ads service overwrite manual changes that I make in AdWords?

Feed-Based Text Ads: Can I add other fields to create keywords?

Feed-Based Text Ads: Are there limitations as to the number of ad patterns?

Feed-Based Text Ads: What if I don’t want to lose the history of my existing campaigns?

Feed-Based Text Ads: Can I set a State, Province or Region as a territory?

Feed-Based Text Ads: What happens if the price changes?

Feed-Based Text Ads: What happens if my campaign is split into multiple campaigns?

Feed-Based Text Ads: What happens with an ad group when a product goes out of stock?

Feed-Based Text Ads: How can I unsubscribe from Google Text Ads in DataFeedWatch?

Feed-Based Text Ads: Can I add & use keywords from a separate file?

Feed-Based Text Ads: Why are not all my products in my campaign?

Feed-Based Text Ads: How often are my campaigns synced with my Google AdWords account?

Feed-Based Text Ads: What if certain fields are no longer in my feed?

Feed-Based Text Ads: Why are some products not eligible?

Feed-Based Text Ads: Can I use a 3rd-party tool to optimize the campaigns?

Feed-Based Text Ads: Why does my template not work for 100% of my ads?

Feed-Based Text Ads: How to add size & color as negatives to the group campaign?

Feed-Based Text Ads: How does Per Partes work?

Feed-Based Text Ads: How to link one shop in the DataFeedWatch App to multiple AdWords Accounts?

Using Feed-Based Text Ads

Feed-Based Text Ads: Overview

Feed-Based Text Ads: Quick Start Guide

Feed-Based Text Ads: Feed Optimization Checklist

Feed-Based Text Ads Does Not Open in DataFeedWatch

Price Watch

Feed Analytics Overview

FAQ

Getting Started

Billing and Account

Shops

Uploading to Channels

Creating Feeds

Google Merchant Center

Release Notes

Main Mapping Types: Lookup table (Local Drive, CSV)

Paweł Updated by Paweł

Difficulty level: Pro.
If you're not sure how to proceed, or the function does not produce the right effects, please contact our Support Team.

The Lookup table option allows you to replace old values with new ones, if you upload a comma separated CSV (or refer to the article for Google Spreadsheet).

The file must contain 2 columns: one with current values from your shop, and another column with new values. Make sure your file contains only one sheet inside.

To use the Lookup table option, follow the steps below:
  1. Prepare the relevant file with both columns included
  2. Save your spreadsheet as comma separated CSV
The first column must include the values as they are in your feed. And to the second one add the new values.
  1. On your mapping page (Internal Fields or Map Fields tab), scroll down to a given field (e.g. size)
  2. From the second drop-down list, select Use lookup table option
  3. In the next field, select the field to be searched for values from the first spreadsheet column (e.g. size internal field)
  4. Upload your CSV
  5. Click IF, select the same field with values (e.g. Size), and is in list from the dropdown adding the same file
    This will let you only change these values if they exist.
  6. In Else > Rename, choose the same field with values (e.g. Size)
    The original values will be kept if you add this rule.
  1. To apply changes, click Save and Proceed

Optimization Case Studies:

Using standard S, M, L sizes instead of other non-standard sizes (like Little, Small, Medium, Large and Big)

Here's a step-by-step animation:

Main Mapping Types: Lookup table (Google Sheets)

Main Mapping Types: Extract from (Google Sheets)

Related Articles

Contact

Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)