TrackingDatafeed FAQs

Document Sample
TrackingDatafeed FAQs Powered By Docstoc
					Tracking/Datafeed FAQ’s
Technical Questions ...................................................................................................................................... 1
Business Questions ....................................................................................................................................... 5

Technical Questions
             1. What are the minimum feed requirements?
                   The minimum requirement for a valid feed are the following fields.
                           i. Merchant Product ID
                          ii. Product Name/Title
                        iii. Manufacturer
                         iv. One of the following fields
                                 1. Manufacturer Part Number
                                 2. UPC
                                 3. ISBN (Book Merchants)
                                 4. SKU
                          v. Product URL
                         vi. Price
                        vii. In-Stock status
                       viii. Description
                         ix. Image URL
                          x. Shipping Costs (if merchant chooses datafeed option in Merchant Center)
                         xi. Merchant’s Category
                B. The Merchant Product ID (MPID) is the primary Key for our matching. When the
                   merchant reports the sale and the MPID’s of the items – we compare the MPID of the
                   sale with the MPID in the feed. We will then apply the % listed in the feed to the price
                   reported for the sale.
                C. If the MPID reported at time of sale is not found in the feed, the default percentage will
                   be applied.

             2. What are the two main requirements to onboard to cashback shopping?
                A. The two main requirements for merchants to join cashback shopping are for merchants
                     to 1) display products (offer feed) and report sales (batch or pixel).
             3. Is the tracking code copy and paste?
                A. No, for the majority of our merchants it is not. This is due to the data being requested
                     and the variations in each merchant’s shopping cart/confirmation page, you must

              custom code the javascript tracking pixel to pull the necessary data from the items
              ordered the customer. Let them know if they have further questions regarding
              tracking, please contact their account manager/rep. FYI: We do have a few copy and
              paste codes available for merchants that use select hosting sites or checkout
              software such as Yahoo, Channel Advisor, and Channel Intelligence. This is not
              necessary to relate to them unless they mention one of these partner names. If they
              do, then you can let them know we have a copy and paste code that they can get
              from their account manager/rep.

    4. Can I submit a datafeed in any other format? (XLS, XML, other Shopping Engine feeds,
       A. No, we only accept the 18 column feed that meets our specificationss and is saved as a
            text-tab delimited file.

    5. Where do I upload my datafeed?
       A. They can upload it at and must use an FTP Client. There
          is no way to upload a datafeed within the online Merchant Center account. Let them
          know that if they have further questions or need their username and password they
          should contact their account manager/rep.

    6. When we create feeds, we have one MPID for each product, but we do not currently
       have MPN, UPC, or ISBN. What can I do to make my feed valid?

         A.   If this is the case you are free to list the MPID in the MPN field for each product.

    7.   If I use Pixel Reporting for New Sales can I use the batch process for Returns and
         A. Yes, in fact we encourage this as a best practice. Simply let us know that you plan to do

    8. Are there any steps I can take to ensure the relevance of my offers?
       A. Absolutely. Simply read the enclosed optimization document and make certain that
           you follow all of our recommendations, including the use of our taxonomy.

    9. Where do I upload my data feed? Why is the link not
       working when I click on it?
       A. is our FTP server name and it is not a link. You need to
          have an FTP Client to upload your data feed. Please let us know when your feed is
          uploaded so we can validate it. It can take up to 36 hours for your feed to show up in
          our system.

    10. If I am a clothing retailer, where do I place the style number in Data feed?

        A.   Many clothing retailers often use SKU column for their style number as opposed to

    11. What are the advantages and disadvantages of each reporting type (Batch vs Pixel)?

        A. Here are the advantages of disadvantages of pixel or batch tracking so that you can
           decide for yourself:
                       1. Pixel Tracking – In this case, a pixel simply refers to a small piece of
                           JavaScript that the merchant must code on their order confirmation
                           page. This is the preferred method that we generally recommend to
                           our merchants. Once this is done, Microsoft and the consumer will
                           receive immediate notification that an order has been placed and a
                           cashback reward is pending. The immediate notification offers all
                           cashback consumers a better experience.
                       2. Disadvantages of Pixel Tracking – Pixel tracking requires you to slightly
                           alter the code in your ecommerce application. While hundreds of
                           merchants have done this successfully, certain merchants may have
                           corporate restrictions which prevent them from changing the code in
                           their application.

    12. Batch Tracking – In this method all sales that result from consumers who arrived at your
        merchant site from cashback will be recorded and uploaded at a frequency of no less than
        one time per day.
        A. Advantages of Batch Tracking – This method does not require the placement of
            additional code on your merchant site.
    13.    Disadvantages of Batch Tracking – Daily upload of transactions requires significant
        effort – either through manual uploading or the creation of a batch process. Additionally,
        Batch Processing presents a delay in notification. Since cashback does not receive
        transactions instantly, consumers do not receive instant notification of their pending
        reward which can create a poor user experience.

    14. Is the tracking code copy and paste?
        A. No, for the majority of our merchants it is not. This is due to the data being requested
             and the variations in each merchant’s shopping cart/confirmation page, you must
             custom code the JavaScript tracking pixel to pull the necessary data from the items
             ordered the customer.

    15. What should I do if the pixel is not firing?
        A. Please be aware that for the majority of cases, the tracking code is not a copy and
           paste code.
        B. Please check if you inserted your unique Merchant ID that allows us to attribute the
           sale to your account.
        C. If you removed part of code or inserted a word or phrase to prevent code from
           running. This was done as a preventative step until you want the code to go live. In
           some cases you may have told us to place a test order but have not changed the code
           back to its proper form.

        D. Make certain the pixel is visible: remove anything that “hides” the pixel. Many times
           developers will write the pixel on the live server, but insert commands to make the
           pixel invisible until launch.
        E. Look for extra spaces inside quotes, especially before and after the Merchant ID.
        F. Closing Tag: verify that the <script src='> tag has a
           closing tag </script>; not an xml empty tag. The empty tag will work in Firefox, but not
           in IE7.
        G. If the pixel relies on external functions, make certain that all of those functions are
           properly referenced on the confirmation page.

    16. What if my pixel is delivering inaccurate results?
        A. Use these resolutions to help in this situation:
                i. Symptom: pixel referencing unknown products that don’t match inventory.
                       1. Cause: SKU numbers referenced instead of Product ID’s.
                       2. Resolution: Reference Product ID’s.
               ii. Symptom: pixel reporting 2x the price for each line item in purchases of 2 or
                   more. For instance, the price of the product is $130, but the pixel is reporting
                   two transactions at ($260 each) or 2 transactions at 2x the price.
                       1. Cause: Pixel pulling the “group price” as opposed to the “product
                            price” from the shopping cart database.
                       2. Resolution: Reference “product price” in lieu of group price.

    17. What should I do if a batch file appears to be formatted correctly and processes
        successfully, but the orders aren’t cancelled?
        A. Please verify that you are sending the correct MPID in the returns file.

    18. Should I submit a returns batch file if I don’t have any returns for that day?
        A. Yes, it is a best practice to report returns every day, so that you don't get into the habit
    of withholding returns. If you don’t have returns for a specific day you can send a blank file.

    19. What is your cookie duration?
        A. We currently set a 24 hour cookie when a customer clicks from our site to the
           merchant’s site. You have the right to selectively show our tracking pixel only for
           “same-session” orders. To do this you will need to append a source ID to both your
           Shop by Store URL and all your Product URL’s in your data feed. You then code your
           tracking to look for these sources ID’s and only display our Tracking Pixel when they are
           present. Below are the examples:
                 i. Shop by Store URL examples:
                ii. or
           Product URL examples:

    20. I cannot login to my Merchant Center to correct my tracking code or where in my
        Merchant Center account can I see or adjust my tracking code?

        A. The tracking pixel is coded directly into your confirmation page and is neither related
           to nor viewable within your online Merchant Center account. Please refer to the
           cashback Shopping Integration Guide for more information.

    21. How do I cancel commissions for test orders, orders returned by the customer, and
        canceled orders, etc?
        A. You can go into your online merchant center account and cancel the commission being
           charged to you for any orders that were test orders, returned by the customer, and
           canceled by the customer, etc. This is done by clicking the "cancel" link beside that
           specific transaction inside the “reports” link and then going to the “transaction history”
           link to see all of your sales.

Business Questions

Q. How much is the commission for Cashback Shopping?
A. Each commission level is set by the merchant. Commissions must be between 2% and 25%.

Q. Do I need to have one commission for all products or can each product have a different
A. Both are available. You can set a blanket commission for all products in the merchant center or a
   specific commission for each product in the feed.

Q. What other fees do you guys charge for cashback shopping?
A. Cashback shopping is a Cost Per Acquisition (CPA) program that charges no hosting, maintenance, or
   startup fees. Merchants will simply pay a commission (between 2 and 25%) for each sale.

Q. How do I pay you for the commissions?
A. We allow both credit card and invoicing for payments. All merchants wishing to be invoiced must
   pass a credit check.

Q. What are your payment terms?
A. Our payment terms are Net 30.

Q. Which reporting method (Batch or Pixel) is better for me?
A. Please read the “Implementation Options” document.

Q. I have variable shipping costs depending on where you want the product shipped to, or how fast
you want it to get there. What should I put in the feed?

A. The merchant center has several options to allow merchants to choose the shipping configuration
that makes the most sense for them. If you log into the merchant center and go to the section called
Shipping and Tax information you will see a drop down box with several options including

        a) Included in Data Feed

        b) Free Shipping Available

        c) Determined by UPS

        d) Based on Price of Product

        e) Based on weight of Product

