konosp

konosp

konosp

itemId_lvl_1	value_lvl_1	itemId_lvl_2	value_lvl_2	metrics/visits	metrics/orders	metrics/event1
0	Other	1	Paid Search	233	39	10
0	Other	2	Natural Search	424	12	412
0	Other	3	Display	840	41	31
...	...	...	...	...	...	...
1728229488	Tablet	1	Paid Search	80	12	41
1728229488	Tablet	2	Natural Search	50	41	21
...	...	...	...	...	...	...

konosp

from analytics.mayhem.adobe import analytics_client

ADOBE_ORG_ID = os.environ['ADOBE_ORG_ID']
SUBJECT_ACCOUNT = os.environ['SUBJECT_ACCOUNT']
CLIENT_ID = os.environ['CLIENT_ID']
CLIENT_SECRET = os.environ['CLIENT_SECRET']
PRIVATE_KEY_LOCATION = os.environ['PRIVATE_KEY_LOCATION']
ACCOUNT_ID = os.environ['ACCOUNT_ID']
REPORT_SUITE_ID = os.environ['REPORT_SUITE_ID']

konosp

{
   "rsid":"adbedocrsid",
   "globalFilters":[
      {
            "type":"dateRange",
            "dateRange":"2017-12-31T00:00:00.000/2018-01-06T23:59:59.999"
      }
   ],
   "metricContainer":{
      "metrics":[

konosp

CREATE OR REPLACE TABLE `<project id>`.`<dataset id>`.`test` 
OPTIONS() AS( SELECT 'a' AS id, '1' AS value );

konosp

adobe-clickstream-bigquery:
  target: local-dev
  outputs:
    local-dev:
      type: bigquery
      method: oauth
      project: <project name>
      dataset: adobe_analytics_dbt_posts
      threads: 1
      timeout_seconds: 300

konosp

// channel_domain_mapping
var DOMAINS_NATURAL_SEARCH = ['www.google.', 'bing.', 
                              'search.yahoo.', '.yandex.'];
var DOMAINS_NATURAL_SOCIAL = ['facebook.com', 't.co', 'pinterest.', 'linkedin.com', 
                              'plus.google','instagram.com'];
var DOMAINS_REFERRING = ['.paypal.com','www.my-bank.com'];
                     
// Returns an array with the channel_id and the referring domain
function identifyChannel( channel_id , channel_domain_mapping , referrer) {
    if (referrer && referrer !== '') {

konosp

function isChannelClickthrough(channel_parameter, referrer) {
    // Tealium-specific variable to identify first hit of session.
    var session_hit_number = b.tealium_session_event_number;
    // If channel_parameter is present, paid channel click-through occured
    if (channel_parameter && channel_parameter !== '')
        return true;
    else if (referrer && referrer !== '') {
        if (identifyChannels(NATURAL_SEARCH, DOMAINS_NATURAL_SEARCH, referrer) 
            || identifyChannels(NATURAL_SOCIAL, DOMAINS_NATURAL_SOCIAL, referrer) 
            || identifyChannels(REFERRING_DOMAIN, DOMAINS_REFERRING, referrer))

konosp

-- This query is not valid as there is no realtime data available in the sample data set.
SELECT
  date AS Date,
  channelGrouping AS Default_Channel_Grouping,
  Sessions
FROM (
  SELECT
    date,
    CASE
      WHEN trafficSource.source = '(direct)' AND (trafficSource.medium = '(not set)' OR trafficSource.medium = '(none)') THEN 'Direct'