Databox Partner Program
Databox Partner Program Google Analytics + Databox: Tips, Tricks & Queries 7/12/17
Agenda for Today: 1. What’s Available? 2. Custom Query Capabilities 3. Templates with Custom Queries 4. Newly Released Features 5. Suggested Activities for You
Naturally, we pull 130 Google Analytics metrics Avg. Order Value ˪ AOV by Channels ˪ AOV by Sources ˪ AOV by New vs Returning Avg. revenue per user Avg. Time on Screen Avg. Time on Page Avg. Quantity ˪ Avg. Quantity by Channels ˪ Avg. Quantity by Sources ˪ Avg. Quantity by New vs Returning Avg. Session Duration Bounce rate ˪ Bounce rate by New vs Returning Avg. Dwell Time Total Dwell Time Goal Completion Rate by Page Sessions by Blog Landing Page Returning users Revenue per visit
Sessions ˪ Sessions by Channels ˪ Sessions by Geo Location ˪ Top Events by Sessions by Label ˪ Sessions by Organic Keywords ˪ Sessions by Page ˪ Sessions by Landing page ˪ Sessions by New vs Returning Sessions via Social referrals % New Sessions Pages / Sessions ˪ Pages / Session by New vs Returning Pageviews ˪ Pageviews by Page New Users Avg. Session Duration ˪ Product Revenue by Product Name Screens / Session ˪ Screens / Session by New vs Returning Screen Views ˪ Screen views by Screen name
Ecommerce Conversion rate ˪ Ecommerce Conv % by Channels ˪ Ecommerce Conv % by Organic Keywords ˪ Ecommerce Conv % by Landing page ˪ Ecommerce Conv % by Sources ˪ Ecommerce Conv % by New vs Returning Goal Completions ˪ Goal Completions by Channels ˪ Goal Completions by Goals ˪ Goal Completions by Sources ˪ Coal Completions by New vs Returning Goal Conversion Rate ˪ Goal Conversion Rate by Channels ˪ Goal Conversion Rate by Goals ˪ Goal Conversion Rate by Sources ˪ Coal Conversion Rate by New vs Returning Goal Value ˪ Goal Value by Channels ˪ Goal Value by Goals ˪ Goal Value by Sources ˪ Coal Value by New vs Returning
Revenue ˪ Revenue by Channels ˪ Revenue by Organic Keywords ˪ Revenue by Landing page ˪ Revenue by Sources ˪ Revenue Value by New vs Returning Quantity ˪ Quantity by Channels ˪ Quantity by Sources ˪ Quantity by New vs Returning ˪ Top Paid Keywords by Sessions ˪ Sessions by Social Networks ˪ Sessions by Sources ˪ Top Sources / Mediums by Sessions Total events Transactions ˪ Transactions by Channels ˪ Transactions by Sources ˪ Transactions by New vs Returning Transactions per user ˪ Transactions per user by Channels
We also have 23 GA templates
… including the most downloaded template in our gallery
Google Analytics (Website Traffic)
use this template
leverage GOOGLE ANALYTICS get more information on GA terms
submit a template
● Not sure what segments are? Unsure how to use filters? Read this article to learn about GA terms that may be causing confusion ● Google Analytics is our most popular connector ● Submit a template to our template library to generate leads
Lead generation from Template downloads
Agenda for Today: 1. What’s Available? 2. Custom Query Capabilities 3. Templates with Custom Queries 4. Newly Released Features 5. Suggested Activities for You
custom QUERIES what do I do if a metric isn’t available?
● You can use custom queries to get a much more granular view of the data and essentially create your own metrics
what kind of queries can I create?
● Can utilize dimensions, segments and filters to sort your data ● Example: desktop users who have viewed your blog vs. mobile users help
C
B
E D
A. Custom Query Name (required): Write a name for your custom query in this field. You will find this name/title as a metric option in the designer after saving the query.
A C E D
B. Metric (required): Select a metric from your connected google analytics data source, such as users, new users, clicks or pageviews. A metric can be used in combination with other dimensions or metrics, but only where valid combinations apply.
A B E D
C. Dimensions (optional) : The dimensions parameter breaks down metrics by common criteria, such as by browser or country (like in the example). When dimensions are requested, metrics are segmented by that value. If a query has no dimensions parameter, the returned metrics will provide aggregate values for the requested date range, such as overall pageviews or total bounces.
A B
C E
D. Date range (required): To display your data the way you like, you will need to choose a date range. Click on the "Date range" field and selected intervals will be enabled for a new metric.
A C
B
D
E. Compare With (optional): Select a date range to compare your previously selected interval to. This date range will be used for "previous line" on line and bar charts, and for calculating change %. Options are: None, Previous Interval, or Same Interval Last Year.
F G
H
F. Segment (optional): A segment is a subset of your Analytics data. For example, out of your entire set of users, one segment might be users from a particular country or city. Another segment might be users who purchase a particular line of products or who visit your page and came from organic search sources, as in our example.
F G H
G. Max Results (optional): Maximum number of rows to include in this response. The Analytics Core Reporting API returns a maximum of 10,000 rows per request by default. This cannot be set any higher. It can return fewer rows than the "Max Results" value if there aren't as many dimension segments as you expected.
F G
H
H: Filters (optional): You can filter results by dimensions or by metrics. Filters can be combined using AND or OR boolean logic. Filtered queries restrict the rows that do (or do not) get included in the result. Each row in the result is tested against the filter. If the filter matches, the row is retained, and if it doesn't match, the row is dropped.
METRIC (New Users) FILTER
US DIMENSION FILTER Australia (Country)
SEGMENT (Organic Traffic)
FILTER
Germany
New Users/ Organic by Country
Agenda for Today: 1. What’s Available? 2. Custom Query Capabilities 3. Templates with Custom Queries 4. Newly Released Features 5. Suggested Activities for You
Blog Quality Metrics
● ●
Blog Post Pageviews ● Blog Pages/ Session ●
Blog Post Pageviews ● Avg & Total Dwell Time ●
Goal Completion (All Blog Posts) Returning Visitors to Blog
use this template
Email Traffic Overview
● ●
● Sum, Email Sessions Sessions by Email Campaign ●
Sessions Email Device Landing Pages from Email
● ●
Signups from Email Conversion Rate by Email
use this template
Organic Blog Traffic
● ●
Organic Traffic Landing Pages Total Pages Viewed, Organic
● ●
Total Time on Page, Organic Goal Completions, Organic
use this template
Agenda for Today: 1. What’s Available? 2. Custom Query Capabilities 3. Templates with Custom Queries 4. Newly Released Features 5. Suggested Activities for You
newly released FEATURES tags & favorites
● Favorites: user-specific databoard classifications ● Tags: account-wide way to organize databoards
mobile switch accounts
● Toggle between your agency and client accounts from your mobile device
master date range switch
● Switch date ranges for the entire databoard ● Only have the ability to switch between date ranges that all datablocks have in common
share DATABOARDS ● Send the streaming URL via email or direct URL ● Schedule a snapshot that Databox will send to selected recipients at a specified time each day, month, week, or quarter help
recently released CONNECTORS ● MOZ, SEMRush, Google Search Console ● YouTube, Vimeo ● New FB Ads, HubSpot Mktg, and HubSpot CRM Connectors ● Seventh Sense, VOIQ
provide agency info here
Agenda for Today: 1. What’s Available? 2. Custom Query Capabilities 3. Templates with Custom Queries 4. Newly Released Features 5. Suggested Activities for You
Suggested Activities for You 1. Download the Blog Quality Metrics template to view custom queries with your own metrics. 2. Create a custom query to get a more granular view of your Google Analytics data. 3. Organize your accounts with tags and favorites. 4. Schedule screenshots to be sent to you, your teammates, and/ or your clients.
Databox Partner Program Session #9: Leveraging the FB Ads Connector
Agenda for Today: 1. What’s Available? 2. Custom Query Capabilities 3. Templates with Custom Queries 4. Newly Released Features 5. Suggested Activities for You
Naturally, we pull 130 Google Analytics metrics Avg. Order Value ˪ AOV by Channels ˪ AOV by Sources ˪ AOV by New vs Returning Avg. revenue per user Avg. Time on Screen Avg. Time on Page Avg. Quantity ˪ Avg. Quantity by Channels ˪ Avg. Quantity by Sources ˪ Avg. Quantity by New vs Returning Avg. Session Duration Bounce rate ˪ Bounce rate by New vs Returning Avg. Dwell Time Total Dwell Time Goal Completion Rate by Page Sessions by Blog Landing Page Returning users Revenue per visit
Sessions ˪ Sessions by Channels ˪ Sessions by Geo Location ˪ Top Events by Sessions by Label ˪ Sessions by Organic Keywords ˪ Sessions by Page ˪ Sessions by Landing page ˪ Sessions by New vs Returning Sessions via Social referrals % New Sessions Pages / Sessions ˪ Pages / Session by New vs Returning Pageviews ˪ Pageviews by Page New Users Avg. Session Duration ˪ Product Revenue by Product Name Screens / Session ˪ Screens / Session by New vs Returning Screen Views ˪ Screen views by Screen name
Ecommerce Conversion rate ˪ Ecommerce Conv % by Channels ˪ Ecommerce Conv % by Organic Keywords ˪ Ecommerce Conv % by Landing page ˪ Ecommerce Conv % by Sources ˪ Ecommerce Conv % by New vs Returning Goal Completions ˪ Goal Completions by Channels ˪ Goal Completions by Goals ˪ Goal Completions by Sources ˪ Coal Completions by New vs Returning Goal Conversion Rate ˪ Goal Conversion Rate by Channels ˪ Goal Conversion Rate by Goals ˪ Goal Conversion Rate by Sources ˪ Coal Conversion Rate by New vs Returning Goal Value ˪ Goal Value by Channels ˪ Goal Value by Goals ˪ Goal Value by Sources ˪ Coal Value by New vs Returning
Revenue ˪ Revenue by Channels ˪ Revenue by Organic Keywords ˪ Revenue by Landing page ˪ Revenue by Sources ˪ Revenue Value by New vs Returning Quantity ˪ Quantity by Channels ˪ Quantity by Sources ˪ Quantity by New vs Returning ˪ Top Paid Keywords by Sessions ˪ Sessions by Social Networks ˪ Sessions by Sources ˪ Top Sources / Mediums by Sessions Total events Transactions ˪ Transactions by Channels ˪ Transactions by Sources ˪ Transactions by New vs Returning Transactions per user ˪ Transactions per user by Channels
We also have 23 GA templates
… including the most downloaded template in our gallery
Google Analytics (Website Traffic)
use this template
leverage GOOGLE ANALYTICS get more information on GA terms
submit a template
● Not sure what segments are? Unsure how to use filters? Read this article to learn about GA terms that may be causing confusion ● Google Analytics is our most popular connector ● Submit a template to our template library to generate leads
Lead generation from Template downloads
Agenda for Today: 1. What’s Available? 2. Custom Query Capabilities 3. Templates with Custom Queries 4. Newly Released Features 5. Suggested Activities for You
custom QUERIES what do I do if a metric isn’t available?
● You can use custom queries to get a much more granular view of the data and essentially create your own metrics
what kind of queries can I create?
● Can utilize dimensions, segments and filters to sort your data ● Example: desktop users who have viewed your blog vs. mobile users help
C
B
E D
A. Custom Query Name (required): Write a name for your custom query in this field. You will find this name/title as a metric option in the designer after saving the query.
A C E D
B. Metric (required): Select a metric from your connected google analytics data source, such as users, new users, clicks or pageviews. A metric can be used in combination with other dimensions or metrics, but only where valid combinations apply.
A B E D
C. Dimensions (optional) : The dimensions parameter breaks down metrics by common criteria, such as by browser or country (like in the example). When dimensions are requested, metrics are segmented by that value. If a query has no dimensions parameter, the returned metrics will provide aggregate values for the requested date range, such as overall pageviews or total bounces.
A B
C E
D. Date range (required): To display your data the way you like, you will need to choose a date range. Click on the "Date range" field and selected intervals will be enabled for a new metric.
A C
B
D
E. Compare With (optional): Select a date range to compare your previously selected interval to. This date range will be used for "previous line" on line and bar charts, and for calculating change %. Options are: None, Previous Interval, or Same Interval Last Year.
F G
H
F. Segment (optional): A segment is a subset of your Analytics data. For example, out of your entire set of users, one segment might be users from a particular country or city. Another segment might be users who purchase a particular line of products or who visit your page and came from organic search sources, as in our example.
F G H
G. Max Results (optional): Maximum number of rows to include in this response. The Analytics Core Reporting API returns a maximum of 10,000 rows per request by default. This cannot be set any higher. It can return fewer rows than the "Max Results" value if there aren't as many dimension segments as you expected.
F G
H
H: Filters (optional): You can filter results by dimensions or by metrics. Filters can be combined using AND or OR boolean logic. Filtered queries restrict the rows that do (or do not) get included in the result. Each row in the result is tested against the filter. If the filter matches, the row is retained, and if it doesn't match, the row is dropped.
METRIC (New Users) FILTER
US DIMENSION FILTER Australia (Country)
SEGMENT (Organic Traffic)
FILTER
Germany
New Users/ Organic by Country
Agenda for Today: 1. What’s Available? 2. Custom Query Capabilities 3. Templates with Custom Queries 4. Newly Released Features 5. Suggested Activities for You
Blog Quality Metrics
● ●
Blog Post Pageviews ● Blog Pages/ Session ●
Blog Post Pageviews ● Avg & Total Dwell Time ●
Goal Completion (All Blog Posts) Returning Visitors to Blog
use this template
Email Traffic Overview
● ●
● Sum, Email Sessions Sessions by Email Campaign ●
Sessions Email Device Landing Pages from Email
● ●
Signups from Email Conversion Rate by Email
use this template
Organic Blog Traffic
● ●
Organic Traffic Landing Pages Total Pages Viewed, Organic
● ●
Total Time on Page, Organic Goal Completions, Organic
use this template
Agenda for Today: 1. What’s Available? 2. Custom Query Capabilities 3. Templates with Custom Queries 4. Newly Released Features 5. Suggested Activities for You
newly released FEATURES tags & favorites
● Favorites: user-specific databoard classifications ● Tags: account-wide way to organize databoards
mobile switch accounts
● Toggle between your agency and client accounts from your mobile device
master date range switch
● Switch date ranges for the entire databoard ● Only have the ability to switch between date ranges that all datablocks have in common
share DATABOARDS ● Send the streaming URL via email or direct URL ● Schedule a snapshot that Databox will send to selected recipients at a specified time each day, month, week, or quarter help
recently released CONNECTORS ● MOZ, SEMRush, Google Search Console ● YouTube, Vimeo ● New FB Ads, HubSpot Mktg, and HubSpot CRM Connectors ● Seventh Sense, VOIQ
provide agency info here
Agenda for Today: 1. What’s Available? 2. Custom Query Capabilities 3. Templates with Custom Queries 4. Newly Released Features 5. Suggested Activities for You
Suggested Activities for You 1. Download the Blog Quality Metrics template to view custom queries with your own metrics. 2. Create a custom query to get a more granular view of your Google Analytics data. 3. Organize your accounts with tags and favorites. 4. Schedule screenshots to be sent to you, your teammates, and/ or your clients.
Databox Partner Program Session #9: Leveraging the FB Ads Connector