We encourage our merchants to make the choice most applicable for their business.

Q. Do we pay for per click?

A: No. Bing cashback Shopping follows the CPA (Cost Per Acquisition) model, not CPC (Cost Per Click).
You do not pay for any click. Only when your customers, referred by Bing cashback, make any purchases
on your site, you will need to pay them cashback through Microsoft.

Q: What is our deposit for and when should I make it?
A: Microsoft does not charge any fees for the cashback Shopping service. Your $100 deposit will
contribute to your cashback to your customers. We pass 100% of your cashback to your customers.
Because it can take up to 3 days for your deposit to show up in our system, it is recommended to make
it at an early stage. You can complete this step after you configure the Merchant Center.

Q: Does the Bing cashback website support used or reconditioned products?
A: Currently we do not support or display any used or reconditioned products in cashback program. You
can still provide those products in your data feed, but please make sure the product condition is marked
clearly, and keep in mind that those products will not be displayed or supported in cashback at this

Q: What if I lost the FTP Server and the Merchant Center credentials, how can I get them back?
A: During the on-boarding process, please contact If you’ve lost your
credentials after your on-boarding process is completed please contact cashback Merchant Support at

Q: How are data feeds processed?
A: We take the latest data feed you upload to the FTP Server and check it against your current products
on the site. If an item is removed from the feed, we remove it from our listings. If an item’s price is
changed, we change it on our listings, etc. All product offerings stay on the site even when there isn’t a
merchant selling that product. Yet they are not accessible through the search function. Once any
merchant adds that item to their data feed, the offering becomes active in search again. The only way a
customer could access an out of stock item is by bookmarking the link to that page.

Q: Can I upload several data feeds in one day?
A: Our indexes only run once every 24 hours. Having multiple feeds pushed to our system within a 24
hour period could actually slow down or completely break the processing of your products.

Q: What is the timing of updates to merchant data?
A: Right now, we only index our site once per day, meaning it could take up to 36-48 hours for the
changes or updates you make in your data feed i.e. pricing and in-stock status, etc, to be reflected.

Q: When do you deduct funds from our Merchant Center and when do you pay consumers?
A: We deduct funds immediately from your Merchant Center balance when there is a qualifying sale.
We then hold the funds for 60 days until the item is no longer returnable and return cash back to

Q: How can I become a Featured Store or feature our products on Bing cashback homepage?
A: The featured stores and products are algorithmically selected based on performance and rebate
amount. Seasonal effects and events (e.g. Mother’s Day) are also taken into account.

Q: What if I have other questions regards cashback on-boarding process?

    A: Please email for any on-boarding related question; while once you
    completed the on-boarding process and cashback on your site has become active, please
    contact for all merchant support issues.


Shared By: