Uploaded image for project: 'Data'
  1. Data
  2. DATA-823

Data - Worldhum will not sync correctly preventing accurate reporting - Priority 0

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: unspecified
    • Fix Version/s: None
    • Component/s: Search Engine Data
    • Labels:
      None
    • Environment:

      Operating System: Linux
      Platform: PC

    • Bugzilla Id:
      1938

      Description

      Worldhum was effected by the bug the CCC ran out of searchEngine adgroup ids.
      the data has been re-pulled search engine side and data feed side, but we are
      still not getting accurate data. It appears that the sync is failing.

      The problem appears to be missing searchEngineGroupIdentifiers and landingPageURLs.

      mysql> select * from sources where accountID=374 and keyword='myanmar'\G

                                                          • 1. row ***************************
                                                            id: 273091391
                                                            altKey: go374t10341s_myanmar
                                                            accountID: 374
                                                            siteID: 0
                                                            searchEngineAccountID: 19972
                                                            keywordID: 0
                                                            distributionID: 3
                                                            searchEngineIdentifier: NULL
                                                            searchEngineGroupIdentifier:
                                                            searchEngineMatchType: broad
                                                            searchEngineGroupID: 425350
                                                            isBiddable: false
                                                            campaignID: 0
                                                            description: Keyword "myanmar"
                                                            type: 1
                                                            keyword: myanmar
                                                            sourceURL:
                                                            cost: NULL
                                                            maxCost: 0
                                                            waypointID: NULL
                                                            landingURL:
                                                            passParams:
                                                            trackPerformance: true
                                                            searchEngineStatus: unknown
                                                            searchEngineStatusText:
                                                            lastChecked: 0000-00-00 00:00:00
                                                          • 2. row ***************************
                                                            id: 245770221
                                                            altKey: go374t10341c_myanmar
                                                            accountID: 374
                                                            siteID: 0
                                                            searchEngineAccountID: 19972
                                                            keywordID: 0
                                                            distributionID: 3
                                                            searchEngineIdentifier: 17186240
                                                            searchEngineGroupIdentifier: 833646701
                                                            searchEngineMatchType: content
                                                            searchEngineGroupID: 425520
                                                            isBiddable: false
                                                            campaignID: 0
                                                            description: Keyword: [myanmar] content
                                                            type: 1
                                                            keyword: myanmar
                                                            sourceURL:
                                                            cost: 1
                                                            maxCost: 5
                                                            waypointID: NULL
                                                            landingURL:
                                                            http://www.worldhum.com/dispatches/item/under_the_banyon_tree_in_burma_20080130/?refcd=GO374T10341c_myanmar&tsacr=GO {creative}
                                                            passParams:
                                                            trackPerformance: true
                                                            searchEngineStatus: ok
                                                            searchEngineStatusText: Active
                                                            lastChecked: 0000-00-00 00:00:00
                                                            *************************** 3. row ***************************
                                                            id: 245294191
                                                            altKey: go374t10341s_myanmar
                                                            accountID: 374
                                                            siteID: 0
                                                            searchEngineAccountID: 19972
                                                            keywordID: 0
                                                            distributionID: 3
                                                            searchEngineIdentifier: 17186240
                                                            searchEngineGroupIdentifier: 833646701
                                                            searchEngineMatchType: broad
                                                            searchEngineGroupID: 425520
                                                            isBiddable: true
                                                            campaignID: 0
                                                            description: Keyword: [myanmar] broad
                                                            type: 1
                                                            keyword: myanmar
                                                            sourceURL:
                                                            cost: 1
                                                            maxCost: 5
                                                            waypointID: NULL
                                                            landingURL:
                                                            http://www.worldhum.com/dispatches/item/under_the_banyon_tree_in_burma_20080130/?refcd=GO374T10341s_myanmar&tsacr=GO{creative}

                                                            passParams:
                                                            trackPerformance: true
                                                            searchEngineStatus: ok
                                                            searchEngineStatusText: Active
                                                            lastChecked: 0000-00-00 00:00:00
                                                            3 rows in set (3.01 sec)

        Attachments

          Activity

            People

            • Assignee:
              therouxj Jeff Theroux
              Reporter:
              bduffy Bill Duffy (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: