Uploaded image for project: 'AdMaxLocal'
  1. AdMaxLocal
  2. AML-3400

Invalid 'Match Type' in internal keywords leads data report

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Rushmore
    • Fix Version/s: Rushmore
    • Labels:
      None
    • Environment:

      Ops scripts #690

    • Sprint:
      Sprint 6

      Description

      googleMcc, sesummarizer and whsumm scripts were run for 26th Feb.
      Ran keyword-leads-data report to generate the internal csv file.

      Match Type in the csv file shows NULL though the DB value shows up a particular match Type
      Eg.,
      Keyword: antique china cabinets

      conversion data 3 bd0d23d8-da91-43d0-a8a8-90ec10b99a0d conversion data 3 bd0d23d8-da91-43d0-a8a8-90ec10b99a0d_10043_18_5999_GT bd0d23d8-da91-43d0-a8a8-90ec10b99a0d_10043_18_5999 Antique Furniture Rhode Island antique china cabinets NULL
      conversion data 3 bd0d23d8-da91-43d0-a8a8-90ec10b99a0d conversion data 3 bd0d23d8-da91-43d0-a8a8-90ec10b99a0d_10043_1_5998_GT bd0d23d8-da91-43d0-a8a8-90ec10b99a0d_10043_1_5998 Antique Furniture United States antique china cabinets exact

      Whereas the DB shows the following
      SELECT s.searchEngineMatchType,s.keyword,sea.description FROM `st-tracker`.sources s JOIN tsacommon.searchEngineAccounts sea ON s.searchEngineAccountID = sea.id WHERE s.accountID = 1249 AND sea.searchEngineStatus != "deleted" AND s.keyword LIKE "%antique china cabinets%";

      searchEngineMatchType keyword description
      exact antique china cabinets bd0d23d8-da91-43d0-a8a8-90ec10b99a0d_10043_1_5998_GT
      exact antique china cabinets bd0d23d8-da91-43d0-a8a8-90ec10b99a0d_10043_18_5999_GT

      Expected Result: Internal csv report should show up the same 'Match Type' as that of the DB

        Attachments

          Activity

            People

            • Assignee:
              varshini.padmanabhan Varshini Padmanabhan (Inactive)
              Reporter:
              varshini.padmanabhan Varshini Padmanabhan (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: