If you have decided to migrate from Adobe Analytics to Google Analytics 360, you may be looking for new ways to generate the types of reports your organization used within the Adobe Analytics infrastructure. This post presents a quick and easy solution for reporting on Google Analytics 360 data in Data Studio in a way that replicates Adobe Analytics’ rules-based approach to data dimension classification.

Defining Calculated Dimensions in Data Studio

Let’s say that you want to look at your daily data using these classifications:

  • Weekend/Weekday
  • Morning/Evening

You can follow four simple steps to calculate these classifications in Data Studio based on standard Google Analytics 360 data:

  1. Connect Google Analytics as a data source in your Data Studio report
  2. Create a calculated dimension
  3. Add this function to create the Weekend/Weekday classification (calculation of day of the week data):
    CASE WHEN REGEXP_MATCH(Day of Week Name, "Saturday|Sunday") 
    
    THEN "Weekend" ELSE "Weekday" END
  4. Add this function to create the Morning/Evening classification (calculation of hourly data):
    CASE WHEN (REGEXP_MATCH(Hour, '0[0-9]|1[0-1]')) 
    
    THEN 'AM' ELSE "PM" END
Adding the Morning/Evening classification function in Data Studio.

Reporting on Calculated Dimensions in Data Studio

Thanks to Data Studio’s calculated dimensions feature, you can report on any rules-based dimensions that your organization needs:

These line charts indicate session count over different time periods for the AM/PM and Weekday/Weekend dimension values that we calculated in Data Studio.

Want to learn more about Data Studio? Enroll in our online course.

Contact us for more questions about migrating from Adobe Analytics to Google Analytics.

Message Sent

Thank you for registering.

Cardinal Path hosted a live session to connect with you and answer all your questions on Google Analytics.
Get all the expertise and none of the consultancy fees in this not-to-be-missed, rapid-fire virtual event.

Thank you for submitting the form.

Thank you for submitting the form.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you.

Click here to download access the tool.

Message Sent

Thank you for registering.

Message Sent

Thank you.

Message Sent

Thank you.

Message Sent

Thank you

Message Sent

Thank you

Message Sent

Thank you.

Message Sent

Thank you

Message Sent

Thank you.

Message Sent

Success!
Your message was received.

Thank you.

Thank you for registering.

Cardinal Path is continuing with its series of free training. Next we are conducting training on Google Data Studio. Check it out here.

Message Sent

Thank you for registering.

Thank you for your submission.

Your request has been submitted and a rep will reach out to you shortly.

Message Sent

Thank you for your interest.

Thank you for registering.

You should receive a confirmation email from GoToWebinar with your unique webinar login information. If you do not receive this email or have trouble logging in to the event, please email asmaa.mourad@cardinalpath.com.

Thank you for subscribing!

You're now looped into the world's largest GMP resource hub!

Thank you for your submission.

Thank you for your submission.

Thank you for your submission.

Thank you for your submission.

Message Sent

Thank you for registering.

Message Sent

Thank you for your submission.

Thank you for your submission.

Message Sent

Thank you for registering.

Thank you for registering.​

Paid media spend by Government websites increased a whopping 139% YoY in 2020.

2020 Online Behavior Live Dashboard

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

2020 Online Behavior Live Dashboard

Thank you for your submission.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Thank you for registering.

Message Sent

Success! Thank you
for reaching out.