Uploaded image for project: 'AdMax'
  1. AdMax
  2. ADMAX-3028

sedatacheck google reports use different auth token behavior than other google reports

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Won't Fix
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Google
    • Labels:
      None
    • Environment:

      xml-06.dc1bos.thesearchagency.com

      /usr/local/tsa/bidmgr -> tsa-build-bidmgr-2012-01-30-p16-r31446/

      Description

      In all the Google report downloads, the auth token is for the top-level MCC for all Google accounts in the MCC (for non-MCC accounts, the auth token is for the individual account). But in sedatachecker, the auth token is for the individual Google accounts.

      it looks like in Agency production we're making a new

      auth token for each searchEngineUser, in addition to using the global

      auth token. Is that a bug?

      YELL production:

      select seUserID, date from googleAuthToken order by date desc limit 30;

      --------------------+

      seUserID date

      --------------------+

      0 2012-02-23

      --------------------+

      1 row in set (0.02 sec)

      AGENCY production:

      select seUserID, date from googleAuthToken order by date desc limit 30;

      --------------------+

      seUserID date

      --------------------+

      0 2012-02-27
      1869 2012-02-27
      1890 2012-02-27
      1875 2012-02-27
      1904 2012-02-27
      1866 2012-02-27
      1903 2012-02-27
      1864 2012-02-27
      1912 2012-02-27
      1882 2012-02-27
      1899 2012-02-27
      1927 2012-02-27
      1871 2012-02-27
      1878 2012-02-26
      1926 2012-02-26
      1905 2012-02-26
      1494 2012-02-25
      1763 2012-02-25
      1900 2012-02-25
      1911 2012-02-25
      1910 2012-02-25
      1731 2012-02-25
      1554 2012-02-25
      1691 2012-02-25
      1555 2012-02-25
      1690 2012-02-25
      1642 2012-02-25
      1907 2012-02-25
      1913 2012-02-25
      1502 2012-02-25

      --------------------+

      30 rows in set (0.03 sec)

      That's coming from search engine data checker I believe. In v13 it checked tsacommon.searchEngineUsers.inTsaMcc (didn't realize googlemcc was doing this too so wasn't thinking about consistency). Then it would run a master report and an individual reports for any non-MCC users. So the most straight-forward way I saw to implement this was by not running that query and instead setting it to false for all the users, forcing each user to download an individual report.

      if (!theSearchEngine.usesMasterReport(aSearchEngineUser) || (theSearchEngineUserID != null)) {

      if((date != null) && (dateUtil != null))

      { ret = new SearchEngineUserWorker((Database)null, aSearchEngineUser, date, endDate, dateUtil); }

      }

      else

      { Debug.debug(Debug.DUMP, "Skipping user #" + aSearchEngineUser.get(SearchEngineUserTable.ID) + "; uses master report"); }

      //if null is returned, Dispatcher skips this worker

      return ret;

      GoogleAPISearchEngine.usesMasterReport(SearchEngineUserTableRow aSearchEngineUser):

      previously returned: aSearchEngineUser.get(SearchEngineUserTable.IN_TSA_MCC).equals(Database.TRUE);

      now returns false (there are no other references in the code to this method so it's safe to change that)

      so this isn't a bug, just an inconsistency - sedatacheck uses individual account auth tokens; all the other google reports use master auth token

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              caitlyn Caitlyn Duggan (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: