Google Ads Developer Blog: New Developments for the DFA API

Google Ads Developer Blog: New Developments for the DFA API: We have some exciting changes and important announcements for the DoubleClick for Advertisers community as we begin to improve our overall ...

Comments

Post a Comment

Popular posts from this blog

install postgreSQL in ubuntu 16.04

When following the Install PostgreSQL in Ubuntu  in Ubuntu 16.04, got error as below: $ apt-get install postgresql-9.6 Reading package lists... Done Building dependency tree Reading state information... Done You might want to run 'apt-get -f install' to correct these: The following packages have unmet dependencies: adobereader-enu:i386 : Depends: libgtk2.0-0:i386 (>= 2.4) but it is not going to be installed postgresql-9.6 : Depends: postgresql-client-9.6 Depends: postgresql-common (>= 171~) but it is not going to be installed Recommends: postgresql-contrib-9.6 but it is not going to be installed E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution). The suggested solution in the last line and a normal ubuntu upgrade do not solve the issue,  and the cmd below can fix it: $sudo apt full-upgrade After the fix, then can apt-get to install postgresql again. After install postgresql, ...
Keep reading

timestamp with 16, 13 and 10 digits to Qlik date

Sometimes, we need to convert the Linux timestamps to Qlik date, it can be done in the SQL script, and can also be done in the Qlik Load/expression. Linux timestamps with 16 digits are microseconds timestamps, and 13 digits are milliseconds, and 10 digits are second timestamps. To convert to a Qlik date, hour or time as following: As the timestamps starts from "19700101 00:00:00",  then this start timestamps needs be added: For 16 digits: Date(Date#('19700101', 'YYYYMMDD')+(SynchronousQuery_ Event_Time/1000000/86400) or  Date(25569+Round(SynchronousQuery_ Event_Time/1000000/86400),'YYYYMMDD') 25569 is the number format for date '19700101' For 13 digits: Date(Date#('19700101', 'YYYYMMDD')+(SynchronousQuery_ Event_Time/1000/86400) or  Date(25569+Round(SynchronousQuery_ Event_Time/1000/86400),'YYYYMMDD') For 10 digits: Date(Date#('19700101', 'YYYYMMDD')+(SynchronousQuery_ Event_T...
Keep reading

Qlikview tips - hide specific rows in a table

There are totally 3 ways to hide specific rows based on dimensions columns and expression column, which are created in "Expression" tab) in Qlikview. If you need to hide the rows based on the dimensions. 1.  You can use "Enable Conditional" in the Dimensions Tab, and then use expressions to select dimensions. The tricky part is to hide the rows based on Expression columns, as Qlikview are not designed to do such job. BUT , we can do it by using expressions. Expression is such a beautiful  thing in Qlikview. 2. Use the "Dimension Limit" tab, where can show top N / N% of a table based on the first expression column. Then we see the limitation, this is only available for the first expression column. 3. Use the expression in one of the expression column and variables. We use  expression_column1 as an example here. The expressions for all the columns are originally like below: For example, expression_column1 =  expression1 , and expression_column2...
Keep reading