# Google Analytics ## Pipeline Concepts Before setting up the pipeline, learn about pipeline concepts [here](https://docs.sprinkledata.com/product/ingesting-your-data/pipelines) ## Step by Step Guide ### STEP-1: Configure Connection To learn about Connection, refer [here](https://docs.sprinkledata.com/product/ingesting-your-data/pipelines) * Log into Sprinkle application * Navigate to Ingest -> Connections Tab -> New Connection -> * Select Google Analytics * Provide all the mandatory details * *Name*: Name to identify this connection * Connect to Google * *Advance Settings* : Refer [here](#advanced-connection-settings) * After pressing Connect to Google, you will see authorise screen to allow permissions required for sprinkle to read data. Press Allow * Test Connection * Create ### STEP-2: Configure Pipeline To learn about datasource, refer [here](https://docs.sprinkledata.com/product/ingesting-your-data/pipelines) * Navigate to Ingest -> Pipeline Tab -> Add -> * Select Google Analytics * Provide the name -> Create * **Connection Tab**: * From the drop-down, select the name of connection created in STEP-2 * Update ### STEP-3: Create Dataset **Datasets Tab**: To learn about Dataset, refer [here](https://docs.sprinkledata.com/product/ingesting-your-data/pipelines). Add Dataset for each report/dataset that you want to integrate, providing following details * *Account Id* (Required) : GA Account * *Properties/Apps* (Required) : Select Property/Apps available in this account * *View Id* (Required) : Select Project/View available in this account * Metrics (Required) : Select upto 10 metrics * Dimensions (Optional) : Select upto 7 dimensions to aggregate your metrics on * Ingestion Mode (Required) * *Snapshot: Every run will pull data from the start date* * *Incremental: Every run will pull data from the last successful run onwards* * *Start Date* (Required) : Pull the data from this date: Format is YYYY-MM-DD * *Destination Schema* (Required) : Data warehouse schema where the table will be ingested into * *Destination Table name* (Required) : It is the table name to be created on the warehouse. If not given, sprinkle will create like ds\_\\_\ * *Destination Create Table Clause*: Provide additional clauses to warehouse-create table queries such as clustering, partitioning, and more, useful for optimizing DML statements. [Learn more](https://docs.sprinkledata.com/product/ingesting-your-data/pipelines/databases/features/destination-create-table-clause) on how to use this field. * Create ### STEP-4: Run and schedule Ingestion In the **Ingestion Jobs** tab**:** * Trigger the Job, using Run button * To schedule, enable Auto-Run. Change the frequency if required ### Advanced Connection Settings * **API Read Timeout (In seconds) :** Maximum time of inactivity between two data packets when waiting for the server's response. The default value is 30 seconds. * **API Connection Timeout (In seconds) :** Time period within which a connection between a client and a server must be established. * **Retry Limit :** Number of retries allowed when an API call fails. For example if an API call fails and retry limit is 5 then it will check 5 times for that API call and if it succeeded then it will stop checking**.** * **Retry Sleep Time (In milliseconds) :** Given time, after which retry should happen in case an API call fails. * **Incremental Batch Size (In days) :** No. of days in one batch for which data is being downloaded during incremental ingestion. * **Version :** It gives information about the version of Google Analytics core reporting API being used. * **Max Records :** Field sets the max limit on the number of records that can be downloaded during each API call. ### Dataset Fields User can pick following fields in datasets * GA\_Users * GA\_New\_Users * GA\_\_\_New\_Sessions * GA\_1\_Day\_Active\_Users * GA\_7\_Day\_Active\_Users * GA\_14\_Day\_Active\_Users * GA\_28\_Day\_Active\_Users * GA\_30\_Day\_Active\_Users * GA\_Sessions * GA\_Bounces * GA\_Bounce\_Rate * GA\_Session\_Duration * GA\_Avg\_\_Session\_Duration * GA\_Organic\_Searches * GA\_Impressions * GA\_Clicks * GA\_Cost * GA\_CPM * GA\_CPC * GA\_CTR * GA\_Cost\_per\_Transaction * GA\_Cost\_per\_Goal\_Conversion * GA\_Cost\_per\_Conversion * GA\_RPC * GA\_ROI * GA\_Margin * GA\_ROAS * GA\_Goal\_1\_Starts * GA\_Goal\_2\_Starts * GA\_Goal\_3\_Starts * GA\_Goal\_4\_Starts * GA\_Goal\_5\_Starts * GA\_Goal\_6\_Starts * GA\_Goal\_7\_Starts * GA\_Goal\_8\_Starts * GA\_Goal\_9\_Starts * GA\_Goal\_10\_Starts * GA\_Goal\_11\_Starts * GA\_Goal\_12\_Starts * GA\_Goal\_13\_Starts * GA\_Goal\_14\_Starts * GA\_Goal\_15\_Starts * GA\_Goal\_16\_Starts * GA\_Goal\_17\_Starts * GA\_Goal\_18\_Starts * GA\_Goal\_19\_Starts * GA\_Goal\_20\_Starts * GA\_Goal\_Starts * GA\_Goal\_1\_Completions * GA\_Goal\_2\_Completions * GA\_Goal\_3\_Completions * GA\_Goal\_4\_Completions * GA\_Goal\_5\_Completions * GA\_Goal\_6\_Completions * GA\_Goal\_7\_Completions * GA\_Goal\_8\_Completions * GA\_Goal\_9\_Completions * GA\_Goal\_10\_Completions * GA\_Goal\_11\_Completions * GA\_Goal\_12\_Completions * GA\_Goal\_13\_Completions * GA\_Goal\_14\_Completions * GA\_Goal\_15\_Completions * GA\_Goal\_16\_Completions * GA\_Goal\_17\_Completions * GA\_Goal\_18\_Completions * GA\_Goal\_19\_Completions * GA\_Goal\_20\_Completions * GA\_Goal\_Completions * GA\_Goal\_1\_Value * GA\_Goal\_2\_Value * GA\_Goal\_3\_Value * GA\_Goal\_4\_Value * GA\_Goal\_5\_Value * GA\_Goal\_6\_Value * GA\_Goal\_7\_Value * GA\_Goal\_8\_Value * GA\_Goal\_9\_Value * GA\_Goal\_10\_Value * GA\_Goal\_11\_Value * GA\_Goal\_12\_Value * GA\_Goal\_13\_Value * GA\_Goal\_14\_Value * GA\_Goal\_15\_Value * GA\_Goal\_16\_Value * GA\_Goal\_17\_Value * GA\_Goal\_18\_Value * GA\_Goal\_19\_Value * GA\_Goal\_20\_Value * GA\_Goal\_Value * GA\_Per\_Session\_Goal\_Value * GA\_Goal\_1\_Conversion\_Rate * GA\_Goal\_2\_Conversion\_Rate * GA\_Goal\_3\_Conversion\_Rate * GA\_Goal\_4\_Conversion\_Rate * GA\_Goal\_5\_Conversion\_Rate * GA\_Goal\_6\_Conversion\_Rate * GA\_Goal\_7\_Conversion\_Rate * GA\_Goal\_8\_Conversion\_Rate * GA\_Goal\_9\_Conversion\_Rate * GA\_Goal\_10\_Conversion\_Rate * GA\_Goal\_11\_Conversion\_Rate * GA\_Goal\_12\_Conversion\_Rate * GA\_Goal\_13\_Conversion\_Rate * GA\_Goal\_14\_Conversion\_Rate * GA\_Goal\_15\_Conversion\_Rate * GA\_Goal\_16\_Conversion\_Rate * GA\_Goal\_17\_Conversion\_Rate * GA\_Goal\_18\_Conversion\_Rate * GA\_Goal\_19\_Conversion\_Rate * GA\_Goal\_20\_Conversion\_Rate * GA\_Goal\_Conversion\_Rate * GA\_Goal\_1\_Abandoned\_Funnels * GA\_Goal\_2\_Abandoned\_Funnels * GA\_Goal\_3\_Abandoned\_Funnels * GA\_Goal\_4\_Abandoned\_Funnels * GA\_Goal\_5\_Abandoned\_Funnels * GA\_Goal\_6\_Abandoned\_Funnels * GA\_Goal\_7\_Abandoned\_Funnels * GA\_Goal\_8\_Abandoned\_Funnels * GA\_Goal\_9\_Abandoned\_Funnels * GA\_Goal\_10\_Abandoned\_Funnels * GA\_Goal\_11\_Abandoned\_Funnels * GA\_Goal\_12\_Abandoned\_Funnels * GA\_Goal\_13\_Abandoned\_Funnels * GA\_Goal\_14\_Abandoned\_Funnels * GA\_Goal\_15\_Abandoned\_Funnels * GA\_Goal\_16\_Abandoned\_Funnels * GA\_Goal\_17\_Abandoned\_Funnels * GA\_Goal\_18\_Abandoned\_Funnels * GA\_Goal\_19\_Abandoned\_Funnels * GA\_Goal\_20\_Abandoned\_Funnels * GA\_Abandoned\_Funnels * GA\_Goal\_1\_Abandonment\_Rate * GA\_Goal\_2\_Abandonment\_Rate * GA\_Goal\_3\_Abandonment\_Rate * GA\_Goal\_4\_Abandonment\_Rate * GA\_Goal\_5\_Abandonment\_Rate * GA\_Goal\_6\_Abandonment\_Rate * GA\_Goal\_7\_Abandonment\_Rate * GA\_Goal\_8\_Abandonment\_Rate * GA\_Goal\_9\_Abandonment\_Rate * GA\_Goal\_10\_Abandonment\_Rate * GA\_Goal\_11\_Abandonment\_Rate * GA\_Goal\_12\_Abandonment\_Rate * GA\_Goal\_13\_Abandonment\_Rate * GA\_Goal\_14\_Abandonment\_Rate * GA\_Goal\_15\_Abandonment\_Rate * GA\_Goal\_16\_Abandonment\_Rate * GA\_Goal\_17\_Abandonment\_Rate * GA\_Goal\_18\_Abandonment\_Rate * GA\_Goal\_19\_Abandonment\_Rate * GA\_Goal\_20\_Abandonment\_Rate * GA\_Total\_Abandonment\_Rate * GA\_Page\_Value * GA\_Entrances * GA\_Entrances\_\_\_Pageviews * GA\_Pageviews * GA\_Pages\_\_\_Session * GA\_Unique\_Views\_1 * GA\_Unique\_Views\_2 * GA\_Unique\_Views\_3 * GA\_Unique\_Views\_4 * GA\_Unique\_Views\_5 * GA\_Unique\_Pageviews * GA\_Time\_on\_Page * GA\_Avg\_\_Time\_on\_Page * GA\_Exits * GA\_\_\_Exit * GA\_Results\_Pageviews * GA\_Total\_Unique\_Searches * GA\_Results\_Pageviews\_\_\_Search * GA\_Sessions\_with\_Search * GA\_\_\_Sessions\_with\_Search * GA\_Search\_Depth * GA\_Avg\_\_Search\_Depth * GA\_Search\_Refinements * GA\_\_\_Search\_Refinements * GA\_Time\_after\_Search * GA\_Search\_Exits * GA\_\_\_Search\_Exits * GA\_Site\_Search\_Goal\_1\_Conversion\_Rate * GA\_Site\_Search\_Goal\_2\_Conversion\_Rate * GA\_Site\_Search\_Goal\_3\_Conversion\_Rate * GA\_Site\_Search\_Goal\_4\_Conversion\_Rate * GA\_Site\_Search\_Goal\_5\_Conversion\_Rate * GA\_Site\_Search\_Goal\_6\_Conversion\_Rate * GA\_Site\_Search\_Goal\_7\_Conversion\_Rate * GA\_Site\_Search\_Goal\_8\_Conversion\_Rate * GA\_Site\_Search\_Goal\_9\_Conversion\_Rate * GA\_Site\_Search\_Goal\_10\_Conversion\_Rate * GA\_Site\_Search\_Goal\_11\_Conversion\_Rate * GA\_Site\_Search\_Goal\_12\_Conversion\_Rate * GA\_Site\_Search\_Goal\_13\_Conversion\_Rate * GA\_Site\_Search\_Goal\_14\_Conversion\_Rate * GA\_Site\_Search\_Goal\_15\_Conversion\_Rate * GA\_Site\_Search\_Goal\_16\_Conversion\_Rate * GA\_Site\_Search\_Goal\_17\_Conversion\_Rate * GA\_Site\_Search\_Goal\_18\_Conversion\_Rate * GA\_Site\_Search\_Goal\_19\_Conversion\_Rate * GA\_Site\_Search\_Goal\_20\_Conversion\_Rate * GA\_Site\_Search\_Goal\_Conversion\_Rate * GA\_Per\_Search\_Goal\_Value * GA\_Page\_Load\_Time\_\_ms\_ * GA\_Page\_Load\_Sample * GA\_Avg\_\_Page\_Load\_Time\_\_sec\_ * GA\_Domain\_Lookup\_Time\_\_ms\_ * GA\_Avg\_\_Domain\_Lookup\_Time\_\_sec\_ * GA\_Page\_Download\_Time\_\_ms\_ * GA\_Avg\_\_Page\_Download\_Time\_\_sec\_ * GA\_Redirection\_Time\_\_ms\_ * GA\_Avg\_\_Redirection\_Time\_\_sec\_ * GA\_Server\_Connection\_Time\_\_ms\_ * GA\_Avg\_\_Server\_Connection\_Time\_\_sec\_ * GA\_Server\_Response\_Time\_\_ms\_ * GA\_Avg\_\_Server\_Response\_Time\_\_sec\_ * GA\_Speed\_Metrics\_Sample * GA\_Document\_Interactive\_Time\_\_ms\_ * GA\_Avg\_\_Document\_Interactive\_Time\_\_sec\_ * GA\_Document\_Content\_Loaded\_Time\_\_ms\_ * GA\_Avg\_\_Document\_Content\_Loaded\_Time\_\_sec\_ * GA\_DOM\_Latency\_Metrics\_Sample * GA\_Screen\_Views * GA\_Unique\_Screen\_Views * GA\_Screens\_\_\_Session * GA\_Time\_on\_Screen * GA\_Avg\_\_Time\_on\_Screen * GA\_Total\_Events * GA\_Unique\_Dimension\_Combinations * GA\_Unique\_Events * GA\_Event\_Value * GA\_Avg\_\_Value * GA\_Sessions\_with\_Event * GA\_Events\_\_\_Session\_with\_Event * GA\_Transactions * GA\_Ecommerce\_Conversion\_Rate * GA\_Revenue * GA\_Avg\_\_Order\_Value * GA\_Per\_Session\_Value * GA\_Shipping * GA\_Tax * GA\_Total\_Value * GA\_Quantity * GA\_Unique\_Purchases * GA\_Avg\_\_Price * GA\_Product\_Revenue * GA\_Avg\_\_QTY * GA\_Local\_Revenue * GA\_Local\_Shipping * GA\_Local\_Tax * GA\_Local\_Product\_Revenue * GA\_Social\_Actions * GA\_Unique\_Social\_Actions * GA\_Actions\_Per\_Social\_Session * GA\_User\_Timing\_\_ms\_ * GA\_User\_Timing\_Sample * GA\_Avg\_\_User\_Timing\_\_sec\_ * GA\_Exceptions * GA\_Exceptions\_\_\_Screen * GA\_Crashes * GA\_Crashes\_\_\_Screen * GA\_Custom\_Metric\_1\_Value * GA\_Custom\_Metric\_2\_Value * GA\_Custom\_Metric\_3\_Value * GA\_Custom\_Metric\_4\_Value * GA\_Custom\_Metric\_5\_Value * GA\_Custom\_Metric\_6\_Value * GA\_Custom\_Metric\_7\_Value * GA\_Custom\_Metric\_8\_Value * GA\_Custom\_Metric\_9Value * GA\_Custom\_Metric\_10\_Value * GA\_Custom\_Metric\_11\_Value * GA\_Custom\_Metric\_12\_Value * GA\_Custom\_Metric\_13\_Value * GA\_Custom\_Metric\_14\_Value * GA\_Custom\_Metric\_15\_Value * GA\_Custom\_Metric\_16\_Value * GA\_Custom\_Metric\_17\_Value * GA\_Custom\_Metric\_18\_Value * GA\_Custom\_Metric\_19\_Value * GA\_Custom\_Metric\_20\_Value * GA\_CM\_Conversions * GA\_CM\_Revenue * GA\_AdSense\_Revenue * GA\_AdSense\_Ad\_Units\_Viewed * GA\_AdSense\_Impressions * GA\_AdSense\_Ads\_Clicked * GA\_AdSense\_Page\_Impressions * GA\_AdSense\_CTR * GA\_AdSense\_eCPM * GA\_AdSense\_Exits * GA\_AdSense\_Viewable\_Impression\_\_ * GA\_AdSense\_Coverage * GA\_Publisher\_Impressions * GA\_Publisher\_Coverage * GA\_Publisher\_Monetized\_Pageviews * GA\_Publisher\_Impressions\_\_\_Session * GA\_Publisher\_Viewable\_Impressions\_\_ * GA\_Publisher\_Clicks * GA\_Publisher\_CTR * GA\_Publisher\_Revenue * GA\_Publisher\_Revenue\_\_\_1000\_Sessions * GA\_Publisher\_eCPM * GA\_AdX\_Impressions * GA\_AdX\_Coverage * GA\_AdX\_Monetized\_Pageviews * GA\_AdX\_Impressions\_\_\_Session * GA\_AdX\_Viewable\_Impressions\_\_ * GA\_AdX\_Clicks * GA\_AdX\_CTR * GA\_AdX\_Revenue * GA\_AdX\_Revenue\_\_\_1000\_Sessions * GA\_AdX\_eCPM * GA\_GAM\_Impressions * GA\_GAM\_Coverage * GA\_GAM\_Monetized\_Pageviews * GA\_GAM\_Impressions\_\_\_Session * GA\_GAM\_Viewable\_Impressions\_\_ * GA\_GAM\_Clicks * GA\_GAM\_CTR * GA\_GAM\_Revenue * GA\_GAM\_Revenue\_\_\_1000\_Sessions * GA\_GAM\_eCPM * GA\_GAM\_Backfill\_Impressions * GA\_GAM\_Backfill\_Coverage * GA\_GAM\_Backfill\_Monetized\_Pageviews * GA\_GAM\_Backfill\_Impressions\_\_\_Session * GA\_GAM\_Backfill\_Viewable\_Impressions\_\_ * GA\_GAM\_Backfill\_Clicks * GA\_GAM\_Backfill\_CTR * GA\_GAM\_Backfill\_Revenue * GA\_GAM\_Backfill\_Revenue\_\_\_1000\_Sessions * GA\_GAM\_Backfill\_eCPM * GA\_Buy-to-Detail\_Rate * GA\_Cart-to-Detail\_Rate * GA\_Appviews\_per\_User * GA\_Appviews\_Per\_User\_\_LTV\_ * GA\_Goal\_Completions\_per\_User * GA\_Goal\_Completions\_Per\_User\_\_LTV\_ * GA\_Pageviews\_per\_User * GA\_Pageviews\_Per\_User\_\_LTV\_ * GA\_User\_Retention * GA\_Revenue\_per\_User * GA\_Revenue\_Per\_User\_\_LTV\_ * GA\_Session\_Duration\_per\_User * GA\_Session\_Duration\_Per\_User\_\_LTV\_ * GA\_Sessions\_per\_User * GA\_Sessions\_Per\_User\_\_LTV\_ * GA\_Total\_Users * GA\_DV360\_eCPA * GA\_DV360\_eCPC * GA\_DV360\_eCPM * GA\_DV360\_CTR * GA\_DV360\_Clicks * GA\_DV360\_Conversions * GA\_DV360\_Cost * GA\_DV360\_Impressions * GA\_DV360\_ROAS * GA\_CM\_CPC * GA\_CM\_CTR * GA\_CM\_Clicks * GA\_CM\_Cost * GA\_CM\_Impressions * GA\_CM\_Margin * GA\_CM\_ROAS * GA\_CM\_RPC * GA\_SA360\_CPC * GA\_SA360\_CTR * GA\_SA360\_Clicks * GA\_SA360\_Cost * GA\_SA360\_Impressions * GA\_SA360\_Profit * GA\_SA360\_ROAS * GA\_SA360\_RPC * GA\_Hits * GA\_Internal\_Promotion\_CTR * GA\_Internal\_Promotion\_Clicks * GA\_Internal\_Promotion\_Views * GA\_Local\_Product\_Refund\_Amount * GA\_Local\_Refund\_Amount * GA\_Product\_Adds\_To\_Cart * GA\_Product\_Checkouts * GA\_Product\_Detail\_Views * GA\_Product\_List\_CTR * GA\_Product\_List\_Clicks * GA\_Product\_List\_Views * GA\_Product\_Refund\_Amount * GA\_Product\_Refunds * GA\_Product\_Removes\_From\_Cart * GA\_Product\_Revenue\_per\_Purchase * GA\_Quantity\_Added\_To\_Cart * GA\_Quantity\_Checked\_Out * GA\_Quantity\_Refunded * GA\_Quantity\_Removed\_From\_Cart * GA\_Refund\_Amount * GA\_Number\_of\_Sessions\_per\_User * GA\_Refunds * GA\_Transactions\_per\_User * event\_date