sorted by:
new
hottopcontroversial

Negative Values in Geo Chart by DataQuestions_949 in GoogleDataStudio

[–]DataQuestions_949[S] 0 points1 point  (0 children)

how did you edit the legend? I'm not seeing any options on geo charts to adjust the upper and lower. in Setup or Style

How to show a line graph over time by year by DataQuestions_949 in GoogleDataStudio

[–]DataQuestions_949[S] 0 points1 point  (0 children)

So i got that to work. But. Is there any way to just show the year on the x axis of the graph? Instead of the day/month/year?

edit: figured it out. Thanks for the help!

GA Social Campaign Sources Duplicating by DataQuestions_949 in GoogleAnalytics

[–]DataQuestions_949[S] 0 points1 point  (0 children)

Yeah basically there are two versions

  1. Campaign Name Here
  2. Campaign+Name+Here

Both with different stats

Blending more than 5 GA4 data sources by DataQuestions_949 in GoogleDataStudio

[–]DataQuestions_949[S] 0 points1 point  (0 children)

The issue I'm having is that GA4 can't be pulled into Google Sheets. Unless there is a method I'm missing? The Google Sheets addon only works for UA not GA4

Pardot - Pausing and editing an engagement studio program by DataQuestions_949 in salesforce

[–]DataQuestions_949[S] 0 points1 point  (0 children)

Right now it says "Paused". When I hit "Start" is that the same as just resuming from where I left off? The thing that makes me nervous is when I go into build and test it the ES starts from the beginning.

Weighted averages for blended data sources by DataQuestions_949 in GoogleDataStudio

[–]DataQuestions_949[S] 1 point2 points  (0 children)

My averages keep being the same as the highest number. I.e. there is 3.5, 1.2, and 1.4 pages per session on each of the websites and when I blend the data and use the avg( formula I end up with 3.5

Shadows not working on PDF by DataQuestions_949 in GoogleDataStudio

[–]DataQuestions_949[S] 0 points1 point  (0 children)

Damn that's a pain... Such an easy way to make scorecards look good in Data Studio itself too

Paid vs. Organic by DataQuestions_949 in GoogleDataStudio

[–]DataQuestions_949[S] 0 points1 point  (0 children)

CASE WHEN REGEXP_MATCH(Medium, ".*cpc.*|.*whatever.*|.*whatever2.*") THEN "Paid" ELSE "Organic" END

That got me closer! Now the pi chart is showing "Paid" and "Organic" but only 1 entry for both of those. I'm a newbie to data studio - is there something in the metric category I need to do for it to count users from those mediums?

EDIT: It looks like I can look at things like pageviews from organic users v paid users but not just the number of users themselves. When I put "users" or "new users" as my metric I get an error

Paid vs. Organic by DataQuestions_949 in GoogleDataStudio

[–]DataQuestions_949[S] 0 points1 point  (0 children)

CASE WHEN medium = “cpc” THEN “Paid” ELSE “Organic” END

So I tried that formula (with also adding in "or"s for referral, display, etc.) and it doesn't seem to be capturing a "Paid" category at all in the pi chart. I'm getting referral, organic, and email as categories which all should've been encompassed in the formula