Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Sooji Feedback #3

Open
DillonMorrison opened this issue Oct 16, 2017 · 2 comments
Open

Sooji Feedback #3

DillonMorrison opened this issue Oct 16, 2017 · 2 comments

Comments

@DillonMorrison
Copy link
Contributor

DillonMorrison commented Oct 16, 2017 •
edited
Loading

  • Pages are tracked in behavior flow, and theyre grouped together automatically done
  • can't see new sessions as its own metrics - done
  • cannot compare more than 4 metrics at a time - done
  • hard to conversion analysis at the goal level - and difficult to configure (see how it comes through) done

------ dashboard around goals and conversions

  • Event goals are impossible - need goal info in fake data set
@DillonMorrison
Copy link
Contributor Author

DillonMorrison commented Oct 16, 2017 •
edited
Loading

  • attribution defaults to last touch - we can make that customizable
  • never uses dashboards in practice because theyre too difficult to configure, can't display enough info, and reports dont align -- theyre unhelpful

@DillonMorrison
Copy link
Contributor Author

  • can only bring in ONE view per Property in GA360 (include in documentation)

alison985 added a commit to alison985/google_ga360 that referenced this issue Jan 30, 2018
@alison985
Update instructions for using scenario 3 for multiple properties
b4aa1a9 
I'm setting up the ga360 block with a bigquery connection and have run into a problem I'm not sure how to solve.
This is the error message I'm getting: Failed to retrieve data - Name partition_date not found inside ga_sessions at [9:24]
this is where partition_date shows up in the query: "WHERE 
	(((ga_sessions.partition_date) >= ((TIMESTAMP_ADD(TIMESTAMP_TRUNC(CURRENT_TIMESTAMP(), DAY), INTERVAL -7 DAY))) AND (ga_sessions.partition_date) < ((TIMESTAMP_ADD(TIMESTAMP_ADD(TIMESTAMP_TRUNC(CURRENT_TIMESTAMP(), DAY), INTERVAL -7 DAY), INTERVAL 7 DAY)))))"
I'm using scenario llooker#3 to handle multiple properties. And commented out the sql clause for the partition_date field as instructed in the block comments.

Solution was to change from `dimension:` to `filter:` on the `partition_date` field so it's only included in the sql_table_name view condition for the FROM clause, but not be in the WHERE clause. I removed the note about changing the field `type:` because it's already that `type:`.
This was referenced Jan 30, 2018
Merged
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@DillonMorrison